MMSRCSLIST
Sourcing Supplier List Header
MMSRCSLIST is an SAP database table in S/4HANA. Sourcing Supplier List Header. It contains 20 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SourcingSupplierList | view_entity | from | EXTENSION | Sourcing Supplier List - Extension |
| R_SourcingSupplierList | view | from | BASIC | Supplier List for Sourcing |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | sourcingsupplierlistuuid | vdm_srcgsupplierlistuuid | UUID of Sourcing Supplier List | |||
| sourcingsupplierlist | vdm_supplierlist | Supplier List | ||||
| sourcingsupplierlistname | vdm_srcgsupplierlistname | Name of Sourcing Supplier List | ||||
| srcgsuplrlistlifecyclestatus | vdm_instsllifecyclests | Supplier List Status | ||||
| suplrlistreferenceobjectuuid | vdm_suplrlrefobjectuuid | Ref Object UUID | ||||
| supplierlistreferenceobject | vdm_suplrlrefobject | Reference Object | ||||
| suplrlistreferenceobjecttype | vdm_suplrlrefobjecttype | Ref Obj Type for Sourcing Supplier List | ||||
| sourcesupplierlistuuid | vdm_sourcesuplrlistuuid | Src Suplr List UUID | ||||
| supplierlistupdatetype | vdm_suplrlupdatetype | Update Type | ||||
| srcgsuplrlistchgisinworkflow | vdm_instslchgisinworkflow | Sourcing Suplr List Changed in Workflow | ||||
| srcgsuplrlistapprvlduedatetime | vdm_srcslapprovalduedatetime | Approval Deadline | ||||
| isdeleted | eloek | Del. Indicator | ||||
| isendofpurposeblocked | eopblocked | Busin. Purp. Cmpltd. | ||||
| createdbyuser | vdm_createdbyuserid | Created By | ||||
| creationdatetime | vdm_suplrlistcreatedate | Created On | ||||
| lastchangedbyuser | vdm_lastchangedbyuserid | Changed By | ||||
| lastchangedatetime | changedatetime | Last Changed | ||||
| sourcingsupplierlistversion | vdm_srcgsupplierlistversion | Supplier List Version | ||||
| srcgsuplrlistversionislatest | vdm_srcgsuplrlistversnislatest | Sourcing Supplier List Version Is Latest |
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.
-- Sourcing Supplier List Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCSLIST (
MANDT, -- Client [mandt]
SOURCINGSUPPLIERLISTUUID, -- UUID of Sourcing Supplier List [vdm_srcgsupplierlistuuid]
SOURCINGSUPPLIERLIST, -- Supplier List [vdm_supplierlist]
SOURCINGSUPPLIERLISTNAME, -- Name of Sourcing Supplier List [vdm_srcgsupplierlistname]
SRCGSUPLRLISTLIFECYCLESTATUS, -- Supplier List Status [vdm_instsllifecyclests]
SUPLRLISTREFERENCEOBJECTUUID, -- Ref Object UUID [vdm_suplrlrefobjectuuid]
SUPPLIERLISTREFERENCEOBJECT, -- Reference Object [vdm_suplrlrefobject]
SUPLRLISTREFERENCEOBJECTTYPE, -- Ref Obj Type for Sourcing Supplier List [vdm_suplrlrefobjecttype]
SOURCESUPPLIERLISTUUID, -- Src Suplr List UUID [vdm_sourcesuplrlistuuid]
SUPPLIERLISTUPDATETYPE, -- Update Type [vdm_suplrlupdatetype]
SRCGSUPLRLISTCHGISINWORKFLOW, -- Sourcing Suplr List Changed in Workflow [vdm_instslchgisinworkflow]
SRCGSUPLRLISTAPPRVLDUEDATETIME, -- Approval Deadline [vdm_srcslapprovalduedatetime]
ISDELETED, -- Del. Indicator [eloek]
ISENDOFPURPOSEBLOCKED, -- Busin. Purp. Cmpltd. [eopblocked]
CREATEDBYUSER, -- Created By [vdm_createdbyuserid]
CREATIONDATETIME, -- Created On [vdm_suplrlistcreatedate]
LASTCHANGEDBYUSER, -- Changed By [vdm_lastchangedbyuserid]
LASTCHANGEDATETIME, -- Last Changed [changedatetime]
SOURCINGSUPPLIERLISTVERSION, -- Supplier List Version [vdm_srcgsupplierlistversion]
SRCGSUPLRLISTVERSIONISLATEST, -- Sourcing Supplier List Version Is Latest [vdm_srcgsuplrlistversnislatest]
PRIMARY KEY (MANDT, SOURCINGSUPPLIERLISTUUID)
);
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