SAP MIG_CMDS_EI_VMD_CENTRAL_DATA Table in S/4 HANA - Ext. Interface: Central Customer Data
MIG_CMDS_EI_VMD_CENTRAL_DATA is a standard SAP Table which is used to store Ext. Interface: Central Customer Data data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MIG_CMDS_EI_VMD_CENTRAL_DATA table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MIG_CMDS_EI_VMD_CENTRAL_DATA
MIG_CMDS_EI_VMD_CENTRAL_DATA table structure field list
Below is the full MIG_CMDS_EI_VMD_CENTRAL_DATA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
AUFSD | Central order block for customer | AUFSD_X | CHAR | 2(0) | KAUFS | |||||
BAHNE | Express train station | BAHNE | CHAR | 25(0) | BAHNH | |||||
BAHNS | Train station | BAHNS | CHAR | 25(0) | BAHNH | |||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7(0) | NUM07 | |||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5(0) | NUM05 | |||||
BEGRU | Authorization Group | BRGRU | CHAR | 4(0) | BRGRU | |||||
BRSCH | Industry key | BRSCH | CHAR | 4(0) | BRSCH | |||||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1(0) | NUM01 | |||||
FAKSD | Central billing block for customer | FAKSD_X | CHAR | 2(0) | FAKSP | |||||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10(0) | ALPHA | KUNNR | ||||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10(0) | ALPHA | KUNNR | ||||
KONZS | Group key | KONZS | CHAR | 10(0) | KONZS | |||||
KTOKD | Customer Account Group | KTOKD | CHAR | 4(0) | KTOKD | KGD | ||||
KUKLA | Customer classification | KUKLA | CHAR | 2(0) | KUKLA | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
LIFSD | Central delivery block for the customer | LIFSD_X | CHAR | 2(0) | LIFSP | |||||
LOCCO | City Coordinates | LOCCO | CHAR | 10(0) | LOCCO | |||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1(0) | XFELD | |||||
NIELS | Nielsen ID | NIELS | CHAR | 2(0) | NIELS | |||||
COUNC | County Code | COUNC | CHAR | 3(0) | COUNC | |||||
CITYC | City Code | CITYC | CHAR | 4(0) | CITYC | |||||
RPMKR | Regional market | RPMKR | CHAR | 5(0) | RPMKR | |||||
SPERR | Central posting block | SPERB_X | CHAR | 1(0) | XFELD | |||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16(0) | STCD1 | |||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11(0) | STCD2 | |||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1(0) | STKZA | |||||
STKZU | Liable for VAT | STKZU | CHAR | 1(0) | XFELD | |||||
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1(0) | XFELD | |||||
VBUND | Company ID of Trading Partner | RASSC | CHAR | 6(0) | ALPHA | RCOMP | PGS | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20(0) | STCEG | |||||
GFORM | Legal status | GFORM | CHAR | 2(0) | GFORM | |||||
BRAN1 | Industry code 1 | BRAN1_D | CHAR | 10(0) | BRACO | |||||
BRAN2 | Industry code 2 | BRAN2 | CHAR | 10(0) | BRACO | |||||
BRAN3 | Industry code 3 | BRAN3 | CHAR | 10(0) | BRACO | |||||
BRAN4 | Industry code 4 | BRAN4 | CHAR | 10(0) | BRACO | |||||
BRAN5 | Industry code 5 | BRAN5 | CHAR | 10(0) | BRACO | |||||
UMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4(0) | JAHR | |||||
UWAER | Currency of sales figure | UWAER | CUKY | 5(0) | WAERS | |||||
JMZAH | Yearly number of employees | JMZAH | NUMC | 6(0) | JMZAH | |||||
JMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4(0) | JAHR | |||||
KATR1 | Attribute 1 | KATR1 | CHAR | 2(0) | ATTR1 | |||||
KATR2 | Attribute 2 | KATR2 | CHAR | 2(0) | ATTR2 | |||||
KATR3 | Attribute 3 | KATR3 | CHAR | 2(0) | ATTR3 | |||||
KATR4 | Attribute 4 | KATR4 | CHAR | 2(0) | ATTR4 | |||||
KATR5 | Attribute 5 | KATR5 | CHAR | 2(0) | ATTR5 | |||||
KATR6 | Attribute 6 | KATR6 | CHAR | 3(0) | ATTR6 | |||||
KATR7 | Attribute 7 | KATR7 | CHAR | 3(0) | ATTR7 | |||||
KATR8 | Attribute 8 | KATR8 | CHAR | 3(0) | ATTR8 | |||||
KATR9 | Attribute 9 | KATR9 | CHAR | 3(0) | ATTR9 | |||||
KATR10 | Attribute 10 | KATR10 | CHAR | 3(0) | ATTR10 | |||||
STKZN | Natural Person | STKZN | CHAR | 1(0) | STKZN | |||||
UMSA1 | Annual sales | UMSA1 | CURR | 15(2) | UMSA1 | |||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2(0) | PERIV | |||||
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | CHAR | 4(0) | KTOKD | |||||
DTAMS | Report key for data medium exchange | DTAMS | CHAR | 1(0) | DTAMS | |||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2(0) | DTAWS | |||||
HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2(0) | HZUOR | |||||
CIVVE | ID for mainly non-military use | CIVVE | CHAR | 1(0) | XFELD | |||||
MILVE | ID for mainly military use | MILVE | CHAR | 1(0) | XFELD | |||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2(0) | J_1AFITP | |||||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2(0) | J_1ATOID | |||||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18(0) | CHAR18 | |||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18(0) | CHAR18 | |||||
XICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1(0) | XFELD | |||||
XXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1(0) | XFELD | |||||
XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3(0) | J_1BTCST1 | |||||
CFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2(0) | ALPHA | J_1BINDUS1 | ||||
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3(0) | ALPHA | J_1BTAXLW1 | ||||
TXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3(0) | ALPHA | J_1BTAXLW2 | ||||
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1(0) | XFELD | |||||
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1(0) | XFELD | |||||
CCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1(0) | XFELD | |||||
CCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1(0) | XFELD | |||||
CASSD | Central sales block for customer | CASSD_X | CHAR | 2(0) | CASSP | |||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2(0) | KDKGR | |||||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2(0) | KDKGR | |||||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2(0) | KDKGR | |||||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2(0) | KDKGR | |||||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2(0) | KDKGR | |||||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1(0) | XFELD | |||||
XSUB2 | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3(0) | J_1BTCST1 | |||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10(0) | REPRES | |||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30(0) | GESTYP | |||||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30(0) | INDTYP | |||||
STCD5 | Tax Number 5 | STCD5 | CHAR | 60(0) | CHAR60 | |||||
CVP_XBLCK | Business Purpose Completed Flag | CVP_XBLCK | CHAR | 1(0) | CVP_XBLCK | |||||
SUFRAMA | Suframa Code | J_1BSUFRAMA | CHAR | 9(0) | J_1BSUFRAMA | |||||
RG | RG Number | J_1BRG | CHAR | 11(0) | J_1BRG | |||||
EXP | Issued by | J_1BEXP | CHAR | 3(0) | J_1BEXP | |||||
UF | State | J_1BUF | CHAR | 2(0) | J_1BUF | |||||
RGDATE | RG Issuing Date | J_1BRGDATE | DATS | 8(0) | DATUM | |||||
RIC | RIC Number | J_1BRIC | NUMC | 11(0) | J_1BRIC | |||||
RNE | Foreign National Registration | J_1BRNE | CHAR | 10(0) | J_1BRNE | |||||
RNEDATE | RNE Issuing Date | J_1BRNEDATE | DATS | 8(0) | DATUM | |||||
CNAE | CNAE | J_1BCNAE | CHAR | 7(0) | J_1BCNAE | |||||
LEGALNAT | Legal Nature | J_1BLEGALNAT | NUMC | 4(0) | J_1BLEGALNAT | |||||
CRTN | CRT Number | J_1BCRTN | CHAR | 1(0) | J_1BCRTN | |||||
ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | CHAR | 2(0) | J_1BICMSTAXPAY | |||||
INDTYP | Industry Main Type | J_1BINDTYP | CHAR | 2(0) | J_1BINDTYP | |||||
TDT | Tax Declaration Type | J_1BTDT | CHAR | 2(0) | J_1BTDT | |||||
COMSIZE | Company Size | J_1BCOMSIZE | CHAR | 2(0) | J_1BCOMSIZE | |||||
DECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC | CHAR | 2(0) | J_1BDECREGPC | |||||
ORT02 | District | ORT02_GP | CHAR | 35(0) | TEXT35 | |||||
DEAR6 | Indicator: Consumer | DEAR6 | CHAR | 1(0) | XFELD | |||||
LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10(0) | ZONE | |||||
XKNZA | Indicator: Alternative payer using account number | XKNZA | CHAR | 1(0) | XFELD | |||||
DEAR1 | Indicator: Competitor | DEAR1 | CHAR | 1(0) | XFELD | |||||
DEAR2 | Indicator: Sales partner | DEAR2 | CHAR | 1(0) | XFELD | |||||
DEAR3 | Indicator: Sales prospect | DEAR3 | CHAR | 1(0) | DEAR3 | |||||
DEAR5 | ID for default sold-to party | DEAR5 | CHAR | 1(0) | XFELD | |||||
WERKS | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
ADRNR | Address | ADRNR | CHAR | 10(0) | ALPHA | ADRNR | ||||
.INCLU--AP | 0(0) | |||||||||
J_1IEXCD | ECC Number | J_1IEXCD | CHAR | 40(0) | CHAR40 | |||||
J_1IEXRN | Excise Registration Number | J_1IEXRN | CHAR | 40(0) | CHAR40 | |||||
J_1IEXRG | Excise Range | J_1IEXRG | CHAR | 60(0) | CHAR60 | |||||
J_1IEXDI | Excise Division | J_1IEXDI | CHAR | 60(0) | CHAR60 | |||||
J_1IEXCO | Excise Commissionerate | J_1IEXCO | CHAR | 60(0) | CHAR60 | |||||
J_1ICSTNO | Central Sales Tax Number | J_1ICSTNO | CHAR | 40(0) | CHAR40 | |||||
J_1ILSTNO | Local Sales Tax Number | J_1ILSTNO | CHAR | 40(0) | CHAR40 | |||||
J_1IPANNO | Permanent Account Number | J_1IPANNO | CHAR | 40(0) | CHAR40 | |||||
J_1IEXCICU | Excise tax indicator for customer | J_1IEXCICU | CHAR | 1(0) | J_1IINDTAX | |||||
J_1ISERN | Service Tax Registration Number | J_1ISERN | CHAR | 40(0) | CHAR40 | |||||
J_1IPANREF | PAN Reference Number | J_1IPANREF | CHAR | 40(0) | CHAR40 | |||||
.INCLU--AP | 0(0) | |||||||||
BONDED_AREA_CONFIRM | TW: Bonded Area Confirm in Business Partner Extension | TWVAT_BONDED_AREA_CONF | CHAR | 1(0) | TWVAT_BONDED_AREA_CONF | |||||
DONATE_MARK | TW: Donate Mark in Business Partner Extension | TWVAT_DONATE_MARK | CHAR | 1(0) | TWVAT_DONATE_MARK |
Search for further information about these or an SAP related objects