RFVD_STR_CORR_CL_DEFCAP SAP (Loans: General Data Transfer) Structure details
Description: Loans: General Data Transfer
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 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
COTYP | Correspondence Type | COTYP_KK | CHAR | 4 | COTYP_KK | COTYP | COTYP_KK | ||
COKEY | Correspondence key | COKEY_KK | CHAR | 36 | COKEY_KK | ||||
UNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
CDATE | Created On | COCDT_KK | DATS | 8 | SYDATS | ||||
CTIME | Time of Creation (to the Second) | COCTM_KK | TIMS | 6 | SYTIME | ||||
GPART | Correspondence Recipient | CREC_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
GPART_GUID | Correspondence Recipient (GUID) | CREC_GP_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
GPART_ADR_KIND | Address Type Of Correspondence Recipient | CORR_ADR_KIND_KK | CHAR | 10 | BU_ADRKIND | ||||
ORG_GPART | Original Correspondence Recipient | CREC_ORG_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ORG_GPART_GUID | Original Correspondence Recipient (GUID) | CREC_ORG_GP_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
ADD_GPART | Additional Business Partner for Correspondence Recipient | CREC_GP_ADD_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ADD_GPART_GUID | Addit. Business Partner for Correspondence Recipient GUID | CREC_GP_ADD_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
ADD_GPART_CAT | Type of Additional Correspondence Recipient | CREC_GP_ADD_CAT_KK | CHAR | 1 | CORR_CREC_ADD_CAT_KK | ||||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
ADR_VALID_ON | Address of Correspondence Recipient Valid On | CREC_AD_VALID_ON_KK | DEC | 15 | TZNTSTMPS | ||||
ADRNR | Address Number of Correspondence Recipient | CREC_AD_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADR_GUID | Address GUID of Correspondence Recipient | CREC_AD_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
ADRNR_INDEP_COMM | Address Number for Address-Independent Communication | CREC_AD_INDEP_COMM_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
AGPART | Sending Business Partner | CSEN_GP_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
AGPART_GUID | Sender (GUID) | CSEN_GP_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
AGPART_ADR_KIND | Address Type Of Correspondence Recipient | CORR_ADR_KIND_KK | CHAR | 10 | BU_ADRKIND | ||||
AADRNR | Address Number of Correspondence Sender | CSEN_AD_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
AADR_GUID | Address GUID of Correspondence Sender | CSEN_AD_GUID_KK | CHAR | 32 | SYSUUID_C | ||||
FORMKEY | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
FORMKEY_RDI | Application form | FORMKEY | CHAR | 30 | FORMKEY | FOM | |||
ENTID1 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA1 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
ENTID2 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA2 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
ENTID3 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA3 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
ENTID4 | Correspondence data | ENTID_KK | CHAR | 4 | ENTID_KK | ||||
DATA4 | Correspondence Data Field | CDATA_KK | CHAR | 32 | CDATA_KK | ||||
CSORT | Correspondence Sort Field | CSORT_KK | CHAR | 50 | CORR_TXT50 | ||||
XCODT | Data Part Is Used | XCODT_KK | CHAR | 1 | XFELD | ||||
XCODT_CLUST | Cluster Data Part is Used | XCODT_CLUST_KK | CHAR | 1 | XFELD | ||||
LAUFD | Date ID for Creation Run | CORR_LAUFD_KK | DATS | 8 | DATUM | ||||
LAUFI | Additional ID Characteristic for Creation Run | CORR_LAUFI_KK | CHAR | 6 | CORR_LAUFI_KK | ||||
XTEST | Correspondence is Result of Test | XTEST_KK | CHAR | 1 | XFELD | ||||
COPRI | Print Date | COPRI_KK | DATS | 8 | SYDATS | ||||
COIDT | Date of Issue | COIDT_KK | DATS | 8 | SYDATS | ||||
COITM | Issue Time to the Second | COITM_KK | TIMS | 6 | SYTIME | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
SALWA | Transaction Currency | CORR_BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
SALBE | Amount in Local Currency with +/- Signs | CORR_BETRH_KK | CURR | 13(2) | WRTV7 | ||||
SENDCONTROL | Dispatch Control | SENDCONTROL | CHAR | 4 | ESENDCONTROL | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
APERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
BUKRS | Company Code in Correspondence | CORR_BUKRS | CHAR | 4 | CORR_BUKRS | ||||
CORR_ROLE | Correspondence Roles | CORR_ROLE_KK | CHAR | 4 | CORR_ROLE_KK | ||||
COPRI_LAUFD | Date ID for Print Run | COPRI_LAUFD_KK | DATS | 8 | DATUM | ||||
COPRI_LAUFI | ID Characteristic for Run | COPRI_LAUFID_KK | CHAR | 6 | COPRI_LAUFID_KK | ||||
PROCESS_ID_ | Business Process ID | CORR_PROCESS_ID_KK | CHAR | 36 | |||||
NO_DOCPARTS | Number of Document Parts | CORR_NO_DOCPARTS_KK | NUMC | 4 | |||||
DOCPART_ROLE | Document Part Role | CORR_DOCPART_ROLE_KK | CHAR | 1 | CORR_DOCPART_ROLE_KK | ||||
XTRIAL | Correspondence Request is Test | XTRIAL_KK | CHAR | 1 | XFELD | ||||
XREPRINT | Recreate Correspondence | XREPRINT_KK | CHAR | 1 | XFELD | ||||
SUBAP | Subapplication Indicator in Correspondence | CORR_SUBAP_KK | CHAR | 1 | CORR_SUBAP_KK | ||||
XDELETE | Correspondence Is Logically Deleted | X_CORR_DELETE_KK | CHAR | 1 | XFELD | ||||
PRINT_MODE | Business Partner Print Format | PRINT_MODE_KK | CHAR | 1 | BU_PRINT_MODE | ||||
X_NO_ARC | SAP ArchiveLink Object ID Part Is Not Used | X_NO_ARC_KK | CHAR | 1 | XFELD | ||||
X_DOCPART_LIST | Document Part List Is Used | X_DOCPART_LIST_KK | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
BKKRS | Bank Area | BKK_BKKRS | CHAR | 4 | BKK_BKKRS | BNS | |||
ACNUM_INT | Internal Account Number for Current Account | BKK_ACCNT | CHAR | 10 | ALPHA | BKK_ACCNT | ACI | ||
.INCLU--AP | 0 | ||||||||
.INCLU-CMS | 0 | ||||||||
OBJECT_IDCMS | Object Identification Number | CMS_DTE_OBJECT_ID | RAW | 16 | SYSUUID | ||||
FLG_ORIGINALCMS | Flag to indicate if the document is original or duplicate | CMS_DTE_FLG_ORIG | CHAR | 1 | CMS_FLG | ||||
SENDCONTROLCMS | Dispatch Control | SENDCONTROL | CHAR | 4 | ESENDCONTROL | ||||
.INCLU--AP | 0 | ||||||||
.INCLU-FVD | 0 | ||||||||
PRODUCTTYPEFVD | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
BP_ROLEFVD | BP Role | BU_PARTNERROLE | CHAR | 6 | BU_ROLE | BUPA_ROLE | |||
BP_ROLETYPEFVD | Business Partner Role Type | BP_ROLE | CHAR | 4 | BP_ROLE | ||||
SOBJECTFVD | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
CORR_ACTIVITYFVD | Correspondence activity | KORRVORF | NUMC | 4 | KORRVORF | ||||
REFERENCEDATEFVD | Reference Date for Creating Correspondence | TB_CORR_REFERENCE_DATE | DATS | 8 | DATUM | ||||
WA_ORIGINAL | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
WA_ORG_ADRDAT | 0 | ||||||||
ADRS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
ADRS_NUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERS_NUM | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
BAD_ADDRESS_ACTION | System Response When Correspondence Cannot Be Delivered | TB_BAD_ADDRESS_FLAG | CHAR | 1 | T_BAD_ADDRESS_FLAG | ||||
WA_ORG_ADRESS | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
WA_ORG_NAME | 0 | ||||||||
NAME_COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
FORMATTED_NAME | Address line | LINES | CHAR | 80 | LINES | ||||
FORMATTED_NAME_WITH_TITLE | Address line | LINES | CHAR | 80 | LINES | ||||
GREETING_LINE | Address line | LINES | CHAR | 80 | LINES | ||||
WA_ORG_TITLES | 0 | ||||||||
TITLE_MEDI | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
TITLE_ACA1 | Academic Title: Written Form | AD_TITLE1T | CHAR | 20 | TEXT20 | ||||
TITLE_ACA2 | Academic Title: Written Form | AD_TITLE1T | CHAR | 20 | TEXT20 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (written form) | AD_TITLEST | CHAR | 20 | TEXT20 | ||||
PREFIX1 | Name prefix | AD_PREFIXT | CHAR | 20 | TEXT20 | ||||
PREFIX2 | Name prefix | AD_PREFIXT | CHAR | 20 | TEXT20 | ||||
WA_RECEIVER | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
WA_REC_ADRDAT | 0 | ||||||||
ADRS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
ADRS_NUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERS_NUM | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
BAD_ADDRESS_ACTION | System Response When Correspondence Cannot Be Delivered | TB_BAD_ADDRESS_FLAG | CHAR | 1 | T_BAD_ADDRESS_FLAG | ||||
WA_REC_ADRESS | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
WA_REC_NAME | 0 | ||||||||
NAME_COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
FORMATTED_NAME | Address line | LINES | CHAR | 80 | LINES | ||||
FORMATTED_NAME_WITH_TITLE | Address line | LINES | CHAR | 80 | LINES | ||||
GREETING_LINE | Address line | LINES | CHAR | 80 | LINES | ||||
WA_REC_TITLES | 0 | ||||||||
TITLE_MEDI | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
TITLE_ACA1 | Academic Title: Written Form | AD_TITLE1T | CHAR | 20 | TEXT20 | ||||
TITLE_ACA2 | Academic Title: Written Form | AD_TITLE1T | CHAR | 20 | TEXT20 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (written form) | AD_TITLEST | CHAR | 20 | TEXT20 | ||||
PREFIX1 | Name prefix | AD_PREFIXT | CHAR | 20 | TEXT20 | ||||
PREFIX2 | Name prefix | AD_PREFIXT | CHAR | 20 | TEXT20 | ||||
WA_SEN_ADRESS | 0 | ||||||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
ADDRHANDLE | Handle for Creating Addresses/Persons (Bus. Addr. Services) | AD_HANDLE | CHAR | 140 | TEXT140 | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
DATE | Date referred to | AD_DATE | DATS | 8 | DATUM | ||||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50 | TEXT50 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | AD_COMM | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4 | AD_GROUP | ||||
WA_CONTRACT | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | STATI | ||||
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
GSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | USTRU | KRE | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | HBKID | ||||
HKTID | ID for account details | HKTID | CHAR | 5 | HKTID | ||||
STITEL | Loan Type Indicator | STITEL | NUMC | 3 | STITEL | ||||
SGLZB | SCB asset group indicator | SGLZB | CHAR | 4 | SGLZB | ||||
SFIBG | Asset Grouping Indicator | SFIBG | NUMC | 4 | SFIBG | ||||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | SBILK | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
RANLALT1 | Alternative Identification | RANLALT1 | CHAR | 13 | CHAR13 | ||||
RANLALT2 | Alternative identification 2 | RANLALT2 | CHAR | 13 | CHAR13 | ||||
SGR1 | Group Key 1 (Freely Available) | SGRP1 | CHAR | 6 | SGRP1 | ||||
SGR2 | Group Key 2 (Freely Available) | SGRP2 | CHAR | 6 | SGRP2 | ||||
RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | ALPHA | RANL | |||
RANLKET | Principle loan investment number | RANLHPT | CHAR | 13 | CHAR13 | RAN | |||
RANTRAG | Application number | RANTRAG | CHAR | 13 | CHAR13 | ||||
SSOLIST | Plan/Actual principle | VVSSOLIST | CHAR | 1 | VVSSOLIST | ||||
SFRIST | Loan Term | SFRIST | NUMC | 2 | SFRIST | ||||
BANTRAG | Capital applied for | BANTRAG | CURR | 13(2) | BWHR | ||||
SANTWHR | Currency | SWHR | CUKY | 5 | WAERS | WHR | |||
DANTRAG | Entry Date of Loan Application | DANTRAG | DATS | 8 | DATUM | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
DZUSAGE | Loan - Date of Commitment by Lender | DZUSAGE | DATS | 8 | DATUM | ||||
DZUSAGE_ORIGIN | Date of the Original Approval from the Lender | DZUSAGE_ORIGIN | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Loan Term | DENDLFZ | DATS | 8 | DATUM | ||||
DBDIS | Start of distribution of discount | DBDIS | DATS | 8 | DDAT | ||||
SDISMETH | Discount distribution method | SDISMETH | NUMC | 1 | DISMETH | ||||
SSICHER | Primary collateral | SSICHER | CHAR | 4 | SSICH | ||||
SVZWECK | Purpose of Loan | SVZWECK | CHAR | 2 | SVZWK | ||||
SSONDER | Special treatment of loan | SSONDER | NUMC | 2 | SSONDER | ||||
SFIWO | Indicator: Type of Residential Object Financing | SFIWO | CHAR | 2 | SFIWO | ||||
SDTI | DTI indicator | SDTI | NUMC | 5 | NUMC | ||||
SHOME | Home statement | SHOME | NUMC | 3 | SHOME | ||||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | LAND1 | ||||
AABTRET | Number of Assignments Still Possible | AABTRET | NUMC | 2 | NUM02 | ||||
BABTRET | Minimum amount for assignments | BABTRET | CURR | 13(2) | BWHR | ||||
SNICHTAB | Reason for Non-Acceptance | SNICHTAB | NUMC | 2 | SNICHTAB | ||||
DARCHIV | Date of Rejection/Withdrawal | DARCHIV | DATS | 8 | DATUM | ||||
BGESDAR | Total amount of syndicated loan | BGESDAR | CURR | 13(2) | BWHR | ||||
DKONS | Syndicate loan date | DKONS | DATS | 8 | DATUM | ||||
SKWGKRED | Credit category indicator Para. 75 report (Austria) | SKWGKRED | NUMC | 1 | SKWGKRED | ||||
SKWGDAR | Credit type indicator for Austrian reporting | SKWGDAR | NUMC | 1 | SKWGDAR | ||||
JORIG | Posting system indicator for borrower's note loans | BUCHSYS | NUMC | 1 | BUCHSYS | ||||
VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
SDTYP | Loans Class | VVSDTYP | NUMC | 3 | VVSDTYP | ||||
DBEWI | Approval date | VVDBEWI | DATS | 8 | DATUM | ||||
SABTRANS | Indicator for Possible Foreign Assignment | VVSABTRANS | CHAR | 1 | XFELD | ||||
AKONS | Number of syndicate members | VVAKONS | NUMC | 3 | NUM03 | ||||
SFGKZ | Release Indicator | VVSFGKZ | CHAR | 1 | VVSFGKZ | ||||
SABT | Assignee | VVSABT | CHAR | 4 | VVSABT | ||||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
MAHNS | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | NUMC08 | ||||
RSBEAR | Dummy field 12 characters CHAR | DUMMY_12 | CHAR | 12 | CHAR12 | ||||
SONDST | Special posting treatment | VVSONDST | CHAR | 2 | VVSONDST | ||||
SGRP3 | Group Key 3 (Freely Available) | SGRP3 | CHAR | 6 | SGRP3 | ||||
SGRP4 | Group Key 4 (Freely Available) | SGRP4 | CHAR | 6 | SGRP4 | ||||
SZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | NUMC | 2 | VVSZKEY | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
SVERFU | Type of Restraint on Drawing | VVSVERFU | NUMC | 2 | VVSVERFU | ||||
STITART | Borrower's Note Loan Security Type | VVSTITART | NUMC | 2 | VVSTITART | ||||
NABTRV | Contract of assignment number | VVNABTRV | CHAR | 15 | CHAR15 | ||||
NAVAL | Guarantee number | VVNAVAL | CHAR | 15 | CHAR15 | ||||
DABTR | Date of assignment | VVDABTR | DATS | 8 | DATUM | ||||
DVERFU | Date of restraint on disposal upto | VVDVERFU | DATS | 8 | DATUM | ||||
SFGBEW | Transaction data to be released available | VVSFGBEW | NUMC | 2 | VVSFGBEW | ||||
DELSOZ | Date of last special interest payment period | VVDLESOZ | DATS | 8 | DATUM | ||||
RPORTB | Portfolio | RPORTB | CHAR | 10 | RPORTB | T50 | H_RPORTB_CORE | ||
SREGION | Sales Region | VVSREGION | CHAR | 4 | VVSREGION | ||||
SGESST | Branch Office | VVSGESST | CHAR | 4 | VVSGESST | ||||
SBEA | Loan Processing Indicator | VVSBEA | NUMC | 2 | VVSBEA | ||||
SOBEZ | Organizational District | VVSOBEZ | CHAR | 2 | CHAR2 | ||||
SBEZIRK | Agent District | VVSBEZIRK | CHAR | 4 | CHAR4 | ||||
SPLIT | Debit position splitting | VVSPLIT | CHAR | 1 | XFELD | ||||
BNBUERG | Initial capital not guaranteed | VVBNBUERG | CURR | 13(2) | WERTV7 | ||||
SREFZINS | Loan With Reference Interest Rate | VVSREFZINS | CHAR | 1 | XFELD | ||||
SMAHNM | Loan Manual Dunning Level | VVSMAHNM | CHAR | 1 | VVSMAHNM | ||||
SIHERK | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
RGENUM | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
DRUECK | Date when loan will probably be redeemed | VVDRUECK | DATS | 8 | DATUM | ||||
SABGRENZ | Loan Discount Accrual/Deferral Method | VVSABGRD | CHAR | 1 | VVSABGRD | ||||
SFEST | Indicator for Control of Fixed Contract | VVFESTKZ | CHAR | 1 | VVFESTKZ | ||||
SRATING | Rating | BP_RATING | CHAR | 3 | BP_RATING | ||||
SRATAGEN | Rating agency | SRATAGEN_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
RDARNEHM | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
OBJNR | Object Number for Financial Transactions | TB_FINOBJNR | CHAR | 22 | J_OBJNR | ||||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | ALPHA | KUNNR | |||
SKWG14_NEU | Position grouping acc. Para 14 GBA (Sec. and loans) | VVSKWG14 | CHAR | 2 | VVSKWG14 | ||||
RANLSTAMNR | Master number part of loan number for finding contracts | RANLSTAMNR | CHAR | 13 | ALPHA | RANL | |||
MIGDATE | Migration date | MIGDATE | DATS | 8 | DATUM | ||||
SDUNNCMP | Summarization Level for Dunning Letter | SDUNNCMP | CHAR | 2 | SDUNNCMP | ||||
XNODUNN | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
SDUNCHARG | Post Dunning Charges and Interest to this Contract | SDUNCHARG | CHAR | 1 | XFELD | ||||
SWHRORG | Loan currency before conversion to EURO | SWHRORG | CUKY | 5 | WAERS | ||||
DCONVERT | Date loan was converted to EURO | DCONVERT | DATS | 8 | DATE | ||||
DCORRECT | Date for adjustment flows resulting from EURO conversion | DCORRECT | DATS | 8 | DATE | ||||
SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1 | VVSAKTPAS | ||||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
GSBER | Business Area | GSBER | CHAR | 4 | GSBER | GSB | |||
JNOREPAY | Payoff Lock | TB_JNOREPAY | CHAR | 1 | XFELD | ||||
JNODOIP | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TPM_COM_VAL_CLASS | CVC | |||
SARC_EXCL | Documents For The Loan May Not Be Archived | TB_SARC_EXCL | CHAR | 1 | T_SARC_EXCL | ||||
SARC_DOCS | Indicator: Archived Loan Documents Exist | TB_SARC_DOCS | CHAR | 1 | T_SARC_DOCS | ||||
NO_PLAN_DONE | Do Not Transfer Loan to Status 'Completed' | TB_NO_PLAN_DONE | CHAR | 1 | CHECKBOX | ||||
DPLAN_SET | Date of Transfer of Contract into Status Planned Completed | TB_DPLAN_SET | DATS | 8 | DATUM | ||||
DOPEN | Opening Date of a Loan Contract | TB_DOPEN | DATS | 8 | DATUM | ||||
DCLOSE | Closing Date of a Loan Contract | TB_DCLOSE | DATS | 8 | DATUM | ||||
DUNN_BLOCK_TILL | Expiration Date of Dunning Lock | TB_VIEW_DATE_DUNNING_BLOCK_TIL | DATS | 8 | DATUM | ||||
XNOIOA | Lock for Interest on Arrears | TB_XNOIOA | CHAR | 1 | CHAR1 | ||||
NOIOA_TILL | Expiry Date of Lock on Interest on Arrears | TB_NOIOA_TILL | DATS | 8 | DATUM | ||||
ORIGIN | Loan Origin | TB_ORIGIN | CHAR | 2 | T_ORIGIN | ||||
DCALLEND | Provision Expiry Date | TB_DCALLEND | DATS | 8 | DATUM | ||||
SVER_EXCL | Documents for the loan may not be summarized | TB_SVER_EXCL | CHAR | 1 | T_SVER_EXCL | ||||
LC_DISBURSEMENT | Processing Characteristic: Disbursement Status | TB_LC_CHARAC_DISBURSEMENT | CHAR | 1 | T_LC_CHARACVALUE | H_VD_CHARAC_DISBURSEMENT | |||
LC_CAPITALS | Processing Characteristic: Status of Capital Amounts | TB_LC_CHARAC_CAPITALS | CHAR | 1 | T_LC_CHARACVALUE | H_VD_CHARAC_CAPITALS | |||
LC_PLANNED_FLOW | Processing Characteristic: Status of Planned Records | TB_LC_CHARAC_PLANNED_FLOW | CHAR | 1 | T_LC_CHARACVALUE | H_VD_CHARAC_PLANNED_FLOW | |||
LC_DEBIT | Processing Characteristic: Status of Customer Receivables | TB_LC_CHARAC_DEBIT | CHAR | 1 | T_LC_CHARACVALUE | H_VD_CHARAC_DEBIT | |||
LC_CREDIT | Processing Characteristic: Status of Customer Payables | TB_LC_CHARAC_CREDIT | CHAR | 1 | T_LC_CHARACVALUE | H_VD_CHARAC_CREDIT | |||
LC_STATUS | Status of Processing Characteristics for Loan | TB_LC_STATUS | CHAR | 1 | T_LC_STATUS | ||||
PAYM_STATUS | Payment Status | TB_PAYM_STATUS | CHAR | 1 | T_PAYM_STATUS | ||||
STOP_INDICATOR | Stop Indicator | TB_STOP_INDICATOR | CHAR | 1 | T_STOP_INDICATOR | ||||
PRODUCT_ID | Internal Product ID | TB_PR_PRODINT | CHAR | 18 | T_PR_PRODINT | ||||
PRODUCT_VERSION | Product Version | TB_PR_VERSION | NUMC | 4 | T_PR_VERSION | TD_PRODVERSION | |||
SCHUFA_MESSAGE | Business Partner Has Signed a Schufa Declaration | TB_VIEW_SCHUFA | CHAR | 1 | XFELD | ||||
DAT_FULL_PAY | Date of Full Disbursement | TB_VIEW_DATE_OF_FULL_PAYMENT | DATS | 8 | DATUM | ||||
DAT_OF_CANCEL | Rescission Date | TB_VIEW_DATE_OF_CANCELATION | DATS | 8 | DATUM | ||||
FLG_CNCL | Rescission Indicator | TB_CNCL | CHAR | 1 | BOOLE | ||||
DINSTR | Date Customer Was Instructed About Rescission Rights | TB_DINSTR | DATS | 8 | DATUM | ||||
ORGUNIT | Organizational Unit | TB_MD_ORGUNIT_CNMGT | CHAR | 12 | T_MD_ORGUNIT_CNMGT | ||||
DISTRIB_CHANNEL | Sales Channel | TB_MD_DISTRIBUTION_CHANNEL | CHAR | 10 | T_MD_DISTRIBUTION_CHANNEL | ||||
FLG_CNCL_CLI | Indicator: Rescind Credit Life Insurance | TB_CNCL_CLI | CHAR | 1 | T_CNCL_CLI | ||||
FLG_NO_CHANGE | Only Limited Changes Possible for Contract Indicator | TB_MD_NO_CHANGE | CHAR | 1 | TB_MD_NO_CHANGE | ||||
SCHEME_ID | Calculation Profile for Interest on Arrears Calculation | TB_SCHEME_ID | CHAR | 3 | T_SCHEME_ID | ||||
SSTATE_OF_EXEC | Region Where Contract Concluded | TB_SREGION | CHAR | 3 | REGIO | ||||
WAIVE_REASON | Reason for Automatic Waiver of Charges | TB_WAIVE_REASON | CHAR | 3 | T_WAIVE_REASON | ||||
WAIVE_METHOD | Waiver Method | TB_WAIVE_METHOD | NUMC | 1 | T_WAIVE_METHOD | ||||
BACKOFFICE_ID | Back Office | TB_BACKOFFICE_ID | NUMC | 8 | HROBJID | ||||
FLG_NON_ACCRUAL | Non-Accrual Status Permitted | TB_FLG_NON_ACCRUAL | CHAR | 1 | XFELD | ||||
SFIMA_METHOD | Control Settings for FiMa Connection | TB_FIMA_METHOD | CHAR | 1 | T_FIMA_METHOD | ||||
GRACE_DAYS | Grace Days | TB_GRACEDAYS | NUMC | 3 | NUM03 | ||||
NOIOA_TILL_BLOCK | End Date of Non-IOA Period | TB_NOIOA_TILL_BLOCK | DATS | 8 | DATS | ||||
FLG_SYNDICATE | Syndicated Loan | TB_FLG_SYNDICATE | CHAR | 1 | XFELD | ||||
FLG_FACILITY | Loan: Part of Facility | TB_FLG_FACILITY | CHAR | 1 | XFELD | ||||
SHADOW_ACCNT | Value of Shadow Account | TB_SHD_ACCNT | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
OPTIMAL_LIST | For interest adjust optimization solution list | TB_OP_LIST_CMLCHN | CHAR | 1 | T_OP_LIST_CMLCHN | ||||
.INCLU--AP | 0 | ||||||||
RP_RELEVANT | Flag „relevant for German Banking Act ' | VVRP_RELEVANT | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
CONTRACT_BIC | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
CONTRACT_IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR | 34 | CHAR34 | ||||
IBAN_DET | Type of Determination of IBAN for a contract | TB_SEPA_IBAN_DET | CHAR | 1 | TB_SEPA_IBAN_DET_DOM | ||||
.INCLU--AP | 0 | ||||||||
FAC_GROUP_NUMBER | Facility Grouping Identifier | TB_FACILITY_GROUP_NUMBER | CHAR | 13 | ALPHA | RANL | |||
FLG_DD_REVOLVING | Revolving Drawdown | TB_FLG_DRAWDOWN_REVOLVING | CHAR | 1 | T_FLG_DRAWDOWN_REVOLVING | ||||
FLG_FAC_INACTIVE | Facility Inactive | TB_FLG_FACILITY_INACTIVE | CHAR | 1 | T_FLG_FACILITY_INACTIVE | ||||
.INCLU--AP | 0 | ||||||||
OBJ_ID | Data object Identifier | DATOBJ_ID | CHAR | 50 | CHAR50 | ||||
OBJ_KEY | Key for Archive File | ARKEY | CHAR | 20 | ARKEY | ||||
OBJ_OFFSET | Archive file data object offset | ADMI_OFFST | INT4 | 10 | |||||
.INCLU--AP | 0 | ||||||||
FLP | Loan Belongs to Forward Loan Purchase | TB_FLP_FLAG | CHAR | 1 | T_FLP_FLAG | ||||
FLP_NUMBER | Forward Loan Purchase Deal Number | TB_FLP_DEAL_NUMBER | CHAR | 13 | ALPHA | T_FLP_DEAL_NUMBER | |||
.INCLU--AP | 0 | ||||||||
VDBEPP_DBEAR | Planned Records Last Edited On | VDBEPP_DBEAR | DATS | 8 | DATUM | ||||
VDBEPP_TBEAR | Planned Records Last Edited At | VDBEPP_TBEAR | TIMS | 6 | TIMES | ||||
VDBEPP_RBHER | Planned Records Editing Source | VDBEPP_RBHER | CHAR | 10 | CHAR10 | ||||
.INCLU--AP | 0 | ||||||||
RESERVED_AMOUNT | Reserved amount | TB_FACILITY_RES_AMT_CMLCHN | CURR | 13(2) | BWHR | ||||
WA_PARTNER | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
WA_ADRDAT | 0 | ||||||||
ADRS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
ADRS_NUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERS_NUM | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
BAD_ADDRESS_ACTION | System Response When Correspondence Cannot Be Delivered | TB_BAD_ADDRESS_FLAG | CHAR | 1 | T_BAD_ADDRESS_FLAG | ||||
WA_ADDRESS | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
WA_NAME | 0 | ||||||||
NAME_COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
FORMATTED_NAME | Address line | LINES | CHAR | 80 | LINES | ||||
FORMATTED_NAME_WITH_TITLE | Address line | LINES | CHAR | 80 | LINES | ||||
GREETING_LINE | Address line | LINES | CHAR | 80 | LINES | ||||
WA_CAP_DETS | 0 | ||||||||
VDCAPITAL | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBO_CAT | Business Operation Category | SBO_CAT | CHAR | 1 | SBO_CAT | ||||
SBO_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | SBO_STATUS | ||||
SBO_STATUS_OLD | Loans: Business operation status | SBO_STATUS | CHAR | 1 | SBO_STATUS | ||||
XBO_TEXT | Text for Business Operation | XBOTEXT | CHAR | 30 | TEXT30 | ||||
SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | T_SRELSTAT | ||||
SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | T_SFGKZ | ||||
UCURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
AARRBAL | Total Amount of Overdue Items | TB_ARRBALANCE | CURR | 13(2) | WERTV7 | ||||
AFUDUPAY | Total Amount for Payments Due in the Future | TB_FUDUPAY | CURR | 13(2) | WERTV7 | ||||
ACAPRECS | Total Amount of Receivables to Be Included in Loan | TB_CAPRECS | CURR | 13(2) | WERTV7 | ||||
ACREBAL | Total Amount of Credit | TB_CREBAL | CURR | 13(2) | WERTV7 | ||||
ABALNUIT | Total Amount of Non-Selected Items | TB_BALNUIT | CURR | 13(2) | WERTV7 | ||||
ABALNCPRECS | Total Amount of Receivables Not Included in Loan | TB_BALNCPRECS | CURR | 13(2) | WERTV7 | ||||
IINCL_KYDTE | Term Including Key Date | TB_INCLKYDTE | CHAR | 1 | XFELD | ||||
IULTI_KYDTE | Key Date Must Be Last Day of the Month | TB_ULTIKYDTE | CHAR | 1 | XFELD | ||||
DPAYM_TO | Payments to | TB_PAYM_TO | DATS | 8 | DATUM | ||||
INOTE_ASSIGNED | Memo Exists | TB_IND_NOTE_ASSIGNED | CHAR | 1 | XFELD | ||||
APRCCHRGE | Processing Charge for Deferral or Capitalization | TB_PRCCHRGE | CURR | 13(2) | WERTV7 | ||||
ICAPITAL | Include Processing Charge in Loan | TB_ICAPITAL | CHAR | 1 | XFELD | ||||
IDEVIATE_PAYM | Alternative Payment Information in Additional Flows | TB_DEVIATE_PAYM | CHAR | 1 | XFELD | ||||
MNORISKMS | Number of Risk-Increasing Measures | TB_NORISKMS | NUMC | 2 | T_NORISKMS | ||||
IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13(2) | WERTV7 | ||||
MPOSTTYPE | Posting Control | TB_DEFCAPPOSTTYPE | NUMC | 2 | VVSBUST | ||||
IDUNNBLCK | Dunning Block for Items for Deferral or Capitalization | TB_DUNNBLCK | CHAR | 1 | MANSP | ||||
IIOABLCK | Interest on Arrears Block for Items for Deferral/Capitaliz. | TB_IOABLCK | CHAR | 2 | ZINKZ | ||||
IDUBLDEFI | Dunning Block for Deferral Installments | TB_DUBLDEFR | CHAR | 1 | MANSP | ||||
IIOABLDEFI | Interest on Arrears Block for Deferral Installments | TB_IOADEFI | CHAR | 2 | ZINKZ | ||||
IPAYBLCK | Payment Block for Deferral Installments | TB_PAYBLCK | CHAR | 1 | ZAHLS | ||||
DOFFER_FR | Creation Date for the Offer | TB_OFFER_FR | DATS | 8 | DATUM | ||||
DOFFER_TO | End of the Validity Period of the Offer | TB_OFFER_TO | DATS | 8 | DATUM | ||||
DACCEPT | Acceptance Date of the Offer | TB_ACCEPT | DATS | 8 | DATUM | ||||
ICAPMANUPROC | Reason for Postprocessing: Key | TB_MAN_POSTPROCESS | NUMC | 3 | |||||
MCAPREASON | Key for Reason for Capitalization | TB_CAPREASON | NUMC | 3 | T_DEFCAPREASON | ||||
ACAPITALI | Capitalization Amount | TB_CAPAMO | CURR | 13(2) | WERTV7 | ||||
DCAPKYDTE | Key Date for Capitalization of Overdue Items | TB_CAPKYDTE | DATS | 8 | DATUM | ||||
DENDPROPO | New End of Term | TB_ENDPROPO | DATS | 8 | DATUM | ||||
AINSTPROPO | New Figure for Payment Installments | TB_INSTPROPO | CURR | 13(2) | WERTV7 | ||||
PKAPEFFINTRT | Effective Interest Based on Capitalization of Overdue Items | TB_KAPEFFINTRT | DEC | 10(7) | DECV3_7 | ||||
MKAPEFFINTMT | Capitalization of Overdue Items: Effective Interest Method | TB_KAPEFFINTMT | NUMC | 1 | SEFFMETH | ||||
DENDWOCAP | End of Term Without Capitalization of Overdue Items | TB_ENDWOCAP | DATS | 8 | DATUM | ||||
AINSTWOCAP | Payment Installment Amount w/o Capitalizn of Overdue Items | TB_INSTWOCAP | CURR | 13(2) | WERTV7 | ||||
IENDPROPO | Specify New End of Term | TB_IENDPROPO | CHAR | 1 | |||||
IINSTPROPO | Specify New Installment | TB_IINSTPROPO | CHAR | 1 | |||||
NINSTPROPO | Total No.Pymnt Installments with Capitalizn of Overdue Items | TB_NINSTPROPO | NUMC | 3 | |||||
NINSTWOCAP | Total No. Pymnt Installments w/o Capitalizn of Overdue Items | TB_NINSTWOCAP | NUMC | 3 | |||||
NOVRTWOCAP | Overall Term in Months w/o Capitalization of Overdue Items | TB_NOVRTWOCAP | NUMC | 3 | |||||
NOVRTPROPO | Overall Term in Months with Capitalization of Overdue Items | TB_NOVRTPROPO | NUMC | 3 | |||||
DSTARTREP | Repayment Start | TB_DSTARTREP | DATS | 8 | |||||
DFIRST_DISB | Field of type DATS | DATS | DATS | 8 | DATS | ||||
DOEFFINTPYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | DATUM | ||||
OEFFINTPYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10(7) | DEC3_7 | ||||
NMAXTERM | Number of Times Units for Maximum Term of Contract | TB_PROD_TERM_MAX_VALUE | NUMC | 4 | T_PROD_TIME_QUANTITY_TERM | ||||
AREIMBURSEMENT | Credit Life Insurance Reimbursement | TB_CLI_RECALC_CONTR | CURR | 13(2) | WERTV7 | ||||
AINSURANCE_CONTR | Single Premium for Credit Life Insurance | TB_CLI_INSURANCE | CURR | 13(2) | WERTV7 | ||||
ADIFFERENCE | Calculated Difference for Credit Life Insurance | TB_LOLIINBAL | CURR | 13(2) | WERTV7 | ||||
ICONSIDER | Transfer CLI Difference | TB_ICONSIDER | CHAR | 1 | XFELD | ||||
CALCULATION_DATE | CLI: Key Date for Calculation of Credit Life Insurance | TB_CLI_CALCULATION_DATE | DATS | 8 | DATUM | ||||
UCLICURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
CLI_FLOW_SBEWART | Flow Type | SBEWART | CHAR | 4 | SBEWART | ||||
CLI_CHANGED | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
NEW | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
RKEY1 | Key part 1 | RKEY1 | CHAR | 13 | RKEY1 | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | STATI | ||||
SKOKOART | Type of Condition Header | SKOKOART | NUMC | 2 | SKOKOART | ||||
STILGRHY | Payment cycle | STILGRHY | NUMC | 2 | SRHYT | ||||
STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
SDISEIN | Type of Discount Withholding | SDISEIN | CHAR | 1 | SDISEIN | ||||
KZAHLUNG | Pay-in/disbursement rate | KZAHLUNG | DEC | 10(7) | DEC3_7 | ||||
BZAHLUNG | Pay-in/disbursement amount | BZAHLUNG | CURR | 13(2) | BWHR | ||||
SWHRZHLG | Currency of payment amount | SWHRZHLG | CUKY | 5 | WAERS | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
SWHRZUSA | Currency of commitment amount | SWHRZUSA | CUKY | 5 | WAERS | ||||
PEFFZINS | Effective Interest Rate | TB_EFF_RATE | DEC | 10(7) | DECV3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SDISKO | Discounted | SDISKO | CHAR | 1 | SDISKO | ||||
DKUEND | Date of notice | DKUEND | DATS | 8 | DATUM | ||||
SKUEND | Reason for Notice | SKUEND | NUMC | 3 | SKUEART | ||||
DKUENDDG | Earliest Possible Date for Notice Given by the Lender | DKUENDDG | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DBLFZ_ORIGIN | Original Term Start | DBLFZ_ORIGIN | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
DRESAM | Reservation of Conditions On | DRESAM | DATS | 8 | DATUM | ||||
DRESBIS | Reservation of Conditions Until | DRESBIS | DATS | 8 | DATUM | ||||
DANGAM | Offer creation date | DANGAM | DATS | 8 | DATUM | ||||
DANGBIS | Offer Effective To | DANGBIS | DATS | 8 | DATUM | ||||
SANGVOR | Offer/Acceptance Reservation Indicator | SANGVOR | NUMC | 2 | SANGVOR | ||||
JANNAHME | Offer Acceptance Indicator | JANNAHME | CHAR | 1 | JANEI | ||||
SANNAHME | Type of offer acceptance indicator | SANNAHME | NUMC | 2 | SKONTAKT | ||||
DANNAHME | Date of acceptance of offer | DANNAHME | DATS | 8 | DATUM | ||||
JVERTRAG | Indicator: Contract Created? | JVERTRAG | CHAR | 1 | JANEI | ||||
DVERTRAM | Contract creation date | DVERTRAM | DATS | 8 | DATUM | ||||
DVERTBIS | Return contract by | DVERTBIS | DATS | 8 | DATUM | ||||
PMANEFFZ | Internal Effective Interest Rate | TB_EFF_RATE_INT | DEC | 10(7) | DECV3_7 | ||||
SEFFM2 | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SKUEGL | Notice Arrangement Lender | VVSKUEGL | NUMC | 3 | VVSKUEGL | ||||
RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | NUMC08 | ||||
DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
DGES | Earliest Notice Date in acc. with the Legal Right of Notice | VVDGES | DATS | 8 | DATUM | ||||
SGESAUS | Legal Right of Notice Excluded | VVSGESAUS | CHAR | 1 | XFELD | ||||
SZKZ | Special int. ID for int. on arrears for remaining balance | VVSZKZ | CHAR | 1 | VVSZKZ | ||||
NANGEBOT | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
ZVRHYEFF | Int.sttlmnt frequency for effective int.rate calc.in months | VVZVRHYEFF | NUMC | 3 | NUMC03 | ||||
PVGLEFFZ | Comparative Effective Interest | TB_EFF_RATE_COM | DEC | 10(7) | DECV3_7 | ||||
SULTEFSZ | Month-end indicator for end of fixed period | VVSULTEFSZ | CHAR | 1 | VVSULT | ||||
DABEFFZ | Date when calculation of effective rate starts | VVDABEFFZ | DATS | 8 | DATUM | ||||
DKUENDDN | Earliest Possible Date for Notice Given by the Borrower | VVDKUENDDN | DATS | 8 | DATUM | ||||
SKUEDN | Notice Arrangement Borrower | VVSKUEDN | NUMC | 3 | VVSKUEDN | ||||
SKUEART | Notice Type for the Loan | VVSKUEART | NUMC | 3 | VVSKUEART | ||||
DMARKTZINS | ISB: Market Rate Date: Market Interest Rate for NPV Calc. | DMARKTZINS | DATS | 8 | DATS | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | WFCID | H_TFACD | |||
EDEFFZINS | Relevant for Closely Defined Effective Interest | TB_EFF_RATE_ED | DEC | 10(7) | DECV3_7 | ||||
EDEFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | EFFMETH | ||||
JAHREFFZINS | Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU | TB_EFF_RATE_YEAR | DEC | 10(7) | DECV3_7 | ||||
JAHREFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | EFFMETH | ||||
PEFFZINS_ORIGIN | Original Effective Interest Rate | TB_EFF_RATE_ORIG | DEC | 10(7) | DECV3_7 | ||||
.INCLU--AP | 0 | ||||||||
ORIGINAL_TERM | Original Term in Months | TB_VIEW_ORIGINAL_TERM | NUMC | 3 | |||||
OVERALL_RUNTIME | Overall Term | TB_VIEW_OVERALL_RUNTIME | NUMC | 3 | |||||
ORIG_CREDIT_SUM | Original Total Loan Amount | TB_VIEW_ORIGINAL_CREDIT_SUM | CURR | 13(2) | WERTV7 | ||||
DATE_REPAYMENT | Start Date for Repayment | TB_VIEW_DATE_REPAYMENT | DATS | 8 | DATUM | ||||
DATE_FIRST_RATE | Due Date for First Installment to Include a Repayment Amount | TB_VIEW_DATE_FIRST_RATE | DATS | 8 | DATUM | ||||
DAY_OF_PAYMENT | Day of Installment Payment | TB_VIEW_DAY_OF_PAYMENT | NUMC | 2 | T_VIEW_DAY_OF_PAYMENT | ||||
CLEARING_RATE | Amount for Final Loan Installment Payment | TB_VIEW_CLEARING_RATE | CURR | 13(2) | WERTV7 | ||||
EFF_INT_L_PYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10(7) | DEC3_7 | ||||
DEFF_INT_L_PYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | DATUM | ||||
REPAY_DELAY | Model Calculation: DE for Periods of Repayment Suspension | TB_MODEL_REPAY_DELAY | NUMC | 2 | |||||
CALCULATED_PARAM | Calculate Installment Amount or Number of Installments? | TB_MODEL_P_RATE_OR_TERM | CHAR | 4 | T_MODEL_P_RATE_OR_TERM | ||||
CURR_CREDIT_SUM | Current Total Loan Amount | TB_VIEW_CURRENT_CREDIT_SUM | CURR | 13(2) | WERTV7 | ||||
BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 13(7) | TFMSRUNIT | ||||
SROUND | Rounding Category (Round up, Round Down or Number Rounding) | TB_SROUND_A | CHAR | 1 | TFM_SROUND | ||||
BOVERLIMIT | Drawing Tolerance as Amount | TB_COMP_OVERLIMIT_AMOUNT | CURR | 13(2) | WERTV7 | ||||
POVERLIMIT | Drawing Tolerance as a Percentage | TB_COMP_OVERLIMT_PERCENT | DEC | 10(7) | DECV3_7 | ||||
CONTAB | Condition Table | TB_FICO_CONTAB | CHAR | 8 | T_FICO_CONTAB | FVD_FICO_CONTAB | |||
CONTAB_VERSION | Version Number for a Condition Table | TB_FICO_CONTAB_VERSION | NUMC | 4 | T_FICO_CONTAB_VERSION | ||||
TERM_PAYMENT | Category of Last Installment | TB_TERM_PAYMENT | CHAR | 1 | T_TERM_PAYMENT | ||||
PAPR_ORIGIN | Original U.S. Effective Interest Rate | TB_PAPR_ORIGIN | DEC | 10(7) | DECV3_7 | ||||
OLD | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
RKEY1 | Key part 1 | RKEY1 | CHAR | 13 | RKEY1 | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | STATI | ||||
SKOKOART | Type of Condition Header | SKOKOART | NUMC | 2 | SKOKOART | ||||
STILGRHY | Payment cycle | STILGRHY | NUMC | 2 | SRHYT | ||||
STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
SDISEIN | Type of Discount Withholding | SDISEIN | CHAR | 1 | SDISEIN | ||||
KZAHLUNG | Pay-in/disbursement rate | KZAHLUNG | DEC | 10(7) | DEC3_7 | ||||
BZAHLUNG | Pay-in/disbursement amount | BZAHLUNG | CURR | 13(2) | BWHR | ||||
SWHRZHLG | Currency of payment amount | SWHRZHLG | CUKY | 5 | WAERS | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
SWHRZUSA | Currency of commitment amount | SWHRZUSA | CUKY | 5 | WAERS | ||||
PEFFZINS | Effective Interest Rate | TB_EFF_RATE | DEC | 10(7) | DECV3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SDISKO | Discounted | SDISKO | CHAR | 1 | SDISKO | ||||
DKUEND | Date of notice | DKUEND | DATS | 8 | DATUM | ||||
SKUEND | Reason for Notice | SKUEND | NUMC | 3 | SKUEART | ||||
DKUENDDG | Earliest Possible Date for Notice Given by the Lender | DKUENDDG | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DBLFZ_ORIGIN | Original Term Start | DBLFZ_ORIGIN | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
DRESAM | Reservation of Conditions On | DRESAM | DATS | 8 | DATUM | ||||
DRESBIS | Reservation of Conditions Until | DRESBIS | DATS | 8 | DATUM | ||||
DANGAM | Offer creation date | DANGAM | DATS | 8 | DATUM | ||||
DANGBIS | Offer Effective To | DANGBIS | DATS | 8 | DATUM | ||||
SANGVOR | Offer/Acceptance Reservation Indicator | SANGVOR | NUMC | 2 | SANGVOR | ||||
JANNAHME | Offer Acceptance Indicator | JANNAHME | CHAR | 1 | JANEI | ||||
SANNAHME | Type of offer acceptance indicator | SANNAHME | NUMC | 2 | SKONTAKT | ||||
DANNAHME | Date of acceptance of offer | DANNAHME | DATS | 8 | DATUM | ||||
JVERTRAG | Indicator: Contract Created? | JVERTRAG | CHAR | 1 | JANEI | ||||
DVERTRAM | Contract creation date | DVERTRAM | DATS | 8 | DATUM | ||||
DVERTBIS | Return contract by | DVERTBIS | DATS | 8 | DATUM | ||||
PMANEFFZ | Internal Effective Interest Rate | TB_EFF_RATE_INT | DEC | 10(7) | DECV3_7 | ||||
SEFFM2 | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SKUEGL | Notice Arrangement Lender | VVSKUEGL | NUMC | 3 | VVSKUEGL | ||||
RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | NUMC08 | ||||
DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
DGES | Earliest Notice Date in acc. with the Legal Right of Notice | VVDGES | DATS | 8 | DATUM | ||||
SGESAUS | Legal Right of Notice Excluded | VVSGESAUS | CHAR | 1 | XFELD | ||||
SZKZ | Special int. ID for int. on arrears for remaining balance | VVSZKZ | CHAR | 1 | VVSZKZ | ||||
NANGEBOT | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
ZVRHYEFF | Int.sttlmnt frequency for effective int.rate calc.in months | VVZVRHYEFF | NUMC | 3 | NUMC03 | ||||
PVGLEFFZ | Comparative Effective Interest | TB_EFF_RATE_COM | DEC | 10(7) | DECV3_7 | ||||
SULTEFSZ | Month-end indicator for end of fixed period | VVSULTEFSZ | CHAR | 1 | VVSULT | ||||
DABEFFZ | Date when calculation of effective rate starts | VVDABEFFZ | DATS | 8 | DATUM | ||||
DKUENDDN | Earliest Possible Date for Notice Given by the Borrower | VVDKUENDDN | DATS | 8 | DATUM | ||||
SKUEDN | Notice Arrangement Borrower | VVSKUEDN | NUMC | 3 | VVSKUEDN | ||||
SKUEART | Notice Type for the Loan | VVSKUEART | NUMC | 3 | VVSKUEART | ||||
DMARKTZINS | ISB: Market Rate Date: Market Interest Rate for NPV Calc. | DMARKTZINS | DATS | 8 | DATS | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | WFCID | H_TFACD | |||
EDEFFZINS | Relevant for Closely Defined Effective Interest | TB_EFF_RATE_ED | DEC | 10(7) | DECV3_7 | ||||
EDEFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | EFFMETH | ||||
JAHREFFZINS | Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU | TB_EFF_RATE_YEAR | DEC | 10(7) | DECV3_7 | ||||
JAHREFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | EFFMETH | ||||
PEFFZINS_ORIGIN | Original Effective Interest Rate | TB_EFF_RATE_ORIG | DEC | 10(7) | DECV3_7 | ||||
.INCLU--AP | 0 | ||||||||
ORIGINAL_TERM | Original Term in Months | TB_VIEW_ORIGINAL_TERM | NUMC | 3 | |||||
OVERALL_RUNTIME | Overall Term | TB_VIEW_OVERALL_RUNTIME | NUMC | 3 | |||||
ORIG_CREDIT_SUM | Original Total Loan Amount | TB_VIEW_ORIGINAL_CREDIT_SUM | CURR | 13(2) | WERTV7 | ||||
DATE_REPAYMENT | Start Date for Repayment | TB_VIEW_DATE_REPAYMENT | DATS | 8 | DATUM | ||||
DATE_FIRST_RATE | Due Date for First Installment to Include a Repayment Amount | TB_VIEW_DATE_FIRST_RATE | DATS | 8 | DATUM | ||||
DAY_OF_PAYMENT | Day of Installment Payment | TB_VIEW_DAY_OF_PAYMENT | NUMC | 2 | T_VIEW_DAY_OF_PAYMENT | ||||
CLEARING_RATE | Amount for Final Loan Installment Payment | TB_VIEW_CLEARING_RATE | CURR | 13(2) | WERTV7 | ||||
EFF_INT_L_PYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10(7) | DEC3_7 | ||||
DEFF_INT_L_PYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | DATUM | ||||
REPAY_DELAY | Model Calculation: DE for Periods of Repayment Suspension | TB_MODEL_REPAY_DELAY | NUMC | 2 | |||||
CALCULATED_PARAM | Calculate Installment Amount or Number of Installments? | TB_MODEL_P_RATE_OR_TERM | CHAR | 4 | T_MODEL_P_RATE_OR_TERM | ||||
CURR_CREDIT_SUM | Current Total Loan Amount | TB_VIEW_CURRENT_CREDIT_SUM | CURR | 13(2) | WERTV7 | ||||
BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 13(7) | TFMSRUNIT | ||||
SROUND | Rounding Category (Round up, Round Down or Number Rounding) | TB_SROUND_A | CHAR | 1 | TFM_SROUND | ||||
BOVERLIMIT | Drawing Tolerance as Amount | TB_COMP_OVERLIMIT_AMOUNT | CURR | 13(2) | WERTV7 | ||||
POVERLIMIT | Drawing Tolerance as a Percentage | TB_COMP_OVERLIMT_PERCENT | DEC | 10(7) | DECV3_7 | ||||
CONTAB | Condition Table | TB_FICO_CONTAB | CHAR | 8 | T_FICO_CONTAB | FVD_FICO_CONTAB | |||
CONTAB_VERSION | Version Number for a Condition Table | TB_FICO_CONTAB_VERSION | NUMC | 4 | T_FICO_CONTAB_VERSION | ||||
TERM_PAYMENT | Category of Last Installment | TB_TERM_PAYMENT | CHAR | 1 | T_TERM_PAYMENT | ||||
PAPR_ORIGIN | Original U.S. Effective Interest Rate | TB_PAPR_ORIGIN | DEC | 10(7) | DECV3_7 | ||||
DNEW_RATE_DUE | Payment Date | DZAHLDATUM | DATS | 8 | DATUM | ||||
TEXT_REASON | Description of Reason for Capitalization | TB_CAPREASONT | CHAR | 40 | CHAR40_LOW | ||||
WA_DEF_DETS | 0 | ||||||||
VDDEFERRAL | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBO_CAT | Business Operation Category | SBO_CAT | CHAR | 1 | SBO_CAT | ||||
SBO_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | SBO_STATUS | ||||
SBO_STATUS_OLD | Loans: Business operation status | SBO_STATUS | CHAR | 1 | SBO_STATUS | ||||
XBO_TEXT | Text for Business Operation | XBOTEXT | CHAR | 30 | TEXT30 | ||||
SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | T_SRELSTAT | ||||
SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | T_SFGKZ | ||||
UCURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
AARRBAL | Total Amount of Overdue Items | TB_ARRBALANCE | CURR | 13(2) | WERTV7 | ||||
AFUDUPAY | Total Amount for Payments Due in the Future | TB_FUDUPAY | CURR | 13(2) | WERTV7 | ||||
ACAPRECS | Total Amount of Receivables to Be Included in Loan | TB_CAPRECS | CURR | 13(2) | WERTV7 | ||||
ACREBAL | Total Amount of Credit | TB_CREBAL | CURR | 13(2) | WERTV7 | ||||
ABALNUIT | Total Amount of Non-Selected Items | TB_BALNUIT | CURR | 13(2) | WERTV7 | ||||
ABALNCPRECS | Total Amount of Receivables Not Included in Loan | TB_BALNCPRECS | CURR | 13(2) | WERTV7 | ||||
IINCL_KYDTE | Term Including Key Date | TB_INCLKYDTE | CHAR | 1 | XFELD | ||||
IULTI_KYDTE | Key Date Must Be Last Day of the Month | TB_ULTIKYDTE | CHAR | 1 | XFELD | ||||
DPAYM_TO | Payments to | TB_PAYM_TO | DATS | 8 | DATUM | ||||
INOTE_ASSIGNED | Memo Exists | TB_IND_NOTE_ASSIGNED | CHAR | 1 | XFELD | ||||
APRCCHRGE | Processing Charge for Deferral or Capitalization | TB_PRCCHRGE | CURR | 13(2) | WERTV7 | ||||
ICAPITAL | Include Processing Charge in Loan | TB_ICAPITAL | CHAR | 1 | XFELD | ||||
IDEVIATE_PAYM | Alternative Payment Information in Additional Flows | TB_DEVIATE_PAYM | CHAR | 1 | XFELD | ||||
MNORISKMS | Number of Risk-Increasing Measures | TB_NORISKMS | NUMC | 2 | T_NORISKMS | ||||
IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13(2) | WERTV7 | ||||
MPOSTTYPE | Posting Control | TB_DEFCAPPOSTTYPE | NUMC | 2 | VVSBUST | ||||
IDUNNBLCK | Dunning Block for Items for Deferral or Capitalization | TB_DUNNBLCK | CHAR | 1 | MANSP | ||||
IIOABLCK | Interest on Arrears Block for Items for Deferral/Capitaliz. | TB_IOABLCK | CHAR | 2 | ZINKZ | ||||
IDUBLDEFI | Dunning Block for Deferral Installments | TB_DUBLDEFR | CHAR | 1 | MANSP | ||||
IIOABLDEFI | Interest on Arrears Block for Deferral Installments | TB_IOADEFI | CHAR | 2 | ZINKZ | ||||
IPAYBLCK | Payment Block for Deferral Installments | TB_PAYBLCK | CHAR | 1 | ZAHLS | ||||
DOFFER_FR | Creation Date for the Offer | TB_OFFER_FR | DATS | 8 | DATUM | ||||
DOFFER_TO | End of the Validity Period of the Offer | TB_OFFER_TO | DATS | 8 | DATUM | ||||
DACCEPT | Acceptance Date of the Offer | TB_ACCEPT | DATS | 8 | DATUM | ||||
IDEFMANUPROC | Reason for Postprocessing: Key | TB_MAN_POSTPROCESS | NUMC | 3 | |||||
MDEFREASON | Reason for Deferral: Key | TB_DEFREASON | NUMC | 3 | T_DEFCAPREASON | ||||
ADEFERR | Deferral Amount | TB_DEFAMO | CURR | 13(2) | WERTV7 | ||||
DDEFKYDTE | Key Date for Deferral | TB_DEFKYDTE | DATS | 8 | DATUM | ||||
PDEFINTRT | Interest Rate for the Deferral | TB_DEFINTRT | DEC | 10(7) | DECV3_7 | ||||
MINTDYMT | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DFRSTDUDTE | Due Date of First Installment Payment for Deferral Plan | TB_FRSDUDTE | DATS | 8 | DATUM | ||||
IULTIDUDTE | Due Date Is Always on the Last Day of the Month | TB_ULTIDUDTE | CHAR | 1 | XFELD | ||||
IINCLDUDTE | Including Due Date | TB_INCLDUDTE | CHAR | 1 | CHAR1 | ||||
MNUMRTS | Number of Payment Installments in the Deferral Plan | TB_NUMRTS | NUMC | 3 | |||||
MRHYTHM | Frequency of Installment Payments in Months | TB_RHYTHM | NUMC | 3 | |||||
MWRKDYRL | Working Day Shift for Calculation Day | TB_SVWERK | NUMC | 1 | T_SWERK | ||||
MPUHOLCAL | Factory calendar | SKALID | CHAR | 2 | WFCID | H_TFACD | |||
IFREEPAYM | Custom Deferral Plan | TB_FREEPAYM | CHAR | 1 | XFELD | ||||
MPARTKUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
MPARTNER | Business Partner Number for Payer of Deferral Installments | TB_DEFPARTNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
MBANKTYPE | Bank Details ID for Deferral Installments | TB_DEFBVTYP | CHAR | 4 | BVTYP | ||||
MPAYMTHD | Payment Method for Deferral Installments | TB_DEFPYMTD | CHAR | 1 | ZLSCH | ||||
PEFFINTRT | Effective Interest Rate for Deferral Agreement | TB_EFFINTRT | DEC | 10(7) | DECV3_7 | ||||
MEFFINTMT | Effective Interest Method for Deferral Agreement | TB_EFFINTMT | NUMC | 1 | SEFFMETH | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
TEXT_REASON | Description of Reason for Deferral | TB_DEFREASONT | CHAR | 40 | CHAR40_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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects