MMSUPLRLIST2_D
Draft table for entity R_SUPPLIERLISTTP
MMSUPLRLIST2_D is an SAP database table in S/4HANA. Draft table for entity R_SUPPLIERLISTTP. It contains 19 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SupplierListD | view_entity | from | EXTENSION | Supplier List - Extension |
| R_SupplierListD | view_entity | from | BASIC | Supplier List - Draft |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | supplierlistuuid | vdm_supplierlistuuid | Supplier List UUID | |||
| supplierlist | vdm_supplierlist | Supplier List | ||||
| supplierlistversion | vdm_supplierlistversion | Suplr List Version | ||||
| supplierlisttype | vdm_supplierlisttype | Supplier List Type | ||||
| supplierlistname | vdm_supplierlistname | Supplier List Name | ||||
| suplrlistlifecyclestatus | vdm_suplrlistlfcycsts | SL Lifecycle Status | ||||
| purchaserrespworkagreement | vdm_purchaserresponsible | Purchaser Responsible | ||||
| purchaserresponsibleuser | vdm_purchaserresponsibleuser | Purchaser Resp | ||||
| createdbyuser | vdm_createdbyuserid | Created By | ||||
| creationdatetime | vdm_suplrlistcreatedate | Created On | ||||
| lastchangedbyuser | vdm_lastchangedbyuserid | Changed By | ||||
| lastchangedatetime | changedatetime | Last Changed | ||||
| supplierlistislatest | vdm_suplrlistislatest | Latest Supplier List | ||||
| isdeleted | vdm_suplrlistisdeleted | Is Deleted | ||||
| supplierlistispublic | vdm_suplrlistispublic | Is Public | ||||
| supplierlisthasallcompanycodes | vdm_suplrlhasallcompanycodes | SL Company Codes | ||||
| suplrlisthaspurchasingcategory | vdm_suplrlhaspuc | |||||
| isendofpurposeblocked | eopblocked | Busin. Purp. Cmpltd. |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Draft table for entity R_SUPPLIERLISTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSUPLRLIST2_D (
MANDT, -- Client [mandt]
SUPPLIERLISTUUID, -- Supplier List UUID [vdm_supplierlistuuid]
SUPPLIERLIST, -- Supplier List [vdm_supplierlist]
SUPPLIERLISTVERSION, -- Suplr List Version [vdm_supplierlistversion]
SUPPLIERLISTTYPE, -- Supplier List Type [vdm_supplierlisttype]
SUPPLIERLISTNAME, -- Supplier List Name [vdm_supplierlistname]
SUPLRLISTLIFECYCLESTATUS, -- SL Lifecycle Status [vdm_suplrlistlfcycsts]
PURCHASERRESPWORKAGREEMENT, -- Purchaser Responsible [vdm_purchaserresponsible]
PURCHASERRESPONSIBLEUSER, -- Purchaser Resp [vdm_purchaserresponsibleuser]
CREATEDBYUSER, -- Created By [vdm_createdbyuserid]
CREATIONDATETIME, -- Created On [vdm_suplrlistcreatedate]
LASTCHANGEDBYUSER, -- Changed By [vdm_lastchangedbyuserid]
LASTCHANGEDATETIME, -- Last Changed [changedatetime]
SUPPLIERLISTISLATEST, -- Latest Supplier List [vdm_suplrlistislatest]
ISDELETED, -- Is Deleted [vdm_suplrlistisdeleted]
SUPPLIERLISTISPUBLIC, -- Is Public [vdm_suplrlistispublic]
SUPPLIERLISTHASALLCOMPANYCODES, -- SL Company Codes [vdm_suplrlhasallcompanycodes]
SUPLRLISTHASPURCHASINGCATEGORY, -- vdm_suplrlhaspuc
ISENDOFPURPOSEBLOCKED, -- Busin. Purp. Cmpltd. [eopblocked]
PRIMARY KEY (MANDT, SUPPLIERLISTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA