SAP Table KNA1
General Data in Customer Master
KNA1 (General Data in Customer Master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNA1 to other SAP tables.
KNA1 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||
KUNNR | Customer Number | KUNNR | CHAR | 10 | 0 | |||||||||||||||||||||||
LAND1 | Country Key | LAND1_GP | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
ORT01 | City | ORT01_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||||||||||||||||||||||
REGIO | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||||||||||||||||
SORTL | Sort field | SORTL | CHAR | 10 | 0 | |||||||||||||||||||||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | 0 | |||||||||||||||||||||||
TELFX | Fax Number | TELFX | CHAR | 31 | 0 | |||||||||||||||||||||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
ADRNR | Address | ADRNR | CHAR | 10 | 0 | |||||||||||||||||||||||
MCOD1 | Search term for matchcode search | MCDD1 | CHAR | 25 | 0 | |||||||||||||||||||||||
MCOD2 | Search Term for Matchcode Search | MCDD2 | CHAR | 25 | 0 | |||||||||||||||||||||||
MCOD3 | Search term for matchcode search | MCDD3 | CHAR | 25 | 0 | |||||||||||||||||||||||
ANRED | Title | ANRED | CHAR | 15 | 0 | |||||||||||||||||||||||
AUFSD | Central order block for customer | AUFSD_X | TVAST | CHAR | 2 | 0 | ||||||||||||||||||||||
BAHNE | Express train station | BAHNE | CHAR | 25 | 0 | |||||||||||||||||||||||
BAHNS | Train station | BAHNS | CHAR | 25 | 0 | |||||||||||||||||||||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | 0 | |||||||||||||||||||||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | 0 | |||||||||||||||||||||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | 0 | |||||||||||||||||||||||
BRSCH | Industry key | BRSCH | T016 | CHAR | 4 | 0 | ||||||||||||||||||||||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | 0 | |||||||||||||||||||||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | 0 | |||||||||||||||||||||||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | 0 | |||||||||||||||||||||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | 0 | |||||||||||||||||||||||
EXABL | Indicator: Unloading points exist | EXABL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
FAKSD | Central billing block for customer | FAKSD_X | TVFS | CHAR | 2 | 0 | ||||||||||||||||||||||
FISKN | Account number of the master record with the fiscal address | FISKN_D | KNA1 | CHAR | 10 | 0 | ||||||||||||||||||||||
KNAZK | Working Time Calendar | KNAZK | TFACD | CHAR | 2 | 0 | ||||||||||||||||||||||
KNRZA | Account number of an alternative payer | KNRZA | KNA1 | CHAR | 10 | 0 | ||||||||||||||||||||||
KONZS | Group key | KONZS | CHAR | 10 | 0 | |||||||||||||||||||||||
KTOKD | Customer Account Group | KTOKD | T077D | CHAR | 4 | 0 | ||||||||||||||||||||||
KUKLA | Customer classification | KUKLA | TKUKL | CHAR | 2 | 0 | ||||||||||||||||||||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||
LIFSD | Central delivery block for the customer | LIFSD_X | TVLS | CHAR | 2 | 0 | ||||||||||||||||||||||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | 0 | |||||||||||||||||||||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
NIELS | Nielsen ID | NIELS | TNLS | CHAR | 2 | 0 | ||||||||||||||||||||||
ORT02 | District | ORT02_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
PFACH | PO Box | PFACH | CHAR | 10 | 0 | |||||||||||||||||||||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | 0 | |||||||||||||||||||||||
COUNC | County Code | COUNC | T005E | CHAR | 3 | 0 | ||||||||||||||||||||||
CITYC | City Code | CITYC | T005G | CHAR | 4 | 0 | ||||||||||||||||||||||
RPMKR | Regional Market | RPMKR | CHAR | 5 | 0 | |||||||||||||||||||||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||||||||||||||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | 0 | |||||||||||||||||||||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | 0 | |||||||||||||||||||||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
TELBX | Telebox number | TELBX | CHAR | 15 | 0 | |||||||||||||||||||||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | 0 | |||||||||||||||||||||||
TELTX | Teletex number | TELTX | CHAR | 30 | 0 | |||||||||||||||||||||||
TELX1 | Telex number | TELX1 | CHAR | 30 | 0 | |||||||||||||||||||||||
LZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||||||||||||||||||||||
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
VBUND | Company ID of trading partner | RASSC | T880 | CHAR | 6 | 0 | ||||||||||||||||||||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | 0 | |||||||||||||||||||||||
DEAR1 | Indicator: Competitor | DEAR1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
DEAR2 | Indicator: Sales partner | DEAR2 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
DEAR3 | Indicator: Sales prospect | DEAR3 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
DEAR4 | Indicator for customer type 4 | DEAR4 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
DEAR5 | ID for default sold-to party | DEAR5 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
GFORM | Legal status | GFORM | TVGF | CHAR | 2 | 0 | ||||||||||||||||||||||
BRAN1 | Industry Code 1 | BRAN1_D | TBRC | CHAR | 10 | 0 | ||||||||||||||||||||||
BRAN2 | Industry code 2 | BRAN2 | TBRC | CHAR | 10 | 0 | ||||||||||||||||||||||
BRAN3 | Industry code 3 | BRAN3 | TBRC | CHAR | 10 | 0 | ||||||||||||||||||||||
BRAN4 | Industry code 4 | BRAN4 | TBRC | CHAR | 10 | 0 | ||||||||||||||||||||||
BRAN5 | Industry code 5 | BRAN5 | TBRC | CHAR | 10 | 0 | ||||||||||||||||||||||
EKONT | Initial contact | EKONT | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||
UMSAT | Annual sales | UMSAT | CURR | 8 | 2 | |||||||||||||||||||||||
UMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4 | 0 | |||||||||||||||||||||||
UWAER | Currency of sales figure | UWAER | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||
JMZAH | Yearly number of employees | JMZAH | NUMC | 6 | 0 | |||||||||||||||||||||||
JMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4 | 0 | |||||||||||||||||||||||
KATR1 | Attribute 1 | KATR1 | TVK1 | CHAR | 2 | 0 | ||||||||||||||||||||||
KATR2 | Attribute 2 | KATR2 | TVK2 | CHAR | 2 | 0 | ||||||||||||||||||||||
KATR3 | Attribute 3 | KATR3 | TVK3 | CHAR | 2 | 0 | ||||||||||||||||||||||
KATR4 | Attribute 4 | KATR4 | TVK4 | CHAR | 2 | 0 | ||||||||||||||||||||||
KATR5 | Attribute 5 | KATR5 | TVK5 | CHAR | 2 | 0 | ||||||||||||||||||||||
KATR6 | Attribute 6 | KATR6 | TVK6 | CHAR | 3 | 0 | ||||||||||||||||||||||
KATR7 | Attribute 7 | KATR7 | TVK7 | CHAR | 3 | 0 | ||||||||||||||||||||||
KATR8 | Attribute 8 | KATR8 | TVK8 | CHAR | 3 | 0 | ||||||||||||||||||||||
KATR9 | Attribute 9 | KATR9 | TVK9 | CHAR | 3 | 0 | ||||||||||||||||||||||
KATR10 | Attribute 10 | KATR10 | TVK0 | CHAR | 3 | 0 | ||||||||||||||||||||||
STKZN | Natural Person | STKZN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
UMSA1 | Annual sales | UMSA1 | CURR | 15 | 2 | |||||||||||||||||||||||
TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 | 0 | ||||||||||||||||||||||
PERIV | Fiscal Year Variant | PERIV | T009 | CHAR | 2 | 0 | ||||||||||||||||||||||
ABRVW | Usage Indicator | ABRVW | TVLV | CHAR | 3 | 0 | ||||||||||||||||||||||
INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | QINSPBYDEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | QINSPATDEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | T077D | CHAR | 4 | 0 | ||||||||||||||||||||||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | 0 | |||||||||||||||||||||||
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | 0 | |||||||||||||||||||||||
SPERZ | Payment Block | SPERZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
ETIKG | IS-R Labeling: customer/plant group | ETIKG | TWEK | CHAR | 10 | 0 | ||||||||||||||||||||||
CIVVE | ID for mainly non-military use | CIVVE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
MILVE | ID for mainly military use | MILVE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
KDKG1 | Customer condition group 1 | KDKG1 | TVKGG | CHAR | 2 | 0 | ||||||||||||||||||||||
KDKG2 | Customer condition group 2 | KDKG2 | TVKGG | CHAR | 2 | 0 | ||||||||||||||||||||||
KDKG3 | Customer condition group 3 | KDKG3 | TVKGG | CHAR | 2 | 0 | ||||||||||||||||||||||
KDKG4 | Customer condition group 4 | KDKG4 | TVKGG | CHAR | 2 | 0 | ||||||||||||||||||||||
KDKG5 | Customer condition group 5 | KDKG5 | TVKGG | CHAR | 2 | 0 | ||||||||||||||||||||||
XKNZA | Indicator: Alternative payer using account number | XKNZA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
FITYP | Tax type | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | ||||||||||||||||||||||
STCDT | Tax Number Type | J_1ATOID | J_1ATODC | CHAR | 2 | 0 | ||||||||||||||||||||||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | 0 | |||||||||||||||||||||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | 0 | |||||||||||||||||||||||
STCD5 | Tax Number 5 | STCD5 | CHAR | 60 | 0 | |||||||||||||||||||||||
XICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
XXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
XSUBT | Customer group for Substitui�ao Tribut�ria calculation | J_1BTCST | J_1BTXSTG | CHAR | 3 | 0 | ||||||||||||||||||||||
CFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | J_1BATL1 | CHAR | 3 | 0 | ||||||||||||||||||||||
TXLW2 | Tax law: IPI | J_1BTAXLW2 | J_1BATL2 | CHAR | 3 | 0 | ||||||||||||||||||||||
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
CCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
CCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
CASSD | Central sales block for customer | CASSD_X | CHAR | 2 | 0 | |||||||||||||||||||||||
KNURL | Uniform Resource Locator | URL | CHAR | 132 | 0 | |||||||||||||||||||||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | 0 | |||||||||||||||||||||||
J_1KFTBUS | Type of Business | GESTYP | BUSTYPE | CHAR | 30 | 0 | ||||||||||||||||||||||
J_1KFTIND | Type of Industry | INDTYP | INDUSTYPE | CHAR | 30 | 0 | ||||||||||||||||||||||
CONFS | Status of Change Authorization (Central) | CONFS_X | CHAR | 1 | 0 | |||||||||||||||||||||||
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | 0 | |||||||||||||||||||||||
UPTIM | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | 0 | |||||||||||||||||||||||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
DEAR6 | Indicator: Consumer | DEAR6 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
SUFRAMA | Suframa Code | J_1BSUFRAMA | CHAR | 9 | 0 | |||||||||||||||||||||||
RG | RG Number | J_1BRG | CHAR | 11 | 0 | |||||||||||||||||||||||
EXP | Issued by | J_1BEXP | CHAR | 3 | 0 | |||||||||||||||||||||||
UF | State | J_1BUF | CHAR | 2 | 0 | |||||||||||||||||||||||
RGDATE | RG Issue Date | J_1BRGDATE | DATS | 8 | 0 | |||||||||||||||||||||||
RIC | RIC Number | J_1BRIC | NUMC | 11 | 0 | |||||||||||||||||||||||
RNE | Foreign National Registration | J_1BRNE | CHAR | 10 | 0 | |||||||||||||||||||||||
RNEDATE | RNE Issue Date | J_1BRNEDATE | DATS | 8 | 0 | |||||||||||||||||||||||
CNAE | CNAE | J_1BCNAE | J_1BTCNAE | CHAR | 7 | 0 | ||||||||||||||||||||||
LEGALNAT | Legal Nature | J_1BLEGALNAT | J_1BTLEGALNAT | NUMC | 4 | 0 | ||||||||||||||||||||||
CRTN | CRT Number | J_1BCRTN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | J_1BTICMSTAXPAY | CHAR | 2 | 0 | ||||||||||||||||||||||
INDTYP | Industry Main Type | J_1BINDTYP | J_1BTINDTYP | CHAR | 2 | 0 | ||||||||||||||||||||||
TDT | Tax Declaration Type | J_1BTDT | J_1BTTDT | CHAR | 2 | 0 | ||||||||||||||||||||||
COMSIZE | Company Size | J_1BCOMSIZE | J_1BTCOMSIZE | CHAR | 2 | 0 | ||||||||||||||||||||||
DECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC | J_1BTDECREGPC | CHAR | 2 | 0 | ||||||||||||||||||||||
/VSO/R_PALHGT | Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | QUAN | 13 | 3 | |||||||||||||||||||||||
/VSO/R_PAL_UL | Unit of Length for Packaging Material (VSO) | /VSO/R_PAL_UNIT_L | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||
/VSO/R_PK_MAT | Customer-Related Packing for Each Packaging Material (VSO) | /VSO/M_PACK_BY_MAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
/VSO/R_MATPAL | Packaging Material of the Customer in VSO | /VSO/M_MATNR_PAL | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||
/VSO/R_I_NO_LYR | Number Layers Under an Inter-Pallet (VSO) | /VSO/M_IPAL_NO_LYR | NUMC | 2 | 0 | |||||||||||||||||||||||
/VSO/R_ONE_MAT | Packing Material-Specific for Each Packaging Material | /VSO/M_ONE_MAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
/VSO/R_ONE_SORT | Pack Only One Package Type for Each PKM (VSO) | /VSO/M_ONE_SORT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
/VSO/R_ULD_SIDE | Side Preference of Loading/Unloading (VSO) | /VSO/M_UNLOAD_SIDE_PREF | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||||||||
/VSO/R_LOAD_PREF | Front/Back Preference of Loading/Unloading (VSO) | /VSO/M_LOAD_PREF | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||||||||
/VSO/R_DPOINT | Collective Unloading Point for VSO | /VSO/R_DELIVERYPOINT | /VSO/R_DPOINT | CHAR | 10 | 0 | ||||||||||||||||||||||
/XLSO/CUSTOMER | Data element to differentiate customer | /XLSO/E_CUSTOMER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
/XLSO/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | 0 | |||||||||||||||||||||||
/XLSO/CLIENT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||||||||||
/XLSO/PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||||||||||||||||||
/XLSO/PREF_PAY | Version Number Component | CHAR2 | CHAR | 2 | 0 | |||||||||||||||||||||||
ALC | Agency Location Code | FMFG_ALC | FMFGT_ALC | CHAR | 8 | 0 | ||||||||||||||||||||||
PMT_OFFICE | Payment Office | FMFG_PMT_OFF | FMFGT_PO | CHAR | 5 | 0 | ||||||||||||||||||||||
FEE_SCHEDULE | Fee schedule | FM_FEE_SCHED | CHAR | 4 | 0 | |||||||||||||||||||||||
DUNS | DUNS Number | FMCCRDUNS | CHAR | 9 | 0 | |||||||||||||||||||||||
DUNS4 | DUNS+4 | FMCCRDUNS4 | CHAR | 4 | 0 | |||||||||||||||||||||||
PSOFG | Processor group | PSOFG | PSO19 | CHAR | 10 | 0 | ||||||||||||||||||||||
PSOIS | Subledger acct preprocessing procedure | PSOIS | CHAR | 20 | 0 | |||||||||||||||||||||||
PSON1 | Name 1 | NAME1_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
PSON2 | Name 2 | NAME2_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
PSON3 | Name 3 | NAME3_GP | CHAR | 35 | 0 | |||||||||||||||||||||||
PSOVN | First Name | PSOVN | CHAR | 35 | 0 | |||||||||||||||||||||||
PSOTL | Title | PSOTL | CHAR | 20 | 0 | |||||||||||||||||||||||
PSOHS | House number: is no longer used from Release 4.6B | PSOHS | CHAR | 6 | 0 | |||||||||||||||||||||||
PSOST | Street: No longer used from Release 4.6B | PSOST | CHAR | 28 | 0 | |||||||||||||||||||||||
PSOO1 | Description | PSOO1 | CHAR | 50 | 0 | |||||||||||||||||||||||
PSOO2 | Description | PSOO1 | CHAR | 50 | 0 | |||||||||||||||||||||||
PSOO3 | Description | PSOO1 | CHAR | 50 | 0 | |||||||||||||||||||||||
PSOO4 | Description | PSOO1 | CHAR | 50 | 0 | |||||||||||||||||||||||
PSOO5 | Description | PSOO1 | CHAR | 50 | 0 | |||||||||||||||||||||||
OIDRC | Differential Reference Code (DRC) | OIC_DRC | OICDC | CHAR | 5 | 0 | ||||||||||||||||||||||
OID_POREQD | Purchase order required: X = Yes, Blank = No | OID_POREQD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
OIPBL | Business location identifier (IS-Oil MRN) | OIF_PBLNR | OIFSPBL | CHAR | 10 | 0 | ||||||||||||||||||||||
RES_CNTRY | CHAR | 3 | 0 | |||||||||||||||||||||||||
CCODE | CHAR | 4 | 0 |
KNA1 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
KNA1 | /VSO/R_DPOINT | SYST | MANDT | /VSO/R_DPOINT | Collective Unloading Point for VSO | MANDT |
KNA1 | /VSO/R_DPOINT | KNA1 | /VSO/R_DPOINT | /VSO/R_DPOINT | Collective Unloading Point for VSO | /VSO/R_DPOINT |
KNA1 | /VSO/R_MATPAL | SYST | MANDT | MARA | General Material Data | MANDT |
KNA1 | /VSO/R_MATPAL | KNA1 | /VSO/R_MATPAL | MARA | General Material Data | MATNR |
KNA1 | /VSO/R_PAL_UL | SYST | MANDT | T006 | Units of Measurement | MANDT |
KNA1 | /VSO/R_PAL_UL | KNA1 | /VSO/R_PAL_UL | T006 | Units of Measurement | MSEHI |
KNA1 | ABRVW | KNA1 | ABRVW | TVLV | Check table for release orders: Usage ID | ABRVW |
KNA1 | ABRVW | KNA1 | MANDT | TVLV | Check table for release orders: Usage ID | MANDT |
KNA1 | ALC | KNA1 | MANDT | FMFGT_ALC | Agency Location Code - U.S. Federal Government | MANDT |
KNA1 | ALC | KNA1 | ALC | FMFGT_ALC | Agency Location Code - U.S. Federal Government | ALC |
KNA1 | AUFSD | KNA1 | MANDT | TVAST | Sales Document Blocking Reasons: Texts | MANDT |
KNA1 | AUFSD | SYST | LANGU | TVAST | Sales Document Blocking Reasons: Texts | SPRAS |
KNA1 | AUFSD | KNA1 | AUFSD | TVAST | Sales Document Blocking Reasons: Texts | AUFSP |
KNA1 | BRAN1 | KNA1 | MANDT | TBRC | Industry Code (Customer Master) | MANDT |
KNA1 | BRAN1 | KNA1 | BRAN1 | TBRC | Industry Code (Customer Master) | BRACO |
KNA1 | BRAN2 | KNA1 | MANDT | TBRC | Industry Code (Customer Master) | MANDT |
KNA1 | BRAN2 | KNA1 | BRAN2 | TBRC | Industry Code (Customer Master) | BRACO |
KNA1 | BRAN3 | KNA1 | MANDT | TBRC | Industry Code (Customer Master) | MANDT |
KNA1 | BRAN3 | KNA1 | BRAN3 | TBRC | Industry Code (Customer Master) | BRACO |
KNA1 | BRAN4 | KNA1 | MANDT | TBRC | Industry Code (Customer Master) | MANDT |
KNA1 | BRAN4 | KNA1 | BRAN4 | TBRC | Industry Code (Customer Master) | BRACO |
KNA1 | BRAN5 | KNA1 | MANDT | TBRC | Industry Code (Customer Master) | MANDT |
KNA1 | BRAN5 | KNA1 | BRAN5 | TBRC | Industry Code (Customer Master) | BRACO |
KNA1 | BRSCH | KNA1 | MANDT | T016 | Industries | MANDT |
KNA1 | BRSCH | KNA1 | BRSCH | T016 | Industries | BRSCH |
KNA1 | CITYC | KNA1 | MANDT | T005G | City | MANDT |
KNA1 | CITYC | KNA1 | LAND1 | T005G | City | LAND1 |
KNA1 | CITYC | KNA1 | REGIO | T005G | City | REGIO |
KNA1 | CITYC | KNA1 | CITYC | T005G | City | CITYC |
KNA1 | CNAE | SYST | MANDT | J_1BTCNAE | CNAE | MANDT |
KNA1 | CNAE | KNA1 | CNAE | J_1BTCNAE | CNAE | J_1BCNAE |
KNA1 | COMSIZE | KNA1 | COMSIZE | J_1BTCOMSIZE | Company Size | J_1BCOMSIZE |
KNA1 | COMSIZE | SYST | MANDT | J_1BTCOMSIZE | Company Size | MANDT |
KNA1 | COUNC | KNA1 | MANDT | T005E | County | MANDT |
KNA1 | COUNC | KNA1 | LAND1 | T005E | County | LAND1 |
KNA1 | COUNC | KNA1 | REGIO | T005E | County | REGIO |
KNA1 | COUNC | KNA1 | COUNC | T005E | County | COUNC |
KNA1 | DECREGPC | SYST | MANDT | J_1BTDECREGPC | Declaration Regimen for PIS/COFINS | MANDT |
KNA1 | DECREGPC | KNA1 | DECREGPC | J_1BTDECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC |
KNA1 | EKONT | KNA1 | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
KNA1 | EKONT | KNA1 | EKONT | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
KNA1 | ETIKG | KNA1 | MANDT | TWEK | IS-R Labeling: Check Table Customer/Plant Groups | MANDT |
KNA1 | ETIKG | KNA1 | ETIKG | TWEK | IS-R Labeling: Check Table Customer/Plant Groups | KUNGR |
KNA1 | FAKSD | KNA1 | FAKSD | TVFS | Billing: Reasons for Blocking | FAKSP |
KNA1 | FAKSD | KNA1 | MANDT | TVFS | Billing: Reasons for Blocking | MANDT |
KNA1 | FISKN | KNA1 | MANDT | KNA1 | General Data in Customer Master | MANDT |
KNA1 | FISKN | KNA1 | FISKN | KNA1 | General Data in Customer Master | KUNNR |
KNA1 | FITYP | 'D' | J_1AFITP | Tax Types | KOART | |
KNA1 | FITYP | KNA1 | FITYP | J_1AFITP | Tax Types | J_1AFITP |
KNA1 | FITYP | KNA1 | MANDT | J_1AFITP | Tax Types | MANDT |
KNA1 | GFORM | KNA1 | MANDT | TVGF | Legal Status (Customer Master) | MANDT |
KNA1 | GFORM | KNA1 | GFORM | TVGF | Legal Status (Customer Master) | GFORM |
KNA1 | ICMSTAXPAY | SYST | MANDT | J_1BTICMSTAXPAY | ICMS Taxpayer | MANDT |
KNA1 | ICMSTAXPAY | KNA1 | ICMSTAXPAY | J_1BTICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY |
KNA1 | INDTYP | SYST | MANDT | J_1BTINDTYP | Industry Main Type | MANDT |
KNA1 | INDTYP | KNA1 | INDTYP | J_1BTINDTYP | Industry Main Type | J_1BINDTYP |
KNA1 | J_1KFTBUS | KNA1 | MANDT | BUSTYPE | Type of Business | MANDT |
KNA1 | J_1KFTBUS | KNA1 | J_1KFTBUS | BUSTYPE | Type of Business | GESTYP |
KNA1 | J_1KFTIND | KNA1 | MANDT | INDUSTYPE | Type of Industry | MANDT |
KNA1 | J_1KFTIND | KNA1 | J_1KFTIND | INDUSTYPE | Type of Industry | INDTYPE |
KNA1 | KATR1 | KNA1 | MANDT | TVK1 | Attribute 1 (customer master) | MANDT |
KNA1 | KATR1 | KNA1 | KATR1 | TVK1 | Attribute 1 (customer master) | KATR1 |
KNA1 | KATR10 | KNA1 | MANDT | TVK0 | Attribute 10 (customer master) | MANDT |
KNA1 | KATR10 | KNA1 | KATR10 | TVK0 | Attribute 10 (customer master) | KATR10 |
KNA1 | KATR2 | KNA1 | MANDT | TVK2 | Attribute 2 (customer master) | MANDT |
KNA1 | KATR2 | KNA1 | KATR2 | TVK2 | Attribute 2 (customer master) | KATR2 |
KNA1 | KATR3 | KNA1 | KATR3 | TVK3 | Attribute 3 (customer master) | KATR3 |
KNA1 | KATR3 | KNA1 | MANDT | TVK3 | Attribute 3 (customer master) | MANDT |
KNA1 | KATR4 | KNA1 | MANDT | TVK4 | Attribute 4 (customer master) | MANDT |
KNA1 | KATR4 | KNA1 | KATR4 | TVK4 | Attribute 4 (customer master) | KATR4 |
KNA1 | KATR5 | KNA1 | MANDT | TVK5 | Attribute 5 (customer master) | MANDT |
KNA1 | KATR5 | KNA1 | KATR5 | TVK5 | Attribute 5 (customer master) | KATR5 |
KNA1 | KATR6 | KNA1 | KATR6 | TVK6 | Attribute 6 (customer master) | KATR6 |
KNA1 | KATR6 | KNA1 | MANDT | TVK6 | Attribute 6 (customer master) | MANDT |
KNA1 | KATR7 | KNA1 | MANDT | TVK7 | Attribute 7 (customer master) | MANDT |
KNA1 | KATR7 | KNA1 | KATR7 | TVK7 | Attribute 7 (customer master) | KATR7 |
KNA1 | KATR8 | KNA1 | MANDT | TVK8 | Attribute 8 (customer master) | MANDT |
KNA1 | KATR8 | KNA1 | KATR8 | TVK8 | Attribute 8 (customer master) | KATR8 |
KNA1 | KATR9 | KNA1 | MANDT | TVK9 | Attribute 9 (customer master) | MANDT |
KNA1 | KATR9 | KNA1 | KATR9 | TVK9 | Attribute 9 (customer master) | KATR9 |
KNA1 | KDKG1 | KNA1 | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
KNA1 | KDKG1 | KNA1 | KDKG1 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
KNA1 | KDKG2 | KNA1 | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
KNA1 | KDKG2 | KNA1 | KDKG2 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
KNA1 | KDKG3 | KNA1 | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
KNA1 | KDKG3 | KNA1 | KDKG3 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
KNA1 | KDKG4 | KNA1 | KDKG4 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
KNA1 | KDKG4 | KNA1 | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
KNA1 | KDKG5 | KNA1 | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
KNA1 | KDKG5 | KNA1 | KDKG5 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
KNA1 | KNAZK | KNA1 | KNAZK | TFACD | Factory calendar definition | IDENT |
KNA1 | KNRZA | KNA1 | KNRZA | KNA1 | General Data in Customer Master | KUNNR |
KNA1 | KNRZA | KNA1 | MANDT | KNA1 | General Data in Customer Master | MANDT |
KNA1 | KTOCD | KNA1 | MANDT | T077D | Customer account groups | MANDT |
KNA1 | KTOCD | KNA1 | KTOCD | T077D | Customer account groups | KTOKD |
KNA1 | KTOKD | KNA1 | KTOKD | T077D | Customer account groups | KTOKD |
KNA1 | KTOKD | KNA1 | MANDT | T077D | Customer account groups | MANDT |
KNA1 | KUKLA | KNA1 | MANDT | TKUKL | Customers: Customer Classifications | MANDT |
KNA1 | KUKLA | KNA1 | KUKLA | TKUKL | Customers: Customer Classifications | KUKLA |
KNA1 | LAND1 | KNA1 | LAND1 | T005 | Countries | LAND1 |
KNA1 | LAND1 | KNA1 | MANDT | T005 | Countries | MANDT |
KNA1 | LEGALNAT | SYST | MANDT | J_1BTLEGALNAT | Legal Nature | MANDT |
KNA1 | LEGALNAT | KNA1 | LEGALNAT | J_1BTLEGALNAT | Legal Nature | J_1BLEGALNAT |
KNA1 | LIFNR | KNA1 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
KNA1 | LIFNR | KNA1 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
KNA1 | LIFSD | KNA1 | MANDT | TVLS | Deliveries: Blocking Reasons/Criteria | MANDT |
KNA1 | LIFSD | KNA1 | LIFSD | TVLS | Deliveries: Blocking Reasons/Criteria | LIFSP |
KNA1 | LZONE | KNA1 | LZONE | TZONE | Customers: Regional zones | ZONE1 |
KNA1 | LZONE | KNA1 | MANDT | TZONE | Customers: Regional zones | MANDT |
KNA1 | LZONE | KNA1 | LAND1 | TZONE | Customers: Regional zones | LAND1 |
KNA1 | MANDT | KNA1 | MANDT | T000 | Clients | MANDT |
KNA1 | NIELS | KNA1 | MANDT | TNLS | Nielsen ID | MANDT |
KNA1 | NIELS | KNA1 | NIELS | TNLS | Nielsen ID | NIELS |
KNA1 | OIDRC | KNA1 | MANDT | OICDC | Differential Reference Code | MANDT |
KNA1 | OIDRC | KNA1 | OIDRC | OICDC | Differential Reference Code | OIDRC |
KNA1 | OIPBL | KNA1 | MANDT | OIFSPBL | Physical Location - Master Data | MANDT |
KNA1 | OIPBL | KNA1 | OIPBL | OIFSPBL | Physical Location - Master Data | PBLNR |
KNA1 | PERIV | KNA1 | MANDT | T009 | Fiscal Year Variants | MANDT |
KNA1 | PERIV | KNA1 | PERIV | T009 | Fiscal Year Variants | PERIV |
KNA1 | PMT_OFFICE | KNA1 | MANDT | FMFGT_PO | Payment Office - U.S. Federal Government | MANDT |
KNA1 | PMT_OFFICE | KNA1 | PMT_OFFICE | FMFGT_PO | Payment Office - U.S. Federal Government | PMT_OFFICE |
KNA1 | PSOFG | KNA1 | PSOFG | PSO19 | Group Responsibility | PSOFG |
KNA1 | PSOFG | KNA1 | MANDT | PSO19 | Group Responsibility | MANDT |
KNA1 | REGIO | KNA1 | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
KNA1 | REGIO | KNA1 | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
KNA1 | REGIO | KNA1 | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
KNA1 | SPRAS | KNA1 | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
KNA1 | STCDT | KNA1 | MANDT | J_1ATODC | Type of identification | MANDT |
KNA1 | STCDT | KNA1 | STCDT | J_1ATODC | Type of identification | J_1ATODC |
KNA1 | TDT | KNA1 | TDT | J_1BTTDT | TDT | J_1BTDT |
KNA1 | TDT | SYST | MANDT | J_1BTTDT | TDT | MANDT |
KNA1 | TXJCD | T005 | KALSM | TTXJ | Check Table for Tax Jurisdiction | KALSM |
KNA1 | TXJCD | KNA1 | TXJCD | TTXJ | Check Table for Tax Jurisdiction | TXJCD |
KNA1 | TXJCD | KNA1 | MANDT | TTXJ | Check Table for Tax Jurisdiction | MANDT |
KNA1 | TXLW1 | KNA1 | TXLW1 | J_1BATL1 | Tax Law ICMS | TAXLAW |
KNA1 | TXLW1 | KNA1 | MANDT | J_1BATL1 | Tax Law ICMS | MANDT |
KNA1 | TXLW2 | KNA1 | MANDT | J_1BATL2 | Tax Law IPI | MANDT |
KNA1 | TXLW2 | KNA1 | TXLW2 | J_1BATL2 | Tax Law IPI | TAXLAW |
KNA1 | UWAER | KNA1 | MANDT | TCURC | Currency Codes | MANDT |
KNA1 | UWAER | KNA1 | UWAER | TCURC | Currency Codes | WAERS |
KNA1 | VBUND | KNA1 | MANDT | T880 | Global Company Data (for KONS Ledger) | MANDT |
KNA1 | VBUND | KNA1 | VBUND | T880 | Global Company Data (for KONS Ledger) | RCOMP |
KNA1 | WERKS | KNA1 | MANDT | T001W | Plants/Branches | MANDT |
KNA1 | WERKS | KNA1 | WERKS | T001W | Plants/Branches | WERKS |
KNA1 | XSUBT | SYST | MANDT | J_1BTXSTG | Tax calc.: Sub.Trib. customer group | MANDT |
KNA1 | XSUBT | KNA1 | XSUBT | J_1BTXSTG | Tax calc.: Sub.Trib. customer group | STGRP |