/1MD/MD______09Z SAP (BP At/Rel BP_HEADER / SALES_L) Table details
Dictionary Type: Table
Description: BP At/Rel BP_HEADER / SALES_L
Description: BP At/Rel BP_HEADER / SALES_L
ABAP Code to SELECT data from /1MD/MD______09Z
Related tables to /1MD/MD______09Z
Access table /1MD/MD______09Z
Related tables to /1MD/MD______09Z
Access table /1MD/MD______09Z
Table field list including key, data, relationships and ABAP select examples
/1MD/MD______09Z is a standard SAP Table which is used to store BP At/Rel BP_HEADER / SALES_L data and is available within R/3 SAP systems depending on the version and release level.
The /1MD/MD______09Z table consists of various fields, each holding specific information or linking keys about BP At/Rel BP_HEADER / SALES_L data available in SAP. These include USMDKBPBP_HEADER (Technical Key), /1MD/BPSPART (Division), /1MD/BPVKORG (Sales Organization), /1MD/BPVTWEG (Distribution Channel).. 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______09Z 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/BPSPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
| /1MD/BPVKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
| /1MD/BPVTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
| /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/BPCSD_AUFSD | Central order block for customer | AUFSD_X | CHAR | 2 | Assigned to domain | KAUFS | |||
| /1MD/BPCSD_BEGRU | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
| /1MD/BPCSD_BROBJ | Authorization object | BROBJ | CHAR | 10 | Assigned to domain | XUOBJECT | |||
| /1MD/BPCSD_LANGU | Language Key (Technical) | SPRAST | CHAR | 1 | Assigned to domain | ISOLA | SPRAST | SPR | STRALAN_LANGUAGE_TECHNICAL |
| /1MD/BPCSD_MEGRU | Unit of Measure Group | MEGRU | CHAR | 4 | Assigned to domain | MEGRU | |||
| /1MD/BPCSD_MEINS | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| USMD_O_BP_SALES | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
| /1MD/BPANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | ANTLF | ||||
| /1MD/BPAUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
| /1MD/BPAWAHR | Order probability of the item | AWAHR | NUMC | 3 | AWAHR | ||||
| /1MD/BPBOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | XFELD | ||||
| /1MD/BPBZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
| /1MD/BPCHSPL | Batch split allowed | CHSPL | CHAR | 1 | XFELD | ||||
| /1MD/BPCSD_AGREL | Indicator: Relevant for agency business | AGREL | CHAR | 1 | XFELD | ||||
| /1MD/BPCSD_BLIND | Indicator: Doc. index compilation active for purchase orders | BLIND | CHAR | 1 | XFELD | ||||
| /1MD/BPCSD_CASSD | Sales block for customer (sales area) | CASSD_V | CHAR | 2 | CASSP | ||||
| /1MD/BPCSD_EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | CHAR12 | ||||
| /1MD/BPCSD_FAKSD | Billing block for customer (sales and distribution) | FAKSD_V | CHAR | 2 | Assigned to domain | FAKSP | |||
| /1MD/BPCSD_INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
| /1MD/BPCSD_INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
| /1MD/BPCSD_LIFSD | Customer delivery block (sales area) | LIFSD_V | CHAR | 2 | Assigned to domain | LIFSP | |||
| /1MD/BPCSD_LOEVM | Deletion flag for customer (sales level) | LOEVM_V | CHAR | 1 | XFELD | ||||
| /1MD/BPCSD_PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | XFELD | ||||
| /1MD/BPCSD_VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
| /1MD/BPCSD_WAERS | Currency | WAERS_V02D | CUKY | 5 | Assigned to domain | WAERS | |||
| /1MD/BPCSD_ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| /1MD/BPKABSS | Customer payment guarantee procedure | KABSSCH_CM | CHAR | 4 | KABSSCH_CM | ||||
| /1MD/BPKALKS | Pricing procedure assigned to this customer | KALKS | CHAR | 1 | Assigned to domain | KALKS | |||
| /1MD/BPKDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
| /1MD/BPKKBER | Credit control area | KKBER | CHAR | 4 | Assigned to domain | KKBER | KKB | ||
| /1MD/BPKLABC | Customer classification (ABC analysis) | KLABC | CHAR | 2 | KLABC | ||||
| /1MD/BPKONDA | Price group (customer) | KONDA | CHAR | 2 | Assigned to domain | KONDA | VKA | ||
| /1MD/BPKTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | Assigned to domain | KTGRD | |||
| /1MD/BPKURST | Exchange Rate Type | KURST | CHAR | 4 | Assigned to domain | KURST | KUT | ||
| /1MD/BPKVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | Assigned to domain | KVGR1 | |||
| /1MD/BPKVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | Assigned to domain | KVGR2 | |||
| /1MD/BPKVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | Assigned to domain | KVGR3 | |||
| /1MD/BPKVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | Assigned to domain | KVGR4 | |||
| /1MD/BPKVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | Assigned to domain | KVGR5 | |||
| /1MD/BPKZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | XFELD | ||||
| /1MD/BPKZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | KZTLF | ||||
| /1MD/BPLPRIO | Delivery Priority | LPRIO | NUMC | 2 | Assigned to domain | LPRIO | |||
| /1MD/BPMRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
| /1MD/BPPERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | Assigned to domain | WFCID | |||
| /1MD/BPPERRL | Invoice list schedule (calendar identification) | PERRL | CHAR | 2 | Assigned to domain | WFCID | |||
| /1MD/BPPLTYP | Price list type | PLTYP | CHAR | 2 | Assigned to domain | PLTYP | VPL | ||
| /1MD/BPPODKZ | Relevant for POD processing | PODKZ | CHAR | 1 | XFELD | ||||
| /1MD/BPPODTG | Timeframe for Confirmation of POD | PODTG | DEC | 11 | TSTRG | TSTRDURAG | |||
| /1MD/BPPVKSM | Customer procedure for product proposal | PVKSM | CHAR | 2 | Assigned to domain | PVKSM | |||
| /1MD/BPRDOFF | Switch off rounding? | RDOFF | CHAR | 1 | XFELD | ||||
| /1MD/BPUEBTK | Unlimited overdelivery allowed | UEBTK_V | CHAR | 1 | XFELD | ||||
| /1MD/BPUEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
| /1MD/BPUNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
| /1MD/BPVERSG | Customer Statistics Group | STGKU | CHAR | 1 | Assigned to domain | STGKU | |||
| /1MD/BPVKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
| /1MD/BPVKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
| /1MD/BPVSORT | Item proposal | VSORT | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| /1MD/BPVWERK | Delivering Plant (Own or External) | DWERK_EXT | CHAR | 4 | Assigned to domain | WERKS | SH_DWERK_EXTS |
| Key field | Non-key field |
How do I retrieve data from SAP table /1MD/MD______09Z using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1MD/MD______09Z to SELECT all data from the tableDATA: WA_/1MD/MD______09Z TYPE /1MD/MD______09Z.
SELECT SINGLE *
FROM /1MD/MD______09Z
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______09Z
WHERE...
How to access SAP table /1MD/MD______09Z
Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______09Z 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