ESALES_SETTYPE_PARTNER SAP (Set type for business partner and contract account data) Structure details
Description: Set type for business partner and contract account data
Related tables to ESALES_SETTYPE_PARTNER
Access table ESALES_SETTYPE_PARTNER
Structure field list including key, data, relationships and ABAP select examples
ESALES_SETTYPE_PARTNER 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 "Set type for business partner and contract account data" 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_ESALES_SETTYPE_PARTNER TYPE ESALES_SETTYPE_PARTNER.
The ESALES_SETTYPE_PARTNER table consists of various fields, each holding specific information or linking keys about Set type for business partner and contract account data data available in SAP. These include PARTNER (Business Partner Number), ADDRNUMBER (Address number), TYPE (Business partner category), BPKIND (Business Partner Type).. 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 (character-type or numeric)
SAP ESALES_SETTYPE_PARTNER 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 |
PARTN_ROLE | Partner Function | PARVW | CHAR | 2 | Assigned to domain | PARVW | PARVW | PAR | |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | TB004 | BU_KIND | |||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | TB001 | 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 | TB005 | BU_SOURCE | |||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | TSAD3 | 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 | Assigned to domain | BU_AUGRP | |||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | 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_RATES | 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 | TB019 | BU_LEGENTY | H_TB019 | ||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | TB023 | BU_INDSECT | H_TB023 | ||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | TB032 | 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 | TSAD2 | AD_TITLE1 | AD_TITLE1 | ||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | TSAD2 | AD_TITLE1 | |||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | TSAD5 | AD_TITLES | |||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | TSAD4 | AD_PREFIX | |||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | TSAD4 | 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 | T005N | AD_NAMFORM | |||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | T005 | LAND1 | |||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | T002 | 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 | TB027 | BU_MARST | |||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | TB028 | BU_JOBGR | |||
NATIO | Nationality | BU_NATIO | CHAR | 3 | T005 | LAND1 | |||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | Assigned to domain | LAND1 | |||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | T005 | LAND1 | |||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | 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 | USR02 | XUBNAME | |||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | T002 | 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 | TB025 | BU_GRPTYP | H_TB025 | ||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
LGTYP | Legitimation Type | BU_LGTYP | CHAR | 4 | TB029 | BU_LGTYP | |||
LGNUM | Identification number of legitimation document | BU_LGNUM | CHAR | 16 | BU_LGNUM | ||||
INFCT | Responsible local court | BU_INFCT | CHAR | 30 | BU_INFCT | ||||
COMRG | Entry in commercial register | BU_COMRG | CHAR | 30 | CHAR30 | ||||
CLBRG | BP: Entry in register of associations | BU_CLBRG | CHAR | 30 | CHAR30 | ||||
COPRG | Entry in Register of Cooperatives | BU_COPRG | CHAR | 30 | CHAR30 | ||||
COMREG_DAT | Date of entry in trade register | BU_COMREG_DAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
M_BONIWERT | Creditworthiness value set manually | BONIWRT_KK | NUMC | 4 | BONIT_KK | ||||
M_BONIDAT | Date on Which Creditworthiness was Manually Set | BONIDAT_KK | DATS | 8 | DATUM | ||||
NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | BU_NAME | ||||
NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | BU_NAME | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ADRCITYPRT | 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 | ADRCITY | ALPHA | CITY_CODE | ||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | ADRREGGRP | 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 | TSAD12 | 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 | ADRCITY | ALPHA | CITY_CODE | ||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | T005S | REGIO | |||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | T005 | 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 | TZONE | ZONE | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | TSAD12 | AD_NO_USE | |||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ADRSTREET | ALPHA | STRT_CODE | ||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | ADRSTRTYPE | 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 | T005 | LAND1 | LND | ||
LANGU | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | 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 | TSAD6 | 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 | TTZZ | 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 | T002 | 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 | ADDRC_DELI_SERV | 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 | ADRCOUNTY | ALPHA | CNTY_CODE | ||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ADRTOWNSHIP | ALPHA | TWSHP_CODE | ||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | TSADC | AD_COMTYPE | |||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
WAKLASS | Employee classification | WAKLASS | CHAR | 4 | TE697 | E_WAKLASS | |||
FIRMART | Type of installation company | FIRMART | CHAR | 2 | TE183 | FIRMART | |||
ARBFELD | Company work field | ARBFELD | CHAR | 2 | TE185 | ARBFELD | |||
MITGLIED | Membership of installer | MITGLIED | CHAR | 1 | MITGLIED | ||||
SPZULASS | Division license of installer | SPZULASS | CHAR | 20 | SPZULASS | ||||
ARTZULASS | Installer license type | ARTZULASS | CHAR | 2 | TE189 | ARTZULASS | |||
AUSWANZ | Number of identifications | AUSWANZ | NUMC | 2 | AUSWANZ | ||||
PLOMBENZ | Sealing pliers number | PLOMBENZ | CHAR | 10 | PLOMBENZ | ||||
FREMDEVU | Main utility company | FREMDEVU | CHAR | 3 | TE187 | EVU | |||
STATINS | Valid status of installer in supply area | STATINS | CHAR | 2 | TE061 | STATINS | |||
STATDATUM | Date on which status of installer comes into effect | STATDATUM | DATS | 8 | STATDATUM | ||||
ERSTZUL | Date of initial license of installer | ERSTZUL | DATS | 8 | ERSTZUL | ||||
WERKSTATT | Date of workshop inspection | WERKSTATT | DATS | 8 | WERKSTATT | ||||
VERLZUL | Date of license renewal | VERLZUL | DATS | 8 | VERLZUL | ||||
ENDEZUL | Date until which license is renewed | ENDEZUL | DATS | 8 | ENDEZUL | ||||
ANZEVU | Number of utility companies | ANZEVU | NUMC | 2 | ANZEVU | ||||
ANZFIL | Number of branches supported by an installionr company | ANZFIL | NUMC | 2 | ANZFIL | ||||
AUSW_INST | Identification number for installer license | AUSW_INST | CHAR | 10 | AUSW_INST | ||||
DR_LICENSE_LAND1 | Country in which driver's license was acquired | DR_LICENSE_LAND1 | CHAR | 3 | T005 | LAND1 | |||
DR_LICENSE_REGIO | Region in which driver's license was acquired | DR_LICENSE_REGIO | CHAR | 3 | T005S | REGIO | |||
DR_LICENSE | Driver's license number | DR_LICENSE | CHAR | 20 | DR_LICENSE | ||||
SOC_SECURE | Social Insurance Number | E_SOC_SECU | CHAR | 12 | E_SOC_SECU | ||||
WELFARE | Welfare office | WELFARE | CHAR | 9 | WELFARE | ||||
PLACE_EMPL | Work center | PLACE_EMPL | CHAR | 40 | CHAR40 | ||||
KTOKLASSE | Account class | KTOKLASSE | CHAR | 4 | KONTOKLASSE | KTOKLASSE | |||
BUPINFOREL | Information release for business partner data | BUPINFOREL | CHAR | 2 | TEBUPINFOREL | ALPHA | BUPINFOREL | ||
CLERK_ID | Business partner-specific criteria for agent determination | E_CLERK_ID | CHAR | 8 | TECLERK_ID | E_CLERK_ID | |||
RECPTYPE | Category for Alternate Payee | E_RECPTYPE | CHAR | 1 | E_RECPTYPE | ||||
PYMET | Payment method for donations/fund payments | E_PYMET_DON | CHAR | 1 | TFK042Z | PYMET_KK | |||
EMBVT | Bank details ID for donations/fund payments | E_EMBVT_DON | CHAR | 4 | CHAR4 | ||||
HKONT | G/L accounts for donations/fund payments | E_HKONT_DON | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
CLASSIFICATION | Classification of Business Partner | E_CLASSIFICATION | CHAR | 4 | TE181 | CHAR4 | |||
VIP | Indicate Very Important Business Partner | E_VIP | CHAR | 1 | KENNZX | ||||
IDENT_INST | Identification Number for Installer License | IDENT_INST | CHAR | 18 | IDENT_INST | ||||
MUSTER_KUN | Reference for creating a standard customer for bus. partner | MUSTER_KUN | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
TEL_CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC | 3 | NUMC3 | ||||
FAX_CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC | 3 | NUMC3 | ||||
SMTP_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
SMTP_CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC | 3 | NUMC3 | ||||
BKVID | Bank details ID | BU_BKVID | CHAR | 4 | CHAR4 | ||||
BANKS | Bank Country Key | BU_BANKS | CHAR | 3 | T005 | LAND1 | |||
BANKL | Bank Key | BU_BANKK | CHAR | 15 | CHAR15 | ||||
BANKN | Bank Account Number | BU_BANKN | CHAR | 18 | CHAR18 | ||||
BKONT | Bank Control Key | BU_BKONT | CHAR | 2 | CHAR2 | ||||
BKREF | Reference Details for Bank Details | BU_BKREF | CHAR | 20 | CHAR20 | ||||
KOINH | Account Holder Name | BU_KOINH | CHAR | 60 | BU_KOINH | ||||
BKEXT | Bank details ID in external system | BU_BKEXT | CHAR | 20 | CHAR20 | ||||
XEZER | Indicator: Collection Authorization | BU_XEZER | CHAR | 1 | XFELD | ||||
ACCNAME | Name of Bank Account | BU_BANKACCNAME | CHAR | 40 | BU_BKCCNAME | ||||
MOVE_BKVID | ID of Target Details for Change of Bank Details (BP) | BU_MOVE_BKVID | CHAR | 4 | CHAR4 | ADR | |||
BK_VALID_FROM | Validity Start of Business Partner Bank Details | BU_BK_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
BK_VALID_TO | Validity End of Business Partner Bank Details | BU_BK_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
BK_MOVE_DATE | Date of Change to Bank Details (BP) | BU_BK_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR | 34 | CHAR34 | ||||
BANK_GUID | Bank GUID | BU_BANK_GUID | RAW | 16 | UUID | ||||
ACCOUNT_ID | Bank Account Number (New) | BU_ACCOUNT_ID | CHAR | 35 | CHAR35 | ||||
CHECK_DIGIT | Bank Account Check Digit | BU_ACCOUNT_CHECK | CHAR | 2 | CHAR2 | ||||
ACCOUNT_TYPE | Bank Account Type | BU_ACCOUNT_TYPE | CHAR | 3 | CHAR3 | ||||
.INCLU-A | 0 | ||||||||
MANDTA | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
VKONTA | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
GPARTA | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
VKBEZA | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
ERDATA | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAMA | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDATPA | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAMPA | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FDZTGA | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
STOPDA | Processing lock until | STOPD_KK | DATS | 8 | STOPD_KK | ||||
QSZDTA | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 8 | DATUM | ||||
GUIDA | Business Agreement GUID | BUAG_GUID | RAW | 16 | SYSUUID | ||||
DDLAMA | Direct Debit Limit | DDLAM_KK | CURR | 13(2) | WRTV7 | ||||
DDLCUA | Currency of Direct Debit Limit | DDLCU_KK | CUKY | 5 | Assigned to domain | WAERS | |||
DDLNMA | Number of Months for Calculation of Direct Debit Limit | DDLNM_KK | NUMC | 2 | NUM02 | ||||
INV_CYCLE_STARTA | Start Date of Billing Cycle in Contract Account | CYCLE_STARTDATE_KK | DATS | 8 | DATS | ||||
INV_CHGDISC_XA | Int: Charges and Discounts Exist for BP-CrtAcct Relations | CHGDISC_X_KK | CHAR | 1 | XFELD | ||||
BPL_XPOCLA | Business Partner Lock for Postings/Clearing | BPL_XPOCL_KK | CHAR | 1 | BPL_XPOCL_KK | ||||
BPL_FDATEA | Lock valid from | FDATE_KK | DATS | 8 | DATUM | ||||
BPL_TDATEA | Lock valid to | TDATE_KK | DATS | 8 | DATUM | ||||
EXVKOA | Reference number for business partner | EXVKO_KK | CHAR | 25 | CHAR25 | ||||
OPBUKA | Company Code Group | OPBUK_KK | CHAR | 4 | TFK001G | OPBUK_KK | OPBUK | ||
STDBKA | Standard Company Code | STDBK_KK | CHAR | 4 | Assigned to domain | BUKRS | |||
ABWREA | Alternative Payer | ABWRE_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
ABWRAA | Alternative Payee | ABWRA_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
ABWMAA | Alternative dunning recipient | ABWMA_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
EBVTYA | Bank Details ID for Incoming Payments | EBVTY_KK | CHAR | 4 | CHAR4 | ||||
ABVTYA | Bank Details ID for Outgoing Payments | ABVTY_KK | CHAR | 4 | CHAR4 | ||||
EZAWEA | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
EZASPA | Lock Reason for Incoming Payments | EZASP_OLD_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
AZAWEA | Outgoing Payment Methods | AZAWE_KK | CHAR | 5 | CHAR5 | ||||
AZASPA | Lock Reason for Outgoing Payments | AZASP_OLD_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
EIGBVA | Own Bank Details | EIGBV_KK | CHAR | 25 | Assigned to domain | EIGBV_KK | |||
VWNZAA | Create Where-Used List For Line Items | VWNZA_KK | CHAR | 1 | VWNZA_KK | ||||
LOEVMA | Mark Contract Account for Deletion | LOEVM_KK | CHAR | 1 | LOEVM_KK | ||||
ABWVKA | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | ||
IKEYA | Interest Key | IKEY_KK | CHAR | 2 | TFK056A | IKEY_KK | |||
MAHNVA | Dunning Procedure | MAHNV_KK | CHAR | 2 | TFK047A | MAHNV_KK | FKK_MAHNV | ||
MANSPA | Dunning Lock Reason | MANSP_OLD_KK | CHAR | 1 | TFK047S | MANSP_KK | |||
MGRUPA | Grouping fur Dunning Notices | MGRUP_KK | CHAR | 2 | TFK047F | MGRUP_KK | |||
FDGRPA | Planning Group | FDGRP_KK | CHAR | 10 | T035 | ALPHA | FDGRP | FFG | |
VKPBZA | Relationship of Business Partner to Contract Account | VKPBZ_KK | CHAR | 2 | TFK002F | VKPBZ_KK | |||
ADRNBA | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
VKONVA | Contract account used for payment transactions | VKONV_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | ||
GPARVA | Business Partner Acting as Payer in Payment Transactions | GPARV_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
ADRREA | Address Number for Alternative Payer | ADRRE_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ADRRAA | Address Number for Alternative Payee | ADRRA_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ADRMAA | Address number for alternative dunning notice recipient | ADRMA_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ABWRHA | Alternative Invoice Recipient | ABWRH_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
ADRRHA | Address number for alternative bill recipient | ADRRH_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
ADRJDCA | Address Number for Jurisdiction Code Address | ADRJDC_KK | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
BEGRUA | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
TOGRUA | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TFK043 | TOGRU_KK | |||
STOPGA | Reason for Processing Lock | STOPG_KK | CHAR | 1 | TFK001S | STOPG_KK | |||
TXJCDA | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | TXJCD_NOCD_KK | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
COPRCA | Correspondence Variant | COPRC_KK | CHAR | 4 | TFK070B | COPRC_KK | |||
VBUNDA | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
CCARD_IDA | Payment Card ID for Incoming Payments | CCID_IN_KK | CHAR | 6 | CHAR6 | ||||
CCARD_OUTA | Payment Card ID for Outgoing Payments | CCID_OUT_KK | CHAR | 6 | CHAR6 | ||||
UEBTRA | Items Transferred To Another Account | XUEBTR_KK | CHAR | 1 | XFELD | ||||
DEF_RECA | Alternative Correspondence Recipient for Standard Case | DEF_CORR_PARTNER_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
DEF_REC_INDA | FI-CA correspondence - activity key | DEF_CORR_ACKEY_KK | CHAR | 4 | TFK070L | CORR_ACKEY_KK | |||
QSSKZ_AA | Witholding Tax Code For Outgoing Payments | QSSKZ_A_KK | CHAR | 2 | Assigned to domain | QSSKZ | |||
QSSKZ_EA | Withholding Tax Code For Incoming Payments | QSSKZ_E_KK | CHAR | 2 | Assigned to domain | QSSKZ | |||
QSZNRA | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
CORR_MAHNVA | Correspondence Dunning Procedure | CORR_MAHNV_KK | CHAR | 2 | Assigned to domain | MAHNV_KK | |||
FITYPA | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITPV | J_1AFITP | |||
PROVINCEA | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
COUNTYA | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
VERTYPA | Clearing Category For Clearing Postings | VERTYP_KK | CHAR | 4 | TFK111 | VERTYP_KK | |||
AUGRS_DEFA | Clearing Restriction | AUGRS_DEF_KK | CHAR | 1 | AUGRS_DEF_KK | ||||
LANDLA | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3 | T005 | LAND1 | |||
BUPLAA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
BPTAXTYPE1A | Tax Number Type 1 for Business Partner | BPTAXTYPE1 | CHAR | 4 | BPTAXTYPE | ||||
BPTAXTYPE2A | Tax Number type 2 for Business Partner | BPTAXTYPE2 | CHAR | 4 | BPTAXTYPE | ||||
PERSRA | Clerk Responsible | PERSR_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
INV_CATEGORYA | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | TFK2604 | INV_CATEGORY_KK | |||
DDLXGA | Rolling Calculation of Direct Debit Limit | DDLXG_KK | CHAR | 1 | XFELD | ||||
CMGRPA | Collection Management: Master Data Group | CMGRP_CM_KK | CHAR | 2 | Assigned to domain | CMGRP_CM_KK | |||
STRATA | Collection Strategy | STRAT_CM_KK | CHAR | 2 | Assigned to domain | STRAT_CM_KK | |||
CPERSA | Collections Contact Person | CPERS_CM_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
BPCL_SUCCA | Duplicate Processing: Predecessor/Successor Business Partner | BPCL_SUCC_KK | CHAR | 1 | BPCL_SUCC_KK | ||||
INV_SCHEDULEA | Selection Characteristic for Scheduling | INV_SCHEDULE_KK | CHAR | 4 | TFK2606 | INV_SCHEDULE_KK | |||
INV_CYCLEA | Billing Cycle | CYCLE_KK | CHAR | 4 | TFK2607 | CYCLE_KK | |||
INV_CYCLE_RULEA | Field Is Not Used - CHAR4 | CYCLE_RULE_KK | CHAR | 4 | |||||
INV_CYCLE_DAYA | Day of Period End | CYCLE_DAY_KK | CHAR | 2 | CYCLE_DAY_KK | ||||
INV_CYCLE_MONTHA | Field Is Not Used - CHAR2 | NOT_USED_CHAR2_KK | CHAR | 2 | |||||
MNDIDA | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
APPLKA | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
VKTYPA | Contract Account Category | VKTYP_KK | CHAR | 2 | TFK002A | VKTYP_KK | KTP | ||
VKONAA | Contract account number in legacy system | VKONA_KK | CHAR | 20 | CHAR20 | ||||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN |
Key field | Non-key field |
How do I retrieve data from SAP structure ESALES_SETTYPE_PARTNER using ABAP code?
As ESALES_SETTYPE_PARTNER 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 ESALES_SETTYPE_PARTNER as there is no data to select.How to access SAP table ESALES_SETTYPE_PARTNER
Within an ECC or HANA version of SAP you can also view further information about ESALES_SETTYPE_PARTNER 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