ISU_IN_COLL_BILL_S_CDOC_HEAD SAP (Header Data for Aggregated Bill Documents) Structure details
Description: Header Data for Aggregated Bill Documents
Related tables to ISU_IN_COLL_BILL_S_CDOC_HEAD
Access table ISU_IN_COLL_BILL_S_CDOC_HEAD
Structure field list including key, data, relationships and ABAP select examples
ISU_IN_COLL_BILL_S_CDOC_HEAD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Header Data for Aggregated Bill Documents" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ISU_IN_COLL_BILL_S_CDOC_HEAD TYPE ISU_IN_COLL_BILL_S_CDOC_HEAD.
The ISU_IN_COLL_BILL_S_CDOC_HEAD table consists of various fields, each holding specific information or linking keys about Header Data for Aggregated Bill Documents data available in SAP. These include MANDT (Client), OPBEL (Number of print document), DRUCKDAT (Print Date), FAEDN (Due date for net payment).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP ISU_IN_COLL_BILL_S_CDOC_HEAD structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
WA_CDOC_HEAD | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
OPBEL | Number of print document | E_PRINTDOC | CHAR | 12 | ALPHA | E_PRINTDOC | E_PRINTDOC | ||
DRUCKDAT | Print Date | DRUCKDAT | DATS | 8 | DATUM | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
STOKZ | Document Has Been Reversed | STOKZ | CHAR | 1 | KENNZX | ||||
INTOPBEL | Number of Print Document Used to Reverse Document | INTOPBEL | CHAR | 12 | ALPHA | E_PRINTDOC | |||
ERDZ_V | ERDZ/ERDL exists for ERDK | ERDZ_V | CHAR | 1 | KENNZX | ||||
ERDR_V | ERDR exists for ERDK | ERDR_V | CHAR | 1 | KENNZX | ||||
ERDO_V | ERDO exists for ERDK | ERDO_V | CHAR | 1 | KENNZX | ||||
ERDB_V | ERDB exists for ERDK | ERDB_V | CHAR | 1 | KENNZX | ||||
ERDU_V | ERDU exists for ERDK | ERDU_V | CHAR | 1 | KENNZX | ||||
ERDTS_V | ERDTS exists for ERDK | ERDTS_V | CHAR | 1 | KENNZX | ||||
FICA_V | FI-CA Document Posted | FICA_V | CHAR | 1 | KENNZX | ||||
TOTAL_AMNT | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
TOTAL_WAER | Transaction Currency | BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
TOTAL_AMNT_USE | Indicator: Use of bill sum total | TOTAL_AMNT_USE | CHAR | 2 | TOTAL_AMNT_USE | ||||
PYMET | Payment Method | PYMET_KK | CHAR | 1 | PYMET_KK | ||||
ZSBTR | Total Amount from Bill Items in Payment Form | E_ZSBTR | CURR | 13(2) | WRTV7 | ||||
ZLSCH | Form ID for Attached Payment Medium | FIDZT | CHAR | 1 | FIDZT | ||||
NRZAS | Payment Form Number | NRZAS_KK | CHAR | 12 | ALPHA | NRZAS_KK | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
PORTION | Portion | PORTION | CHAR | 8 | PORTION | TPR | E420 | ||
ABRVORG | Billing Transaction | ABRVORG | CHAR | 2 | ABRVORG | ABV | |||
FORMKEY | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | FIKEY_KK | FKFI1 | |||
TOBRELEASD | Indicator: document not released yet | TOBRELEASD | CHAR | 1 | KENNZX | ||||
SIMULATED | Indicator: invoicing generates a simulated document | SIMULATED | CHAR | 1 | KENNZX | ||||
INVOICED | Indicator: document posted | INVOICED | CHAR | 1 | KENNZX | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
ABWBL | Number of the substitute FI-CA document | ABWBL_KK | CHAR | 12 | ALPHA | ABWBL_KK | |||
ERGRD | Reason for creating print document | ERGRD | CHAR | 2 | ERGRD | ||||
LANGU | Language in connection with the contract account | LANGU_ACC | LANG | 1 | ISOLA | SPRAS | |||
INVOICING_PARTY | Service Provider That Invoices the Contract | INVOICING_PARTY | CHAR | 10 | SERVICE_PROV | SERVICEPROVIDER | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
VERART | Clearing Type For Clearing Postings | VERART_KK | CHAR | 3 | CHAR3 | ||||
STO_BUDAT | Reversal Date of Original Document (Reversal Only) | STO_BUDAT | DATS | 8 | DATUM | ||||
STO_OPBEL | Document Number of Original Document (Only for Reversal) | STO_OPBEL | CHAR | 12 | ALPHA | E_PRINTDOC | |||
ICREASON | Reason for Reversal | BCREASON | CHAR | 2 | BCREASON | TE272_BCREASON_F4 | |||
MAZAE | Counter for several dunning notices to a business partner | MAZAE_KK | NUMC | 6 | NUMC6 | ||||
ITEMS_ARCHIVED | Line items are archived | ITEMS_ARCHIVED | CHAR | 1 | ISU_ARCH_KENNZ1 | ||||
EXKID | Key Identification | EXKID_KK | CHAR | 2 | EXKID_KK | ||||
EXBEL | Official Document Number | EXBEL_KK | CHAR | 16 | ALPHA | EXBEL_KK | |||
MAZAE_ABS | Counter for several dunning notices to a business partner | MAZAE_KK | NUMC | 6 | NUMC6 | ||||
PRINTLOCK | Document is Blocked for Printing | E_PRINTLOCK | CHAR | 1 | E_PRINTLOCK | ||||
EDIDISPATCH | Transmit Print Document Via EDI | E_EDIDISPATCH | CHAR | 1 | KENNZX | ||||
EDISENDDATE | Generation Date of EDI for Print Document | EDISENDDAT | DATS | 8 | DATUM | ||||
TAXDATE | Tax Determination Date | E_TAXDATE | DATS | 8 | DATS | ||||
CREATION_TIME | Time of Print Document Creation | E_CREATION_TIME | TIMS | 6 | TIME | ||||
BILLING_PERIOD | Billing Key Date (For Example January 2002) | E_BILLING_PERIOD | CHAR | 10 | E_BILLING_PERIOD | ||||
OSB_GROUP | On-Site Billing Group | E_OSB_GROUP | CHAR | 3 | |||||
REVLOCK | Reversal Block Indicator for Print Documents | E_REVLOCK | CHAR | 1 | E_REVLOCK | ||||
SEPA_PRENOT | Invoicing Document Contains SEPA Pre-Notification | E_SEPA_PRENOT | CHAR | 1 | XFELD | ||||
WA_CPROV | 0 | ||||||||
INVTHIRD | Request to Service Provider That Invoices Provider | INV_INVTHIRD | CHAR | 1 | INV_KENNZX | ||||
INVSETTYPE | Type of Bill Issue | INV_INVSETTYPE | NUMC | 2 | INV_INVSETTYPE | ||||
INVPRINT | Print Bill | INV_INVPRINT | CHAR | 1 | INV_INVPRINT | ||||
INVSEFORM | Bill Form for Individual Bill | INV_INVSEFORM | CHAR | 30 | FORMKEY | ||||
PRODUCT_ID_TYPE | ID Type | INV_PRODUCT_ID_TYPE | NUMC | 3 | INV_PRODUCT_ID_TYPE | ||||
INVSEND_INTERNAL | Bill To Be Processed Internally | INV_INVSEND_INTERNAL | CHAR | 1 | INV_KENNZX | ||||
INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | INV_INVOICE_TYPE | NUMC | 3 | INV_INVOICE_TYPE | INV_INVOICE_TYPE | INV_INVOICE_TYPE | ||
DOC_TYPE | Document Type | INV_DOC_TYPE | NUMC | 3 | INV_DOC_TYPE | ||||
DOC_CATEGORY | Document Category | INV_DOC_CATEGORY | NUMC | 2 | INV_DOC_CATEGORY | ||||
V_GROUP | Grouping Characteristic for Aggregated Contract Account | INV_GROUPVKONT | NUMC | 2 | INV_GROUPVKONT | ||||
SET_REVLOCK | Set Reversal Lock Flag for Print Document | INV_SET_REVLOCK | CHAR | 1 | INV_SET_REVLOCK | ||||
WA_CBUS_PART | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
LGTYP | Legitimation Type | BU_LGTYP | CHAR | 4 | BU_LGTYP | ||||
LGNUM | Identification number of legitimation document | BU_LGNUM | CHAR | 16 | BU_LGNUM | ||||
INFCT | Responsible local court | BU_INFCT | CHAR | 30 | BU_INFCT | ||||
COMRG | Entry in commercial register | BU_COMRG | CHAR | 30 | CHAR30 | ||||
CLBRG | BP: Entry in register of associations | BU_CLBRG | CHAR | 30 | CHAR30 | ||||
COPRG | Entry in Register of Cooperatives | BU_COPRG | CHAR | 30 | CHAR30 | ||||
COMREG_DAT | Date of entry in trade register | BU_COMREG_DAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
M_BONIWERT | Creditworthiness value set manually | BONIWRT_KK | NUMC | 4 | BONIT_KK | ||||
M_BONIDAT | Date on Which Creditworthiness was Manually Set | BONIDAT_KK | DATS | 8 | DATUM | ||||
NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | BU_NAME | ||||
NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | BU_NAME | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
WAKLASS | Employee classification | WAKLASS | CHAR | 4 | E_WAKLASS | ||||
FIRMART | Type of installation company | FIRMART | CHAR | 2 | FIRMART | ||||
ARBFELD | Company work field | ARBFELD | CHAR | 2 | ARBFELD | ||||
MITGLIED | Membership of installer | MITGLIED | CHAR | 1 | MITGLIED | ||||
SPZULASS | Division license of installer | SPZULASS | CHAR | 20 | SPZULASS | ||||
ARTZULASS | Installer license type | ARTZULASS | CHAR | 2 | ARTZULASS | ||||
AUSWANZ | Number of identifications | AUSWANZ | NUMC | 2 | AUSWANZ | ||||
PLOMBENZ | Sealing pliers number | PLOMBENZ | CHAR | 10 | PLOMBENZ | ||||
FREMDEVU | Main utility company | FREMDEVU | CHAR | 3 | EVU | ||||
STATINS | Valid status of installer in supply area | STATINS | CHAR | 2 | STATINS | ||||
STATDATUM | Date on which status of installer comes into effect | STATDATUM | DATS | 8 | STATDATUM | ||||
ERSTZUL | Date of initial license of installer | ERSTZUL | DATS | 8 | ERSTZUL | ||||
WERKSTATT | Date of workshop inspection | WERKSTATT | DATS | 8 | WERKSTATT | ||||
VERLZUL | Date of license renewal | VERLZUL | DATS | 8 | VERLZUL | ||||
ENDEZUL | Date until which license is renewed | ENDEZUL | DATS | 8 | ENDEZUL | ||||
ANZEVU | Number of utility companies | ANZEVU | NUMC | 2 | ANZEVU | ||||
ANZFIL | Number of branches supported by an installionr company | ANZFIL | NUMC | 2 | ANZFIL | ||||
AUSW_INST | Identification number for installer license | AUSW_INST | CHAR | 10 | AUSW_INST | ||||
DR_LICENSE_LAND1 | Country in which driver's license was acquired | DR_LICENSE_LAND1 | CHAR | 3 | LAND1 | ||||
DR_LICENSE_REGIO | Region in which driver's license was acquired | DR_LICENSE_REGIO | CHAR | 3 | REGIO | ||||
DR_LICENSE | Driver's license number | DR_LICENSE | CHAR | 20 | DR_LICENSE | ||||
SOC_SECURE | Social Insurance Number | E_SOC_SECU | CHAR | 12 | E_SOC_SECU | ||||
WELFARE | Welfare office | WELFARE | CHAR | 9 | WELFARE | ||||
PLACE_EMPL | Work center | PLACE_EMPL | CHAR | 40 | CHAR40 | ||||
KTOKLASSE | Account class | KTOKLASSE | CHAR | 4 | KTOKLASSE | ||||
BUPINFOREL | Information release for business partner data | BUPINFOREL | CHAR | 2 | ALPHA | BUPINFOREL | |||
CLERK_ID | Business partner-specific criteria for agent determination | E_CLERK_ID | CHAR | 8 | E_CLERK_ID | ||||
RECPTYPE | Category for Alternate Payee | E_RECPTYPE | CHAR | 1 | E_RECPTYPE | ||||
PYMET | Payment method for donations/fund payments | E_PYMET_DON | CHAR | 1 | PYMET_KK | ||||
EMBVT | Bank details ID for donations/fund payments | E_EMBVT_DON | CHAR | 4 | CHAR4 | ||||
HKONT | G/L accounts for donations/fund payments | E_HKONT_DON | CHAR | 10 | ALPHA | SAKNR | |||
CLASSIFICATION | Classification of Business Partner | E_CLASSIFICATION | CHAR | 4 | CHAR4 | ||||
VIP | Indicate Very Important Business Partner | E_VIP | CHAR | 1 | KENNZX | ||||
IDENT_INST | Identification Number for Installer License | IDENT_INST | CHAR | 18 | IDENT_INST | ||||
MUSTER_KUN | Reference for creating a standard customer for bus. partner | MUSTER_KUN | CHAR | 10 | ALPHA | KUNNR | |||
WA_CBP_ADRESS | 0 | ||||||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
ADDRHANDLE | Handle for Creating Addresses/Persons (Bus. Addr. Services) | AD_HANDLE | CHAR | 140 | TEXT140 | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
DATE | Date referred to | AD_DATE | DATS | 8 | DATUM | ||||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50 | TEXT50 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | AD_COMM | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4 | AD_GROUP | ||||
TXTLANGU_VBS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
LAGEVBSZUS | Additional Information on Location | LGZUSATZ | CHAR | 40 | LGZUSATZ | ||||
STR_ERG2_VBS | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_ERG4_VBS | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
HAUS_NUM2_VBS | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
FLOOR_VBS | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER_VBS | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
STORTGP | Location of maintenance object | PMLOC | CHAR | 10 | AP_STAND | ||||
STORTGPTXT | Text for location | LAGETEXT | CHAR | 40 | TEXT40 | ||||
STORTGPZUS | Addition to device location | STORTZUS | CHAR | 30 | TEXT30 | ||||
TITLE_MEDI | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
WA_CCONT_ACCT | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
GPART | Business Partner Number | GPART_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
VKBEZ | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDATP | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAMP | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
STOPD | Processing lock until | STOPD_KK | DATS | 8 | STOPD_KK | ||||
QSZDT | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 8 | DATUM | ||||
GUID | Business Agreement GUID | BUAG_GUID | RAW | 16 | SYSUUID | ||||
DDLAM | Direct Debit Limit | DDLAM_KK | CURR | 13(2) | WRTV7 | ||||
DDLCU | Currency of Direct Debit Limit | DDLCU_KK | CUKY | 5 | WAERS | ||||
DDLNM | Number of Months for Calculation of Direct Debit Limit | DDLNM_KK | NUMC | 2 | NUM02 | ||||
INV_CYCLE_START | Start Date of Billing Cycle in Contract Account | CYCLE_STARTDATE_KK | DATS | 8 | DATS | ||||
INV_CHGDISC_X | Int: Charges and Discounts Exist for BP-CrtAcct Relations | CHGDISC_X_KK | CHAR | 1 | XFELD | ||||
BPL_XPOCL | Business Partner Lock for Postings/Clearing | BPL_XPOCL_KK | CHAR | 1 | BPL_XPOCL_KK | ||||
BPL_FDATE | Lock valid from | FDATE_KK | DATS | 8 | DATUM | ||||
BPL_TDATE | Lock valid to | TDATE_KK | DATS | 8 | DATUM | ||||
EXVKO | Reference number for business partner | EXVKO_KK | CHAR | 25 | CHAR25 | ||||
OPBUK | Company Code Group | OPBUK_KK | CHAR | 4 | OPBUK_KK | OPBUK | |||
STDBK | Standard Company Code | STDBK_KK | CHAR | 4 | BUKRS | ||||
ABWRE | Alternative Payer | ABWRE_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ABWRA | Alternative Payee | ABWRA_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ABWMA | Alternative dunning recipient | ABWMA_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
EBVTY | Bank Details ID for Incoming Payments | EBVTY_KK | CHAR | 4 | CHAR4 | ||||
ABVTY | Bank Details ID for Outgoing Payments | ABVTY_KK | CHAR | 4 | CHAR4 | ||||
EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
EZASP | Lock Reason for Incoming Payments | EZASP_OLD_KK | CHAR | 1 | SPZAH_KK | ||||
AZAWE | Outgoing Payment Methods | AZAWE_KK | CHAR | 5 | CHAR5 | ||||
AZASP | Lock Reason for Outgoing Payments | AZASP_OLD_KK | CHAR | 1 | SPZAH_KK | ||||
EIGBV | Own Bank Details | EIGBV_KK | CHAR | 25 | EIGBV_KK | ||||
VWNZA | Create Where-Used List For Line Items | VWNZA_KK | CHAR | 1 | VWNZA_KK | ||||
LOEVM | Mark Contract Account for Deletion | LOEVM_KK | CHAR | 1 | LOEVM_KK | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
IKEY | Interest Key | IKEY_KK | CHAR | 2 | IKEY_KK | ||||
MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | MAHNV_KK | FKK_MAHNV | |||
MANSP | Dunning Lock Reason | MANSP_OLD_KK | CHAR | 1 | MANSP_KK | ||||
MGRUP | Grouping fur Dunning Notices | MGRUP_KK | CHAR | 2 | MGRUP_KK | ||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | ALPHA | FDGRP | FFG | ||
VKPBZ | Relationship of Business Partner to Contract Account | VKPBZ_KK | CHAR | 2 | VKPBZ_KK | ||||
ADRNB | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
VKONV | Contract account used for payment transactions | VKONV_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
GPARV | Business Partner Acting as Payer in Payment Transactions | GPARV_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ADRRE | Address Number for Alternative Payer | ADRRE_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRRA | Address Number for Alternative Payee | ADRRA_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRMA | Address number for alternative dunning notice recipient | ADRMA_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ABWRH | Alternative Invoice Recipient | ABWRH_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ADRRH | Address number for alternative bill recipient | ADRRH_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRJDC | Address Number for Jurisdiction Code Address | ADRJDC_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TOGRU_KK | ||||
STOPG | Reason for Processing Lock | STOPG_KK | CHAR | 1 | STOPG_KK | ||||
TXJCD | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | TXJCD_NOCD_KK | CHAR | 15 | TXJCD | TXJ | |||
COPRC | Correspondence Variant | COPRC_KK | CHAR | 4 | COPRC_KK | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
CCARD_ID | Payment Card ID for Incoming Payments | CCID_IN_KK | CHAR | 6 | CHAR6 | ||||
CCARD_OUT | Payment Card ID for Outgoing Payments | CCID_OUT_KK | CHAR | 6 | CHAR6 | ||||
UEBTR | Items Transferred To Another Account | XUEBTR_KK | CHAR | 1 | XFELD | ||||
DEF_REC | Alternative Correspondence Recipient for Standard Case | DEF_CORR_PARTNER_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
DEF_REC_IND | FI-CA correspondence - activity key | DEF_CORR_ACKEY_KK | CHAR | 4 | CORR_ACKEY_KK | ||||
QSSKZ_A | Witholding Tax Code For Outgoing Payments | QSSKZ_A_KK | CHAR | 2 | QSSKZ | ||||
QSSKZ_E | Withholding Tax Code For Incoming Payments | QSSKZ_E_KK | CHAR | 2 | QSSKZ | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
CORR_MAHNV | Correspondence Dunning Procedure | CORR_MAHNV_KK | CHAR | 2 | MAHNV_KK | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
PROVINCE | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
COUNTY | County Code | COUNC | CHAR | 3 | COUNC | ||||
VERTYP | Clearing Category For Clearing Postings | VERTYP_KK | CHAR | 4 | VERTYP_KK | ||||
AUGRS_DEF | Clearing Restriction | AUGRS_DEF_KK | CHAR | 1 | AUGRS_DEF_KK | ||||
LANDL | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3 | LAND1 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
BPTAXTYPE1 | Tax Number Type 1 for Business Partner | BPTAXTYPE1 | CHAR | 4 | BPTAXTYPE | ||||
BPTAXTYPE2 | Tax Number type 2 for Business Partner | BPTAXTYPE2 | CHAR | 4 | BPTAXTYPE | ||||
PERSR | Clerk Responsible | PERSR_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
INV_CATEGORY | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | INV_CATEGORY_KK | ||||
DDLXG | Rolling Calculation of Direct Debit Limit | DDLXG_KK | CHAR | 1 | XFELD | ||||
CMGRP | Collection Management: Master Data Group | CMGRP_CM_KK | CHAR | 2 | CMGRP_CM_KK | ||||
STRAT | Collection Strategy | STRAT_CM_KK | CHAR | 2 | STRAT_CM_KK | ||||
CPERS | Collections Contact Person | CPERS_CM_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
BPCL_SUCC | Duplicate Processing: Predecessor/Successor Business Partner | BPCL_SUCC_KK | CHAR | 1 | BPCL_SUCC_KK | ||||
INV_SCHEDULE | Selection Characteristic for Scheduling | INV_SCHEDULE_KK | CHAR | 4 | INV_SCHEDULE_KK | ||||
INV_CYCLE | Billing Cycle | CYCLE_KK | CHAR | 4 | CYCLE_KK | ||||
INV_CYCLE_RULE | Field Is Not Used - CHAR4 | CYCLE_RULE_KK | CHAR | 4 | |||||
INV_CYCLE_DAY | Day of Period End | CYCLE_DAY_KK | CHAR | 2 | CYCLE_DAY_KK | ||||
INV_CYCLE_MONTH | Field Is Not Used - CHAR2 | NOT_USED_CHAR2_KK | CHAR | 2 | |||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
VKTYP | Contract Account Category | VKTYP_KK | CHAR | 2 | VKTYP_KK | KTP | |||
VKONA | Contract account number in legacy system | VKONA_KK | CHAR | 20 | CHAR20 | ||||
WA_CPAYMO | 0 | ||||||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
ZLSCH | Form ID for Attached Payment Medium | FIDZT | CHAR | 1 | FIDZT | ||||
NACHA | Transmission Medium for Correspondence | FI_NACHA | CHAR | 1 | FI_NACHA | ||||
APPLK | Application Indicator | APPLK_BF | CHAR | 6 | APPLK_BF | ||||
ZANRE | Title of the payee | DZANRE | CHAR | 15 | TEXT15 | ||||
ZNME1 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME2 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME3 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME4 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZPSTL | Postal code of the payee | DZPSTL | CHAR | 10 | PSTLZ | ||||
ZORT1 | City of the payee | DZORT1 | CHAR | 35 | TEXT35 | ||||
ZORT2 | Location from payee's address | ORT02_Z | CHAR | 35 | TEXT35 | ||||
ZSTRA | Street and house number of the payee | DZSTRA | CHAR | 35 | TEXT35 | ||||
ZPST2 | P.O. box postal code of the payee | DZPST2 | CHAR | 10 | PSTLZ | ||||
ZPFAC | P.O. box of the payee | DZPFAC | CHAR | 10 | PFACH | ||||
ZPFOR | City of payee's PO box | PFORT_Z | CHAR | 35 | TEXT35 | ||||
ZLAND | Country Key | DZLAND | CHAR | 3 | LAND1 | LND | |||
ZREGI | Regional code of the payee | DZREGI | CHAR | 3 | REGIO | ||||
ZSPRA | Language key of the payee | DZSPRA | LANG | 1 | ISOLA | SPRAS | |||
ZPLOR | Postal Code/City of the Payee's Display Field | DZPLOR | CHAR | 46 | TEXT46 | ||||
ZLNDX | Name of the Payee's Country | DZLNDX | CHAR | 15 | TEXT15 | ||||
ZREGX | Region | REGIX | CHAR | 20 | TEXT20 | ||||
ZNAME | Short Name of Payee | NAMEZ | CHAR | 50 | TEXT50 | ||||
KUNID | Customer ID Number | KUNID_49E | CHAR | 15 | CHAR15 | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
EMPZ1 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
EMPZ2 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
EMPZ3 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
EMPZ4 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
ZBNKS | Country Key | DZBNKS | CHAR | 3 | LAND1 | LND | |||
ZBNKN | Bank account number of the payee | DZBNKN | CHAR | 18 | BANKN | ||||
ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15 | BANKL | ||||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2 | BKONT | ||||
ZBNKY | Bank key of the payee's bank | DZBNKY | CHAR | 15 | BANKK | ||||
ZBNKA | Name of the Payee's Bank | DZBNKA | CHAR | 60 | TEXT60 | ||||
ZBSTR | Street of the Payee's Bank | DZBSTR | CHAR | 35 | TEXT35 | ||||
ZBORT | City of the Payee's Bank | DZBORT | CHAR | 35 | TEXT35 | ||||
ZBANK | Payee Bank (Name and City) | EBANK | CHAR | 100 | TEXT100 | ||||
ZBRCH | Bank Branch | BRNCH | CHAR | 40 | TEXT40 | ||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
PLORT | Postal code/city display field | PLORT | CHAR | 46 | TEXT46 | ||||
LANDX | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
REGIX | Region | REGIX | CHAR | 20 | TEXT20 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
HWAER | Local Currency | HWAER | CUKY | 5 | WAERS | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
RBBTR | Gross Amount in Local Currency | RBBTR_FI | CURR | 13(2) | WRTV7 | ||||
RSKON | Total Cash Discount for the Payment Trans. (Local Currency) | RSKON | CURR | 13(2) | WRTV7 | ||||
RBETR | Amount in Local Currency | RBETR | CURR | 13(2) | WRTV7 | ||||
RWBBT | Gross Amount in the Payment Currency | RWBBT_FI | CURR | 13(2) | WRTV7 | ||||
RWSKT | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | RWSKT | CURR | 13(2) | WRTV7 | ||||
RWBTR | Amount Paid in the Payment Currency | RWBTR | CURR | 13(2) | WRTV7 | ||||
ZWCK1 | Reason for payment | DZWECK_015 | CHAR | 70 | TXT70 | ||||
ZWCK2 | Reason for payment | DZWECK_015 | CHAR | 70 | TXT70 | ||||
VORID | Transaction ID | VORID | CHAR | 4 | VORID | ||||
NUMBER | Whole digits of the amount converted | IN_NUMBERS | NUMC | 15 | NUMC15 | ||||
DECIMAL | Decimal places of the amount converted | IN_DECI | NUMC | 3 | NUMC03 | ||||
CURRDEC | Number of decimal places | CURRDEC | INT1 | 3 | CURRDEC | ||||
WORD | Amount in words | IN_WORDS | CHAR | 255 | CHAR255 | ||||
DECWORD | Decimal places in words | DECWORD | CHAR | 128 | CHAR128 | ||||
DIG01 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG02 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG03 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG04 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG05 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG06 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG07 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG08 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG09 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG10 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG11 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG12 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG13 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG14 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG15 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
KTEXT | Short Text | KTEXT_048W | CHAR | 20 | TEXT20 | ||||
LTEXT | Long Text | LTEXT_048W | CHAR | 40 | TEXT40 | ||||
OZWCK | Reference for OCRA Line | OZWCK | NUMC | 13 | NUMC13 | ||||
OZBKT | Account Number of Customer/Vendor for OCRA Line | OZBKT | NUMC | 18 | NUM18 | ||||
OZBKL | Bank Number of Customer/Vendor Bank for OCRA Line | OZBKL | NUMC | 15 | NUMC15 | ||||
SOCRA | Total for the OCRA Lines (OCRA/OCRB) | SOCRA | NUMC | 11 | NUMC11 | ||||
MBETR | Amount field for ISR | MBETR | CHAR | 13 | CHAR13 | ||||
MREFN | Reference number on the payment order | MREFN | CHAR | 27 | CHAR27 | ||||
MKODZ | ISR coding line | MKODZ | CHAR | 53 | CHAR53 | ||||
CODNL | Code Line for Dutch Bank Transfer | CODNL | CHAR | 65 | TEXT65 | ||||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
WA_CBANKOUT | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
BKVID | Bank details ID | BU_BKVID | CHAR | 4 | CHAR4 | ||||
BANKS | Bank Country Key | BU_BANKS | CHAR | 3 | LAND1 | ||||
BANKL | Bank Key | BU_BANKK | CHAR | 15 | CHAR15 | ||||
BANKN | Bank Account Number | BU_BANKN | CHAR | 18 | CHAR18 | ||||
BKONT | Bank Control Key | BU_BKONT | CHAR | 2 | CHAR2 | ||||
BKREF | Reference Details for Bank Details | BU_BKREF | CHAR | 20 | CHAR20 | ||||
KOINH | Account Holder Name | BU_KOINH | CHAR | 60 | BU_KOINH | ||||
BKEXT | Bank details ID in external system | BU_BKEXT | CHAR | 20 | CHAR20 | ||||
XEZER | Indicator: Collection Authorization | BU_XEZER | CHAR | 1 | XFELD | ||||
ACCNAME | Name of Bank Account | BU_BANKACCNAME | CHAR | 40 | BU_BKCCNAME | ||||
MOVE_BKVID | ID of Target Details for Change of Bank Details (BP) | BU_MOVE_BKVID | CHAR | 4 | CHAR4 | ADR | |||
BK_VALID_FROM | Validity Start of Business Partner Bank Details | BU_BK_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
BK_VALID_TO | Validity End of Business Partner Bank Details | BU_BK_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
BK_MOVE_DATE | Date of Change to Bank Details (BP) | BU_BK_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR | 34 | CHAR34 | ||||
BANK_GUID | Bank GUID | BU_BANK_GUID | RAW | 16 | UUID | ||||
ACCOUNT_ID | Bank Account Number (New) | BU_ACCOUNT_ID | CHAR | 35 | CHAR35 | ||||
CHECK_DIGIT | Bank Account Check Digit | BU_ACCOUNT_CHECK | CHAR | 2 | CHAR2 | ||||
ACCOUNT_TYPE | Bank Account Type | BU_ACCOUNT_TYPE | CHAR | 3 | CHAR3 | ||||
WA_CBANKIN | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
BKVID | Bank details ID | BU_BKVID | CHAR | 4 | CHAR4 | ||||
BANKS | Bank Country Key | BU_BANKS | CHAR | 3 | LAND1 | ||||
BANKL | Bank Key | BU_BANKK | CHAR | 15 | CHAR15 | ||||
BANKN | Bank Account Number | BU_BANKN | CHAR | 18 | CHAR18 | ||||
BKONT | Bank Control Key | BU_BKONT | CHAR | 2 | CHAR2 | ||||
BKREF | Reference Details for Bank Details | BU_BKREF | CHAR | 20 | CHAR20 | ||||
KOINH | Account Holder Name | BU_KOINH | CHAR | 60 | BU_KOINH | ||||
BKEXT | Bank details ID in external system | BU_BKEXT | CHAR | 20 | CHAR20 | ||||
XEZER | Indicator: Collection Authorization | BU_XEZER | CHAR | 1 | XFELD | ||||
ACCNAME | Name of Bank Account | BU_BANKACCNAME | CHAR | 40 | BU_BKCCNAME | ||||
MOVE_BKVID | ID of Target Details for Change of Bank Details (BP) | BU_MOVE_BKVID | CHAR | 4 | CHAR4 | ADR | |||
BK_VALID_FROM | Validity Start of Business Partner Bank Details | BU_BK_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
BK_VALID_TO | Validity End of Business Partner Bank Details | BU_BK_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
BK_MOVE_DATE | Date of Change to Bank Details (BP) | BU_BK_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR | 34 | CHAR34 | ||||
BANK_GUID | Bank GUID | BU_BANK_GUID | RAW | 16 | UUID | ||||
ACCOUNT_ID | Bank Account Number (New) | BU_ACCOUNT_ID | CHAR | 35 | CHAR35 | ||||
CHECK_DIGIT | Bank Account Check Digit | BU_ACCOUNT_CHECK | CHAR | 2 | CHAR2 | ||||
ACCOUNT_TYPE | Bank Account Type | BU_ACCOUNT_TYPE | CHAR | 3 | CHAR3 | ||||
WA_CBP_BANKIN | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
LGTYP | Legitimation Type | BU_LGTYP | CHAR | 4 | BU_LGTYP | ||||
LGNUM | Identification number of legitimation document | BU_LGNUM | CHAR | 16 | BU_LGNUM | ||||
INFCT | Responsible local court | BU_INFCT | CHAR | 30 | BU_INFCT | ||||
COMRG | Entry in commercial register | BU_COMRG | CHAR | 30 | CHAR30 | ||||
CLBRG | BP: Entry in register of associations | BU_CLBRG | CHAR | 30 | CHAR30 | ||||
COPRG | Entry in Register of Cooperatives | BU_COPRG | CHAR | 30 | CHAR30 | ||||
COMREG_DAT | Date of entry in trade register | BU_COMREG_DAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
M_BONIWERT | Creditworthiness value set manually | BONIWRT_KK | NUMC | 4 | BONIT_KK | ||||
M_BONIDAT | Date on Which Creditworthiness was Manually Set | BONIDAT_KK | DATS | 8 | DATUM | ||||
NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | BU_NAME | ||||
NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | BU_NAME | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
WAKLASS | Employee classification | WAKLASS | CHAR | 4 | E_WAKLASS | ||||
FIRMART | Type of installation company | FIRMART | CHAR | 2 | FIRMART | ||||
ARBFELD | Company work field | ARBFELD | CHAR | 2 | ARBFELD | ||||
MITGLIED | Membership of installer | MITGLIED | CHAR | 1 | MITGLIED | ||||
SPZULASS | Division license of installer | SPZULASS | CHAR | 20 | SPZULASS | ||||
ARTZULASS | Installer license type | ARTZULASS | CHAR | 2 | ARTZULASS | ||||
AUSWANZ | Number of identifications | AUSWANZ | NUMC | 2 | AUSWANZ | ||||
PLOMBENZ | Sealing pliers number | PLOMBENZ | CHAR | 10 | PLOMBENZ | ||||
FREMDEVU | Main utility company | FREMDEVU | CHAR | 3 | EVU | ||||
STATINS | Valid status of installer in supply area | STATINS | CHAR | 2 | STATINS | ||||
STATDATUM | Date on which status of installer comes into effect | STATDATUM | DATS | 8 | STATDATUM | ||||
ERSTZUL | Date of initial license of installer | ERSTZUL | DATS | 8 | ERSTZUL | ||||
WERKSTATT | Date of workshop inspection | WERKSTATT | DATS | 8 | WERKSTATT | ||||
VERLZUL | Date of license renewal | VERLZUL | DATS | 8 | VERLZUL | ||||
ENDEZUL | Date until which license is renewed | ENDEZUL | DATS | 8 | ENDEZUL | ||||
ANZEVU | Number of utility companies | ANZEVU | NUMC | 2 | ANZEVU | ||||
ANZFIL | Number of branches supported by an installionr company | ANZFIL | NUMC | 2 | ANZFIL | ||||
AUSW_INST | Identification number for installer license | AUSW_INST | CHAR | 10 | AUSW_INST | ||||
DR_LICENSE_LAND1 | Country in which driver's license was acquired | DR_LICENSE_LAND1 | CHAR | 3 | LAND1 | ||||
DR_LICENSE_REGIO | Region in which driver's license was acquired | DR_LICENSE_REGIO | CHAR | 3 | REGIO | ||||
DR_LICENSE | Driver's license number | DR_LICENSE | CHAR | 20 | DR_LICENSE | ||||
SOC_SECURE | Social Insurance Number | E_SOC_SECU | CHAR | 12 | E_SOC_SECU | ||||
WELFARE | Welfare office | WELFARE | CHAR | 9 | WELFARE | ||||
PLACE_EMPL | Work center | PLACE_EMPL | CHAR | 40 | CHAR40 | ||||
KTOKLASSE | Account class | KTOKLASSE | CHAR | 4 | KTOKLASSE | ||||
BUPINFOREL | Information release for business partner data | BUPINFOREL | CHAR | 2 | ALPHA | BUPINFOREL | |||
CLERK_ID | Business partner-specific criteria for agent determination | E_CLERK_ID | CHAR | 8 | E_CLERK_ID | ||||
RECPTYPE | Category for Alternate Payee | E_RECPTYPE | CHAR | 1 | E_RECPTYPE | ||||
PYMET | Payment method for donations/fund payments | E_PYMET_DON | CHAR | 1 | PYMET_KK | ||||
EMBVT | Bank details ID for donations/fund payments | E_EMBVT_DON | CHAR | 4 | CHAR4 | ||||
HKONT | G/L accounts for donations/fund payments | E_HKONT_DON | CHAR | 10 | ALPHA | SAKNR | |||
CLASSIFICATION | Classification of Business Partner | E_CLASSIFICATION | CHAR | 4 | CHAR4 | ||||
VIP | Indicate Very Important Business Partner | E_VIP | CHAR | 1 | KENNZX | ||||
IDENT_INST | Identification Number for Installer License | IDENT_INST | CHAR | 18 | IDENT_INST | ||||
MUSTER_KUN | Reference for creating a standard customer for bus. partner | MUSTER_KUN | CHAR | 10 | ALPHA | KUNNR | |||
WA_CBP_AD_BIN | 0 | ||||||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
ADDRHANDLE | Handle for Creating Addresses/Persons (Bus. Addr. Services) | AD_HANDLE | CHAR | 140 | TEXT140 | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
DATE | Date referred to | AD_DATE | DATS | 8 | DATUM | ||||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50 | TEXT50 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | AD_COMM | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4 | AD_GROUP | ||||
TXTLANGU_VBS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
LAGEVBSZUS | Additional Information on Location | LGZUSATZ | CHAR | 40 | LGZUSATZ | ||||
STR_ERG2_VBS | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_ERG4_VBS | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
HAUS_NUM2_VBS | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
FLOOR_VBS | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER_VBS | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
STORTGP | Location of maintenance object | PMLOC | CHAR | 10 | AP_STAND | ||||
STORTGPTXT | Text for location | LAGETEXT | CHAR | 40 | TEXT40 | ||||
STORTGPZUS | Addition to device location | STORTZUS | CHAR | 30 | TEXT30 | ||||
TITLE_MEDI | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
WA_CBP_BANKOU | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
LGTYP | Legitimation Type | BU_LGTYP | CHAR | 4 | BU_LGTYP | ||||
LGNUM | Identification number of legitimation document | BU_LGNUM | CHAR | 16 | BU_LGNUM | ||||
INFCT | Responsible local court | BU_INFCT | CHAR | 30 | BU_INFCT | ||||
COMRG | Entry in commercial register | BU_COMRG | CHAR | 30 | CHAR30 | ||||
CLBRG | BP: Entry in register of associations | BU_CLBRG | CHAR | 30 | CHAR30 | ||||
COPRG | Entry in Register of Cooperatives | BU_COPRG | CHAR | 30 | CHAR30 | ||||
COMREG_DAT | Date of entry in trade register | BU_COMREG_DAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
M_BONIWERT | Creditworthiness value set manually | BONIWRT_KK | NUMC | 4 | BONIT_KK | ||||
M_BONIDAT | Date on Which Creditworthiness was Manually Set | BONIDAT_KK | DATS | 8 | DATUM | ||||
NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | BU_NAME | ||||
NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | BU_NAME | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
WAKLASS | Employee classification | WAKLASS | CHAR | 4 | E_WAKLASS | ||||
FIRMART | Type of installation company | FIRMART | CHAR | 2 | FIRMART | ||||
ARBFELD | Company work field | ARBFELD | CHAR | 2 | ARBFELD | ||||
MITGLIED | Membership of installer | MITGLIED | CHAR | 1 | MITGLIED | ||||
SPZULASS | Division license of installer | SPZULASS | CHAR | 20 | SPZULASS | ||||
ARTZULASS | Installer license type | ARTZULASS | CHAR | 2 | ARTZULASS | ||||
AUSWANZ | Number of identifications | AUSWANZ | NUMC | 2 | AUSWANZ | ||||
PLOMBENZ | Sealing pliers number | PLOMBENZ | CHAR | 10 | PLOMBENZ | ||||
FREMDEVU | Main utility company | FREMDEVU | CHAR | 3 | EVU | ||||
STATINS | Valid status of installer in supply area | STATINS | CHAR | 2 | STATINS | ||||
STATDATUM | Date on which status of installer comes into effect | STATDATUM | DATS | 8 | STATDATUM | ||||
ERSTZUL | Date of initial license of installer | ERSTZUL | DATS | 8 | ERSTZUL | ||||
WERKSTATT | Date of workshop inspection | WERKSTATT | DATS | 8 | WERKSTATT | ||||
VERLZUL | Date of license renewal | VERLZUL | DATS | 8 | VERLZUL | ||||
ENDEZUL | Date until which license is renewed | ENDEZUL | DATS | 8 | ENDEZUL | ||||
ANZEVU | Number of utility companies | ANZEVU | NUMC | 2 | ANZEVU | ||||
ANZFIL | Number of branches supported by an installionr company | ANZFIL | NUMC | 2 | ANZFIL | ||||
AUSW_INST | Identification number for installer license | AUSW_INST | CHAR | 10 | AUSW_INST | ||||
DR_LICENSE_LAND1 | Country in which driver's license was acquired | DR_LICENSE_LAND1 | CHAR | 3 | LAND1 | ||||
DR_LICENSE_REGIO | Region in which driver's license was acquired | DR_LICENSE_REGIO | CHAR | 3 | REGIO | ||||
DR_LICENSE | Driver's license number | DR_LICENSE | CHAR | 20 | DR_LICENSE | ||||
SOC_SECURE | Social Insurance Number | E_SOC_SECU | CHAR | 12 | E_SOC_SECU | ||||
WELFARE | Welfare office | WELFARE | CHAR | 9 | WELFARE | ||||
PLACE_EMPL | Work center | PLACE_EMPL | CHAR | 40 | CHAR40 | ||||
KTOKLASSE | Account class | KTOKLASSE | CHAR | 4 | KTOKLASSE | ||||
BUPINFOREL | Information release for business partner data | BUPINFOREL | CHAR | 2 | ALPHA | BUPINFOREL | |||
CLERK_ID | Business partner-specific criteria for agent determination | E_CLERK_ID | CHAR | 8 | E_CLERK_ID | ||||
RECPTYPE | Category for Alternate Payee | E_RECPTYPE | CHAR | 1 | E_RECPTYPE | ||||
PYMET | Payment method for donations/fund payments | E_PYMET_DON | CHAR | 1 | PYMET_KK | ||||
EMBVT | Bank details ID for donations/fund payments | E_EMBVT_DON | CHAR | 4 | CHAR4 | ||||
HKONT | G/L accounts for donations/fund payments | E_HKONT_DON | CHAR | 10 | ALPHA | SAKNR | |||
CLASSIFICATION | Classification of Business Partner | E_CLASSIFICATION | CHAR | 4 | CHAR4 | ||||
VIP | Indicate Very Important Business Partner | E_VIP | CHAR | 1 | KENNZX | ||||
IDENT_INST | Identification Number for Installer License | IDENT_INST | CHAR | 18 | IDENT_INST | ||||
MUSTER_KUN | Reference for creating a standard customer for bus. partner | MUSTER_KUN | CHAR | 10 | ALPHA | KUNNR | |||
WA_CBP_AD_BOU | 0 | ||||||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
ADDRHANDLE | Handle for Creating Addresses/Persons (Bus. Addr. Services) | AD_HANDLE | CHAR | 140 | TEXT140 | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
DATE | Date referred to | AD_DATE | DATS | 8 | DATUM | ||||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50 | TEXT50 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | AD_COMM | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4 | AD_GROUP | ||||
TXTLANGU_VBS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
LAGEVBSZUS | Additional Information on Location | LGZUSATZ | CHAR | 40 | LGZUSATZ | ||||
STR_ERG2_VBS | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_ERG4_VBS | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
HAUS_NUM2_VBS | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
FLOOR_VBS | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER_VBS | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
STORTGP | Location of maintenance object | PMLOC | CHAR | 10 | AP_STAND | ||||
STORTGPTXT | Text for location | LAGETEXT | CHAR | 40 | TEXT40 | ||||
STORTGPZUS | Addition to device location | STORTZUS | CHAR | 30 | TEXT30 | ||||
TITLE_MEDI | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
WA_CPREV_DOCH | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
OPBEL | Number of print document | E_PRINTDOC | CHAR | 12 | ALPHA | E_PRINTDOC | E_PRINTDOC | ||
DRUCKDAT | Print Date | DRUCKDAT | DATS | 8 | DATUM | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
STOKZ | Document Has Been Reversed | STOKZ | CHAR | 1 | KENNZX | ||||
INTOPBEL | Number of Print Document Used to Reverse Document | INTOPBEL | CHAR | 12 | ALPHA | E_PRINTDOC | |||
ERDZ_V | ERDZ/ERDL exists for ERDK | ERDZ_V | CHAR | 1 | KENNZX | ||||
ERDR_V | ERDR exists for ERDK | ERDR_V | CHAR | 1 | KENNZX | ||||
ERDO_V | ERDO exists for ERDK | ERDO_V | CHAR | 1 | KENNZX | ||||
ERDB_V | ERDB exists for ERDK | ERDB_V | CHAR | 1 | KENNZX | ||||
ERDU_V | ERDU exists for ERDK | ERDU_V | CHAR | 1 | KENNZX | ||||
ERDTS_V | ERDTS exists for ERDK | ERDTS_V | CHAR | 1 | KENNZX | ||||
FICA_V | FI-CA Document Posted | FICA_V | CHAR | 1 | KENNZX | ||||
TOTAL_AMNT | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
TOTAL_WAER | Transaction Currency | BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
TOTAL_AMNT_USE | Indicator: Use of bill sum total | TOTAL_AMNT_USE | CHAR | 2 | TOTAL_AMNT_USE | ||||
PYMET | Payment Method | PYMET_KK | CHAR | 1 | PYMET_KK | ||||
ZSBTR | Total Amount from Bill Items in Payment Form | E_ZSBTR | CURR | 13(2) | WRTV7 | ||||
ZLSCH | Form ID for Attached Payment Medium | FIDZT | CHAR | 1 | FIDZT | ||||
NRZAS | Payment Form Number | NRZAS_KK | CHAR | 12 | ALPHA | NRZAS_KK | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
PORTION | Portion | PORTION | CHAR | 8 | PORTION | TPR | E420 | ||
ABRVORG | Billing Transaction | ABRVORG | CHAR | 2 | ABRVORG | ABV | |||
FORMKEY | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | FIKEY_KK | FKFI1 | |||
TOBRELEASD | Indicator: document not released yet | TOBRELEASD | CHAR | 1 | KENNZX | ||||
SIMULATED | Indicator: invoicing generates a simulated document | SIMULATED | CHAR | 1 | KENNZX | ||||
INVOICED | Indicator: document posted | INVOICED | CHAR | 1 | KENNZX | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
ABWBL | Number of the substitute FI-CA document | ABWBL_KK | CHAR | 12 | ALPHA | ABWBL_KK | |||
ERGRD | Reason for creating print document | ERGRD | CHAR | 2 | ERGRD | ||||
LANGU | Language in connection with the contract account | LANGU_ACC | LANG | 1 | ISOLA | SPRAS | |||
INVOICING_PARTY | Service Provider That Invoices the Contract | INVOICING_PARTY | CHAR | 10 | SERVICE_PROV | SERVICEPROVIDER | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
VERART | Clearing Type For Clearing Postings | VERART_KK | CHAR | 3 | CHAR3 | ||||
STO_BUDAT | Reversal Date of Original Document (Reversal Only) | STO_BUDAT | DATS | 8 | DATUM | ||||
STO_OPBEL | Document Number of Original Document (Only for Reversal) | STO_OPBEL | CHAR | 12 | ALPHA | E_PRINTDOC | |||
ICREASON | Reason for Reversal | BCREASON | CHAR | 2 | BCREASON | TE272_BCREASON_F4 | |||
MAZAE | Counter for several dunning notices to a business partner | MAZAE_KK | NUMC | 6 | NUMC6 | ||||
ITEMS_ARCHIVED | Line items are archived | ITEMS_ARCHIVED | CHAR | 1 | ISU_ARCH_KENNZ1 | ||||
EXKID | Key Identification | EXKID_KK | CHAR | 2 | EXKID_KK | ||||
EXBEL | Official Document Number | EXBEL_KK | CHAR | 16 | ALPHA | EXBEL_KK | |||
MAZAE_ABS | Counter for several dunning notices to a business partner | MAZAE_KK | NUMC | 6 | NUMC6 | ||||
PRINTLOCK | Document is Blocked for Printing | E_PRINTLOCK | CHAR | 1 | E_PRINTLOCK | ||||
EDIDISPATCH | Transmit Print Document Via EDI | E_EDIDISPATCH | CHAR | 1 | KENNZX | ||||
EDISENDDATE | Generation Date of EDI for Print Document | EDISENDDAT | DATS | 8 | DATUM | ||||
TAXDATE | Tax Determination Date | E_TAXDATE | DATS | 8 | DATS | ||||
CREATION_TIME | Time of Print Document Creation | E_CREATION_TIME | TIMS | 6 | TIME | ||||
BILLING_PERIOD | Billing Key Date (For Example January 2002) | E_BILLING_PERIOD | CHAR | 10 | E_BILLING_PERIOD | ||||
OSB_GROUP | On-Site Billing Group | E_OSB_GROUP | CHAR | 3 | |||||
REVLOCK | Reversal Block Indicator for Print Documents | E_REVLOCK | CHAR | 1 | E_REVLOCK | ||||
SEPA_PRENOT | Invoicing Document Contains SEPA Pre-Notification | E_SEPA_PRENOT | CHAR | 1 | XFELD | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
ARCHIV_ID | Content Repository Identification | SAEARCHIVI | CHAR | 2 | SADC2_AR | ||||
ARC_DOC_ID | SAP ArchiveLink: Document ID | SAEARDOID | CHAR | 40 | SADC40 | ||||
URI | SAP ArchiveLink: Data Element for Absolute URI | SAEURI | CHAR | 4096 | SADC4096 | ||||
T_CDOC_LOCKS | 0 | ||||||||
T_CDOC_ITEM | 0 | ||||||||
T_DOC_THI | 0 | ||||||||
T_DATEXTASK | 0 | ||||||||
T_DOC_HEADER | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure ISU_IN_COLL_BILL_S_CDOC_HEAD using ABAP code?
As ISU_IN_COLL_BILL_S_CDOC_HEAD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ISU_IN_COLL_BILL_S_CDOC_HEAD as there is no data to select.How to access SAP table ISU_IN_COLL_BILL_S_CDOC_HEAD
Within an ECC or HANA version of SAP you can also view further information about ISU_IN_COLL_BILL_S_CDOC_HEAD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects