FICA_BALANOTE_STR_BALANOTE SAP (Balance Notification Header) Structure details

Dictionary Type: Structure
Description: Balance Notification Header




ABAP Code to SELECT data from FICA_BALANOTE_STR_BALANOTE
Related tables to FICA_BALANOTE_STR_BALANOTE
Access table FICA_BALANOTE_STR_BALANOTE




Structure field list including key, data, relationships and ABAP select examples

FICA_BALANOTE_STR_BALANOTE 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 "Balance Notification Header" 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_FICA_BALANOTE_STR_BALANOTE TYPE FICA_BALANOTE_STR_BALANOTE.

The FICA_BALANOTE_STR_BALANOTE table consists of various fields, each holding specific information or linking keys about Balance Notification Header 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 FICA_BALANOTE_STR_BALANOTE 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_BALANOTE 0
MANDTClient MANDTCLNT3MANDT
COTYPCorrespondence Type COTYP_KKCHAR4COTYP_KKCOTYPCOTYP_KK
COKEYCorrespondence key COKEY_KKCHAR36COKEY_KK
UNAMEUser Name SYUNAMECHAR12SYCHAR12
CDATECreated On COCDT_KKDATS8SYDATS
CTIMETime of Creation (to the Second) COCTM_KKTIMS6SYTIME
GPARTCorrespondence Recipient CREC_GP_KKCHAR10ALPHABU_PARTNER
GPART_GUIDCorrespondence Recipient (GUID) CREC_GP_GUID_KKCHAR32SYSUUID_C
GPART_ADR_KINDAddress Type Of Correspondence Recipient CORR_ADR_KIND_KKCHAR10BU_ADRKIND
ORG_GPARTOriginal Correspondence Recipient CREC_ORG_GP_KKCHAR10ALPHABU_PARTNER
ORG_GPART_GUIDOriginal Correspondence Recipient (GUID) CREC_ORG_GP_GUID_KKCHAR32SYSUUID_C
ADD_GPARTAdditional Business Partner for Correspondence Recipient CREC_GP_ADD_KKCHAR10ALPHABU_PARTNER
ADD_GPART_GUIDAddit. Business Partner for Correspondence Recipient GUID CREC_GP_ADD_GUID_KKCHAR32SYSUUID_C
ADD_GPART_CATType of Additional Correspondence Recipient CREC_GP_ADD_CAT_KKCHAR1CORR_CREC_ADD_CAT_KK
VKONTContract Account Number CORR_VKONT_KKCHAR12ALPHACORR_VKONT_KK
VTREFReference Specifications from Contract CORR_VTREF_KKCHAR20ALPHACORR_VTREF_KK
ADR_VALID_ONAddress of Correspondence Recipient Valid On CREC_AD_VALID_ON_KKDEC15TZNTSTMPS
ADRNRAddress Number of Correspondence Recipient CREC_AD_KKCHAR10ALPHAAD_ADDRNUM
ADR_GUIDAddress GUID of Correspondence Recipient CREC_AD_GUID_KKCHAR32SYSUUID_C
ADRNR_INDEP_COMMAddress Number for Address-Independent Communication CREC_AD_INDEP_COMM_KKCHAR10ALPHAAD_ADDRNUM
AGPARTSending Business Partner CSEN_GP_KKCHAR10ALPHABU_PARTNER
AGPART_GUIDSender (GUID) CSEN_GP_GUID_KKCHAR32SYSUUID_C
AGPART_ADR_KINDAddress Type Of Correspondence Recipient CORR_ADR_KIND_KKCHAR10BU_ADRKIND
AADRNRAddress Number of Correspondence Sender CSEN_AD_KKCHAR10ALPHAAD_ADDRNUM
AADR_GUIDAddress GUID of Correspondence Sender CSEN_AD_GUID_KKCHAR32SYSUUID_C
FORMKEYApplication form FORMKEYCHAR30FORMKEYFOM
FORMKEY_RDIApplication form FORMKEYCHAR30FORMKEYFOM
ENTID1Correspondence data ENTID_KKCHAR4ENTID_KK
DATA1Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID2Correspondence data ENTID_KKCHAR4ENTID_KK
DATA2Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID3Correspondence data ENTID_KKCHAR4ENTID_KK
DATA3Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID4Correspondence data ENTID_KKCHAR4ENTID_KK
DATA4Correspondence Data Field CDATA_KKCHAR32CDATA_KK
CSORTCorrespondence Sort Field CSORT_KKCHAR50CORR_TXT50
XCODTData Part Is Used XCODT_KKCHAR1XFELD
XCODT_CLUSTCluster Data Part is Used XCODT_CLUST_KKCHAR1XFELD
LAUFDDate ID for Creation Run CORR_LAUFD_KKDATS8DATUM
LAUFIAdditional ID Characteristic for Creation Run CORR_LAUFI_KKCHAR6CORR_LAUFI_KK
XTESTCorrespondence is Result of Test XTEST_KKCHAR1XFELD
COPRIPrint Date COPRI_KKDATS8SYDATS
COIDTDate of Issue COIDT_KKDATS8SYDATS
COITMIssue Time to the Second COITM_KKTIMS6SYTIME
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
SALWATransaction Currency CORR_BLWAE_KKCUKY5WAERSFWS
SALBEAmount in Local Currency with +/- Signs CORR_BETRH_KKCURR13(2) WRTV7
SENDCONTROLDispatch Control SENDCONTROLCHAR4ESENDCONTROL
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
APERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
BUKRSCompany Code in Correspondence CORR_BUKRSCHAR4CORR_BUKRS
CORR_ROLECorrespondence Roles CORR_ROLE_KKCHAR4CORR_ROLE_KK
COPRI_LAUFDDate ID for Print Run COPRI_LAUFD_KKDATS8DATUM
COPRI_LAUFIID Characteristic for Run COPRI_LAUFID_KKCHAR6COPRI_LAUFID_KK
PROCESS_ID_Business Process ID CORR_PROCESS_ID_KKCHAR36
NO_DOCPARTSNumber of Document Parts CORR_NO_DOCPARTS_KKNUMC4
DOCPART_ROLEDocument Part Role CORR_DOCPART_ROLE_KKCHAR1CORR_DOCPART_ROLE_KK
XTRIALCorrespondence Request is Test XTRIAL_KKCHAR1XFELD
XREPRINTRecreate Correspondence XREPRINT_KKCHAR1XFELD
SUBAPSubapplication Indicator in Correspondence CORR_SUBAP_KKCHAR1CORR_SUBAP_KK
XDELETECorrespondence Is Logically Deleted X_CORR_DELETE_KKCHAR1XFELD
PRINT_MODEBusiness Partner Print Format PRINT_MODE_KKCHAR1BU_PRINT_MODE
X_NO_ARCSAP ArchiveLink Object ID Part Is Not Used X_NO_ARC_KKCHAR1XFELD
X_DOCPART_LISTDocument Part List Is Used X_DOCPART_LIST_KKCHAR1XFELD
.INCLU--AP 0
BKKRSBank Area BKK_BKKRSCHAR4BKK_BKKRSBNS
ACNUM_INTInternal Account Number for Current Account BKK_ACCNTCHAR10ALPHABKK_ACCNTACI
.INCLU--AP 0
.INCLU-CMS 0
OBJECT_IDCMSObject Identification Number CMS_DTE_OBJECT_IDRAW16SYSUUID
FLG_ORIGINALCMSFlag to indicate if the document is original or duplicate CMS_DTE_FLG_ORIGCHAR1CMS_FLG
SENDCONTROLCMSDispatch Control SENDCONTROLCHAR4ESENDCONTROL
.INCLU--AP 0
.INCLU-FVD 0
PRODUCTTYPEFVDProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
BP_ROLEFVDBP Role BU_PARTNERROLECHAR6BU_ROLEBUPA_ROLE
BP_ROLETYPEFVDBusiness Partner Role Type BP_ROLECHAR4BP_ROLE
SOBJECTFVDInternal key for object VVKEYOBJCHAR10VVKEY
CORR_ACTIVITYFVDCorrespondence activity KORRVORFNUMC4KORRVORF
REFERENCEDATEFVDReference Date for Creating Correspondence TB_CORR_REFERENCE_DATEDATS8DATUM
WA_RECEIVER 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
TYPEBusiness partner category BU_TYPECHAR1BU_TYPEBPY
BPKINDBusiness Partner Type BU_BPKINDCHAR4BU_KIND
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4BU_GROUPBPP
BPEXTBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
SOURCEData Origin Types BU_SOURCECHAR4BU_SOURCE
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
XDELECentral Archiving Flag BU_XDELECHAR1XFELD
XBLCKCentral Block for Business Partner BU_XBLCKCHAR1XFELD
AUGRPAuthorization Group BU_AUGRPCHAR4BU_AUGRP
TITLE_LETSalutation BU_TITLE_LETCHAR50TEXT50
BU_LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
CONTACTBusiness Partner: Contact Permission BU_CONTACTCHAR1BU_CONTACT
NOT_RELEASEDIndicator: Not Released BU_XNOT_RELEASEDCHAR1XFELD
NOT_LG_COMPETENTIndicator: Not Legally Competent BU_NOT_LEG_COMPETENTCHAR1BOOLE
PRINT_MODEBusiness Partner Print Format BU_PRINT_MODECHAR1BU_PRINT_MODE
BP_EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
NAPRBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
BBP_IPISPTax Split BBP_J_1BINDEQUCHAR1XFELD
.INCLU--AP 0
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15DPR_RATE_TYPE
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4BU_JOBGR
NATIONationality BU_NATIOCHAR3LAND1
CNTAXObsolete Field BU_CNTAXCHAR3LAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
LGTYPLegitimation Type BU_LGTYPCHAR4BU_LGTYP
LGNUMIdentification number of legitimation document BU_LGNUMCHAR16BU_LGNUM
INFCTResponsible local court BU_INFCTCHAR30BU_INFCT
COMRGEntry in commercial register BU_COMRGCHAR30CHAR30
CLBRGBP: Entry in register of associations BU_CLBRGCHAR30CHAR30
COPRGEntry in Register of Cooperatives BU_COPRGCHAR30CHAR30
COMREG_DATDate of entry in trade register BU_COMREG_DATDATS8DATUM
.INCLU--AP 0
M_BONIWERTCreditworthiness value set manually BONIWRT_KKNUMC4BONIT_KK
M_BONIDATDate on Which Creditworthiness was Manually Set BONIDAT_KKDATS8DATUM
NAME1Name field 1 (name1/last name) BU_NAME1CHAR40BU_NAME
NAME2Name field 2 (name2/first name) BU_NAME2CHAR40BU_NAME
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
WA_REC_ADRESS 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
XDFADRIndicator: Address is standard address BU_XDFADRCHAR1XFELD
ADEXTAddress number in external system BU_ADEXTCHAR20BU_ADEXT
NATIONVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
MOVE_ADDRNumber of Move Target Address for Address Moves BU_MOVE_ADDRCHAR10ALPHAAD_ADDRNUMADR
DATE_FROMDate Obsolete BU_DATE_OBSOLETEDATS8DATUM
ADDRESS_GUIDGUID of a Business Partner Address BU_ADDRESS_GUIDRAW16SYSUUID
ADDR_VALID_FROMValidity Start of a Business Partner Address BU_ADDR_VALID_FROMDEC15TZNTSTMPS
ADDR_VALID_TOValidity End of a Business Partner Address BU_ADDR_VALID_TODEC15TZNTSTMPS
ADDR_MOVE_DATEDate of Move for Address Moves BU_ADDR_MOVE_DATEDEC15TZNTSTMPS
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
WA_SENDER 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
TYPEBusiness partner category BU_TYPECHAR1BU_TYPEBPY
BPKINDBusiness Partner Type BU_BPKINDCHAR4BU_KIND
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4BU_GROUPBPP
BPEXTBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
SOURCEData Origin Types BU_SOURCECHAR4BU_SOURCE
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
XDELECentral Archiving Flag BU_XDELECHAR1XFELD
XBLCKCentral Block for Business Partner BU_XBLCKCHAR1XFELD
AUGRPAuthorization Group BU_AUGRPCHAR4BU_AUGRP
TITLE_LETSalutation BU_TITLE_LETCHAR50TEXT50
BU_LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
CONTACTBusiness Partner: Contact Permission BU_CONTACTCHAR1BU_CONTACT
NOT_RELEASEDIndicator: Not Released BU_XNOT_RELEASEDCHAR1XFELD
NOT_LG_COMPETENTIndicator: Not Legally Competent BU_NOT_LEG_COMPETENTCHAR1BOOLE
PRINT_MODEBusiness Partner Print Format BU_PRINT_MODECHAR1BU_PRINT_MODE
BP_EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
NAPRBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
BBP_IPISPTax Split BBP_J_1BINDEQUCHAR1XFELD
.INCLU--AP 0
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15DPR_RATE_TYPE
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4BU_JOBGR
NATIONationality BU_NATIOCHAR3LAND1
CNTAXObsolete Field BU_CNTAXCHAR3LAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
LGTYPLegitimation Type BU_LGTYPCHAR4BU_LGTYP
LGNUMIdentification number of legitimation document BU_LGNUMCHAR16BU_LGNUM
INFCTResponsible local court BU_INFCTCHAR30BU_INFCT
COMRGEntry in commercial register BU_COMRGCHAR30CHAR30
CLBRGBP: Entry in register of associations BU_CLBRGCHAR30CHAR30
COPRGEntry in Register of Cooperatives BU_COPRGCHAR30CHAR30
COMREG_DATDate of entry in trade register BU_COMREG_DATDATS8DATUM
.INCLU--AP 0
M_BONIWERTCreditworthiness value set manually BONIWRT_KKNUMC4BONIT_KK
M_BONIDATDate on Which Creditworthiness was Manually Set BONIDAT_KKDATS8DATUM
NAME1Name field 1 (name1/last name) BU_NAME1CHAR40BU_NAME
NAME2Name field 2 (name2/first name) BU_NAME2CHAR40BU_NAME
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
WA_SEN_ADRESS 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
XDFADRIndicator: Address is standard address BU_XDFADRCHAR1XFELD
ADEXTAddress number in external system BU_ADEXTCHAR20BU_ADEXT
NATIONVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
MOVE_ADDRNumber of Move Target Address for Address Moves BU_MOVE_ADDRCHAR10ALPHAAD_ADDRNUMADR
DATE_FROMDate Obsolete BU_DATE_OBSOLETEDATS8DATUM
ADDRESS_GUIDGUID of a Business Partner Address BU_ADDRESS_GUIDRAW16SYSUUID
ADDR_VALID_FROMValidity Start of a Business Partner Address BU_ADDR_VALID_FROMDEC15TZNTSTMPS
ADDR_VALID_TOValidity End of a Business Partner Address BU_ADDR_VALID_TODEC15TZNTSTMPS
ADDR_MOVE_DATEDate of Move for Address Moves BU_ADDR_MOVE_DATEDEC15TZNTSTMPS
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
WA_SEN_ANSADR 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
XDFADRIndicator: Address is standard address BU_XDFADRCHAR1XFELD
ADEXTAddress number in external system BU_ADEXTCHAR20BU_ADEXT
NATIONVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
MOVE_ADDRNumber of Move Target Address for Address Moves BU_MOVE_ADDRCHAR10ALPHAAD_ADDRNUMADR
DATE_FROMDate Obsolete BU_DATE_OBSOLETEDATS8DATUM
ADDRESS_GUIDGUID of a Business Partner Address BU_ADDRESS_GUIDRAW16SYSUUID
ADDR_VALID_FROMValidity Start of a Business Partner Address BU_ADDR_VALID_FROMDEC15TZNTSTMPS
ADDR_VALID_TOValidity End of a Business Partner Address BU_ADDR_VALID_TODEC15TZNTSTMPS
ADDR_MOVE_DATEDate of Move for Address Moves BU_ADDR_MOVE_DATEDEC15TZNTSTMPS
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
WA_BALANOTEEU 0
MANDTClient MANDTCLNT3MANDT
COTYPCorrespondence Type COTYP_KKCHAR4COTYP_KKCOTYPCOTYP_KK
COKEYCorrespondence key COKEY_KKCHAR36COKEY_KK
UNAMEUser Name SYUNAMECHAR12SYCHAR12
CDATECreated On COCDT_KKDATS8SYDATS
CTIMETime of Creation (to the Second) COCTM_KKTIMS6SYTIME
GPARTCorrespondence Recipient CREC_GP_KKCHAR10ALPHABU_PARTNER
GPART_GUIDCorrespondence Recipient (GUID) CREC_GP_GUID_KKCHAR32SYSUUID_C
GPART_ADR_KINDAddress Type Of Correspondence Recipient CORR_ADR_KIND_KKCHAR10BU_ADRKIND
ORG_GPARTOriginal Correspondence Recipient CREC_ORG_GP_KKCHAR10ALPHABU_PARTNER
ORG_GPART_GUIDOriginal Correspondence Recipient (GUID) CREC_ORG_GP_GUID_KKCHAR32SYSUUID_C
ADD_GPARTAdditional Business Partner for Correspondence Recipient CREC_GP_ADD_KKCHAR10ALPHABU_PARTNER
ADD_GPART_GUIDAddit. Business Partner for Correspondence Recipient GUID CREC_GP_ADD_GUID_KKCHAR32SYSUUID_C
ADD_GPART_CATType of Additional Correspondence Recipient CREC_GP_ADD_CAT_KKCHAR1CORR_CREC_ADD_CAT_KK
VKONTContract Account Number CORR_VKONT_KKCHAR12ALPHACORR_VKONT_KK
VTREFReference Specifications from Contract CORR_VTREF_KKCHAR20ALPHACORR_VTREF_KK
ADR_VALID_ONAddress of Correspondence Recipient Valid On CREC_AD_VALID_ON_KKDEC15TZNTSTMPS
ADRNRAddress Number of Correspondence Recipient CREC_AD_KKCHAR10ALPHAAD_ADDRNUM
ADR_GUIDAddress GUID of Correspondence Recipient CREC_AD_GUID_KKCHAR32SYSUUID_C
ADRNR_INDEP_COMMAddress Number for Address-Independent Communication CREC_AD_INDEP_COMM_KKCHAR10ALPHAAD_ADDRNUM
AGPARTSending Business Partner CSEN_GP_KKCHAR10ALPHABU_PARTNER
AGPART_GUIDSender (GUID) CSEN_GP_GUID_KKCHAR32SYSUUID_C
AGPART_ADR_KINDAddress Type Of Correspondence Recipient CORR_ADR_KIND_KKCHAR10BU_ADRKIND
AADRNRAddress Number of Correspondence Sender CSEN_AD_KKCHAR10ALPHAAD_ADDRNUM
AADR_GUIDAddress GUID of Correspondence Sender CSEN_AD_GUID_KKCHAR32SYSUUID_C
FORMKEYApplication form FORMKEYCHAR30FORMKEYFOM
FORMKEY_RDIApplication form FORMKEYCHAR30FORMKEYFOM
ENTID1Correspondence data ENTID_KKCHAR4ENTID_KK
DATA1Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID2Correspondence data ENTID_KKCHAR4ENTID_KK
DATA2Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID3Correspondence data ENTID_KKCHAR4ENTID_KK
DATA3Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID4Correspondence data ENTID_KKCHAR4ENTID_KK
DATA4Correspondence Data Field CDATA_KKCHAR32CDATA_KK
CSORTCorrespondence Sort Field CSORT_KKCHAR50CORR_TXT50
XCODTData Part Is Used XCODT_KKCHAR1XFELD
XCODT_CLUSTCluster Data Part is Used XCODT_CLUST_KKCHAR1XFELD
LAUFDDate ID for Creation Run CORR_LAUFD_KKDATS8DATUM
LAUFIAdditional ID Characteristic for Creation Run CORR_LAUFI_KKCHAR6CORR_LAUFI_KK
XTESTCorrespondence is Result of Test XTEST_KKCHAR1XFELD
COPRIPrint Date COPRI_KKDATS8SYDATS
COIDTDate of Issue COIDT_KKDATS8SYDATS
COITMIssue Time to the Second COITM_KKTIMS6SYTIME
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
SALWATransaction Currency CORR_BLWAE_KKCUKY5WAERSFWS
SALBEAmount in Local Currency with +/- Signs CORR_BETRH_KKCURR13(2) WRTV7
SENDCONTROLDispatch Control SENDCONTROLCHAR4ESENDCONTROL
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
APERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
BUKRSCompany Code in Correspondence CORR_BUKRSCHAR4CORR_BUKRS
CORR_ROLECorrespondence Roles CORR_ROLE_KKCHAR4CORR_ROLE_KK
COPRI_LAUFDDate ID for Print Run COPRI_LAUFD_KKDATS8DATUM
COPRI_LAUFIID Characteristic for Run COPRI_LAUFID_KKCHAR6COPRI_LAUFID_KK
PROCESS_ID_Business Process ID CORR_PROCESS_ID_KKCHAR36
NO_DOCPARTSNumber of Document Parts CORR_NO_DOCPARTS_KKNUMC4
DOCPART_ROLEDocument Part Role CORR_DOCPART_ROLE_KKCHAR1CORR_DOCPART_ROLE_KK
XTRIALCorrespondence Request is Test XTRIAL_KKCHAR1XFELD
XREPRINTRecreate Correspondence XREPRINT_KKCHAR1XFELD
SUBAPSubapplication Indicator in Correspondence CORR_SUBAP_KKCHAR1CORR_SUBAP_KK
XDELETECorrespondence Is Logically Deleted X_CORR_DELETE_KKCHAR1XFELD
PRINT_MODEBusiness Partner Print Format PRINT_MODE_KKCHAR1BU_PRINT_MODE
X_NO_ARCSAP ArchiveLink Object ID Part Is Not Used X_NO_ARC_KKCHAR1XFELD
X_DOCPART_LISTDocument Part List Is Used X_DOCPART_LIST_KKCHAR1XFELD
.INCLU--AP 0
BKKRSBank Area BKK_BKKRSCHAR4BKK_BKKRSBNS
ACNUM_INTInternal Account Number for Current Account BKK_ACCNTCHAR10ALPHABKK_ACCNTACI
.INCLU--AP 0
.INCLU-CMS 0
OBJECT_IDCMSObject Identification Number CMS_DTE_OBJECT_IDRAW16SYSUUID
FLG_ORIGINALCMSFlag to indicate if the document is original or duplicate CMS_DTE_FLG_ORIGCHAR1CMS_FLG
SENDCONTROLCMSDispatch Control SENDCONTROLCHAR4ESENDCONTROL
.INCLU--AP 0
.INCLU-FVD 0
PRODUCTTYPEFVDProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
BP_ROLEFVDBP Role BU_PARTNERROLECHAR6BU_ROLEBUPA_ROLE
BP_ROLETYPEFVDBusiness Partner Role Type BP_ROLECHAR4BP_ROLE
SOBJECTFVDInternal key for object VVKEYOBJCHAR10VVKEY
CORR_ACTIVITYFVDCorrespondence activity KORRVORFNUMC4KORRVORF
REFERENCEDATEFVDReference Date for Creating Correspondence TB_CORR_REFERENCE_DATEDATS8DATUM
WA_PARTNER 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
TYPEBusiness partner category BU_TYPECHAR1BU_TYPEBPY
BPKINDBusiness Partner Type BU_BPKINDCHAR4BU_KIND
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4BU_GROUPBPP
BPEXTBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
SOURCEData Origin Types BU_SOURCECHAR4BU_SOURCE
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
XDELECentral Archiving Flag BU_XDELECHAR1XFELD
XBLCKCentral Block for Business Partner BU_XBLCKCHAR1XFELD
AUGRPAuthorization Group BU_AUGRPCHAR4BU_AUGRP
TITLE_LETSalutation BU_TITLE_LETCHAR50TEXT50
BU_LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
CONTACTBusiness Partner: Contact Permission BU_CONTACTCHAR1BU_CONTACT
NOT_RELEASEDIndicator: Not Released BU_XNOT_RELEASEDCHAR1XFELD
NOT_LG_COMPETENTIndicator: Not Legally Competent BU_NOT_LEG_COMPETENTCHAR1BOOLE
PRINT_MODEBusiness Partner Print Format BU_PRINT_MODECHAR1BU_PRINT_MODE
BP_EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
NAPRBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
BBP_IPISPTax Split BBP_J_1BINDEQUCHAR1XFELD
.INCLU--AP 0
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15DPR_RATE_TYPE
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4BU_JOBGR
NATIONationality BU_NATIOCHAR3LAND1
CNTAXObsolete Field BU_CNTAXCHAR3LAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
LGTYPLegitimation Type BU_LGTYPCHAR4BU_LGTYP
LGNUMIdentification number of legitimation document BU_LGNUMCHAR16BU_LGNUM
INFCTResponsible local court BU_INFCTCHAR30BU_INFCT
COMRGEntry in commercial register BU_COMRGCHAR30CHAR30
CLBRGBP: Entry in register of associations BU_CLBRGCHAR30CHAR30
COPRGEntry in Register of Cooperatives BU_COPRGCHAR30CHAR30
COMREG_DATDate of entry in trade register BU_COMREG_DATDATS8DATUM
.INCLU--AP 0
M_BONIWERTCreditworthiness value set manually BONIWRT_KKNUMC4BONIT_KK
M_BONIDATDate on Which Creditworthiness was Manually Set BONIDAT_KKDATS8DATUM
NAME1Name field 1 (name1/last name) BU_NAME1CHAR40BU_NAME
NAME2Name field 2 (name2/first name) BU_NAME2CHAR40BU_NAME
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
WA_ACCOUNT 0
MANDTClient MANDTCLNT3MANDT
VKONTContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
LOEVMMark Contract Account for Deletion LOEVM_KKCHAR1LOEVM_KK
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
APPLKApplication area APPLK_KKCHAR1APPLK_KK
VKTYPContract Account Category VKTYP_KKCHAR2VKTYP_KKKTP
VKONAContract account number in legacy system VKONA_KKCHAR20CHAR20
VKBEZContract account name VKBEZ_KKCHAR35TEXT35
WA_ACCOUNTREL 0
MANDTClient MANDTCLNT3MANDT
VKONTContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
GPARTBusiness Partner Number GPART_KKCHAR10ALPHABU_PARTNERBPA
VKBEZContract account name VKBEZ_KKCHAR35TEXT35
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATPChanged On AEDATDATS8DATUM
AENAMPName of Person Who Changed Object AENAMCHAR12USNAM
FDZTGAdditional Days for Cash Management FDZTG_KKNUMC2NUM2
STOPDProcessing lock until STOPD_KKDATS8STOPD_KK
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
GUIDBusiness Agreement GUID BUAG_GUIDRAW16SYSUUID
DDLAMDirect Debit Limit DDLAM_KKCURR13(2) WRTV7
DDLCUCurrency of Direct Debit Limit DDLCU_KKCUKY5WAERS
DDLNMNumber of Months for Calculation of Direct Debit Limit DDLNM_KKNUMC2NUM02
INV_CYCLE_STARTStart Date of Billing Cycle in Contract Account CYCLE_STARTDATE_KKDATS8DATS
INV_CHGDISC_XInt: Charges and Discounts Exist for BP-CrtAcct Relations CHGDISC_X_KKCHAR1XFELD
BPL_XPOCLBusiness Partner Lock for Postings/Clearing BPL_XPOCL_KKCHAR1BPL_XPOCL_KK
BPL_FDATELock valid from FDATE_KKDATS8DATUM
BPL_TDATELock valid to TDATE_KKDATS8DATUM
EXVKOReference number for business partner EXVKO_KKCHAR25CHAR25
OPBUKCompany Code Group OPBUK_KKCHAR4OPBUK_KKOPBUK
STDBKStandard Company Code STDBK_KKCHAR4BUKRS
ABWREAlternative Payer ABWRE_KKCHAR10ALPHABU_PARTNERBUPA
ABWRAAlternative Payee ABWRA_KKCHAR10ALPHABU_PARTNERBUPA
ABWMAAlternative dunning recipient ABWMA_KKCHAR10ALPHABU_PARTNERBUPA
EBVTYBank Details ID for Incoming Payments EBVTY_KKCHAR4CHAR4
ABVTYBank Details ID for Outgoing Payments ABVTY_KKCHAR4CHAR4
EZAWEIncoming Payment Method EZAWE_KKCHAR1CHAR1
EZASPLock Reason for Incoming Payments EZASP_OLD_KKCHAR1SPZAH_KK
AZAWEOutgoing Payment Methods AZAWE_KKCHAR5CHAR5
AZASPLock Reason for Outgoing Payments AZASP_OLD_KKCHAR1SPZAH_KK
EIGBVOwn Bank Details EIGBV_KKCHAR25EIGBV_KK
VWNZACreate Where-Used List For Line Items VWNZA_KKCHAR1VWNZA_KK
LOEVMMark Contract Account for Deletion LOEVM_KKCHAR1LOEVM_KK
ABWVKAlternative contract account for collective bills ABWVK_KKCHAR12ALPHAVKONT_KK
IKEYInterest Key IKEY_KKCHAR2IKEY_KK
MAHNVDunning Procedure MAHNV_KKCHAR2MAHNV_KKFKK_MAHNV
MANSPDunning Lock Reason MANSP_OLD_KKCHAR1MANSP_KK
MGRUPGrouping fur Dunning Notices MGRUP_KKCHAR2MGRUP_KK
FDGRPPlanning Group FDGRP_KKCHAR10ALPHAFDGRPFFG
VKPBZRelationship of Business Partner to Contract Account VKPBZ_KKCHAR2VKPBZ_KK
ADRNBAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
VKONVContract account used for payment transactions VKONV_KKCHAR12ALPHAVKONT_KK
GPARVBusiness Partner Acting as Payer in Payment Transactions GPARV_KKCHAR10ALPHABU_PARTNER
ADRREAddress Number for Alternative Payer ADRRE_KKCHAR10ALPHAAD_ADDRNUM
ADRRAAddress Number for Alternative Payee ADRRA_KKCHAR10ALPHAAD_ADDRNUM
ADRMAAddress number for alternative dunning notice recipient ADRMA_KKCHAR10ALPHAAD_ADDRNUM
ABWRHAlternative Invoice Recipient ABWRH_KKCHAR10ALPHABU_PARTNERBUPA
ADRRHAddress number for alternative bill recipient ADRRH_KKCHAR10ALPHAAD_ADDRNUM
ADRJDCAddress Number for Jurisdiction Code Address ADRJDC_KKCHAR10ALPHAAD_ADDRNUM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
TOGRUTolerance group for contract account TOGRU_KKCHAR4TOGRU_KK
STOPGReason for Processing Lock STOPG_KKCHAR1STOPG_KK
TXJCDJurisdiction for Tax Calculation - Tax Jurisdiction Code TXJCD_NOCD_KKCHAR15TXJCDTXJ
COPRCCorrespondence Variant COPRC_KKCHAR4COPRC_KK
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
CCARD_IDPayment Card ID for Incoming Payments CCID_IN_KKCHAR6CHAR6
CCARD_OUTPayment Card ID for Outgoing Payments CCID_OUT_KKCHAR6CHAR6
UEBTRItems Transferred To Another Account XUEBTR_KKCHAR1XFELD
DEF_RECAlternative Correspondence Recipient for Standard Case DEF_CORR_PARTNER_KKCHAR10ALPHABU_PARTNERBUPA
DEF_REC_INDFI-CA correspondence - activity key DEF_CORR_ACKEY_KKCHAR4CORR_ACKEY_KK
QSSKZ_AWitholding Tax Code For Outgoing Payments QSSKZ_A_KKCHAR2QSSKZ
QSSKZ_EWithholding Tax Code For Incoming Payments QSSKZ_E_KKCHAR2QSSKZ
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
CORR_MAHNVCorrespondence Dunning Procedure CORR_MAHNV_KKCHAR2MAHNV_KK
FITYPTax type J_1AFITP_DCHAR2J_1AFITP
PROVINCESTATE (State, Province, County) REGIOCHAR3REGIO
COUNTYCounty Code COUNCCHAR3COUNC
VERTYPClearing Category For Clearing Postings VERTYP_KKCHAR4VERTYP_KK
AUGRS_DEFClearing Restriction AUGRS_DEF_KKCHAR1AUGRS_DEF_KK
LANDLCountry Supplied (for Tax Notifications) LANDL_KKCHAR3LAND1
BUPLABusiness Place BUPLACHAR4J_1BBRANCH
BPTAXTYPE1Tax Number Type 1 for Business Partner BPTAXTYPE1CHAR4BPTAXTYPE
BPTAXTYPE2Tax Number type 2 for Business Partner BPTAXTYPE2CHAR4BPTAXTYPE
PERSRClerk Responsible PERSR_KKCHAR10ALPHABU_PARTNERBUPA
INV_CATEGORYInvoicing Category INV_CATEGORY_KKCHAR4INV_CATEGORY_KK
DDLXGRolling Calculation of Direct Debit Limit DDLXG_KKCHAR1XFELD
CMGRPCollection Management: Master Data Group CMGRP_CM_KKCHAR2CMGRP_CM_KK
STRATCollection Strategy STRAT_CM_KKCHAR2STRAT_CM_KK
CPERSCollections Contact Person CPERS_CM_KKCHAR10ALPHABU_PARTNERBPA
BPCL_SUCCDuplicate Processing: Predecessor/Successor Business Partner BPCL_SUCC_KKCHAR1BPCL_SUCC_KK
INV_SCHEDULESelection Characteristic for Scheduling INV_SCHEDULE_KKCHAR4INV_SCHEDULE_KK
INV_CYCLEBilling Cycle CYCLE_KKCHAR4CYCLE_KK
INV_CYCLE_RULEField Is Not Used - CHAR4 CYCLE_RULE_KKCHAR4
INV_CYCLE_DAYDay of Period End CYCLE_DAY_KKCHAR2CYCLE_DAY_KK
INV_CYCLE_MONTHField Is Not Used - CHAR2 NOT_USED_CHAR2_KKCHAR2
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
WA_PARAMS 0
R_BETRH 0
XPERIOD_APPENDIXCorrespondence: Print Period Supplement XPERIOD_APPENDIX_KKCHAR1XFELD
SEL_NAME_MAPredefined Selection for Master Data SLNMA_KKCHAR10SLNAM_KKFKK_SELP_OPNAME
COR_IGN_MAIgnore Correspondence Variant COIGN_KKCHAR1XFELD
COPERCorrespondence Interval COPER_KKCHAR1COPER_KK
SENDCONTROLDispatch Control SENDCONTROLCHAR4ESENDCONTROL
CHGIDCharges schema CORR_CHGID_KKCHAR2CORR_CHGID_KKCORR_CHGID_KK
OLDDT_PROld Items To OLDDT_RB_KKCHAR1BOOLE
OLDDT_INPOld Items To OLDDT_RB_KKCHAR1BOOLE
OLDDTKey Date for Items in Balance Notification OLDDT_KKDATS8DATUM
KEYDTKey Date for Balance Notification KEYDT_KKDATS8SYDATS
SALDO 0
UMSATZ 0
UMSINTReceivables Volume: Time Interval UMSINT_KKNUMC3NUM3
WAERHLocal currency WAERHCUKY5WAERS
SALNULLNo Accounts with Zero Balance SALNULL_KKCHAR1XFELD
UMSNULLOnly Accounts without Transactions UMSNULL_KKCHAR1XFELD
MLAUFDDunning Date ID MLAUFD_KKDATS8DATUM
MLAUFIDunning Identification Characteristic MLAUFI_KKCHAR6LAUFI_KK
METHODBalance Confirmation Procedure BNMETH_KKCHAR1F130BSTV
RANTWORTBalance Notification - No Reply BNANTW_KKCHAR1XFELD
T_SALDO 0
T_SALDOEURO 0
T_ITEM 0
T_ITEMOLD 0

Key field Non-key field



How do I retrieve data from SAP structure FICA_BALANOTE_STR_BALANOTE using ABAP code?

As FICA_BALANOTE_STR_BALANOTE 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 FICA_BALANOTE_STR_BALANOTE as there is no data to select.

How to access SAP table FICA_BALANOTE_STR_BALANOTE

Within an ECC or HANA version of SAP you can also view further information about FICA_BALANOTE_STR_BALANOTE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!