/1MD/MD______07O SAP (BP At/Rel BP_HEADER / ASSGN_CUS) Table details
Dictionary Type: Table
Description: BP At/Rel BP_HEADER / ASSGN_CUS
Description: BP At/Rel BP_HEADER / ASSGN_CUS
ABAP Code to SELECT data from /1MD/MD______07O
Related tables to /1MD/MD______07O
Access table /1MD/MD______07O
Related tables to /1MD/MD______07O
Access table /1MD/MD______07O
Table field list including key, data, relationships and ABAP select examples
/1MD/MD______07O is a standard SAP Table which is used to store BP At/Rel BP_HEADER / ASSGN_CUS data and is available within R/3 SAP systems depending on the version and release level.
The /1MD/MD______07O table consists of various fields, each holding specific information or linking keys about BP At/Rel BP_HEADER / ASSGN_CUS data available in SAP. These include USMDKBPBP_HEADER (Technical Key), /1MD/BPASSGNM_ID (Multiple Assignment ID (Number)), USMD_ACTIVE (Active/Inactive Data Record), /1MD/BPAUFSD (Central order block for customer).. 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______07O 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 | |||
| /1MD/BPASSGNM_ID | Multiple Assignment ID (Number) | MDG_BP_ASSIGNMENT_ID | NUMC | 12 | MDG_BP_ASSIGNMENT_ID | ||||
| USMD_ACTIVE | Active/Inactive Data Record | USMD_ACTIVE | CHAR | 1 | USMD_ACTIVE | ||||
| /1MD/BPAUFSD | Central order block for customer | AUFSD_X | CHAR | 2 | Assigned to domain | KAUFS | |||
| /1MD/BPBEGRU | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
| /1MD/BPBROBJ | Authorization object | BROBJ | CHAR | 10 | Assigned to domain | XUOBJECT | |||
| /1MD/BPCITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
| /1MD/BPCOUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
| /1MD/BPCOUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| /1MD/BPCUS_LANGU | Language Key (Technical) | SPRAST | CHAR | 1 | Assigned to domain | ISOLA | SPRAST | SPR | STRALAN_LANGUAGE_TECHNICAL |
| /1MD/BPDTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
| /1MD/BPLAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| /1MD/BPPYMT_METH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
| /1MD/BPREGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
| USMD_O_BP_CUSGEN | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
| /1MD/BPBAHNE | Express train station | BAHNE | CHAR | 25 | BAHNH | ||||
| /1MD/BPBRAN1 | Industry Code 1 | BRAN1_D | CHAR | 10 | Assigned to domain | BRACO | |||
| /1MD/BPBRAN2 | Industry code 2 | BRAN2 | CHAR | 10 | Assigned to domain | BRACO | |||
| /1MD/BPBRAN3 | Industry code 3 | BRAN3 | CHAR | 10 | Assigned to domain | BRACO | |||
| /1MD/BPBRAN4 | Industry code 4 | BRAN4 | CHAR | 10 | Assigned to domain | BRACO | |||
| /1MD/BPBRAN5 | Industry code 5 | BRAN5 | CHAR | 10 | Assigned to domain | BRACO | |||
| /1MD/BPCASSD | Central sales block for customer | CASSD_X | CHAR | 2 | CASSP | ||||
| /1MD/BPCCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1 | XFELD | ||||
| /1MD/BPCCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1 | XFELD | ||||
| /1MD/BPCCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1 | XFELD | ||||
| /1MD/BPCCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1 | XFELD | ||||
| /1MD/BPCFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | ALPHA | J_1BINDUS1 | |||
| /1MD/BPCIVVE | ID for mainly non-military use | CIVVE | CHAR | 1 | XFELD | ||||
| /1MD/BPCUS_BAHNS | Train station | BAHNS | CHAR | 25 | BAHNH | ||||
| /1MD/BPCUS_DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
| /1MD/BPCUS_FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
| /1MD/BPCUS_KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
| /1MD/BPCUS_LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
| /1MD/BPCUS_NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | XFELD | ||||
| /1MD/BPCUS_SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
| /1MD/BPCUS_STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
| /1MD/BPCUS_STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
| /1MD/BPCUS_VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
| /1MD/BPCUS_XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1 | XFELD | ||||
| /1MD/BPFAKSD | Central billing block for customer | FAKSD_X | CHAR | 2 | Assigned to domain | FAKSP | |||
| /1MD/BPFITYP | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
| /1MD/BPJMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4 | JAHR | ||||
| /1MD/BPJMZAH | Yearly number of employees | JMZAH | NUMC | 6 | JMZAH | ||||
| /1MD/BPJ_1KFREPR | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
| /1MD/BPJ_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | Assigned to domain | GESTYP | |||
| /1MD/BPJ_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | Assigned to domain | INDTYP | |||
| /1MD/BPKATR1 | Attribute 1 | KATR1 | CHAR | 2 | Assigned to domain | ATTR1 | |||
| /1MD/BPKATR10 | Attribute 10 | KATR10 | CHAR | 3 | Assigned to domain | ATTR10 | |||
| /1MD/BPKATR2 | Attribute - 2 | KATR2 | CHAR | 2 | Assigned to domain | ATTR2 | |||
| /1MD/BPKATR3 | Attribute 3 | KATR3 | CHAR | 2 | Assigned to domain | ATTR3 | |||
| /1MD/BPKATR4 | Attribute 4 | KATR4 | CHAR | 2 | Assigned to domain | ATTR4 | |||
| /1MD/BPKATR5 | Attribute 5 | KATR5 | CHAR | 2 | Assigned to domain | ATTR5 | |||
| /1MD/BPKATR6 | Attribute 6 | KATR6 | CHAR | 3 | Assigned to domain | ATTR6 | |||
| /1MD/BPKATR7 | Attribute 7 | KATR7 | CHAR | 3 | Assigned to domain | ATTR7 | |||
| /1MD/BPKATR8 | Attribute 8 | KATR8 | CHAR | 3 | Assigned to domain | ATTR8 | |||
| /1MD/BPKATR9 | Attribute 9 | KATR9 | CHAR | 3 | Assigned to domain | ATTR9 | |||
| /1MD/BPKDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | Assigned to domain | KDKGR | |||
| /1MD/BPKDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | Assigned to domain | KDKGR | |||
| /1MD/BPKDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | Assigned to domain | KDKGR | |||
| /1MD/BPKDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | Assigned to domain | KDKGR | |||
| /1MD/BPKDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | Assigned to domain | KDKGR | |||
| /1MD/BPKNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
| /1MD/BPKTOKD | Customer Account Group | KTOKD | CHAR | 4 | Assigned to domain | KTOKD | KGD | ||
| /1MD/BPKUKLA | Customer classification | KUKLA | CHAR | 2 | Assigned to domain | KUKLA | |||
| /1MD/BPKUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
| /1MD/BPLIFSD | Central delivery block for the customer | LIFSD_X | CHAR | 2 | Assigned to domain | LIFSP | |||
| /1MD/BPLOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
| /1MD/BPMILVE | ID for mainly military use | MILVE | CHAR | 1 | XFELD | ||||
| /1MD/BPNIELS | Nielsen ID | NIELS | CHAR | 2 | Assigned to domain | NIELS | |||
| /1MD/BPPERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
| /1MD/BPUMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4 | JAHR | ||||
| /1MD/BPUMSA1 | Annual sales | UMSA1 | CURR | 15(2) | UMSA1 | ||||
| /1MD/BPUWAER | Currency of sales figure | UWAER | CUKY | 5 | Assigned to domain | WAERS | |||
| /1MD/BPXICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1 | XFELD | ||||
| /1MD/BPXSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3 | Assigned to domain | J_1BTCST1 | |||
| /1MD/BPXXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table /1MD/MD______07O using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1MD/MD______07O to SELECT all data from the tableDATA: WA_/1MD/MD______07O TYPE /1MD/MD______07O.
SELECT SINGLE *
FROM /1MD/MD______07O
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______07O
WHERE...
How to access SAP table /1MD/MD______07O
Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______07O 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