MANDT |
Client |
CLNT |
3 |
0 |
|
MANDT
|
|
KUNNR |
Customer Number |
CHAR |
10 |
0 |
|
KUNNR
|
|
ADRNR |
Address |
CHAR |
10 |
0 |
|
ADRNR
|
|
AUFSD |
Central order block for customer |
CHAR |
2 |
0 |
|
AUFSD_X
|
|
BAHNE |
Express train station |
CHAR |
25 |
0 |
|
BAHNE
|
|
BAHNS |
Train station |
CHAR |
25 |
0 |
|
BAHNS
|
|
BBBNR |
International location number (part 1) |
NUMC |
7 |
0 |
|
BBBNR
|
|
BBSNR |
International location number (Part 2) |
NUMC |
5 |
0 |
|
BBSNR
|
|
BEGRU |
Authorization Group |
CHAR |
4 |
0 |
|
BRGRU
|
|
BRSCH |
Industry key |
CHAR |
4 |
0 |
|
BRSCH
|
|
BUBKZ |
Check digit for the international location number |
NUMC |
1 |
0 |
|
BUBKZ
|
|
DATLT |
Data communication line no. |
CHAR |
14 |
0 |
|
DATLT
|
|
ERDAT |
Date on which the Record Was Created |
DATS |
8 |
0 |
|
ERDAT_RF
|
|
ERNAM |
Name of Person who Created the Object |
CHAR |
12 |
0 |
|
ERNAM_RF
|
|
EXABL |
Indicator: Unloading points exist |
CHAR |
1 |
0 |
|
EXABL
|
|
FAKSD |
Central billing block for customer |
CHAR |
2 |
0 |
|
FAKSD_X
|
|
FISKN |
Account number of the master record with the fiscal address |
CHAR |
10 |
0 |
|
FISKN_D
|
|
KNAZK |
Working Time Calendar |
CHAR |
2 |
0 |
|
KNAZK
|
|
KNRZA |
Account Number of an Alternative Payer |
CHAR |
10 |
0 |
|
KNRZA
|
|
KONZS |
Group key |
CHAR |
10 |
0 |
|
KONZS
|
|
KTOKD |
Customer Account Group |
CHAR |
4 |
0 |
|
KTOKD
|
|
KUKLA |
Customer Classification |
CHAR |
2 |
0 |
|
KUKLA
|
|
LAND1 |
Country/Region Key |
CHAR |
3 |
0 |
|
LAND1_GP
|
|
LIFNR |
Account Number of Supplier |
CHAR |
10 |
0 |
|
LIFNR
|
|
LIFSD |
Central delivery block for the customer |
CHAR |
2 |
0 |
|
LIFSD_X
|
|
LOCCO |
City Coordinates |
CHAR |
10 |
0 |
|
LOCCO
|
|
LOEVM |
Central Deletion Flag for Master Record |
CHAR |
1 |
0 |
|
LOEVM_X
|
|
NIELS |
Nielsen ID |
CHAR |
2 |
0 |
|
NIELS
|
|
ORT01 |
City |
CHAR |
35 |
0 |
|
ORT01_GP
|
|
ORT02 |
District |
CHAR |
35 |
0 |
|
ORT02_GP
|
|
PFACH |
PO Box |
CHAR |
10 |
0 |
|
PFACH
|
|
PSTL2 |
P.O. Box Postal Code |
CHAR |
10 |
0 |
|
PSTL2
|
|
PSTLZ |
Postal Code |
CHAR |
10 |
0 |
|
PSTLZ
|
|
REGIO |
Region (State, Province, County) |
CHAR |
3 |
0 |
|
REGIO
|
|
COUNC |
County Code |
CHAR |
3 |
0 |
|
COUNC
|
|
CITYC |
City Code |
CHAR |
4 |
0 |
|
CITYC
|
|
RPMKR |
Regional market |
CHAR |
5 |
0 |
|
RPMKR
|
|
SPERR |
Central posting block |
CHAR |
1 |
0 |
|
SPERB_X
|
|
SPRAS |
Language Key |
LANG |
1 |
0 |
|
SPRAS
|
|
STCD1 |
Tax Number 1 |
CHAR |
16 |
0 |
|
STCD1
|
|
STCD2 |
Tax Number 2 |
CHAR |
11 |
0 |
|
STCD2
|
|
STKZA |
Indicator: Business Partner Subject to Equalization Tax? |
CHAR |
1 |
0 |
|
STKZA
|
|
Not subject to equalization tax |
X |
Subject to equalization tax |
|
STKZU |
Liable for VAT |
CHAR |
1 |
0 |
|
STKZU
|
|
STRAS |
Street and House Number |
CHAR |
35 |
0 |
|
STRAS_GP
|
|
TELBX |
Telebox number |
CHAR |
15 |
0 |
|
TELBX
|
|
TELF1 |
First telephone number |
CHAR |
16 |
0 |
|
TELF1
|
|
TELF2 |
Second telephone number |
CHAR |
16 |
0 |
|
TELF2
|
|
TELFX |
Fax Number |
CHAR |
31 |
0 |
|
TELFX
|
|
TELTX |
Teletex number |
CHAR |
30 |
0 |
|
TELTX
|
|
TELX1 |
Telex number |
CHAR |
30 |
0 |
|
TELX1
|
|
LZONE |
Transportation zone to or from which the goods are delivered |
CHAR |
10 |
0 |
|
LZONE
|
|
XCPDK |
Indicator: Is the account a one-time account? |
CHAR |
1 |
0 |
|
XCPDK
|
|
XZEMP |
Indicator: Alternative Payee in Document Allowed? |
CHAR |
1 |
0 |
|
XZEMP
|
|
VBUND |
Company ID of Trading Partner |
CHAR |
6 |
0 |
|
RASSC
|
|
STCEG |
VAT Registration Number |
CHAR |
20 |
0 |
|
STCEG
|
|
DEAR1 |
Indicator: Competitor |
CHAR |
1 |
0 |
|
DEAR1
|
|
DEAR2 |
Indicator: Sales partner |
CHAR |
1 |
0 |
|
DEAR2
|
|
DEAR3 |
Indicator: Sales prospect |
CHAR |
1 |
0 |
|
DEAR3
|
|
DEAR4 |
Indicator for customer type 4 |
CHAR |
1 |
0 |
|
DEAR4
|
|
DEAR5 |
ID for default sold-to party |
CHAR |
1 |
0 |
|
DEAR5
|
|
DEAR6 |
Indicator: Consumer |
CHAR |
1 |
0 |
|
DEAR6
|
|
GFORM |
Legal status |
CHAR |
2 |
0 |
|
GFORM
|
|
BRAN1 |
Industry code 1 |
CHAR |
10 |
0 |
|
BRAN1_D
|
|
BRAN2 |
Industry code 2 |
CHAR |
10 |
0 |
|
BRAN2
|
|
BRAN3 |
Industry code 3 |
CHAR |
10 |
0 |
|
BRAN3
|
|
BRAN4 |
Industry code 4 |
CHAR |
10 |
0 |
|
BRAN4
|
|
BRAN5 |
Industry code 5 |
CHAR |
10 |
0 |
|
BRAN5
|
|
EKONT |
Initial contact |
CHAR |
10 |
0 |
|
EKONT
|
|
UMSAT |
Annual sales |
CURR |
8 |
2 |
|
UMSAT
|
|
UMJAH |
Year For Which Sales are Given |
NUMC |
4 |
0 |
|
UMJAH
|
|
UWAER |
Currency of sales figure |
CUKY |
5 |
0 |
|
UWAER
|
|
JMZAH |
Yearly number of employees |
NUMC |
6 |
0 |
|
JMZAH
|
|
JMJAH |
Year for which the number of employees is given |
NUMC |
4 |
0 |
|
JMJAH
|
|
KATR1 |
Attribute 1 |
CHAR |
2 |
0 |
|
KATR1
|
|
KATR2 |
Attribute 2 |
CHAR |
2 |
0 |
|
KATR2
|
|
KATR3 |
Attribute 3 |
CHAR |
2 |
0 |
|
KATR3
|
|
KATR4 |
Attribute 4 |
CHAR |
2 |
0 |
|
KATR4
|
|
KATR5 |
Attribute 5 |
CHAR |
2 |
0 |
|
KATR5
|
|
KATR6 |
Attribute 6 |
CHAR |
3 |
0 |
|
KATR6
|
|
KATR7 |
Attribute 7 |
CHAR |
3 |
0 |
|
KATR7
|
|
KATR8 |
Attribute 8 |
CHAR |
3 |
0 |
|
KATR8
|
|
KATR9 |
Attribute 9 |
CHAR |
3 |
0 |
|
KATR9
|
|
KATR10 |
Attribute 10 |
CHAR |
3 |
0 |
|
KATR10
|
|
STKZN |
Natural Person |
CHAR |
1 |
0 |
|
STKZN
|
|
Legal person |
X |
Natural person |
|
UMSA1 |
Annual sales |
CURR |
15 |
2 |
|
UMSA1
|
|
TXJCD |
Tax Jurisdiction |
CHAR |
15 |
0 |
|
TXJCD
|
|
MCOD1 |
Search term for matchcode search |
CHAR |
25 |
0 |
|
MCDD1
|
|
MCOD2 |
Search Term for Matchcode Search |
CHAR |
25 |
0 |
|
MCDD2
|
|
MCOD3 |
Search term for matchcode search |
CHAR |
25 |
0 |
|
MCDD3
|
|
PERIV |
Fiscal Year Variant |
CHAR |
2 |
0 |
|
PERIV
|
|
ABRVW |
Usage Indicator |
CHAR |
3 |
0 |
|
ABRVW
|
|
INSPBYDEBI |
Inspection Carried Out By Customer (No Inspection Lot) |
CHAR |
1 |
0 |
|
QINSPBYDEB
|
|
INSPATDEBI |
Inspection for a Delivery Note After Outbound Delivery |
CHAR |
1 |
0 |
|
QINSPATDEB
|
|
KTOCD |
Reference Account Group for One-Time Account (Customer) |
CHAR |
4 |
0 |
|
KTOCD
|
|
PFORT |
PO Box city |
CHAR |
35 |
0 |
|
PFORT_GP
|
|
WERKS |
Plant |
CHAR |
4 |
0 |
|
WERKS_D
|
|
DTAMS |
Report key for data medium exchange |
CHAR |
1 |
0 |
|
DTAMS
|
|
Use house bank default value |
0 |
Single data record can be forwarded to the Bundesbank |
1 |
Single data record not to be forwarded to the Bundesbank |
|
DTAWS |
Instruction Key for Data Medium Exchange |
CHAR |
2 |
0 |
|
DTAWS
|
|
DUEFL |
Status of Data Transfer into Subsequent Release |
CHAR |
1 |
0 |
|
DUEFL_BKPF
|
|
Not transferred yet |
A |
Transfer taken place, document changed later |
X |
Transfer taken place, document unchanged |
|
HZUOR |
Assignment to Hierarchy |
NUMC |
2 |
0 |
|
HZUOR
|
|
SPERZ |
Payment Block |
CHAR |
1 |
0 |
|
SPERZ
|
|
ETIKG |
IS-R Labeling: customer/plant group |
CHAR |
10 |
0 |
|
ETIKG
|
|
CIVVE |
ID for mainly non-military use |
CHAR |
1 |
0 |
|
CIVVE
|
|
MILVE |
ID for mainly military use |
CHAR |
1 |
0 |
|
MILVE
|
|
KDKG1 |
Customer condition group 1 |
CHAR |
2 |
0 |
|
KDKG1
|
|
KDKG2 |
Customer condition group 2 |
CHAR |
2 |
0 |
|
KDKG2
|
|
KDKG3 |
Customer condition group 3 |
CHAR |
2 |
0 |
|
KDKG3
|
|
KDKG4 |
Customer condition group 4 |
CHAR |
2 |
0 |
|
KDKG4
|
|
KDKG5 |
Customer condition group 5 |
CHAR |
2 |
0 |
|
KDKG5
|
|
XKNZA |
Indicator: Alternative payer using account number |
CHAR |
1 |
0 |
|
XKNZA
|
|
FITYP |
Tax type |
CHAR |
2 |
0 |
|
J_1AFITP_D
|
|
STCDT |
Tax Number Type |
CHAR |
2 |
0 |
|
J_1ATOID
|
|
STCD3 |
Tax Number 3 |
CHAR |
18 |
0 |
|
STCD3
|
|
STCD4 |
Tax Number 4 |
CHAR |
18 |
0 |
|
STCD4
|
|
XICMS |
Customer is ICMS-exempt |
CHAR |
1 |
0 |
|
J_1BTCICMS
|
|
XXIPI |
Customer is IPI-exempt |
CHAR |
1 |
0 |
|
J_1BTCIPI
|
|
XSUBT |
Customer group for Substituiçao Tributária calculation |
CHAR |
3 |
0 |
|
J_1BTCST
|
|
CFOPC |
Customer's CFOP category |
CHAR |
2 |
0 |
|
J_1BINDUS1
|
00 |
industry (cooperative) |
01 |
electric co. |
02 |
communication co. |
03 |
transport co. |
04 |
service co. |
05 |
consumer industry (cooperative) |
06 |
non-contributing customer |
07 |
agricultural customer |
08 |
trading company |
09 |
producer establishment |
|
TXLW1 |
Tax law: ICMS |
CHAR |
3 |
0 |
|
J_1BTAXLW1
|
|
TXLW2 |
Tax law: IPI |
CHAR |
3 |
0 |
|
J_1BTAXLW2
|
|
CCC01 |
Indicator for biochemical warfare for legal control |
CHAR |
1 |
0 |
|
CCC01
|
|
CCC02 |
Indicator for nuclear nonproliferation for legal control |
CHAR |
1 |
0 |
|
CCC02
|
|
CCC03 |
Indicator for national security for legal control |
CHAR |
1 |
0 |
|
CCC03
|
|
CCC04 |
Indicator for missile technology for legal control |
CHAR |
1 |
0 |
|
CCC04
|
|
CASSD |
Central sales block for customer |
CHAR |
2 |
0 |
|
CASSD_X
|
|
KNURL |
Uniform resource locator |
CHAR |
132 |
0 |
|
URL
|
|
PARNR |
Number of Contact Person |
NUMC |
10 |
0 |
|
PARNR
|
|
NAMEV |
First name |
CHAR |
35 |
0 |
|
NAMEV_VP
|
|
NAME1 |
Name 1 |
CHAR |
35 |
0 |
|
NAME1_GP
|
|
ADRND |
Business address |
CHAR |
10 |
0 |
|
ADRND
|
|
ADRNP |
Home address |
CHAR |
10 |
0 |
|
ADRNP
|
|
ABTPA |
Contact person's department at customer |
CHAR |
12 |
0 |
|
ABTEI_PA
|
|
ABTNR |
Contact person department |
CHAR |
4 |
0 |
|
ABTNR_PA
|
|
UEPAR |
Higher-Level Partner |
NUMC |
10 |
0 |
|
UEPAR
|
|
ANRED |
Form of address for contact person (Mr, Mrs...etc) |
CHAR |
30 |
0 |
|
ANRED_AP
|
|
PAFKT |
Contact person function |
CHAR |
2 |
0 |
|
PAFKT
|
|
PARVO |
Partner's Authority |
CHAR |
1 |
0 |
|
PARVO
|
|
PAVIP |
VIP Partner |
CHAR |
1 |
0 |
|
PAVIP
|
|
PARGE |
Partner's gender |
CHAR |
1 |
0 |
|
PARGE
|
|
PARLA |
Partner language |
LANG |
1 |
0 |
|
PARLA
|
|
GBDAT |
Date of Birth |
DATS |
8 |
0 |
|
GBDAT
|
|
VRTNR |
Representative number |
NUMC |
10 |
0 |
|
VTRNR
|
|
BRYTH |
Call frequency |
CHAR |
4 |
0 |
|
BRYTH
|
|
AKVER |
Buying habits |
CHAR |
2 |
0 |
|
AKVER
|
|
NMAIL |
Advertising material indicator |
CHAR |
1 |
0 |
|
NMAIL
|
|
PARAU |
Notes about contact person |
CHAR |
40 |
0 |
|
PARAU
|
|
PARH1 |
Contact person: Attribute 1 |
CHAR |
2 |
0 |
|
PAAT1
|
|
PARH2 |
Contact person: Attribute 2 |
CHAR |
2 |
0 |
|
PAAT2
|
|
PARH3 |
Contact person: Attribute 3 |
CHAR |
2 |
0 |
|
PAAT3
|
|
PARH4 |
Contact person: Attribute 4 |
CHAR |
2 |
0 |
|
PAAT4
|
|
PARH5 |
Contact person: Attribute 5 |
CHAR |
2 |
0 |
|
PAAT5
|
|
MOAB1 |
Contact person's visiting hours: Monday morning from ... |
TIMS |
6 |
0 |
|
BEMOAB1
|
|
MOBI1 |
Contact person's visiting hours: Monday morning until ... |
TIMS |
6 |
0 |
|
BEMOBI1
|
|
MOAB2 |
Contact person's visiting hours: Monday afternoon from ... |
TIMS |
6 |
0 |
|
BEMOAB2
|
|
MOBI2 |
Contact person's visiting hours: Monday afternoon until ... |
TIMS |
6 |
0 |
|
BEMOBI2
|
|
DIAB1 |
Contact person's visiting hours: Tuesday morning from... |
TIMS |
6 |
0 |
|
BEDIAB1
|
|
DIBI1 |
Contact person's visiting hours: Tuesday morning until ... |
TIMS |
6 |
0 |
|
BEDIBI1
|
|
DIAB2 |
Contact person's visiting hours: Tuesday afternoon from.. |
TIMS |
6 |
0 |
|
BEDIAB2
|
|
DIBI2 |
Contact person's visiting hours: Tuesday afternoon until ... |
TIMS |
6 |
0 |
|
BEDIBI2
|
|
MIAB1 |
Contact person's visiting hours: Wednesday morning from... |
TIMS |
6 |
0 |
|
BEMIAB1
|
|
MIBI1 |
Contact person's visiting hours: Wednesday morning until ... |
TIMS |
6 |
0 |
|
BEMIBI1
|
|
MIAB2 |
Contact person's visiting hours: Wednesday afternoon from .. |
TIMS |
6 |
0 |
|
BEMIAB2
|
|
MIBI2 |
Contact person's visiting hours: Wednesday afternoon until.. |
TIMS |
6 |
0 |
|
BEMIBI2
|
|
DOAB1 |
Contact person's visiting hours: Thursday morning from .... |
TIMS |
6 |
0 |
|
BEDOAB1
|
|
DOBI1 |
Contact person's visiting hours: Thursday morning until .... |
TIMS |
6 |
0 |
|
BEDOBI1
|
|
DOAB2 |
Contact person's visiting hours: Thursday afternoon from... |
TIMS |
6 |
0 |
|
BEDOAB2
|
|
DOBI2 |
Contact person's visiting hours: Thursday afternoon until .. |
TIMS |
6 |
0 |
|
BEDOBI2
|
|
FRAB1 |
Contact person's visiting hours: Friday morning from ... |
TIMS |
6 |
0 |
|
BEFRAB1
|
|
FRBI1 |
Contact person's visiting hours: Friday morning until ... |
TIMS |
6 |
0 |
|
BEFRBI1
|
|
FRAB2 |
Contact person's visiting hours: Friday afternoon from ... |
TIMS |
6 |
0 |
|
BEFRAB2
|
|
FRBI2 |
Contact person's visiting hours: Friday afternoon until ... |
TIMS |
6 |
0 |
|
BEFRBI2
|
|
SAAB1 |
Contact person's visiting hours: Saturday morning from ... |
TIMS |
6 |
0 |
|
BESAAB1
|
|
SABI1 |
Contact person's visiting hours: Saturday morning until ... |
TIMS |
6 |
0 |
|
BESABI1
|
|
SAAB2 |
Contact person's visiting hours: Saturday afternoon from ... |
TIMS |
6 |
0 |
|
BESAAB2
|
|
SABI2 |
Contact person's visiting hours: Saturday afternoon until .. |
TIMS |
6 |
0 |
|
BESABI2
|
|
SOAB1 |
Contact person's visiting hours: Sunday morning from ... |
TIMS |
6 |
0 |
|
BESOAB1
|
|
SOBI1 |
Contact person's visiting hours: Sunday morning until ... |
TIMS |
6 |
0 |
|
BESOBI1
|
|
SOAB2 |
Contact person's visiting hours: Sunday afternoon from ... |
TIMS |
6 |
0 |
|
BESOAB2
|
|
SOBI2 |
Contact person's visiting hours: Sunday afternoon until ... |
TIMS |
6 |
0 |
|
BESOBI2
|
|
PAKN1 |
Contact person: Attribute 6 |
CHAR |
3 |
0 |
|
PAAT6
|
|
PAKN2 |
Contact person: Attribute 7 |
CHAR |
3 |
0 |
|
PAAT7
|
|
PAKN3 |
Contact person: Attribute 8 |
CHAR |
3 |
0 |
|
PAAT8
|
|
PAKN4 |
Contact person: Attribute 9 |
CHAR |
3 |
0 |
|
PAAT9
|
|
PAKN5 |
Contact person: Attribute 10 |
CHAR |
3 |
0 |
|
PAAT0
|
|
SORTL |
Sort field |
CHAR |
10 |
0 |
|
SORTL
|
|
FAMST |
Marital Status Key |
CHAR |
1 |
0 |
|
FAMST
|
|
SPNAM |
Nickname |
CHAR |
10 |
0 |
|
SPNAM
|
|
TITEL_AP |
Title of contact person (description of function) |
CHAR |
35 |
0 |
|
TITEL_AP
|
|
KZHERK |
Internal indicator for origin of the CP: Customer or Vendor |
CHAR |
1 |
0 |
|
KZHERK
|
|
ADRNP_2 |
Address Number |
CHAR |
10 |
0 |
|
AD_ADDRNUM
|
|
PRSNR |
Person Number |
CHAR |
10 |
0 |
|
AD_PERSNUM
|
|