- Accounting - General (AC)
- Controlling (CO)
- Cross-Application Sources (OCA)
- Customer Service (0CS)
- Enterprise Controlling (EC)
- Financial Accounting (FI)
- Investment Management (IM)
- Logistics - General (LO)
- Materials Management (MM)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Quality Management (QM)
- Real Estate Management (0RE)
- Sales and Distribution (SD)
- Time Management (PT)
- Training and Event Management (PE)
- Treasury (TR)
0CONSUMER_ATTR
- 🔑 Keys (5)
- 💰 Amounts (2)
- ∑ Quantities
- 📅 Dates (30)
- ☰ Categorical (31)
- Other (122)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| KUNNR | Customer Number | |
| LIFNR | Account Number of Supplier | |
| WERKS | Plant | |
| PARNR | Number of Contact Person |
| Column Name | Description | |
|---|---|---|
| 💲 Currency of sales figure (UWAER): | ||
| UMSAT | Annual sales | |
| UMSA1 | Annual sales | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ERDAT | Date on which the Record Was Created | |
| GBDAT | Date of Birth | |
| MOAB1 | Contact person's visiting hours: Monday morning from ... | |
| MOBI1 | Contact person's visiting hours: Monday morning until ... | |
| MOAB2 | Contact person's visiting hours: Monday afternoon from ... | |
| MOBI2 | Contact person's visiting hours: Monday afternoon until ... | |
| DIAB1 | Contact person's visiting hours: Tuesday morning from... | |
| DIBI1 | Contact person's visiting hours: Tuesday morning until ... | |
| DIAB2 | Contact person's visiting hours: Tuesday afternoon from.. | |
| DIBI2 | Contact person's visiting hours: Tuesday afternoon until ... | |
| MIAB1 | Contact person's visiting hours: Wednesday morning from... | |
| MIBI1 | Contact person's visiting hours: Wednesday morning until ... | |
| MIAB2 | Contact person's visiting hours: Wednesday afternoon from .. | |
| MIBI2 | Contact person's visiting hours: Wednesday afternoon until.. | |
| DOAB1 | Contact person's visiting hours: Thursday morning from .... | |
| DOBI1 | Contact person's visiting hours: Thursday morning until .... | |
| DOAB2 | Contact person's visiting hours: Thursday afternoon from... | |
| DOBI2 | Contact person's visiting hours: Thursday afternoon until .. | |
| FRAB1 | Contact person's visiting hours: Friday morning from ... | |
| FRBI1 | Contact person's visiting hours: Friday morning until ... | |
| FRAB2 | Contact person's visiting hours: Friday afternoon from ... | |
| FRBI2 | Contact person's visiting hours: Friday afternoon until ... | |
| SAAB1 | Contact person's visiting hours: Saturday morning from ... | |
| SABI1 | Contact person's visiting hours: Saturday morning until ... | |
| SAAB2 | Contact person's visiting hours: Saturday afternoon from ... | |
| SABI2 | Contact person's visiting hours: Saturday afternoon until .. | |
| SOAB1 | Contact person's visiting hours: Sunday morning from ... | |
| SOBI1 | Contact person's visiting hours: Sunday morning until ... | |
| SOAB2 | Contact person's visiting hours: Sunday afternoon from ... | |
| SOBI2 | Contact person's visiting hours: Sunday afternoon until ... |
| Column Name | Description | |
|---|---|---|
| EXABL | Indicator: Unloading points exist | Show values |
| LOEVM | Central Deletion Flag for Master Record | Show values |
| SPERR | Central posting block | Show values |
| STKZA | Indicator: Business Partner Subject to Equalization Tax? | Show values |
| STKZU | Liable for VAT | Show values |
| XCPDK | Indicator: Is the account a one-time account? | Show values |
| XZEMP | Indicator: Alternative Payee in Document Allowed? | Show values |
| DEAR1 | Indicator: Competitor | Show values |
| DEAR2 | Indicator: Sales partner | Show values |
| DEAR3 | Indicator: Sales prospect | Show values |
| DEAR4 | Indicator for customer type 4 | Show values |
| DEAR5 | ID for default sold-to party | Show values |
| DEAR6 | Indicator: Consumer | Show values |
| STKZN | Natural Person | Show values |
| INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | Show values |
| INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | Show values |
| DTAMS | Report key for data medium exchange | Show values |
| DUEFL | Status of Data Transfer into Subsequent Release | Show values |
| SPERZ | Payment Block | Show values |
| CIVVE | ID for mainly non-military use | Show values |
| MILVE | ID for mainly military use | Show values |
| XKNZA | Indicator: Alternative payer using account number | Show values |
| XICMS | Customer is ICMS-exempt | Show values |
| XXIPI | Customer is IPI-exempt | Show values |
| CFOPC | Customer's CFOP category | Show values |
| CCC01 | Indicator for biochemical warfare for legal control | Show values |
| CCC02 | Indicator for nuclear nonproliferation for legal control | Show values |
| CCC03 | Indicator for national security for legal control | Show values |
| CCC04 | Indicator for missile technology for legal control | Show values |
| NMAIL | Advertising material indicator | Show values |
| KZHERK | Internal indicator for origin of the CP: Customer or Vendor | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| ADRNR | Address | ADRNR | |
| AUFSD | Central order block for customer | KAUFS | |
| BAHNE | Express train station | BAHNH | |
| BAHNS | Train station | BAHNH | |
| BBBNR | International location number (part 1) | NUM07 | |
| BBSNR | International location number (Part 2) | NUM05 | |
| BEGRU | Authorization Group | BRGRU | |
| BRSCH | Industry key | BRSCH | |
| BUBKZ | Check digit for the international location number | NUM01 | |
| DATLT | Data communication line no. | TEXT14 | |
| ERNAM | Name of Person who Created the Object | USNAM | |
| FAKSD | Central billing block for customer | FAKSP | |
| FISKN | Account number of the master record with the fiscal address | KUNNR | |
| KNAZK | Working Time Calendar | WFCID | |
| KNRZA | Account Number of an Alternative Payer | KUNNR | |
| KONZS | Group key | KONZS | |
| KTOKD | Customer Account Group | KTOKD | |
| KUKLA | Customer Classification | KUKLA | |
| LAND1 | Country/Region Key | LAND1 | |
| LIFSD | Central delivery block for the customer | LIFSP | |
| LOCCO | City Coordinates | LOCCO | |
| NIELS | Nielsen ID | NIELS | |
| ORT01 | City | TEXT35 | |
| ORT02 | District | TEXT35 | |
| PFACH | PO Box | PFACH | |
| PSTL2 | P.O. Box Postal Code | PSTLZ | |
| PSTLZ | Postal Code | PSTLZ | |
| REGIO | Region (State, Province, County) | REGIO | |
| COUNC | County Code | COUNC | |
| CITYC | City Code | CITYC | |
| RPMKR | Regional market | RPMKR | |
| SPRAS | Language Key | SPRAS | |
| STCD1 | Tax Number 1 | STCD1 | |
| STCD2 | Tax Number 2 | STCD2 | |
| STRAS | Street and House Number | TEXT35 | |
| TELBX | Telebox number | TEXT15 | |
| TELF1 | First telephone number | TEXT16 | |
| TELF2 | Second telephone number | TEXT16 | |
| TELFX | Fax Number | TEXT31 | |
| TELTX | Teletex number | TEXT30 | |
| TELX1 | Telex number | TEXT30 | |
| LZONE | Transportation zone to or from which the goods are delivered | ZONE | |
| VBUND | Company ID of Trading Partner | RCOMP | |
| STCEG | VAT Registration Number | STCEG | |
| GFORM | Legal status | GFORM | |
| BRAN1 | Industry code 1 | BRACO | |
| BRAN2 | Industry code 2 | BRACO | |
| BRAN3 | Industry code 3 | BRACO | |
| BRAN4 | Industry code 4 | BRACO | |
| BRAN5 | Industry code 5 | BRACO | |
| EKONT | Initial contact | VBELN | |
| UMJAH | Year For Which Sales are Given | JAHR | |
| JMZAH | Yearly number of employees | JMZAH | |
| JMJAH | Year for which the number of employees is given | JAHR | |
| KATR1 | Attribute 1 | ATTR1 | |
| KATR2 | Attribute 2 | ATTR2 | |
| KATR3 | Attribute 3 | ATTR3 | |
| KATR4 | Attribute 4 | ATTR4 | |
| KATR5 | Attribute 5 | ATTR5 | |
| KATR6 | Attribute 6 | ATTR6 | |
| KATR7 | Attribute 7 | ATTR7 | |
| KATR8 | Attribute 8 | ATTR8 | |
| KATR9 | Attribute 9 | ATTR9 | |
| KATR10 | Attribute 10 | ATTR10 | |
| TXJCD | Tax Jurisdiction | TXJCD | |
| MCOD1 | Search term for matchcode search | CHAR25 | |
| MCOD2 | Search Term for Matchcode Search | CHAR25 | |
| MCOD3 | Search term for matchcode search | CHAR25 | |
| PERIV | Fiscal Year Variant | PERIV | |
| ABRVW | Usage Indicator | ABRVW | |
| KTOCD | Reference Account Group for One-Time Account (Customer) | KTOKD | |
| PFORT | PO Box city | TEXT35 | |
| DTAWS | Instruction Key for Data Medium Exchange | DTAWS | |
| HZUOR | Assignment to Hierarchy | HZUOR | |
| ETIKG | IS-R Labeling: customer/plant group | ETIKG | |
| KDKG1 | Customer condition group 1 | KDKGR | |
| KDKG2 | Customer condition group 2 | KDKGR | |
| KDKG3 | Customer condition group 3 | KDKGR | |
| KDKG4 | Customer condition group 4 | KDKGR | |
| KDKG5 | Customer condition group 5 | KDKGR | |
| FITYP | Tax type | J_1AFITP | |
| STCDT | Tax Number Type | J_1ATOID | |
| STCD3 | Tax Number 3 | CHAR18 | |
| STCD4 | Tax Number 4 | CHAR18 | |
| XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST1 | |
| TXLW1 | Tax law: ICMS | J_1BTAXLW1 | |
| TXLW2 | Tax law: IPI | J_1BTAXLW2 | |
| CASSD | Central sales block for customer | CASSP | |
| KNURL | Uniform resource locator | TEXT132 | |
| NAMEV | First name | NAME | |
| NAME1 | Name 1 | NAME | |
| ADRND | Business address | ADRNR | |
| ADRNP | Home address | ADRNR | |
| ABTPA | Contact person's department at customer | ABTEI | |
| ABTNR | Contact person department | ABTNR | |
| UEPAR | Higher-Level Partner | PARNR | |
| ANRED | Form of address for contact person (Mr, Mrs...etc) | TEXT30 | |
| PAFKT | Contact person function | PAFKT | |
| PARVO | Partner's Authority | PARVO | |
| PAVIP | VIP Partner | PAVIP | |
| PARGE | Partner's gender | AD_SEX | |
| PARLA | Partner language | SPRAS | |
| VRTNR | Representative number | VTRNR | |
| BRYTH | Call frequency | BRYTH | |
| AKVER | Buying habits | AKVER | |
| PARAU | Notes about contact person | TEXT40 | |
| PARH1 | Contact person: Attribute 1 | PARHO | |
| PARH2 | Contact person: Attribute 2 | PAAT2 | |
| PARH3 | Contact person: Attribute 3 | PAAT3 | |
| PARH4 | Contact person: Attribute 4 | PAAT4 | |
| PARH5 | Contact person: Attribute 5 | PAAT5 | |
| PAKN1 | Contact person: Attribute 6 | PAAT6 | |
| PAKN2 | Contact person: Attribute 7 | PAAT7 | |
| PAKN3 | Contact person: Attribute 8 | PAAT8 | |
| PAKN4 | Contact person: Attribute 9 | PAAT9 | |
| PAKN5 | Contact person: Attribute 10 | PAAT0 | |
| SORTL | Sort field | CHAR10 | |
| FAMST | Marital Status Key | FAMST | |
| SPNAM | Nickname | TEXT10 | |
| TITEL_AP | Title of contact person (description of function) | TEXT35 | |
| ADRNP_2 | Address Number | AD_ADDRNUM | |
| PRSNR | Person Number | AD_PERSNUM |