SAP ABAP Table RJGBUSISM007_CUST_STAT_STR (IS-M: Business Partner All KN* Attributes STAT)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
Basic Data
Table Category | INTTAB | Structure |
Structure | RJGBUSISM007_CUST_STAT_STR | Table Relationship Diagram |
Short Description | IS-M: Business Partner All KN* Attributes STAT |
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 | KNA1 | RJGBP_KNA1_STAT_STR | STRU | 0 | 0 | ||||
2 | .INCLUDE | 0 | 0 | General Data in Customer Master | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
4 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | ||
5 | LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | ||
6 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
7 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
8 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
9 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
10 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | ||
11 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
12 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
13 | TELF1 | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
14 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
15 | XCPDK | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
16 | ADRNR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | ||
17 | MCOD1 | MCDD1 | CHAR25 | CHAR | 25 | 0 | Search term for matchcode search | ||
18 | MCOD2 | MCDD2 | CHAR25 | CHAR | 25 | 0 | Search Term for Matchcode Search | ||
19 | MCOD3 | MCDD3 | CHAR25 | CHAR | 25 | 0 | Search term for matchcode search | ||
20 | .INCLUDE | 0 | 0 | General Data in Customer Master | |||||
21 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
22 | AUFSD | AUFSD_X | KAUFS | CHAR | 2 | 0 | Central order block for customer | ||
23 | BAHNE | BAHNE | BAHNH | CHAR | 25 | 0 | Express train station | ||
24 | BAHNS | BAHNS | BAHNH | CHAR | 25 | 0 | Train station | ||
25 | BBBNR | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
26 | BBSNR | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
27 | BEGRU | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | ||
28 | BRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | ||
29 | BUBKZ | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
30 | DATLT | DATLT | TEXT14 | CHAR | 14 | 0 | Data communication line no. | ||
31 | ERDAT | ERDAT_RF | DATUM | DATS | 8 | 0 | Date on which the Record Was Created | ||
32 | ERNAM | ERNAM_RF | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
33 | EXABL | EXABL | XFELD | CHAR | 1 | 0 | Indicator: Unloading points exist | ||
34 | FAKSD | FAKSD_X | FAKSP | CHAR | 2 | 0 | Central billing block for customer | ||
35 | FISKN | FISKN_D | KUNNR | CHAR | 10 | 0 | Account number of the master record with the fiscal address | ||
36 | KNAZK | KNAZK | WFCID | CHAR | 2 | 0 | Working Time Calendar | ||
37 | KNRZA | KNRZA | KUNNR | CHAR | 10 | 0 | Account number of an alternative payer | ||
38 | KONZS | KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
39 | KTOKD | KTOKD | KTOKD | CHAR | 4 | 0 | Customer Account Group | ||
40 | KUKLA | KUKLA | KUKLA | CHAR | 2 | 0 | Customer classification | ||
41 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | ||
42 | LIFSD | LIFSD_X | LIFSP | CHAR | 2 | 0 | Central delivery block for the customer | ||
43 | LOCCO | LOCCO | LOCCO | CHAR | 10 | 0 | City Coordinates | ||
44 | LOEVM | LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
45 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
46 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
47 | NIELS | NIELS | NIELS | CHAR | 2 | 0 | Nielsen ID | ||
48 | ORT02 | ORT02_GP | TEXT35 | CHAR | 35 | 0 | District | ||
49 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
50 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
51 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | ||
52 | CITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | ||
53 | RPMKR | RPMKR | RPMKR | CHAR | 5 | 0 | Regional market | ||
54 | SPERR | SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
55 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | ||
56 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
57 | STCD2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
58 | STKZA | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
59 | STKZU | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
60 | TELBX | TELBX | TEXT15 | CHAR | 15 | 0 | Telebox number | ||
61 | TELF2 | TELF2 | TEXT16 | CHAR | 16 | 0 | Second telephone number | ||
62 | TELTX | TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
63 | TELX1 | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
64 | LZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | ||
65 | XZEMP | XREGU | XFELD | CHAR | 1 | 0 | Indicator: Is an alternative payer allowed in document? | ||
66 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | ||
67 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
68 | DEAR1 | DEAR1 | XFELD | CHAR | 1 | 0 | Indicator: Competitor | ||
69 | DEAR2 | DEAR2 | XFELD | CHAR | 1 | 0 | Indicator: Sales partner | ||
70 | DEAR3 | DEAR3 | DEAR3 | CHAR | 1 | 0 | Indicator: Sales prospect | ||
71 | DEAR4 | DEAR4 | XFELD | CHAR | 1 | 0 | Indicator for customer type 4 | ||
72 | DEAR5 | DEAR5 | XFELD | CHAR | 1 | 0 | ID for default sold-to party | ||
73 | GFORM | GFORM | GFORM | CHAR | 2 | 0 | Legal status | ||
74 | BRAN1 | BRAN1_D | BRACO | CHAR | 10 | 0 | Industry code 1 | ||
75 | BRAN2 | BRAN2 | BRACO | CHAR | 10 | 0 | Industry code 2 | ||
76 | BRAN3 | BRAN3 | BRACO | CHAR | 10 | 0 | Industry code 3 | ||
77 | BRAN4 | BRAN4 | BRACO | CHAR | 10 | 0 | Industry code 4 | ||
78 | BRAN5 | BRAN5 | BRACO | CHAR | 10 | 0 | Industry code 5 | ||
79 | EKONT | EKONT | VBELN | CHAR | 10 | 0 | Initial contact | ||
80 | UMSAT | UMSAT | UMSAT | CURR | 8 | 2 | Annual sales | ||
81 | UMJAH | UMJAH | JAHR | NUMC | 4 | 0 | Year For Which Sales are Given | ||
82 | UWAER | UWAER | WAERS | CUKY | 5 | 0 | Currency of Sales Volume | ||
83 | JMZAH | JMZAH | JMZAH | NUMC | 6 | 0 | Yearly number of employees | ||
84 | JMJAH | JMJAH | JAHR | NUMC | 4 | 0 | Year for which the number of employees is given | ||
85 | KATR1 | KATR1 | ATTR1 | CHAR | 2 | 0 | Attribute 1 | ||
86 | KATR2 | KATR2 | ATTR2 | CHAR | 2 | 0 | Attribute 2 | ||
87 | KATR3 | KATR3 | ATTR3 | CHAR | 2 | 0 | Attribute 3 | ||
88 | KATR4 | KATR4 | ATTR4 | CHAR | 2 | 0 | Attribute 4 | ||
89 | KATR5 | KATR5 | ATTR5 | CHAR | 2 | 0 | Attribute 5 | ||
90 | KATR6 | KATR6 | ATTR6 | CHAR | 3 | 0 | Attribute 6 | ||
91 | KATR7 | KATR7 | ATTR7 | CHAR | 3 | 0 | Attribute 7 | ||
92 | KATR8 | KATR8 | ATTR8 | CHAR | 3 | 0 | Attribute 8 | ||
93 | KATR9 | KATR9 | ATTR9 | CHAR | 3 | 0 | Attribute 9 | ||
94 | KATR10 | KATR10 | ATTR10 | CHAR | 3 | 0 | Attribute 10 | ||
95 | STKZN | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
96 | UMSA1 | UMSA1 | UMSA1 | CURR | 15 | 2 | Annual sales | ||
97 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
98 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | ||
99 | ABRVW | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | ||
100 | INSPBYDEBI | QINSPBYDEB | QKZ | CHAR | 1 | 0 | Inspection Carried Out By Customer (No Inspection Lot) | ||
101 | INSPATDEBI | QINSPATDEB | QKZ | CHAR | 1 | 0 | Inspection for a Delivery Note After Outbound Delivery | ||
102 | KTOCD | KTOCD | KTOKD | CHAR | 4 | 0 | Reference Account Group for One-Time Account (Customer) | ||
103 | PFORT | PFORT_GP | TEXT35 | CHAR | 35 | 0 | PO Box city | ||
104 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | ||
105 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
106 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | ||
107 | DUEFL | DUEFL_BKPF | DUEFL_BKPF | CHAR | 1 | 0 | Status of Data Transfer into Subsequent Release | ||
108 | HZUOR | HZUOR | HZUOR | NUMC | 2 | 0 | Assignment to Hierarchy | ||
109 | SPERZ | SPERZ | XFELD | CHAR | 1 | 0 | Payment Block | ||
110 | ETIKG | ETIKG | ETIKG | CHAR | 10 | 0 | IS-R Labeling: customer/plant group | ||
111 | CIVVE | CIVVE | XFELD | CHAR | 1 | 0 | ID for mainly non-military use | ||
112 | MILVE | MILVE | XFELD | CHAR | 1 | 0 | ID for mainly military use | ||
113 | KDKG1 | KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | ||
114 | KDKG2 | KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | ||
115 | KDKG3 | KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | ||
116 | KDKG4 | KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | ||
117 | KDKG5 | KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | ||
118 | XKNZA | XKNZA | XFELD | CHAR | 1 | 0 | Indicator: Alternative payer using account number | ||
119 | FITYP | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | ||
120 | STCDT | J_1ATOID | J_1ATOID | CHAR | 2 | 0 | Tax Number Type | ||
121 | STCD3 | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
122 | STCD4 | STCD4 | CHAR18 | CHAR | 18 | 0 | Tax Number 4 | ||
123 | STCD5 | STCD5 | CHAR60 | CHAR | 60 | 0 | Tax Number 5 | ||
124 | XICMS | J_1BTCICMS | XFELD | CHAR | 1 | 0 | Customer is ICMS-exempt | ||
125 | XXIPI | J_1BTCIPI | XFELD | CHAR | 1 | 0 | Customer is IPI-exempt | ||
126 | XSUBT | J_1BTCST | J_1BTCST1 | CHAR | 3 | 0 | Customer group for Substituiçao Tributária calculation | ||
127 | CFOPC | J_1BINDUS1 | J_1BINDUS1 | CHAR | 2 | 0 | Customer's CFOP category | ||
128 | TXLW1 | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | ||
129 | TXLW2 | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | ||
130 | CCC01 | CCC01 | XFELD | CHAR | 1 | 0 | Indicator for biochemical warfare for legal control | ||
131 | CCC02 | CCC02 | XFELD | CHAR | 1 | 0 | Indicator for nuclear nonproliferation for legal control | ||
132 | CCC03 | CCC03 | XFELD | CHAR | 1 | 0 | Indicator for national security for legal control | ||
133 | CCC04 | CCC04 | XFELD | CHAR | 1 | 0 | Indicator for missile technology for legal control | ||
134 | CASSD | CASSD_X | CASSP | CHAR | 2 | 0 | Central sales block for customer | ||
135 | KNURL | URL | TEXT132 | CHAR | 132 | 0 | Uniform resource locator | ||
136 | J_1KFREPRE | REPRES | REPRES | CHAR | 10 | 0 | Name of Representative | ||
137 | J_1KFTBUS | GESTYP | GESTYP | CHAR | 30 | 0 | Type of Business | ||
138 | J_1KFTIND | INDTYP | INDTYP | CHAR | 30 | 0 | Type of Industry | ||
139 | CONFS | CONFS_X | CHAR1 | CHAR | 1 | 0 | Status of Change Authorization (Central) | ||
140 | UPDAT | UPDAT_RF | DATUM | DATS | 8 | 0 | Date on Which the Changes Were Confirmed | ||
141 | UPTIM | UPTIM_RF | AS4TIME | TIMS | 6 | 0 | Time of Last Change Confirmation | ||
142 | NODEL | NODEL_X | XFELD | CHAR | 1 | 0 | Central deletion block for master record | ||
143 | DEAR6 | DEAR6 | XFELD | CHAR | 1 | 0 | Indicator: Consumer | ||
144 | .INCLUDE | 0 | 0 | Customer Master Data - Brazil | |||||
145 | SUFRAMA | J_1BSUFRAMA | J_1BSUFRAMA | CHAR | 9 | 0 | Suframa Code | ||
146 | RG | J_1BRG | J_1BRG | CHAR | 11 | 0 | RG Number | ||
147 | EXP | J_1BEXP | J_1BEXP | CHAR | 3 | 0 | Issued by | ||
148 | UF | J_1BUF | J_1BUF | CHAR | 2 | 0 | State | ||
149 | RGDATE | J_1BRGDATE | DATUM | DATS | 8 | 0 | RG Issue Date | ||
150 | RIC | J_1BRIC | J_1BRIC | NUMC | 11 | 0 | RIC Number | ||
151 | RNE | J_1BRNE | J_1BRNE | CHAR | 10 | 0 | Foreign National Registration | ||
152 | RNEDATE | J_1BRNEDATE | DATUM | DATS | 8 | 0 | RNE Issue Date | ||
153 | CNAE | J_1BCNAE | J_1BCNAE | CHAR | 7 | 0 | CNAE | ||
154 | LEGALNAT | J_1BLEGALNAT | J_1BLEGALNAT | NUMC | 4 | 0 | Legal Nature | ||
155 | CRTN | J_1BCRTN | J_1BCRTN | CHAR | 1 | 0 | CRT Number | ||
156 | ICMSTAXPAY | J_1BICMSTAXPAY | J_1BICMSTAXPAY | CHAR | 2 | 0 | ICMS Taxpayer | ||
157 | INDTYP | J_1BINDTYP | J_1BINDTYP | CHAR | 2 | 0 | Industry Main Type | ||
158 | TDT | J_1BTDT | J_1BTDT | CHAR | 2 | 0 | Tax Declaration Type | ||
159 | COMSIZE | J_1BCOMSIZE | J_1BCOMSIZE | CHAR | 2 | 0 | Company Size | ||
160 | DECREGPC | J_1BDECREGPC | J_1BDECREGPC | CHAR | 2 | 0 | Declaration Regimen for PIS/COFINS | ||
161 | .INCLU--AP | 0 | 0 | Append to KNA1 for Vehicle Space Optimization | |||||
162 | .INCLUDE | 0 | 0 | Additional Data for Vehicle Space Optimization for KNA1 | |||||
163 | /VSO/R_PALHGT | /VSO/R_PAL_BIN_HGT | MENG13 | QUAN | 13 | 3 | Maximum Stacking Height of the Packaging Material (VSO) | ||
164 | /VSO/R_PAL_UL | /VSO/R_PAL_UNIT_L | MEINS | UNIT | 3 | 0 | Unit of Length for Packaging Material (VSO) | ||
165 | /VSO/R_PK_MAT | /VSO/M_PACK_BY_MAT | /VSO/M_XFIELD | CHAR | 1 | 0 | Customer-Related Packing for Each Packaging Material (VSO) | ||
166 | /VSO/R_MATPAL | /VSO/M_MATNR_PAL | MATNR | CHAR | 18 | 0 | Packaging Material of the Customer in VSO | ||
167 | /VSO/R_I_NO_LYR | /VSO/M_IPAL_NO_LYR | /VSO/M_IPAL_NO_LYR | NUMC | 2 | 0 | Number Layers Under an Inter-Pallet (VSO) | ||
168 | /VSO/R_ONE_MAT | /VSO/M_ONE_MAT | /VSO/M_XFIELD | CHAR | 1 | 0 | Packing Material-Specific for Each Packaging Material | ||
169 | /VSO/R_ONE_SORT | /VSO/M_ONE_SORT | /VSO/M_XFIELD | CHAR | 1 | 0 | Pack Only One Package Type for Each PKM (VSO) | ||
170 | /VSO/R_ULD_SIDE | /VSO/M_UNLOAD_SIDE_PREF | /VSO/M_SIDE_PREF | NUMC | 1 | 0 | Side Preference of Loading/Unloading (VSO) | ||
171 | /VSO/R_LOAD_PREF | /VSO/M_LOAD_PREF | /VSO/M_LOAD_PREF | NUMC | 1 | 0 | Front/Back Preference of Loading/Unloading (VSO) | ||
172 | /VSO/R_DPOINT | /VSO/R_DELIVERYPOINT | /VSO/R_DELIVERYPOINT | CHAR | 10 | 0 | Collective Unloading Point for VSO | ||
173 | .INCLU--AP | 0 | 0 | US Federal Government Customer Master Data Additional Fields | |||||
174 | ALC | FMFG_ALC | FMFG_ALC | CHAR | 8 | 0 | Agency Location Code | ||
175 | PMT_OFFICE | FMFG_PMT_OFF | FMFG_PMT_OFF | CHAR | 5 | 0 | Payment Office | ||
176 | .INCLUDE | 0 | 0 | ||||||
177 | .INCLU--AP | 0 | 0 | Local Authority Additional Fields | |||||
178 | PSOFG | PSOFG | PSOFG | CHAR | 10 | 0 | Processor group | ||
179 | PSOIS | PSOIS | CHAR20 | CHAR | 20 | 0 | Subledger acct preprocessing procedure | ||
180 | .INCLUDE | 0 | 0 | Local Authority Additional Fields (Address) | |||||
181 | PSON1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
182 | PSON2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
183 | PSON3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
184 | PSOVN | PSOVN | NAME | CHAR | 35 | 0 | First Name | ||
185 | PSOTL | PSOTL | FMPSOTL | CHAR | 20 | 0 | Title | ||
186 | PSOHS | PSOHS | CHAR06 | CHAR | 6 | 0 | House number: is no longer used from Release 4.6B | ||
187 | PSOST | PSOST | PSOST | CHAR | 28 | 0 | Street: No longer used from Release 4.6B | ||
188 | .INCLUDE | 0 | 0 | Description (Customer/Vendor Supplement) | |||||
189 | PSOO1 | PSOO1 | TEXT50 | CHAR | 50 | 0 | Description | ||
190 | PSOO2 | PSOO1 | TEXT50 | CHAR | 50 | 0 | Description | ||
191 | PSOO3 | PSOO1 | TEXT50 | CHAR | 50 | 0 | Description | ||
192 | PSOO4 | PSOO1 | TEXT50 | CHAR | 50 | 0 | Description | ||
193 | PSOO5 | PSOO1 | TEXT50 | CHAR | 50 | 0 | Description | ||
194 | .INCLUDE | 0 | 0 | IS-M: JGBP BAPI Status Information STR (Template: BUS_ISTAT) | |||||
195 | AKTDB | BU_AKTDB | BU_AKTYP | CHAR | 2 | 0 | Activity in database for primary table BUT000 | ||
196 | KNB1 | RJGBP_KNB1_STAT_TAB | TTYP | 0 | 0 | ||||
197 | KNVV | RJGBP_KNVV_STAT_TAB | TTYP | 0 | 0 | ||||
198 | KNB5 | RJGBP_KNB5_STAT_TAB | TTYP | 0 | 0 | ||||
199 | KNVI | RJGBP_KNVI_STAT_TAB | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 464 |