SAP Table EWASWDOC_WORKAREA_BP_DP
Screen Structure for Business Partner Work Area
EWASWDOC_WORKAREA_BP_DP (Screen Structure for Business Partner Work Area) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EWASWDOC_WORKAREA_BP_DP to other SAP tables.
EWASWDOC_WORKAREA_BP_DP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| WORKAREA | Waste Disposal Order Cockpit: Work Area | EWADWDOC_WORKAREA | EWA_WDOC_WAREA | CHAR | 30 | 0 | ||||||||
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR | 10 | 0 | ||||||||
| TYPE | Business partner category | BU_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||||
| BPKIND | Business Partner Type | BU_BPKIND | TB004 | CHAR | 4 | 0 | ||||||||
| BU_GROUP | Business Partner Grouping | BU_GROUP | TB001 | CHAR | 4 | 0 | ||||||||
| BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | 0 | |||||||||
| BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | 0 | |||||||||
| BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | 0 | |||||||||
| SOURCE | Data Origin Types | BU_SOURCE | TB005 | CHAR | 4 | 0 | ||||||||
| TITLE | Form-of-Address Key | AD_TITLE | TSAD3 | CHAR | 4 | 0 | ||||||||
| XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | 0 |
Possible values
|
||||||||
| XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | 0 |
Possible values
|
||||||||
| AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | 0 | |||||||||
| TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | 0 | |||||||||
| BU_LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||||||||
| CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | 0 |
Possible values
|
||||||||
| NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | 0 |
Possible values
|
||||||||
| NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | 0 |
Possible values
|
||||||||
| PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | 0 |
Possible values
|
||||||||
| BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||||||||
| NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | 0 |
Possible values
|
||||||||
| BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | 0 |
Possible values
|
||||||||
| RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | DPR_RATES | CHAR | 15 | 0 | ||||||||
| NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | 0 | |||||||||
| NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | 0 | |||||||||
| NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | 0 | |||||||||
| NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | 0 | |||||||||
| LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | TB019 | CHAR | 2 | 0 | ||||||||
| IND_SECTOR | Industry sector | BU_INDSECT | TB023 | CHAR | 10 | 0 | ||||||||
| LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | TB032 | CHAR | 2 | 0 | ||||||||
| FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | 0 | |||||||||
| LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | 0 | |||||||||
| LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | 0 | |||||||||
| LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | 0 | |||||||||
| LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | 0 | |||||||||
| NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | 0 | |||||||||
| NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | 0 | |||||||||
| NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | 0 | |||||||||
| NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | 0 | |||||||||
| NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | 0 | |||||||||
| TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | TSAD2 | CHAR | 4 | 0 | ||||||||
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | TSAD2 | CHAR | 4 | 0 | ||||||||
| TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | TSAD5 | CHAR | 4 | 0 | ||||||||
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | TSAD4 | CHAR | 4 | 0 | ||||||||
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | TSAD4 | CHAR | 4 | 0 | ||||||||
| NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | 0 | |||||||||
| NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | 0 | |||||||||
| INITIALS | "Middle Initial" or personal initials | AD_INITS | CHAR | 10 | 0 | |||||||||
| NAMEFORMAT | Name format | AD_FORMAT | T005N | CHAR | 2 | 0 | ||||||||
| NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | T005 | CHAR | 3 | 0 | ||||||||
| LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | T002 | LANG | 1 | 0 | ||||||||
| XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | 0 |
Possible values
|
||||||||
| XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | 0 |
Possible values
|
||||||||
| BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | 0 | |||||||||
| MARST | Marital Status of Business Partner | BU_MARST | TB027 | CHAR | 1 | 0 | ||||||||
| EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | 0 | |||||||||
| JOBGR | Occupation/group | BU_JOBGR | TB028 | CHAR | 4 | 0 | ||||||||
| NATIO | Nationality | BU_NATIO | T005 | CHAR | 3 | 0 | ||||||||
| CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | 0 | |||||||||
| CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | T005 | CHAR | 3 | 0 | ||||||||
| PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | 0 | |||||||||
| XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | 0 |
Possible values
|
||||||||
| XUBNAME | Obsolete Field | BU_XUBNAME | USR02 | CHAR | 12 | 0 | ||||||||
| BU_LANGU | Business partner: Language | BU_LANGU | T002 | LANG | 1 | 0 | ||||||||
| BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | 0 | |||||||||
| DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | 0 | |||||||||
| PERNO | Personnel Number | BU_PERNO | NUMC | 8 | 0 | |||||||||
| CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | 0 | |||||||||
| MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | 0 | |||||||||
| PARTGRPTYP | Group type | BU_GRPTYP | TB025 | CHAR | 4 | 0 | ||||||||
| NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | 0 | |||||||||
| NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | 0 | |||||||||
EWASWDOC_WORKAREA_BP_DP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EWASWDOC_WORKAREA_BP_DP | BPKIND | SYST | MANDT | TB004 | BP types | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | BPKIND | EWASWDOC_WORKAREA_BP_DP | BPKIND | TB004 | BP types | BPKIND |
| EWASWDOC_WORKAREA_BP_DP | BU_GROUP | BUT000 | CLIENT | TB001 | BP groupings | MANDT |
| EWASWDOC_WORKAREA_BP_DP | BU_GROUP | EWASWDOC_WORKAREA_BP_DP | BU_GROUP | TB001 | BP groupings | BU_GROUP |
| EWASWDOC_WORKAREA_BP_DP | BU_LANGU | EWASWDOC_WORKAREA_BP_DP | BU_LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| EWASWDOC_WORKAREA_BP_DP | BU_LOGSYS | EWASWDOC_WORKAREA_BP_DP | BU_LOGSYS | TBDLS | Logical system | LOGSYS |
| EWASWDOC_WORKAREA_BP_DP | CNDSC | SYST | MANDT | T005 | Countries | MANDT |
| EWASWDOC_WORKAREA_BP_DP | CNDSC | EWASWDOC_WORKAREA_BP_DP | CNDSC | T005 | Countries | LAND1 |
| EWASWDOC_WORKAREA_BP_DP | IND_SECTOR | SYST | MANDT | TB023 | BP industries (Obsolete ==> TB038A) | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | IND_SECTOR | EWASWDOC_WORKAREA_BP_DP | IND_SECTOR | TB023 | BP industries (Obsolete ==> TB038A) | IND_SECTOR |
| EWASWDOC_WORKAREA_BP_DP | JOBGR | SYST | MANDT | TB028 | Occupations | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | JOBGR | EWASWDOC_WORKAREA_BP_DP | JOBGR | TB028 | Occupations | JOBGR |
| EWASWDOC_WORKAREA_BP_DP | LANGU_CORR | EWASWDOC_WORKAREA_BP_DP | LANGU_CORR | T002 | Language Keys (Component BC-I18) | SPRAS |
| EWASWDOC_WORKAREA_BP_DP | LEGAL_ENTY | SY | MANDT | TB019 | BP legal forms | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | LEGAL_ENTY | EWASWDOC_WORKAREA_BP_DP | LEGAL_ENTY | TB019 | BP legal forms | LEGAL_ENTY |
| EWASWDOC_WORKAREA_BP_DP | LEGAL_ORG | SYST | MANDT | TB032 | BP Legal Entity | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | LEGAL_ORG | EWASWDOC_WORKAREA_BP_DP | LEGAL_ORG | TB032 | BP Legal Entity | LEGAL_ORG |
| EWASWDOC_WORKAREA_BP_DP | MANDT | EWASWDOC_WORKAREA_BP_DP | MANDT | T000 | Clients | MANDT |
| EWASWDOC_WORKAREA_BP_DP | MARST | SYST | MANDT | TB027 | BP marital status | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | MARST | EWASWDOC_WORKAREA_BP_DP | MARST | TB027 | BP marital status | MARST |
| EWASWDOC_WORKAREA_BP_DP | NAMCOUNTRY | EWASWDOC_WORKAREA_BP_DP | NAMCOUNTRY | T005 | Countries | LAND1 |
| EWASWDOC_WORKAREA_BP_DP | NAMCOUNTRY | SYST | MANDT | T005 | Countries | MANDT |
| EWASWDOC_WORKAREA_BP_DP | NAMEFORMAT | SYST | MANDT | T005N | Name formats | MANDT |
| EWASWDOC_WORKAREA_BP_DP | NAMEFORMAT | EWASWDOC_WORKAREA_BP_DP | NAMCOUNTRY | T005N | Name formats | LAND1 |
| EWASWDOC_WORKAREA_BP_DP | NAMEFORMAT | EWASWDOC_WORKAREA_BP_DP | NAMEFORMAT | T005N | Name formats | NAMEFORMAT |
| EWASWDOC_WORKAREA_BP_DP | NATIO | * | T005 | Countries | MANDT | |
| EWASWDOC_WORKAREA_BP_DP | NATIO | EWASWDOC_WORKAREA_BP_DP | NATIO | T005 | Countries | LAND1 |
| EWASWDOC_WORKAREA_BP_DP | PARTGRPTYP | SY | MANDT | TB025 | BP group types | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | PARTGRPTYP | EWASWDOC_WORKAREA_BP_DP | PARTGRPTYP | TB025 | BP group types | PARTGRPTYP |
| EWASWDOC_WORKAREA_BP_DP | PARTNER | EWASWDOC_WORKAREA_BP_DP | MANDT | BUT000 | BP: General data I | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | PARTNER | EWASWDOC_WORKAREA_BP_DP | PARTNER | BUT000 | BP: General data I | PARTNER |
| EWASWDOC_WORKAREA_BP_DP | PREFIX1 | EWASWDOC_WORKAREA_BP_DP | PREFIX1 | TSAD4 | Name Prefixes (Business Address Services) | PREFIX_KEY |
| EWASWDOC_WORKAREA_BP_DP | PREFIX1 | * | TSAD4 | Name Prefixes (Business Address Services) | CLIENT | |
| EWASWDOC_WORKAREA_BP_DP | PREFIX2 | * | TSAD4 | Name Prefixes (Business Address Services) | CLIENT | |
| EWASWDOC_WORKAREA_BP_DP | PREFIX2 | EWASWDOC_WORKAREA_BP_DP | PREFIX2 | TSAD4 | Name Prefixes (Business Address Services) | PREFIX_KEY |
| EWASWDOC_WORKAREA_BP_DP | RATE | SYST | MANDT | DPR_RATES | Customizing: Cost/Revenue Rates for Project Roles | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | RATE | EWASWDOC_WORKAREA_BP_DP | RATE | DPR_RATES | Customizing: Cost/Revenue Rates for Project Roles | RATE |
| EWASWDOC_WORKAREA_BP_DP | SOURCE | EWASWDOC_WORKAREA_BP_DP | SOURCE | TB005 | BP data sources | SOURCE |
| EWASWDOC_WORKAREA_BP_DP | SOURCE | SY | MANDT | TB005 | BP data sources | CLIENT |
| EWASWDOC_WORKAREA_BP_DP | TITLE | * | TSAD3 | Forms of Address (Key) (Business Address Services) | CLIENT | |
| EWASWDOC_WORKAREA_BP_DP | TITLE | EWASWDOC_WORKAREA_BP_DP | TITLE | TSAD3 | Forms of Address (Key) (Business Address Services) | TITLE |
| EWASWDOC_WORKAREA_BP_DP | TITLE_ACA1 | * | TSAD2 | Academic Title (Business Address Services) | CLIENT | |
| EWASWDOC_WORKAREA_BP_DP | TITLE_ACA1 | EWASWDOC_WORKAREA_BP_DP | TITLE_ACA1 | TSAD2 | Academic Title (Business Address Services) | TITLE_KEY |
| EWASWDOC_WORKAREA_BP_DP | TITLE_ACA2 | * | TSAD2 | Academic Title (Business Address Services) | CLIENT | |
| EWASWDOC_WORKAREA_BP_DP | TITLE_ACA2 | EWASWDOC_WORKAREA_BP_DP | TITLE_ACA2 | TSAD2 | Academic Title (Business Address Services) | TITLE_KEY |
| EWASWDOC_WORKAREA_BP_DP | TITLE_ROYL | * | TSAD5 | Name Suffixes/Title (Key) (Business Address Services) | CLIENT | |
| EWASWDOC_WORKAREA_BP_DP | TITLE_ROYL | EWASWDOC_WORKAREA_BP_DP | TITLE_ROYL | TSAD5 | Name Suffixes/Title (Key) (Business Address Services) | TITLE_KEY |
| EWASWDOC_WORKAREA_BP_DP | WORKAREA | EWASWDOC_WORKAREA_BP_DP | MANDT | EWA_WDOC_WAREA | Waste Disposal Order Cockpit: Work Area | MANDT |
| EWASWDOC_WORKAREA_BP_DP | WORKAREA | EWASWDOC_WORKAREA_BP_DP | WORKAREA | EWA_WDOC_WAREA | Waste Disposal Order Cockpit: Work Area | WORKAREA |
| EWASWDOC_WORKAREA_BP_DP | XUBNAME | EWASWDOC_WORKAREA_BP_DP | XUBNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| EWASWDOC_WORKAREA_BP_DP | XUBNAME | * | USR02 | Logon Data (Kernel-Side Use) | MANDT | |
