RFVD_STR_CORR_CL_DEFCAP SAP (Loans: General Data Transfer) Structure details

Dictionary Type: Structure
Description: Loans: General Data Transfer




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




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

RFVD_STR_CORR_CL_DEFCAP 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 "Loans: General Data Transfer" 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_RFVD_STR_CORR_CL_DEFCAP TYPE RFVD_STR_CORR_CL_DEFCAP.

The RFVD_STR_CORR_CL_DEFCAP table consists of various fields, each holding specific information or linking keys about Loans: General Data Transfer 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 RFVD_STR_CORR_CL_DEFCAP 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_CL_DEFCAP 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_ORIGINAL 0
CLIENTClient MANDTCLNT3MANDT
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
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
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
CRUSRUser who created the object BU_CRUSRCHAR12USNAM
CRDATDate on which the object was created BU_CRDATDATS8DATUM
CRTIMTime at which the object was created BU_CRTIMTIMS6UZEIT
CHUSRLast user to change object BU_CHUSRCHAR12USNAM
CHDATDate when object was last changed BU_CHDATDATS8DATUM
CHTIMTime at which object was last changed BU_CHTIMTIMS6UZEIT
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
ADDRCOMMAddress Number BU_ADDRCOMMCHAR10ALPHAAD_ADDRNUMADR
TD_SWITCHPlanned Change Documents for Partner Were Converted BU_TD_SWITCHCHAR1CHAR1
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRECHAR1BU_IS_ORG_CENTRE
DB_KEYUUID in X form (binary) SYSUUID_XRAW16SYSUUID
VALID_FROMValidity Start BUT000 BP Data BU_BP_VALID_FROMDEC15TZNTSTMPS
VALID_TOValidity End BUT000 BP Data BU_BP_VALID_TODEC15TZNTSTMPS
XPCPTBusiness Purpose Completed Flag BU_XPCPTCHAR1BU_XPCPT
.INCLU--AP 0
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
.INCLU--AP 0
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
BP_SORTSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
.INCLU--AP 0
KBANKSBank country key BANKSCHAR3LAND1BKL
KBANKLBank Keys BANKKCHAR15BANKKBNK
.INCLU--AP 0
WA_ORG_ADRDAT 0
ADRS_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
ADRS_NUMAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
PERS_NUMPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
BAD_ADDRESS_ACTIONSystem Response When Correspondence Cannot Be Delivered TB_BAD_ADDRESS_FLAGCHAR1T_BAD_ADDRESS_FLAG
WA_ORG_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_ORG_NAME 0
NAME_COUNTRYCountry Key LAND1CHAR3LAND1LND
FORMATTED_NAMEAddress line LINESCHAR80LINES
FORMATTED_NAME_WITH_TITLEAddress line LINESCHAR80LINES
GREETING_LINEAddress line LINESCHAR80LINES
WA_ORG_TITLES 0
TITLE_MEDITitle text AD_TITLETXCHAR30TEXT30
TITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ACA2Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ROYLName supplement, e.g. noble title (written form) AD_TITLESTCHAR20TEXT20
PREFIX1Name prefix AD_PREFIXTCHAR20TEXT20
PREFIX2Name prefix AD_PREFIXTCHAR20TEXT20
WA_RECEIVER 0
CLIENTClient MANDTCLNT3MANDT
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
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
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
CRUSRUser who created the object BU_CRUSRCHAR12USNAM
CRDATDate on which the object was created BU_CRDATDATS8DATUM
CRTIMTime at which the object was created BU_CRTIMTIMS6UZEIT
CHUSRLast user to change object BU_CHUSRCHAR12USNAM
CHDATDate when object was last changed BU_CHDATDATS8DATUM
CHTIMTime at which object was last changed BU_CHTIMTIMS6UZEIT
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
ADDRCOMMAddress Number BU_ADDRCOMMCHAR10ALPHAAD_ADDRNUMADR
TD_SWITCHPlanned Change Documents for Partner Were Converted BU_TD_SWITCHCHAR1CHAR1
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRECHAR1BU_IS_ORG_CENTRE
DB_KEYUUID in X form (binary) SYSUUID_XRAW16SYSUUID
VALID_FROMValidity Start BUT000 BP Data BU_BP_VALID_FROMDEC15TZNTSTMPS
VALID_TOValidity End BUT000 BP Data BU_BP_VALID_TODEC15TZNTSTMPS
XPCPTBusiness Purpose Completed Flag BU_XPCPTCHAR1BU_XPCPT
.INCLU--AP 0
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
.INCLU--AP 0
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
BP_SORTSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
.INCLU--AP 0
KBANKSBank country key BANKSCHAR3LAND1BKL
KBANKLBank Keys BANKKCHAR15BANKKBNK
.INCLU--AP 0
WA_REC_ADRDAT 0
ADRS_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
ADRS_NUMAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
PERS_NUMPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
BAD_ADDRESS_ACTIONSystem Response When Correspondence Cannot Be Delivered TB_BAD_ADDRESS_FLAGCHAR1T_BAD_ADDRESS_FLAG
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_REC_NAME 0
NAME_COUNTRYCountry Key LAND1CHAR3LAND1LND
FORMATTED_NAMEAddress line LINESCHAR80LINES
FORMATTED_NAME_WITH_TITLEAddress line LINESCHAR80LINES
GREETING_LINEAddress line LINESCHAR80LINES
WA_REC_TITLES 0
TITLE_MEDITitle text AD_TITLETXCHAR30TEXT30
TITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ACA2Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ROYLName supplement, e.g. noble title (written form) AD_TITLESTCHAR20TEXT20
PREFIX1Name prefix AD_PREFIXTCHAR20TEXT20
PREFIX2Name prefix AD_PREFIXTCHAR20TEXT20
WA_SEN_ADRESS 0
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
ADDRHANDLEHandle for Creating Addresses/Persons (Bus. Addr. Services) AD_HANDLECHAR140TEXT140
NATIONVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
DATEDate referred to AD_DATEDATS8DATUM
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_TXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
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_COMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3AD_COMM
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL_EXTENSFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
ADDR_GROUPAddress Group (Key) (Business Address Services) AD_GROUPCHAR4AD_GROUP
WA_CONTRACT 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
SOBJEKTInternal key for object VVKEYOBJCHAR10VVKEY
SSTATIStatus of data record SSTATINUMC2STATI
SANLFProduct Category SANLFNUMC3VVSANLF
GSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
RREFKONTAccount Assignment Reference in Financial Assets Management RREFKONTCHAR8USTRUKRE
HBKIDShort Key for a House Bank HBKIDCHAR5HBKID
HKTIDID for account details HKTIDCHAR5HKTID
STITELLoan Type Indicator STITELNUMC3STITEL
SGLZBSCB asset group indicator SGLZBCHAR4SGLZB
SFIBGAsset Grouping Indicator SFIBGNUMC4SFIBG
SBILKBalance Sheet Indicator SBILKCHAR2SBILK
XALKZShort name XALKZCHAR15XKBEZ
XALLBLong name XALLBCHAR60XLBEZ
XAKTFile Number XAKTCHAR32CHAR32
RANLALT1Alternative Identification RANLALT1CHAR13CHAR13
RANLALT2Alternative identification 2 RANLALT2CHAR13CHAR13
SGR1Group Key 1 (Freely Available) SGRP1CHAR6SGRP1
SGR2Group Key 2 (Freely Available) SGRP2CHAR6SGRP2
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
RANLKETPrinciple loan investment number RANLHPTCHAR13CHAR13RAN
RANTRAGApplication number RANTRAGCHAR13CHAR13
SSOLISTPlan/Actual principle VVSSOLISTCHAR1VVSSOLIST
SFRISTLoan Term SFRISTNUMC2SFRIST
BANTRAGCapital applied for BANTRAGCURR13(2) BWHR
SANTWHRCurrency SWHRCUKY5WAERSWHR
DANTRAGEntry Date of Loan Application DANTRAGDATS8DATUM
BZUSAGECommitment capital BZUSAGECURR13(2) WERTV7
DZUSAGELoan - Date of Commitment by Lender DZUSAGEDATS8DATUM
DZUSAGE_ORIGINDate of the Original Approval from the Lender DZUSAGE_ORIGINDATS8DATUM
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Loan Term DENDLFZDATS8DATUM
DBDISStart of distribution of discount DBDISDATS8DDAT
SDISMETHDiscount distribution method SDISMETHNUMC1DISMETH
SSICHERPrimary collateral SSICHERCHAR4SSICH
SVZWECKPurpose of Loan SVZWECKCHAR2SVZWK
SSONDERSpecial treatment of loan SSONDERNUMC2SSONDER
SFIWOIndicator: Type of Residential Object Financing SFIWOCHAR2SFIWO
SDTIDTI indicator SDTINUMC5NUMC
SHOMEHome statement SHOMENUMC3SHOME
SLAENDERCountry ID SLAENDERCHAR3LAND1
AABTRETNumber of Assignments Still Possible AABTRETNUMC2NUM02
BABTRETMinimum amount for assignments BABTRETCURR13(2) BWHR
SNICHTABReason for Non-Acceptance SNICHTABNUMC2SNICHTAB
DARCHIVDate of Rejection/Withdrawal DARCHIVDATS8DATUM
BGESDARTotal amount of syndicated loan BGESDARCURR13(2) BWHR
DKONSSyndicate loan date DKONSDATS8DATUM
SKWGKREDCredit category indicator Para. 75 report (Austria) SKWGKREDNUMC1SKWGKRED
SKWGDARCredit type indicator for Austrian reporting SKWGDARNUMC1SKWGDAR
JORIGPosting system indicator for borrower's note loans BUCHSYSNUMC1BUCHSYS
VVSLOEKZDeletion indicator VVSLOEKZNUMC1VVSLOEKZ
SDTYPLoans Class VVSDTYPNUMC3VVSDTYP
DBEWIApproval date VVDBEWIDATS8DATUM
SABTRANSIndicator for Possible Foreign Assignment VVSABTRANSCHAR1XFELD
AKONSNumber of syndicate members VVAKONSNUMC3NUM03
SFGKZRelease Indicator VVSFGKZCHAR1VVSFGKZ
SABTAssignee VVSABTCHAR4VVSABT
MABERDunning Area MABERCHAR2MABER
MAHNSDunning level MAHNS_DNUMC1MAHNS
MADATLast dunned on MADATDATS8DATUM
RPNRActivity number/rollover number VVRPNRNUMC8NUMC08
RSBEARDummy field 12 characters CHAR DUMMY_12CHAR12CHAR12
SONDSTSpecial posting treatment VVSONDSTCHAR2VVSONDST
SGRP3Group Key 3 (Freely Available) SGRP3CHAR6SGRP3
SGRP4Group Key 4 (Freely Available) SGRP4CHAR6SGRP4
SZKEYIndicator for Control of Incoming Payment Distribution VVSZKEYNUMC2VVSZKEY
BEGRUAuthorization Group BEGRUCHAR4BEGRU
SVERFUType of Restraint on Drawing VVSVERFUNUMC2VVSVERFU
STITARTBorrower's Note Loan Security Type VVSTITARTNUMC2VVSTITART
NABTRVContract of assignment number VVNABTRVCHAR15CHAR15
NAVALGuarantee number VVNAVALCHAR15CHAR15
DABTRDate of assignment VVDABTRDATS8DATUM
DVERFUDate of restraint on disposal upto VVDVERFUDATS8DATUM
SFGBEWTransaction data to be released available VVSFGBEWNUMC2VVSFGBEW
DELSOZDate of last special interest payment period VVDLESOZDATS8DATUM
RPORTBPortfolio RPORTBCHAR10RPORTBT50H_RPORTB_CORE
SREGIONSales Region VVSREGIONCHAR4VVSREGION
SGESSTBranch Office VVSGESSTCHAR4VVSGESST
SBEALoan Processing Indicator VVSBEANUMC2VVSBEA
SOBEZOrganizational District VVSOBEZCHAR2CHAR2
SBEZIRKAgent District VVSBEZIRKCHAR4CHAR4
SPLITDebit position splitting VVSPLITCHAR1XFELD
BNBUERGInitial capital not guaranteed VVBNBUERGCURR13(2) WERTV7
SREFZINSLoan With Reference Interest Rate VVSREFZINSCHAR1XFELD
SMAHNMLoan Manual Dunning Level VVSMAHNMCHAR1VVSMAHNM
SIHERKVersion Number Component CHAR2CHAR2CHAR2
RGENUMCharacter Field Length = 10 CHAR10CHAR10CHAR10
DRUECKDate when loan will probably be redeemed VVDRUECKDATS8DATUM
SABGRENZLoan Discount Accrual/Deferral Method VVSABGRDCHAR1VVSABGRD
SFESTIndicator for Control of Fixed Contract VVFESTKZCHAR1VVFESTKZ
SRATINGRating BP_RATINGCHAR3BP_RATING
SRATAGENRating agency SRATAGEN_NEWCHAR10ALPHABU_PARTNERBPABUPA
RDARNEHMBusiness Partner Number BP_PARTNR_NEWCHAR10ALPHABU_PARTNERBPABUPA
OBJNRObject Number for Financial Transactions TB_FINOBJNRCHAR22J_OBJNR
HDN_KUNNRMain Borrower Customer Number HDN_KUNNRCHAR10ALPHAKUNNR
SKWG14_NEUPosition grouping acc. Para 14 GBA (Sec. and loans) VVSKWG14CHAR2VVSKWG14
RANLSTAMNRMaster number part of loan number for finding contracts RANLSTAMNRCHAR13ALPHARANL
MIGDATEMigration date MIGDATEDATS8DATUM
SDUNNCMPSummarization Level for Dunning Letter SDUNNCMPCHAR2SDUNNCMP
XNODUNNExclude Loan from Dunning Run XNODUNNCHAR1XFELD
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
SDUNCHARGPost Dunning Charges and Interest to this Contract SDUNCHARGCHAR1XFELD
SWHRORGLoan currency before conversion to EURO SWHRORGCUKY5WAERS
DCONVERTDate loan was converted to EURO DCONVERTDATS8DATE
DCORRECTDate for adjustment flows resulting from EURO conversion DCORRECTDATS8DATE
SAKTPASIndicator: Asset/Liability Transaction VVSAKTPASCHAR1VVSAKTPAS
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10ALPHABU_PARTNERBPABUPA
GSBERBusiness Area GSBERCHAR4GSBERGSB
JNOREPAYPayoff Lock TB_JNOREPAYCHAR1XFELD
JNODOIPBlocked by Payoff: No Open Item Clearing for Loan TB_JNODOIPCHAR1XFELD
COM_VAL_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TPM_COM_VAL_CLASSCVC
SARC_EXCLDocuments For The Loan May Not Be Archived TB_SARC_EXCLCHAR1T_SARC_EXCL
SARC_DOCSIndicator: Archived Loan Documents Exist TB_SARC_DOCSCHAR1T_SARC_DOCS
NO_PLAN_DONEDo Not Transfer Loan to Status 'Completed' TB_NO_PLAN_DONECHAR1CHECKBOX
DPLAN_SETDate of Transfer of Contract into Status Planned Completed TB_DPLAN_SETDATS8DATUM
DOPENOpening Date of a Loan Contract TB_DOPENDATS8DATUM
DCLOSEClosing Date of a Loan Contract TB_DCLOSEDATS8DATUM
DUNN_BLOCK_TILLExpiration Date of Dunning Lock TB_VIEW_DATE_DUNNING_BLOCK_TILDATS8DATUM
XNOIOALock for Interest on Arrears TB_XNOIOACHAR1CHAR1
NOIOA_TILLExpiry Date of Lock on Interest on Arrears TB_NOIOA_TILLDATS8DATUM
ORIGINLoan Origin TB_ORIGINCHAR2T_ORIGIN
DCALLENDProvision Expiry Date TB_DCALLENDDATS8DATUM
SVER_EXCLDocuments for the loan may not be summarized TB_SVER_EXCLCHAR1T_SVER_EXCL
LC_DISBURSEMENTProcessing Characteristic: Disbursement Status TB_LC_CHARAC_DISBURSEMENTCHAR1T_LC_CHARACVALUEH_VD_CHARAC_DISBURSEMENT
LC_CAPITALSProcessing Characteristic: Status of Capital Amounts TB_LC_CHARAC_CAPITALSCHAR1T_LC_CHARACVALUEH_VD_CHARAC_CAPITALS
LC_PLANNED_FLOWProcessing Characteristic: Status of Planned Records TB_LC_CHARAC_PLANNED_FLOWCHAR1T_LC_CHARACVALUEH_VD_CHARAC_PLANNED_FLOW
LC_DEBITProcessing Characteristic: Status of Customer Receivables TB_LC_CHARAC_DEBITCHAR1T_LC_CHARACVALUEH_VD_CHARAC_DEBIT
LC_CREDITProcessing Characteristic: Status of Customer Payables TB_LC_CHARAC_CREDITCHAR1T_LC_CHARACVALUEH_VD_CHARAC_CREDIT
LC_STATUSStatus of Processing Characteristics for Loan TB_LC_STATUSCHAR1T_LC_STATUS
PAYM_STATUSPayment Status TB_PAYM_STATUSCHAR1T_PAYM_STATUS
STOP_INDICATORStop Indicator TB_STOP_INDICATORCHAR1T_STOP_INDICATOR
PRODUCT_IDInternal Product ID TB_PR_PRODINTCHAR18T_PR_PRODINT
PRODUCT_VERSIONProduct Version TB_PR_VERSIONNUMC4T_PR_VERSIONTD_PRODVERSION
SCHUFA_MESSAGEBusiness Partner Has Signed a Schufa Declaration TB_VIEW_SCHUFACHAR1XFELD
DAT_FULL_PAYDate of Full Disbursement TB_VIEW_DATE_OF_FULL_PAYMENTDATS8DATUM
DAT_OF_CANCELRescission Date TB_VIEW_DATE_OF_CANCELATIONDATS8DATUM
FLG_CNCLRescission Indicator TB_CNCLCHAR1BOOLE
DINSTRDate Customer Was Instructed About Rescission Rights TB_DINSTRDATS8DATUM
ORGUNITOrganizational Unit TB_MD_ORGUNIT_CNMGTCHAR12T_MD_ORGUNIT_CNMGT
DISTRIB_CHANNELSales Channel TB_MD_DISTRIBUTION_CHANNELCHAR10T_MD_DISTRIBUTION_CHANNEL
FLG_CNCL_CLIIndicator: Rescind Credit Life Insurance TB_CNCL_CLICHAR1T_CNCL_CLI
FLG_NO_CHANGEOnly Limited Changes Possible for Contract Indicator TB_MD_NO_CHANGECHAR1TB_MD_NO_CHANGE
SCHEME_IDCalculation Profile for Interest on Arrears Calculation TB_SCHEME_IDCHAR3T_SCHEME_ID
SSTATE_OF_EXECRegion Where Contract Concluded TB_SREGIONCHAR3REGIO
WAIVE_REASONReason for Automatic Waiver of Charges TB_WAIVE_REASONCHAR3T_WAIVE_REASON
WAIVE_METHODWaiver Method TB_WAIVE_METHODNUMC1T_WAIVE_METHOD
BACKOFFICE_IDBack Office TB_BACKOFFICE_IDNUMC8HROBJID
FLG_NON_ACCRUALNon-Accrual Status Permitted TB_FLG_NON_ACCRUALCHAR1XFELD
SFIMA_METHODControl Settings for FiMa Connection TB_FIMA_METHODCHAR1T_FIMA_METHOD
GRACE_DAYSGrace Days TB_GRACEDAYSNUMC3NUM03
NOIOA_TILL_BLOCKEnd Date of Non-IOA Period TB_NOIOA_TILL_BLOCKDATS8DATS
FLG_SYNDICATESyndicated Loan TB_FLG_SYNDICATECHAR1XFELD
FLG_FACILITYLoan: Part of Facility TB_FLG_FACILITYCHAR1XFELD
SHADOW_ACCNTValue of Shadow Account TB_SHD_ACCNTCHAR1CHAR1
.INCLU--AP 0
OPTIMAL_LISTFor interest adjust optimization solution list TB_OP_LIST_CMLCHNCHAR1T_OP_LIST_CMLCHN
.INCLU--AP 0
RP_RELEVANTFlag „relevant for German Banking Act ' VVRP_RELEVANTCHAR1XFELD
.INCLU--AP 0
CONTRACT_BICSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
CONTRACT_IBANIBAN (International Bank Account Number) BU_IBANCHAR34CHAR34
IBAN_DETType of Determination of IBAN for a contract TB_SEPA_IBAN_DETCHAR1TB_SEPA_IBAN_DET_DOM
.INCLU--AP 0
FAC_GROUP_NUMBERFacility Grouping Identifier TB_FACILITY_GROUP_NUMBERCHAR13ALPHARANL
FLG_DD_REVOLVINGRevolving Drawdown TB_FLG_DRAWDOWN_REVOLVINGCHAR1T_FLG_DRAWDOWN_REVOLVING
FLG_FAC_INACTIVEFacility Inactive TB_FLG_FACILITY_INACTIVECHAR1T_FLG_FACILITY_INACTIVE
.INCLU--AP 0
OBJ_IDData object Identifier DATOBJ_IDCHAR50CHAR50
OBJ_KEYKey for Archive File ARKEYCHAR20ARKEY
OBJ_OFFSETArchive file data object offset ADMI_OFFSTINT410
.INCLU--AP 0
FLPLoan Belongs to Forward Loan Purchase TB_FLP_FLAGCHAR1T_FLP_FLAG
FLP_NUMBERForward Loan Purchase Deal Number TB_FLP_DEAL_NUMBERCHAR13ALPHAT_FLP_DEAL_NUMBER
.INCLU--AP 0
VDBEPP_DBEARPlanned Records Last Edited On VDBEPP_DBEARDATS8DATUM
VDBEPP_TBEARPlanned Records Last Edited At VDBEPP_TBEARTIMS6TIMES
VDBEPP_RBHERPlanned Records Editing Source VDBEPP_RBHERCHAR10CHAR10
.INCLU--AP 0
RESERVED_AMOUNTReserved amount TB_FACILITY_RES_AMT_CMLCHNCURR13(2) BWHR
WA_PARTNER 0
CLIENTClient MANDTCLNT3MANDT
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
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
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
CRUSRUser who created the object BU_CRUSRCHAR12USNAM
CRDATDate on which the object was created BU_CRDATDATS8DATUM
CRTIMTime at which the object was created BU_CRTIMTIMS6UZEIT
CHUSRLast user to change object BU_CHUSRCHAR12USNAM
CHDATDate when object was last changed BU_CHDATDATS8DATUM
CHTIMTime at which object was last changed BU_CHTIMTIMS6UZEIT
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
ADDRCOMMAddress Number BU_ADDRCOMMCHAR10ALPHAAD_ADDRNUMADR
TD_SWITCHPlanned Change Documents for Partner Were Converted BU_TD_SWITCHCHAR1CHAR1
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRECHAR1BU_IS_ORG_CENTRE
DB_KEYUUID in X form (binary) SYSUUID_XRAW16SYSUUID
VALID_FROMValidity Start BUT000 BP Data BU_BP_VALID_FROMDEC15TZNTSTMPS
VALID_TOValidity End BUT000 BP Data BU_BP_VALID_TODEC15TZNTSTMPS
XPCPTBusiness Purpose Completed Flag BU_XPCPTCHAR1BU_XPCPT
.INCLU--AP 0
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
.INCLU--AP 0
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
BP_SORTSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
.INCLU--AP 0
KBANKSBank country key BANKSCHAR3LAND1BKL
KBANKLBank Keys BANKKCHAR15BANKKBNK
.INCLU--AP 0
WA_ADRDAT 0
ADRS_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
ADRS_NUMAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
PERS_NUMPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
BAD_ADDRESS_ACTIONSystem Response When Correspondence Cannot Be Delivered TB_BAD_ADDRESS_FLAGCHAR1T_BAD_ADDRESS_FLAG
WA_ADDRESS 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_NAME 0
NAME_COUNTRYCountry Key LAND1CHAR3LAND1LND
FORMATTED_NAMEAddress line LINESCHAR80LINES
FORMATTED_NAME_WITH_TITLEAddress line LINESCHAR80LINES
GREETING_LINEAddress line LINESCHAR80LINES
WA_CAP_DETS 0
VDCAPITAL 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SBO_CATBusiness Operation Category SBO_CATCHAR1SBO_CAT
SBO_STATUSBus. operation status TB_SBOSTATUSCHAR1SBO_STATUS
SBO_STATUS_OLDLoans: Business operation status SBO_STATUSCHAR1SBO_STATUS
XBO_TEXTText for Business Operation XBOTEXTCHAR30TEXT30
SRELSTATInternal Release Status in the Business Operations TB_SRELSTATCHAR1T_SRELSTAT
SFGKZRelease Workflow Indicator for the Business Operation TB_SFGKZACHAR1T_SFGKZ
UCURRPosition Currency (Currency of Position Amount) SBWHRCUKY5WAERS
AARRBALTotal Amount of Overdue Items TB_ARRBALANCECURR13(2) WERTV7
AFUDUPAYTotal Amount for Payments Due in the Future TB_FUDUPAYCURR13(2) WERTV7
ACAPRECSTotal Amount of Receivables to Be Included in Loan TB_CAPRECSCURR13(2) WERTV7
ACREBALTotal Amount of Credit TB_CREBALCURR13(2) WERTV7
ABALNUITTotal Amount of Non-Selected Items TB_BALNUITCURR13(2) WERTV7
ABALNCPRECSTotal Amount of Receivables Not Included in Loan TB_BALNCPRECSCURR13(2) WERTV7
IINCL_KYDTETerm Including Key Date TB_INCLKYDTECHAR1XFELD
IULTI_KYDTEKey Date Must Be Last Day of the Month TB_ULTIKYDTECHAR1XFELD
DPAYM_TOPayments to TB_PAYM_TODATS8DATUM
INOTE_ASSIGNEDMemo Exists TB_IND_NOTE_ASSIGNEDCHAR1XFELD
APRCCHRGEProcessing Charge for Deferral or Capitalization TB_PRCCHRGECURR13(2) WERTV7
ICAPITALInclude Processing Charge in Loan TB_ICAPITALCHAR1XFELD
IDEVIATE_PAYMAlternative Payment Information in Additional Flows TB_DEVIATE_PAYMCHAR1XFELD
MNORISKMSNumber of Risk-Increasing Measures TB_NORISKMSNUMC2T_NORISKMS
IOA_AMOUNTInterest on Arrears Calculated TB_IOA_CALCULATION_RESULTCURR13(2) WERTV7
MPOSTTYPEPosting Control TB_DEFCAPPOSTTYPENUMC2VVSBUST
IDUNNBLCKDunning Block for Items for Deferral or Capitalization TB_DUNNBLCKCHAR1MANSP
IIOABLCKInterest on Arrears Block for Items for Deferral/Capitaliz. TB_IOABLCKCHAR2ZINKZ
IDUBLDEFIDunning Block for Deferral Installments TB_DUBLDEFRCHAR1MANSP
IIOABLDEFIInterest on Arrears Block for Deferral Installments TB_IOADEFICHAR2ZINKZ
IPAYBLCKPayment Block for Deferral Installments TB_PAYBLCKCHAR1ZAHLS
DOFFER_FRCreation Date for the Offer TB_OFFER_FRDATS8DATUM
DOFFER_TOEnd of the Validity Period of the Offer TB_OFFER_TODATS8DATUM
DACCEPTAcceptance Date of the Offer TB_ACCEPTDATS8DATUM
ICAPMANUPROCReason for Postprocessing: Key TB_MAN_POSTPROCESSNUMC3
MCAPREASONKey for Reason for Capitalization TB_CAPREASONNUMC3T_DEFCAPREASON
ACAPITALICapitalization Amount TB_CAPAMOCURR13(2) WERTV7
DCAPKYDTEKey Date for Capitalization of Overdue Items TB_CAPKYDTEDATS8DATUM
DENDPROPONew End of Term TB_ENDPROPODATS8DATUM
AINSTPROPONew Figure for Payment Installments TB_INSTPROPOCURR13(2) WERTV7
PKAPEFFINTRTEffective Interest Based on Capitalization of Overdue Items TB_KAPEFFINTRTDEC10(7) DECV3_7
MKAPEFFINTMTCapitalization of Overdue Items: Effective Interest Method TB_KAPEFFINTMTNUMC1SEFFMETH
DENDWOCAPEnd of Term Without Capitalization of Overdue Items TB_ENDWOCAPDATS8DATUM
AINSTWOCAPPayment Installment Amount w/o Capitalizn of Overdue Items TB_INSTWOCAPCURR13(2) WERTV7
IENDPROPOSpecify New End of Term TB_IENDPROPOCHAR1
IINSTPROPOSpecify New Installment TB_IINSTPROPOCHAR1
NINSTPROPOTotal No.Pymnt Installments with Capitalizn of Overdue Items TB_NINSTPROPONUMC3
NINSTWOCAPTotal No. Pymnt Installments w/o Capitalizn of Overdue Items TB_NINSTWOCAPNUMC3
NOVRTWOCAPOverall Term in Months w/o Capitalization of Overdue Items TB_NOVRTWOCAPNUMC3
NOVRTPROPOOverall Term in Months with Capitalization of Overdue Items TB_NOVRTPROPONUMC3
DSTARTREPRepayment Start TB_DSTARTREPDATS8
DFIRST_DISBField of type DATS DATSDATS8DATS
DOEFFINTPYMNPKey Date for Last Change to Installment Plan TB_MODEL_DATE_LAST_PAYMENTPLANDATS8DATUM
OEFFINTPYMNPEffective Interest Rate for Last Change to Installment Plan TB_MODEL_EFFECTIV_INTERSTS_PPCDEC10(7) DEC3_7
NMAXTERMNumber of Times Units for Maximum Term of Contract TB_PROD_TERM_MAX_VALUENUMC4T_PROD_TIME_QUANTITY_TERM
AREIMBURSEMENTCredit Life Insurance Reimbursement TB_CLI_RECALC_CONTRCURR13(2) WERTV7
AINSURANCE_CONTRSingle Premium for Credit Life Insurance TB_CLI_INSURANCECURR13(2) WERTV7
ADIFFERENCECalculated Difference for Credit Life Insurance TB_LOLIINBALCURR13(2) WERTV7
ICONSIDERTransfer CLI Difference TB_ICONSIDERCHAR1XFELD
CALCULATION_DATECLI: Key Date for Calculation of Credit Life Insurance TB_CLI_CALCULATION_DATEDATS8DATUM
UCLICURRPosition Currency (Currency of Position Amount) SBWHRCUKY5WAERS
CLI_FLOW_SBEWARTFlow Type SBEWARTCHAR4SBEWART
CLI_CHANGEDCheckbox XFELDCHAR1XFELD
NEW 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SANLFProduct Category SANLFNUMC3VVSANLF
RKEY1Key part 1 RKEY1CHAR13RKEY1
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
NLFD_ANGOffer consecutive number NLFD_ANGNUMC3LFNR3
SSTATIStatus of data record SSTATINUMC2STATI
SKOKOARTType of Condition Header SKOKOARTNUMC2SKOKOART
STILGRHYPayment cycle STILGRHYNUMC2SRHYT
STILGARTRepayment Type Indicator STILGARTNUMC1STILGART
SDISEINType of Discount Withholding SDISEINCHAR1SDISEIN
KZAHLUNGPay-in/disbursement rate KZAHLUNGDEC10(7) DEC3_7
BZAHLUNGPay-in/disbursement amount BZAHLUNGCURR13(2) BWHR
SWHRZHLGCurrency of payment amount SWHRZHLGCUKY5WAERS
BZUSAGECommitment capital BZUSAGECURR13(2) WERTV7
SWHRZUSACurrency of commitment amount SWHRZUSACUKY5WAERS
PEFFZINSEffective Interest Rate TB_EFF_RATEDEC10(7) DECV3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SDISKODiscounted SDISKOCHAR1SDISKO
DKUENDDate of notice DKUENDDATS8DATUM
SKUENDReason for Notice SKUENDNUMC3SKUEART
DKUENDDGEarliest Possible Date for Notice Given by the Lender DKUENDDGDATS8DATUM
DBLFZStart of Term DBLFZDATS8DATUM
DBLFZ_ORIGINOriginal Term Start DBLFZ_ORIGINDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
DRESAMReservation of Conditions On DRESAMDATS8DATUM
DRESBISReservation of Conditions Until DRESBISDATS8DATUM
DANGAMOffer creation date DANGAMDATS8DATUM
DANGBISOffer Effective To DANGBISDATS8DATUM
SANGVOROffer/Acceptance Reservation Indicator SANGVORNUMC2SANGVOR
JANNAHMEOffer Acceptance Indicator JANNAHMECHAR1JANEI
SANNAHMEType of offer acceptance indicator SANNAHMENUMC2SKONTAKT
DANNAHMEDate of acceptance of offer DANNAHMEDATS8DATUM
JVERTRAGIndicator: Contract Created? JVERTRAGCHAR1JANEI
DVERTRAMContract creation date DVERTRAMDATS8DATUM
DVERTBISReturn contract by DVERTBISDATS8DATUM
PMANEFFZInternal Effective Interest Rate TB_EFF_RATE_INTDEC10(7) DECV3_7
SEFFM2Effective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SKUEGLNotice Arrangement Lender VVSKUEGLNUMC3VVSKUEGL
RPNRActivity number/rollover number VVRPNRNUMC8NUMC08
DEFSZDate of fixed period end VVDEFSZDATS8DATUM
DGESEarliest Notice Date in acc. with the Legal Right of Notice VVDGESDATS8DATUM
SGESAUSLegal Right of Notice Excluded VVSGESAUSCHAR1XFELD
SZKZSpecial int. ID for int. on arrears for remaining balance VVSZKZCHAR1VVSZKZ
NANGEBOTOffer consecutive number NLFD_ANGNUMC3LFNR3
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
ZVRHYEFFInt.sttlmnt frequency for effective int.rate calc.in months VVZVRHYEFFNUMC3NUMC03
PVGLEFFZComparative Effective Interest TB_EFF_RATE_COMDEC10(7) DECV3_7
SULTEFSZMonth-end indicator for end of fixed period VVSULTEFSZCHAR1VVSULT
DABEFFZDate when calculation of effective rate starts VVDABEFFZDATS8DATUM
DKUENDDNEarliest Possible Date for Notice Given by the Borrower VVDKUENDDNDATS8DATUM
SKUEDNNotice Arrangement Borrower VVSKUEDNNUMC3VVSKUEDN
SKUEARTNotice Type for the Loan VVSKUEARTNUMC3VVSKUEART
DMARKTZINSISB: Market Rate Date: Market Interest Rate for NPV Calc. DMARKTZINSDATS8DATS
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2WFCIDH_TFACD
EDEFFZINSRelevant for Closely Defined Effective Interest TB_EFF_RATE_EDDEC10(7) DECV3_7
EDEFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statistics EFFMETHCHAR1EFFMETH
JAHREFFZINSRelevant for Yearly Eff. Interest Acc Guideline 87/102/EU TB_EFF_RATE_YEARDEC10(7) DECV3_7
JAHREFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statistics EFFMETHCHAR1EFFMETH
PEFFZINS_ORIGINOriginal Effective Interest Rate TB_EFF_RATE_ORIGDEC10(7) DECV3_7
.INCLU--AP 0
ORIGINAL_TERMOriginal Term in Months TB_VIEW_ORIGINAL_TERMNUMC3
OVERALL_RUNTIMEOverall Term TB_VIEW_OVERALL_RUNTIMENUMC3
ORIG_CREDIT_SUMOriginal Total Loan Amount TB_VIEW_ORIGINAL_CREDIT_SUMCURR13(2) WERTV7
DATE_REPAYMENTStart Date for Repayment TB_VIEW_DATE_REPAYMENTDATS8DATUM
DATE_FIRST_RATEDue Date for First Installment to Include a Repayment Amount TB_VIEW_DATE_FIRST_RATEDATS8DATUM
DAY_OF_PAYMENTDay of Installment Payment TB_VIEW_DAY_OF_PAYMENTNUMC2T_VIEW_DAY_OF_PAYMENT
CLEARING_RATEAmount for Final Loan Installment Payment TB_VIEW_CLEARING_RATECURR13(2) WERTV7
EFF_INT_L_PYMNPEffective Interest Rate for Last Change to Installment Plan TB_MODEL_EFFECTIV_INTERSTS_PPCDEC10(7) DEC3_7
DEFF_INT_L_PYMNPKey Date for Last Change to Installment Plan TB_MODEL_DATE_LAST_PAYMENTPLANDATS8DATUM
REPAY_DELAYModel Calculation: DE for Periods of Repayment Suspension TB_MODEL_REPAY_DELAYNUMC2
CALCULATED_PARAMCalculate Installment Amount or Number of Installments? TB_MODEL_P_RATE_OR_TERMCHAR4T_MODEL_P_RATE_OR_TERM
CURR_CREDIT_SUMCurrent Total Loan Amount TB_VIEW_CURRENT_CREDIT_SUMCURR13(2) WERTV7
BROUNDUNITRounding Unit for Amounts TB_BROUNDUNIT_ADEC13(7) TFMSRUNIT
SROUNDRounding Category (Round up, Round Down or Number Rounding) TB_SROUND_ACHAR1TFM_SROUND
BOVERLIMITDrawing Tolerance as Amount TB_COMP_OVERLIMIT_AMOUNTCURR13(2) WERTV7
POVERLIMITDrawing Tolerance as a Percentage TB_COMP_OVERLIMT_PERCENTDEC10(7) DECV3_7
CONTABCondition Table TB_FICO_CONTABCHAR8T_FICO_CONTABFVD_FICO_CONTAB
CONTAB_VERSIONVersion Number for a Condition Table TB_FICO_CONTAB_VERSIONNUMC4T_FICO_CONTAB_VERSION
TERM_PAYMENTCategory of Last Installment TB_TERM_PAYMENTCHAR1T_TERM_PAYMENT
PAPR_ORIGINOriginal U.S. Effective Interest Rate TB_PAPR_ORIGINDEC10(7) DECV3_7
OLD 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SANLFProduct Category SANLFNUMC3VVSANLF
RKEY1Key part 1 RKEY1CHAR13RKEY1
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
NLFD_ANGOffer consecutive number NLFD_ANGNUMC3LFNR3
SSTATIStatus of data record SSTATINUMC2STATI
SKOKOARTType of Condition Header SKOKOARTNUMC2SKOKOART
STILGRHYPayment cycle STILGRHYNUMC2SRHYT
STILGARTRepayment Type Indicator STILGARTNUMC1STILGART
SDISEINType of Discount Withholding SDISEINCHAR1SDISEIN
KZAHLUNGPay-in/disbursement rate KZAHLUNGDEC10(7) DEC3_7
BZAHLUNGPay-in/disbursement amount BZAHLUNGCURR13(2) BWHR
SWHRZHLGCurrency of payment amount SWHRZHLGCUKY5WAERS
BZUSAGECommitment capital BZUSAGECURR13(2) WERTV7
SWHRZUSACurrency of commitment amount SWHRZUSACUKY5WAERS
PEFFZINSEffective Interest Rate TB_EFF_RATEDEC10(7) DECV3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SDISKODiscounted SDISKOCHAR1SDISKO
DKUENDDate of notice DKUENDDATS8DATUM
SKUENDReason for Notice SKUENDNUMC3SKUEART
DKUENDDGEarliest Possible Date for Notice Given by the Lender DKUENDDGDATS8DATUM
DBLFZStart of Term DBLFZDATS8DATUM
DBLFZ_ORIGINOriginal Term Start DBLFZ_ORIGINDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
DRESAMReservation of Conditions On DRESAMDATS8DATUM
DRESBISReservation of Conditions Until DRESBISDATS8DATUM
DANGAMOffer creation date DANGAMDATS8DATUM
DANGBISOffer Effective To DANGBISDATS8DATUM
SANGVOROffer/Acceptance Reservation Indicator SANGVORNUMC2SANGVOR
JANNAHMEOffer Acceptance Indicator JANNAHMECHAR1JANEI
SANNAHMEType of offer acceptance indicator SANNAHMENUMC2SKONTAKT
DANNAHMEDate of acceptance of offer DANNAHMEDATS8DATUM
JVERTRAGIndicator: Contract Created? JVERTRAGCHAR1JANEI
DVERTRAMContract creation date DVERTRAMDATS8DATUM
DVERTBISReturn contract by DVERTBISDATS8DATUM
PMANEFFZInternal Effective Interest Rate TB_EFF_RATE_INTDEC10(7) DECV3_7
SEFFM2Effective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SKUEGLNotice Arrangement Lender VVSKUEGLNUMC3VVSKUEGL
RPNRActivity number/rollover number VVRPNRNUMC8NUMC08
DEFSZDate of fixed period end VVDEFSZDATS8DATUM
DGESEarliest Notice Date in acc. with the Legal Right of Notice VVDGESDATS8DATUM
SGESAUSLegal Right of Notice Excluded VVSGESAUSCHAR1XFELD
SZKZSpecial int. ID for int. on arrears for remaining balance VVSZKZCHAR1VVSZKZ
NANGEBOTOffer consecutive number NLFD_ANGNUMC3LFNR3
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
ZVRHYEFFInt.sttlmnt frequency for effective int.rate calc.in months VVZVRHYEFFNUMC3NUMC03
PVGLEFFZComparative Effective Interest TB_EFF_RATE_COMDEC10(7) DECV3_7
SULTEFSZMonth-end indicator for end of fixed period VVSULTEFSZCHAR1VVSULT
DABEFFZDate when calculation of effective rate starts VVDABEFFZDATS8DATUM
DKUENDDNEarliest Possible Date for Notice Given by the Borrower VVDKUENDDNDATS8DATUM
SKUEDNNotice Arrangement Borrower VVSKUEDNNUMC3VVSKUEDN
SKUEARTNotice Type for the Loan VVSKUEARTNUMC3VVSKUEART
DMARKTZINSISB: Market Rate Date: Market Interest Rate for NPV Calc. DMARKTZINSDATS8DATS
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2WFCIDH_TFACD
EDEFFZINSRelevant for Closely Defined Effective Interest TB_EFF_RATE_EDDEC10(7) DECV3_7
EDEFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statistics EFFMETHCHAR1EFFMETH
JAHREFFZINSRelevant for Yearly Eff. Interest Acc Guideline 87/102/EU TB_EFF_RATE_YEARDEC10(7) DECV3_7
JAHREFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statistics EFFMETHCHAR1EFFMETH
PEFFZINS_ORIGINOriginal Effective Interest Rate TB_EFF_RATE_ORIGDEC10(7) DECV3_7
.INCLU--AP 0
ORIGINAL_TERMOriginal Term in Months TB_VIEW_ORIGINAL_TERMNUMC3
OVERALL_RUNTIMEOverall Term TB_VIEW_OVERALL_RUNTIMENUMC3
ORIG_CREDIT_SUMOriginal Total Loan Amount TB_VIEW_ORIGINAL_CREDIT_SUMCURR13(2) WERTV7
DATE_REPAYMENTStart Date for Repayment TB_VIEW_DATE_REPAYMENTDATS8DATUM
DATE_FIRST_RATEDue Date for First Installment to Include a Repayment Amount TB_VIEW_DATE_FIRST_RATEDATS8DATUM
DAY_OF_PAYMENTDay of Installment Payment TB_VIEW_DAY_OF_PAYMENTNUMC2T_VIEW_DAY_OF_PAYMENT
CLEARING_RATEAmount for Final Loan Installment Payment TB_VIEW_CLEARING_RATECURR13(2) WERTV7
EFF_INT_L_PYMNPEffective Interest Rate for Last Change to Installment Plan TB_MODEL_EFFECTIV_INTERSTS_PPCDEC10(7) DEC3_7
DEFF_INT_L_PYMNPKey Date for Last Change to Installment Plan TB_MODEL_DATE_LAST_PAYMENTPLANDATS8DATUM
REPAY_DELAYModel Calculation: DE for Periods of Repayment Suspension TB_MODEL_REPAY_DELAYNUMC2
CALCULATED_PARAMCalculate Installment Amount or Number of Installments? TB_MODEL_P_RATE_OR_TERMCHAR4T_MODEL_P_RATE_OR_TERM
CURR_CREDIT_SUMCurrent Total Loan Amount TB_VIEW_CURRENT_CREDIT_SUMCURR13(2) WERTV7
BROUNDUNITRounding Unit for Amounts TB_BROUNDUNIT_ADEC13(7) TFMSRUNIT
SROUNDRounding Category (Round up, Round Down or Number Rounding) TB_SROUND_ACHAR1TFM_SROUND
BOVERLIMITDrawing Tolerance as Amount TB_COMP_OVERLIMIT_AMOUNTCURR13(2) WERTV7
POVERLIMITDrawing Tolerance as a Percentage TB_COMP_OVERLIMT_PERCENTDEC10(7) DECV3_7
CONTABCondition Table TB_FICO_CONTABCHAR8T_FICO_CONTABFVD_FICO_CONTAB
CONTAB_VERSIONVersion Number for a Condition Table TB_FICO_CONTAB_VERSIONNUMC4T_FICO_CONTAB_VERSION
TERM_PAYMENTCategory of Last Installment TB_TERM_PAYMENTCHAR1T_TERM_PAYMENT
PAPR_ORIGINOriginal U.S. Effective Interest Rate TB_PAPR_ORIGINDEC10(7) DECV3_7
DNEW_RATE_DUEPayment Date DZAHLDATUMDATS8DATUM
TEXT_REASONDescription of Reason for Capitalization TB_CAPREASONTCHAR40CHAR40_LOW
WA_DEF_DETS 0
VDDEFERRAL 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SBO_CATBusiness Operation Category SBO_CATCHAR1SBO_CAT
SBO_STATUSBus. operation status TB_SBOSTATUSCHAR1SBO_STATUS
SBO_STATUS_OLDLoans: Business operation status SBO_STATUSCHAR1SBO_STATUS
XBO_TEXTText for Business Operation XBOTEXTCHAR30TEXT30
SRELSTATInternal Release Status in the Business Operations TB_SRELSTATCHAR1T_SRELSTAT
SFGKZRelease Workflow Indicator for the Business Operation TB_SFGKZACHAR1T_SFGKZ
UCURRPosition Currency (Currency of Position Amount) SBWHRCUKY5WAERS
AARRBALTotal Amount of Overdue Items TB_ARRBALANCECURR13(2) WERTV7
AFUDUPAYTotal Amount for Payments Due in the Future TB_FUDUPAYCURR13(2) WERTV7
ACAPRECSTotal Amount of Receivables to Be Included in Loan TB_CAPRECSCURR13(2) WERTV7
ACREBALTotal Amount of Credit TB_CREBALCURR13(2) WERTV7
ABALNUITTotal Amount of Non-Selected Items TB_BALNUITCURR13(2) WERTV7
ABALNCPRECSTotal Amount of Receivables Not Included in Loan TB_BALNCPRECSCURR13(2) WERTV7
IINCL_KYDTETerm Including Key Date TB_INCLKYDTECHAR1XFELD
IULTI_KYDTEKey Date Must Be Last Day of the Month TB_ULTIKYDTECHAR1XFELD
DPAYM_TOPayments to TB_PAYM_TODATS8DATUM
INOTE_ASSIGNEDMemo Exists TB_IND_NOTE_ASSIGNEDCHAR1XFELD
APRCCHRGEProcessing Charge for Deferral or Capitalization TB_PRCCHRGECURR13(2) WERTV7
ICAPITALInclude Processing Charge in Loan TB_ICAPITALCHAR1XFELD
IDEVIATE_PAYMAlternative Payment Information in Additional Flows TB_DEVIATE_PAYMCHAR1XFELD
MNORISKMSNumber of Risk-Increasing Measures TB_NORISKMSNUMC2T_NORISKMS
IOA_AMOUNTInterest on Arrears Calculated TB_IOA_CALCULATION_RESULTCURR13(2) WERTV7
MPOSTTYPEPosting Control TB_DEFCAPPOSTTYPENUMC2VVSBUST
IDUNNBLCKDunning Block for Items for Deferral or Capitalization TB_DUNNBLCKCHAR1MANSP
IIOABLCKInterest on Arrears Block for Items for Deferral/Capitaliz. TB_IOABLCKCHAR2ZINKZ
IDUBLDEFIDunning Block for Deferral Installments TB_DUBLDEFRCHAR1MANSP
IIOABLDEFIInterest on Arrears Block for Deferral Installments TB_IOADEFICHAR2ZINKZ
IPAYBLCKPayment Block for Deferral Installments TB_PAYBLCKCHAR1ZAHLS
DOFFER_FRCreation Date for the Offer TB_OFFER_FRDATS8DATUM
DOFFER_TOEnd of the Validity Period of the Offer TB_OFFER_TODATS8DATUM
DACCEPTAcceptance Date of the Offer TB_ACCEPTDATS8DATUM
IDEFMANUPROCReason for Postprocessing: Key TB_MAN_POSTPROCESSNUMC3
MDEFREASONReason for Deferral: Key TB_DEFREASONNUMC3T_DEFCAPREASON
ADEFERRDeferral Amount TB_DEFAMOCURR13(2) WERTV7
DDEFKYDTEKey Date for Deferral TB_DEFKYDTEDATS8DATUM
PDEFINTRTInterest Rate for the Deferral TB_DEFINTRTDEC10(7) DECV3_7
MINTDYMTInterest Calculation Method SZBMETHCHAR1SZBMETH
DFRSTDUDTEDue Date of First Installment Payment for Deferral Plan TB_FRSDUDTEDATS8DATUM
IULTIDUDTEDue Date Is Always on the Last Day of the Month TB_ULTIDUDTECHAR1XFELD
IINCLDUDTEIncluding Due Date TB_INCLDUDTECHAR1CHAR1
MNUMRTSNumber of Payment Installments in the Deferral Plan TB_NUMRTSNUMC3
MRHYTHMFrequency of Installment Payments in Months TB_RHYTHMNUMC3
MWRKDYRLWorking Day Shift for Calculation Day TB_SVWERKNUMC1T_SWERK
MPUHOLCALFactory calendar SKALIDCHAR2WFCIDH_TFACD
IFREEPAYMCustom Deferral Plan TB_FREEPAYMCHAR1XFELD
MPARTKUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
MPARTNERBusiness Partner Number for Payer of Deferral Installments TB_DEFPARTNERCHAR10ALPHABU_PARTNER
MBANKTYPEBank Details ID for Deferral Installments TB_DEFBVTYPCHAR4BVTYP
MPAYMTHDPayment Method for Deferral Installments TB_DEFPYMTDCHAR1ZLSCH
PEFFINTRTEffective Interest Rate for Deferral Agreement TB_EFFINTRTDEC10(7) DECV3_7
MEFFINTMTEffective Interest Method for Deferral Agreement TB_EFFINTMTNUMC1SEFFMETH
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
TEXT_REASONDescription of Reason for Deferral TB_DEFREASONTCHAR40CHAR40_LOW
T_CONDITIONS 0
T_BANKDETAIL 0
T_FINANCIALS 0
T_COLLATERAL 0
T_BPARTNERS 0
T_CLERKS 0
T_DEF_INSTLM 0
T_PPCHG_DET 0
T_IOATAB 0
T_USER_TEXTS 0
T_OPT_TEXTS 0

Key field Non-key field



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

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

How to access SAP table RFVD_STR_CORR_CL_DEFCAP

Within an ECC or HANA version of SAP you can also view further information about RFVD_STR_CORR_CL_DEFCAP 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!