/1MD/MD______078 SAP (BP At/Rel BP_HEADER / HAS_CENTR) Table details
Dictionary Type: Table
Description: BP At/Rel BP_HEADER / HAS_CENTR
Description: BP At/Rel BP_HEADER / HAS_CENTR
ABAP Code to SELECT data from /1MD/MD______078
Related tables to /1MD/MD______078
Access table /1MD/MD______078
Related tables to /1MD/MD______078
Access table /1MD/MD______078
Table field list including key, data, relationships and ABAP select examples
/1MD/MD______078 is a standard SAP Table which is used to store BP At/Rel BP_HEADER / HAS_CENTR data and is available within R/3 SAP systems depending on the version and release level.
The /1MD/MD______078 table consists of various fields, each holding specific information or linking keys about BP At/Rel BP_HEADER / HAS_CENTR data available in SAP. These include USMDKBPBP_HEADER (Technical Key), USMD_ACTIVE (Active/Inactive Data Record), /1MD/BPREF_CEN (Authorization Group), /1MD/BPOBJHASBP (Authorization Group Object).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP /1MD/MD______078 table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
USMDKBPBP_HEADER | Technical Key | USMD_TECH_KEY | INT4 | 10 | /1MD/MD______0B4 | INT4 | |||
USMD_ACTIVE | Active/Inactive Data Record | USMD_ACTIVE | CHAR | 1 | USMD_ACTIVE | ||||
/1MD/BPREF_CEN | Authorization Group | BU_AUGRP | CHAR | 4 | Assigned to domain | BU_AUGRP | |||
/1MD/BPOBJHASBP | Authorization Group Object | BU_AUOBJ | CHAR | 10 | Assigned to domain | BU_AUOBJ | |||
/1MD/BPREF_CENTR | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
/1MD/BPREFCENTRL | Name format | AD_FORMAT | CHAR | 2 | Assigned to domain | AD_NAMFORM | |||
USMD_O_BP_CENTRL | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
/1MD/BPBIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
/1MD/BPBIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
/1MD/BPBPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
/1MD/BPBPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | Assigned to domain | BU_KIND | |||
/1MD/BPBU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
/1MD/BPBU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
/1MD/BPBU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
/1MD/BPCNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | Assigned to domain | LAND1 | |||
/1MD/BPCONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
/1MD/BPDEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
/1MD/BPEMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
/1MD/BPFOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
/1MD/BPGENDER | Sex of business partner (person) | BU_SEXID | CHAR | 1 | BU_SEXID | ||||
/1MD/BPINITIALSB | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
/1MD/BPJOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | Assigned to domain | BU_JOBGR | |||
/1MD/BPLEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | Assigned to domain | BU_LEGAL_ORG | |||
/1MD/BPLGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | Assigned to domain | BU_LEGENTY | H_TB019 | ||
/1MD/BPLNGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
/1MD/BPLOCATION1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
/1MD/BPLOCATION2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
/1MD/BPLOCATION3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
/1MD/BPLQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
/1MD/BPMARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | Assigned to domain | BU_MARST | |||
/1MD/BPMCNAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
/1MD/BPMCNAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
/1MD/BPNAME_GRP1 | First Name of Group | BU_GR_NAME1 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_GRP2 | Second Name of Group | BU_GR_NAME2 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_ORG1 | First Name of Organization | BU_ORG_NAME1 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_ORG2 | Second Name of Organization | BU_ORG_NAME2 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_ORG3 | Third Name of Organization | BU_ORG_NAME3 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAME_ORG4 | Fourth Name of Organization | BU_ORG_NAME4 | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAM_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
/1MD/BPNAM_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
/1MD/BPNANMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
/1MD/BPNATIO | Nationality | BU_NATIO | CHAR | 3 | Assigned to domain | LAND1 | |||
/1MD/BPNATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
/1MD/BPNICK_NAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
/1MD/BPNME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
/1MD/BPNTRLEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
/1MD/BPPREFIX1_B | 1st Name Prefix (Key) | BU_AD_PREFIX1 | CHAR | 4 | Assigned to domain | AD_PREFIX | MDG_SH_AD_PREFIX | ||
/1MD/BPPREFIX2_B | 2nd Name Prefix (Key) | BU_AD_PREFIX2 | CHAR | 4 | Assigned to domain | AD_PREFIX | MDG_SH_AD_PREFIX | ||
/1MD/BPPRINT_MOD | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
/1MD/BPPRTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | Assigned to domain | BU_GRPTYP | H_TB025 | ||
/1MD/BPSOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | Assigned to domain | BU_SOURCE | |||
/1MD/BPTITLE_BP | Form-of-Address Key | AD_TITLE | CHAR | 4 | Assigned to domain | AD_TITLE | |||
/1MD/BPTITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
/1MD/BPTTLE_ACA1 | First Academic Title (Key) | BU_AD_TITLE1 | CHAR | 4 | Assigned to domain | AD_TITLE1 | |||
/1MD/BPTTLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | Assigned to domain | AD_TITLE1 | |||
/1MD/BPTTLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | Assigned to domain | AD_TITLES | |||
/1MD/BPXBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
/1MD/BPXDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table /1MD/MD______078 using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1MD/MD______078 to SELECT all data from the tableDATA: WA_/1MD/MD______078 TYPE /1MD/MD______078.
SELECT SINGLE *
FROM /1MD/MD______078
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______078
WHERE...
How to access SAP table /1MD/MD______078
Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______078 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