MMPURSPAWD_D
Draft table for entity R_SrcgProjAwardingScenarioTP
MMPURSPAWD_D is an SAP database table in S/4HANA. Draft table for entity R_SrcgProjAwardingScenarioTP. It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SrcgProjectAwardingScenarioD | view_entity | from | EXTENSION | SrcgProject AwardingScenario - Extension |
| R_SrcgProjAwardingScenDraft | view_entity | from | BASIC | Awarding Scenario in SrcgProj - Draft |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | srcgprojawardingscenariouuid | mm_pur_spawd_uuid | Awarding Scenario UUID | |||
| srcgprojectawardingscenario | mm_pur_spawd_id | Awarding Scenario | ||||
| srcgprojectawardingscenname | mm_pur_spawd_name | Name | ||||
| srcgprojawardingscenisprfrd | mm_pur_spawd_preferred | Preferred | ||||
| sourcingprojectuuid | vdm_sourcingprojectuuid | Sourcing Project UUID | ||||
| srcgprojlifecyclestatus | vdm_srcgprojectlfcycsts | Status | ||||
| srcgprojawdgscenlifecyclests | mm_pur_spawd_lfcyc_status | Status | ||||
| srcgprojawdgscenapprovalstatus | mm_pur_spawd_approval_sts | Approval Status | ||||
| srcgprojawdgscenawardingstatus | mm_pur_spawd_award_status | Awarding Status | ||||
| srcgprojawdgscenawardingdate | mm_pur_spawd_award_date | Awarded On | ||||
| createdbyuser | vdm_createdbyuserid | Created By | ||||
| creationdatetime | vdm_srcgprojcreationdate | Created On | ||||
| lastchangedbyuser | vdm_lastchangedbyuserid | Changed By | ||||
| lastchangedatetime | vdm_lastchangedon | Last Changed On | ||||
| isattachmentsenabled | abap.char |
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_SrcgProjAwardingScenarioTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPURSPAWD_D (
MANDT, -- Client [mandt]
SRCGPROJAWARDINGSCENARIOUUID, -- Awarding Scenario UUID [mm_pur_spawd_uuid]
SRCGPROJECTAWARDINGSCENARIO, -- Awarding Scenario [mm_pur_spawd_id]
SRCGPROJECTAWARDINGSCENNAME, -- Name [mm_pur_spawd_name]
SRCGPROJAWARDINGSCENISPRFRD, -- Preferred [mm_pur_spawd_preferred]
SOURCINGPROJECTUUID, -- Sourcing Project UUID [vdm_sourcingprojectuuid]
SRCGPROJLIFECYCLESTATUS, -- Status [vdm_srcgprojectlfcycsts]
SRCGPROJAWDGSCENLIFECYCLESTS, -- Status [mm_pur_spawd_lfcyc_status]
SRCGPROJAWDGSCENAPPROVALSTATUS, -- Approval Status [mm_pur_spawd_approval_sts]
SRCGPROJAWDGSCENAWARDINGSTATUS, -- Awarding Status [mm_pur_spawd_award_status]
SRCGPROJAWDGSCENAWARDINGDATE, -- Awarded On [mm_pur_spawd_award_date]
CREATEDBYUSER, -- Created By [vdm_createdbyuserid]
CREATIONDATETIME, -- Created On [vdm_srcgprojcreationdate]
LASTCHANGEDBYUSER, -- Changed By [vdm_lastchangedbyuserid]
LASTCHANGEDATETIME, -- Last Changed On [vdm_lastchangedon]
ISATTACHMENTSENABLED, -- abap.char
PRIMARY KEY (MANDT, SRCGPROJAWARDINGSCENARIOUUID)
);
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