SAP ABAP Table EMG_KNA1 (Business Partner: Migration of Customer Master (Gen. Part))
Hierarchy
☛
FI-CA (Software Component) FI-CA
⤷ IS-U-TO-MI (Application Component) Migration
⤷ EEMI (Package) IS-U Migration
⤷ IS-U-TO-MI (Application Component) Migration
⤷ EEMI (Package) IS-U Migration
Basic Data
Table Category | INTTAB | Structure |
Structure | EMG_KNA1 | Table Relationship Diagram |
Short Description | Business Partner: Migration of Customer Master (Gen. Part) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
2 | AUFSD | AUFSD_X | KAUFS | CHAR | 2 | 0 | Central order block for customer | * | |
3 | BAHNE | BAHNE | BAHNH | CHAR | 25 | 0 | Express train station | ||
4 | BAHNS | BAHNS | BAHNH | CHAR | 25 | 0 | Train station | ||
5 | BBBNR | BBBNR_BI | CHAR7 | CHAR | 7 | 0 | German Standard Company Number (Batch Input Field) | ||
6 | BBSNR | BBSNR_BI | CHAR5 | CHAR | 5 | 0 | German Standard Company Number (Additional) (Batch Input) | ||
7 | BEGRU_KNA1 | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
8 | BRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | * | |
9 | BUBKZ | BUBKZ_BI | CHAR1 | CHAR | 1 | 0 | German Standard Company Number Check Digit (Batch Input) | ||
10 | DATLT | DATLT | TEXT14 | CHAR | 14 | 0 | Data communication line no. | ||
11 | ERDAT | DATUM_DI | CHAR10 | CHAR | 10 | 0 | Date for Direct Input | ||
12 | ERNAM | ERNAM_RF | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
13 | EXABL | EXABL | XFELD | CHAR | 1 | 0 | Indicator: Unloading points exist | ||
14 | FAKSD | FAKSD_X | FAKSP | CHAR | 2 | 0 | Central billing block for customer | * | |
15 | FISKN_KNA1 | FISKN_D | KUNNR | CHAR | 10 | 0 | Account number of the master record with the fiscal address | * | |
16 | KNAZK | KNAZK | WFCID | CHAR | 2 | 0 | Working Time Calendar | * | |
17 | KNRZA | KNRZA | KUNNR | CHAR | 10 | 0 | Account number of an alternative payer | * | |
18 | KONZS | KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
19 | KTOKD | KTOKD | KTOKD | CHAR | 4 | 0 | Customer Account Group | * | |
20 | KUKLA | KUKLA | KUKLA | CHAR | 2 | 0 | Customer classification | * | |
21 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
22 | LIFSD | LIFSD_X | LIFSP | CHAR | 2 | 0 | Central delivery block for the customer | * | |
23 | LOCCO | LOCCO | LOCCO | CHAR | 10 | 0 | City Coordinates | ||
24 | LOEVM | LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
25 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
26 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
27 | NIELS | NIELS | NIELS | CHAR | 2 | 0 | Nielsen ID | * | |
28 | ORT02 | ORT02_GP | TEXT35 | CHAR | 35 | 0 | District | ||
29 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
30 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
31 | COUNC_KNA1 | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
32 | CITYC_KNA1 | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
33 | RPMKR | RPMKR | RPMKR | CHAR | 5 | 0 | Regional market | ||
34 | SPERR | SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
35 | SPRAS | SPRAS_BI | CHAR1 | CHAR | 1 | 0 | Language key (batch input) | ||
36 | STCD1_KNA1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
37 | STCD2_KNA1 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
38 | STKZA_KNA1 | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
39 | STKZU_KNA1 | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
40 | TELBX | TELBX | TEXT15 | CHAR | 15 | 0 | Telebox number | ||
41 | TELF2 | TELF2 | TEXT16 | CHAR | 16 | 0 | Second telephone number | ||
42 | TELTX | TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
43 | TELX1 | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
44 | LZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
45 | XZEMP | XREGU | XFELD | CHAR | 1 | 0 | Indicator: Is an alternative payer allowed in document? | ||
46 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
47 | STCEG_KNA1 | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
48 | DEAR1 | DEAR1 | XFELD | CHAR | 1 | 0 | Indicator: Competitor | ||
49 | DEAR2 | DEAR2 | XFELD | CHAR | 1 | 0 | Indicator: Sales partner | ||
50 | DEAR3 | DEAR3 | DEAR3 | CHAR | 1 | 0 | Indicator: Sales prospect | ||
51 | DEAR4 | DEAR4 | XFELD | CHAR | 1 | 0 | Indicator for customer type 4 | ||
52 | DEAR5 | DEAR5 | XFELD | CHAR | 1 | 0 | ID for default sold-to party | ||
53 | GFORM | GFORM | GFORM | CHAR | 2 | 0 | Legal status | * | |
54 | BRAN1_KNA1 | BRAN1_D | BRACO | CHAR | 10 | 0 | Industry code 1 | * | |
55 | BRAN2_KNA1 | BRAN2 | BRACO | CHAR | 10 | 0 | Industry code 2 | * | |
56 | BRAN3_KNA1 | BRAN3 | BRACO | CHAR | 10 | 0 | Industry code 3 | * | |
57 | BRAN4_KNA1 | BRAN4 | BRACO | CHAR | 10 | 0 | Industry code 4 | * | |
58 | BRAN5_KNA1 | BRAN5 | BRACO | CHAR | 10 | 0 | Industry code 5 | * | |
59 | EKONT | EKONT | VBELN | CHAR | 10 | 0 | Initial contact | * | |
60 | UMSAT | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
61 | UMJAH | UMJAH_BI | CHAR4 | CHAR | 4 | 0 | Sales Year (Batch Input) | ||
62 | UWAER | WAERS_BI | CHAR5 | CHAR | 5 | 0 | Currency key (BTCI) | ||
63 | JMZAH | JMZAH_BI | CHAR6 | CHAR | 6 | 0 | No.of employees for the year (batch input) | ||
64 | JMJAH | JMJAH_BI | CHAR4 | CHAR | 4 | 0 | Year for which number is given (batch input) | ||
65 | KATR1 | KATR1 | ATTR1 | CHAR | 2 | 0 | Attribute 1 | * | |
66 | KATR2 | KATR2 | ATTR2 | CHAR | 2 | 0 | Attribute 2 | * | |
67 | KATR3 | KATR3 | ATTR3 | CHAR | 2 | 0 | Attribute 3 | * | |
68 | KATR4 | KATR4 | ATTR4 | CHAR | 2 | 0 | Attribute 4 | * | |
69 | KATR5 | KATR5 | ATTR5 | CHAR | 2 | 0 | Attribute 5 | * | |
70 | KATR6 | KATR6 | ATTR6 | CHAR | 3 | 0 | Attribute 6 | * | |
71 | KATR7 | KATR7 | ATTR7 | CHAR | 3 | 0 | Attribute 7 | * | |
72 | KATR8 | KATR8 | ATTR8 | CHAR | 3 | 0 | Attribute 8 | * | |
73 | KATR9 | KATR9 | ATTR9 | CHAR | 3 | 0 | Attribute 9 | * | |
74 | KATR10 | KATR10 | ATTR10 | CHAR | 3 | 0 | Attribute 10 | * | |
75 | STKZN | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
76 | UMSA1 | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
77 | TXJCD_KNA1 | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
78 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
79 | ABRVW | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
80 | INSPBYDEBI | QINSPBYDEB | QKZ | CHAR | 1 | 0 | Inspection Carried Out By Customer (No Inspection Lot) | ||
81 | INSPATDEBI | QINSPATDEB | QKZ | CHAR | 1 | 0 | Inspection for a Delivery Note After Outbound Delivery | ||
82 | KTOCD | KTOCD | KTOKD | CHAR | 4 | 0 | Reference Account Group for One-Time Account (Customer) | * | |
83 | PFORT | PFORT_GP | TEXT35 | CHAR | 35 | 0 | PO Box city | ||
84 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
85 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
86 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
87 | DUEFL | DUEFL_BKPF | DUEFL_BKPF | CHAR | 1 | 0 | Status of Data Transfer into Subsequent Release | ||
88 | HZUOR | HZUOR_BI | CHAR2 | CHAR | 2 | 0 | Hierarchy assignment (batch input) | ||
89 | SPERZ | SPERZ | XFELD | CHAR | 1 | 0 | Payment Block | ||
90 | ETIKG | ETIKG | ETIKG | CHAR | 10 | 0 | IS-R Labeling: customer/plant group | * | |
91 | CIVVE | CIVVE | XFELD | CHAR | 1 | 0 | ID for mainly non-military use | ||
92 | MILVE | MILVE | XFELD | CHAR | 1 | 0 | ID for mainly military use | ||
93 | KDKG1 | KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | * | |
94 | KDKG2 | KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | * | |
95 | KDKG3 | KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | * | |
96 | KDKG4 | KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | * | |
97 | KDKG5 | KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | * | |
98 | XKNZA | XKNZA | XFELD | CHAR | 1 | 0 | Indicator: Alternative payer using account number | ||
99 | FITYP | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | * | |
100 | STCDT | J_1ATOID | J_1ATOID | CHAR | 2 | 0 | Tax Number Type | * | |
101 | STCD3 | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
102 | STCD4 | STCD4 | CHAR18 | CHAR | 18 | 0 | Tax Number 4 | ||
103 | XICMS | J_1BTCICMS | XFELD | CHAR | 1 | 0 | Customer is ICMS-exempt | ||
104 | XXIPI | J_1BTCIPI | XFELD | CHAR | 1 | 0 | Customer is IPI-exempt | ||
105 | XSUBT | J_1BTCST | J_1BTCST1 | CHAR | 3 | 0 | Customer group for Substituiçao Tributária calculation | * | |
106 | CFOPC | J_1BINDUS1 | J_1BINDUS1 | CHAR | 2 | 0 | Customer's CFOP category | ||
107 | TXLW1 | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | * | |
108 | TXLW2 | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | * | |
109 | CCC01 | CCC01 | XFELD | CHAR | 1 | 0 | Indicator for biochemical warfare for legal control | ||
110 | CCC02 | CCC02 | XFELD | CHAR | 1 | 0 | Indicator for nuclear nonproliferation for legal control | ||
111 | CCC03 | CCC03 | XFELD | CHAR | 1 | 0 | Indicator for national security for legal control | ||
112 | CCC04 | CCC04 | XFELD | CHAR | 1 | 0 | Indicator for missile technology for legal control | ||
113 | CASSD | CASSD_X | CASSP | CHAR | 2 | 0 | Central sales block for customer | ||
114 | KNURL | URL | TEXT132 | CHAR | 132 | 0 | Uniform resource locator | ||
115 | J_1KFREPRE | REPRES | REPRES | CHAR | 10 | 0 | Name of Representative | ||
116 | J_1KFTBUS | GESTYP | GESTYP | CHAR | 30 | 0 | Type of Business | * | |
117 | J_1KFTIND | INDTYP | INDTYP | CHAR | 30 | 0 | Type of Industry | * | |
118 | NODEL_KNA1 | NODEL_X | XFELD | CHAR | 1 | 0 | Central deletion block for master record | ||
119 | DEAR6 | DEAR6 | XFELD | CHAR | 1 | 0 | Indicator: Consumer |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |