FKKCORR_STR_EXP_CORRESP SAP (Correspondence Request) Structure details
Description: Correspondence Request
Related tables to FKKCORR_STR_EXP_CORRESP
Access table FKKCORR_STR_EXP_CORRESP
Structure field list including key, data, relationships and ABAP select examples
FKKCORR_STR_EXP_CORRESP 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 "Correspondence Request" 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_FKKCORR_STR_EXP_CORRESP TYPE FKKCORR_STR_EXP_CORRESP.
The FKKCORR_STR_EXP_CORRESP table consists of various fields, each holding specific information or linking keys about Correspondence Request data available in SAP. These include MANDT (Client), COTYP (Correspondence Type), COKEY (Correspondence key), UNAME (User Name).. 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 FKKCORR_STR_EXP_CORRESP 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_CORRESP | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
COTYP | Correspondence Type | COTYP_KK | CHAR | 4 | COTYP_KK | COTYP | COTYP_KK | ||
COKEY | Correspondence key | COKEY_KK | CHAR | 36 | COKEY_KK | ||||
UNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
CDATE | Created On | COCDT_KK | DATS | 8 | SYDATS | ||||
CTIME | Time of Creation (to the Second) | COCTM_KK | TIMS | 6 | SYTIME | ||||
GPART | Correspondence Recipient | CREC_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
GPART_GUID | Correspondence Recipient (GUID) | CREC_GP_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
GPART_ADR_KIND | Address Type Of Correspondence Recipient | CORR_ADR_KIND_KK | CHAR | 10 | BU_ADRKIND | ||||
ORG_GPART | Original Correspondence Recipient | CREC_ORG_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ORG_GPART_GUID | Original Correspondence Recipient (GUID) | CREC_ORG_GP_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
ADD_GPART | Additional Business Partner for Correspondence Recipient | CREC_GP_ADD_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ADD_GPART_GUID | Addit. Business Partner for Correspondence Recipient GUID | CREC_GP_ADD_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
ADD_GPART_CAT | Type of Additional Correspondence Recipient | CREC_GP_ADD_CAT_KK | CHAR | 1 | CORR_CREC_ADD_CAT_KK | ||||
ADRNR_INDEP_COMM | Address Number for Address-Independent Communication | CREC_AD_INDEP_COMM_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
AGPART | Sending Business Partner | CSEN_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
AADRNR | Address Number of Correspondence Sender | CSEN_AD_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
FORMKEY | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
ADR_VALID_ON | Address of Correspondence Recipient Valid On | CREC_AD_VALID_ON_KK | DEC | 15 | TZNTSTMPS | ||||
ADRNR | Address Number of Correspondence Recipient | CREC_AD_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
FORMKEY_RDI | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
ENTID1 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
ADR_GUID | Address GUID of Correspondence Recipient | CREC_AD_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
DATA1 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
ADRNR_INDEP_COMM | Address Number for Address-Independent Communication | CREC_AD_INDEP_COMM_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
AGPART | Sending Business Partner | CSEN_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ENTID2 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA2 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
AGPART_GUID | Sender (GUID) | CSEN_GP_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
ENTID3 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
AGPART_ADR_KIND | Address Type Of Correspondence Recipient | CORR_ADR_KIND_KK | CHAR | 10 | BU_ADRKIND | ||||
DATA3 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
AADRNR | Address Number of Correspondence Sender | CSEN_AD_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ENTID4 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
AADR_GUID | Address GUID of Correspondence Sender | CSEN_AD_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
DATA4 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
FORMKEY | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
CSORT | Correspondence Sort Field | CSORT_KK | CHAR | 50 | CORR_TXT50 | ||||
FORMKEY_RDI | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
XCODT | Data Part Is Used | XCODT_KK | CHAR | 1 | XFELD | ||||
ENTID1 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA1 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
XCODT_CLUST | Cluster Data Part is Used | XCODT_CLUST_KK | CHAR | 1 | XFELD | ||||
LAUFD | Date ID for Creation Run | CORR_LAUFD_KK | DATS | 8 | DATUM | ||||
ENTID2 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA2 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
LAUFI | Additional ID Characteristic for Creation Run | CORR_LAUFI_KK | CHAR | 6 | CORR_LAUFI_KK | ||||
XTEST | Correspondence is Result of Test | XTEST_KK | CHAR | 1 | XFELD | ||||
ENTID3 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
COPRI | Print Date | COPRI_KK | DATS | 8 | SYDATS | ||||
DATA3 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
COIDT | Date of Issue | COIDT_KK | DATS | 8 | SYDATS | ||||
ENTID4 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
COITM | Issue Time to the Second | COITM_KK | TIMS | 6 | SYTIME | ||||
DATA4 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
CSORT | Correspondence Sort Field | CSORT_KK | CHAR | 50 | CORR_TXT50 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
SALWA | Transaction Currency | CORR_BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
XCODT | Data Part Is Used | XCODT_KK | CHAR | 1 | XFELD | ||||
SALBE | Amount in Local Currency with +/- Signs | CORR_BETRH_KK | CURR | 13(2) | WRTV7 | ||||
XCODT_CLUST | Cluster Data Part is Used | XCODT_CLUST_KK | CHAR | 1 | XFELD | ||||
LAUFD | Date ID for Creation Run | CORR_LAUFD_KK | DATS | 8 | DATUM | ||||
SENDCONTROL | Dispatch Control | SENDCONTROL | CHAR | 4 | ESENDCONTROL | ||||
LAUFI | Additional ID Characteristic for Creation Run | CORR_LAUFI_KK | CHAR | 6 | CORR_LAUFI_KK | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
BUKRS | Company Code in Correspondence | CORR_BUKRS | CHAR | 4 | CORR_BUKRS | ||||
XTEST | Correspondence is Result of Test | XTEST_KK | CHAR | 1 | XFELD | ||||
COPRI | Print Date | COPRI_KK | DATS | 8 | SYDATS | ||||
CORR_ROLE | Correspondence Roles | CORR_ROLE_KK | CHAR | 4 | CORR_ROLE_KK | ||||
COIDT | Date of Issue | COIDT_KK | DATS | 8 | SYDATS | ||||
COPRI_LAUFD | Date ID for Print Run | COPRI_LAUFD_KK | DATS | 8 | DATUM | ||||
COITM | Issue Time to the Second | COITM_KK | TIMS | 6 | SYTIME | ||||
COPRI_LAUFI | ID Characteristic for Run | COPRI_LAUFID_KK | CHAR | 6 | COPRI_LAUFID_KK | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
XTRIAL | Correspondence Request is Test | XTRIAL_KK | CHAR | 1 | XFELD | ||||
SALWA | Transaction Currency | CORR_BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
XREPRINT | Recreate Correspondence | XREPRINT_KK | CHAR | 1 | XFELD | ||||
SALBE | Amount in Local Currency with +/- Signs | CORR_BETRH_KK | CURR | 13(2) | WRTV7 | ||||
SUBAP | Subapplication Indicator in Correspondence | CORR_SUBAP_KK | CHAR | 1 | CORR_SUBAP_KK | ||||
SENDCONTROL | Dispatch Control | SENDCONTROL | CHAR | 4 | ESENDCONTROL | ||||
XDELETE | Correspondence Is Logically Deleted | X_CORR_DELETE_KK | CHAR | 1 | XFELD | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
PRINT_MODE | Business Partner Print Format | PRINT_MODE_KK | CHAR | 1 | BU_PRINT_MODE | ||||
APERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
BUKRS | Company Code in Correspondence | CORR_BUKRS | CHAR | 4 | CORR_BUKRS | ||||
WA_RECEIVER | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
CORR_ROLE | Correspondence Roles | CORR_ROLE_KK | CHAR | 4 | CORR_ROLE_KK | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
COPRI_LAUFD | Date ID for Print Run | COPRI_LAUFD_KK | DATS | 8 | DATUM | ||||
COPRI_LAUFI | ID Characteristic for Run | COPRI_LAUFID_KK | CHAR | 6 | COPRI_LAUFID_KK | ||||
PROCESS_ID_ | Business Process ID | CORR_PROCESS_ID_KK | CHAR | 36 | |||||
NO_DOCPARTS | Number of Document Parts | CORR_NO_DOCPARTS_KK | NUMC | 4 | |||||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
DOCPART_ROLE | Document Part Role | CORR_DOCPART_ROLE_KK | CHAR | 1 | CORR_DOCPART_ROLE_KK | ||||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
XTRIAL | Correspondence Request is Test | XTRIAL_KK | CHAR | 1 | XFELD | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
XREPRINT | Recreate Correspondence | XREPRINT_KK | CHAR | 1 | XFELD | ||||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
SUBAP | Subapplication Indicator in Correspondence | CORR_SUBAP_KK | CHAR | 1 | CORR_SUBAP_KK | ||||
XDELETE | Correspondence Is Logically Deleted | X_CORR_DELETE_KK | CHAR | 1 | XFELD | ||||
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 | ||||
PRINT_MODE | Business Partner Print Format | PRINT_MODE_KK | CHAR | 1 | BU_PRINT_MODE | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
X_NO_ARC | SAP ArchiveLink Object ID Part Is Not Used | X_NO_ARC_KK | CHAR | 1 | XFELD | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
X_DOCPART_LIST | Document Part List Is Used | X_DOCPART_LIST_KK | CHAR | 1 | XFELD | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
BKKRS | Bank Area | BKK_BKKRS | CHAR | 4 | BKK_BKKRS | BNS | |||
ACNUM_INT | Internal Account Number for Current Account | BKK_ACCNT | CHAR | 10 | ALPHA | BKK_ACCNT | ACI | ||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
.INCLU--AP | 0 | ||||||||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
.INCLU-CMS | 0 | ||||||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
OBJECT_IDCMS | Object Identification Number | CMS_DTE_OBJECT_ID | RAW | 16 | SYSUUID | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
FLG_ORIGINALCMS | Flag to indicate if the document is original or duplicate | CMS_DTE_FLG_ORIG | CHAR | 1 | CMS_FLG | ||||
SENDCONTROLCMS | Dispatch Control | SENDCONTROL | CHAR | 4 | ESENDCONTROL | ||||
.INCLU--AP | 0 | ||||||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU-FVD | 0 | ||||||||
PRODUCTTYPEFVD | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
BP_ROLEFVD | BP Role | BU_PARTNERROLE | CHAR | 6 | BU_ROLE | BUPA_ROLE | |||
BP_ROLETYPEFVD | Business Partner Role Type | BP_ROLE | CHAR | 4 | BP_ROLE | ||||
SOBJECTFVD | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
CORR_ACTIVITYFVD | Correspondence activity | KORRVORF | NUMC | 4 | KORRVORF | ||||
REFERENCEDATEFVD | Reference Date for Creating Correspondence | TB_CORR_REFERENCE_DATE | DATS | 8 | DATUM | ||||
WA_RECEIVER | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
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 | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
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 | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
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 | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
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 | ||||
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 | ||||
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 | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
.INCLU--AP | 0 | ||||||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
.INCLU--AP | 0 | ||||||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
.INCLU--AP | 0 | ||||||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
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 | ||||
.INCLU--AP | 0 | ||||||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
WA_REC_ADDRDT | 0 | ||||||||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
ADRS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
ADRS_NUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
PERS_NUM | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
WA_REC_ADDRES | 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 | ||
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 | ||||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
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 | |||
WA_REC_ADDRDT | 0 | ||||||||
ADRS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
ADRS_NUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
PERS_NUM | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
WA_REC_ADDRES | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
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 | ||||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
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 | |||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
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 | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
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 | |||
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 | ||||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
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 | |||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
WA_REC_INDEP | 0 | ||||||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
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 | ||||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
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 | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
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 | |||
WA_REC_BANK | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
BANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
ERDAT | Date on which the record was created | ERDAT_BF | DATS | 8 | DATUM | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
ERNAM | Name of person who created the object | ERNAM_BF | CHAR | 12 | USNAM | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
BANKA | Name of bank | BANKA | CHAR | 60 | TEXT60 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
PROVZ | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
BGRUP | Bank group (bank network) | BGRUP | CHAR | 2 | BGRUP | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
XPGRO | Post Office Bank Current Account | XPGRO | CHAR | 1 | XFELD | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
BNKLZ | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
PSKTO | Post office bank current account number | PSKTO_CH | CHAR | 16 | PSKTO | ||||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
BRNCH | Bank Branch | BRNCH | CHAR | 40 | TEXT40 | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
CHKME | Check digit calculation method | CHECKMETH | CHAR | 4 | ALPHA | CHECKMETH | |||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
VERS | Format of File with Bank Data | VERS_BF | CHAR | 3 | ALPHA | VERS_BF | H_T005BU_VERS | ||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
WA_ADD_DATA | 0 | ||||||||
DATA | Char255 | CHAR255 | CHAR | 255 | CHAR255 | ||||
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 | ||||
WA_ORG_REC | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
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 | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
WA_ADD_REC | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
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 | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
WA_SENDER | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
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 | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
WA_SEN_ADDRDT | 0 | ||||||||
ADRS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
ADRS_NUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERS_NUM | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
WA_SEN_ADDRES | 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 | ||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
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 | ||||
WA_SEN_ADDESC | 0 | ||||||||
ADDRESS_DESC | BP: Address Description | BU_ADDSC | CHAR | 60 | TEXT60 | ||||
WA_ADD_DATA | 0 | ||||||||
DATA | Char255 | CHAR255 | CHAR | 255 | CHAR255 | ||||
T_DOCTART | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure FKKCORR_STR_EXP_CORRESP using ABAP code?
As FKKCORR_STR_EXP_CORRESP 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 FKKCORR_STR_EXP_CORRESP as there is no data to select.How to access SAP table FKKCORR_STR_EXP_CORRESP
Within an ECC or HANA version of SAP you can also view further information about FKKCORR_STR_EXP_CORRESP 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