MMSRCSLIST2_D
Draft table for entity R_SOURCINGSUPPLIERLISTTP
MMSRCSLIST2_D is an SAP database table in S/4HANA. Draft table for entity R_SOURCINGSUPPLIERLISTTP. It contains 31 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SourcingSupplierListDraft | view_entity | from | EXTENSION | Sourcing Supplier List - Extension |
| R_SourcingSupplierListDraft | view_entity | from | BASIC | Supplier List for Sourcing - Draft |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | sourcingsupplierlistuuid | VDM_SUPPLIERLISTUUID | Supplier List UUID | |||
| sourcingsupplierlist | VDM_SUPPLIERLIST | Supplier List | ||||
| sourcingsupplierlistname | VDM_SUPPLIERLISTNAME | Supplier List Name | ||||
| 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 | ||||
| supplierlistuuid | VDM_SUPPLIERLISTUUID | Supplier List UUID | ||||
| supplierlistname | VDM_SUPPLIERLISTNAME | Supplier List Name | ||||
| sourcingsupplierlistactioncode | VDM_SRCSLUSERACTION | User action in Sourcing Suplr List | ||||
| sourcingsupplierlistversion | VDM_SRCGSUPPLIERLISTVERSION | Supplier List Version | ||||
| srcgsuplrlistversionislatest | VDM_SRCGSUPLRLISTVERSNISLATEST | Sourcing Supplier List Version Is Latest | ||||
| srcgsuplrlistsrcgprojhaserror | VDM_SRCGSUPLRLISTSRCGPRJHSERR | Error Indicator | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Draft - Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Field Changes | ||||
| dummy_srcgsuplrl_incl_eew_ps | CFD_DUMMY | Dummy |
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_SOURCINGSUPPLIERLISTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCSLIST2_D (
MANDT, -- Client [MANDT]
SOURCINGSUPPLIERLISTUUID, -- Supplier List UUID [VDM_SUPPLIERLISTUUID]
SOURCINGSUPPLIERLIST, -- Supplier List [VDM_SUPPLIERLIST]
SOURCINGSUPPLIERLISTNAME, -- Supplier List Name [VDM_SUPPLIERLISTNAME]
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]
SUPPLIERLISTUUID, -- Supplier List UUID [VDM_SUPPLIERLISTUUID]
SUPPLIERLISTNAME, -- Supplier List Name [VDM_SUPPLIERLISTNAME]
SOURCINGSUPPLIERLISTACTIONCODE, -- User action in Sourcing Suplr List [VDM_SRCSLUSERACTION]
SOURCINGSUPPLIERLISTVERSION, -- Supplier List Version [VDM_SRCGSUPPLIERLISTVERSION]
SRCGSUPLRLISTVERSIONISLATEST, -- Sourcing Supplier List Version Is Latest [VDM_SRCGSUPLRLISTVERSNISLATEST]
SRCGSUPLRLISTSRCGPROJHASERROR, -- Error Indicator [VDM_SRCGSUPLRLISTSRCGPRJHSERR]
DRAFTENTITYCREATIONDATETIME, -- Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
DUMMY_SRCGSUPLRL_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
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