MMPUR_CQTNFOD_DI
Item Data of Follow-on Document
MMPUR_CQTNFOD_DI is an SAP database table in S/4HANA. Item Data of Follow-on Document. It contains 22 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CntrlQtanFllwOnDocStagingItm | view | from | BASIC | Staging view for creating foll-on doc from Central Quotation |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | cntrlqtanfllwondocdrafthdruuid | /BOBF/UUID | Key | |||
| KEY | cntrlqtanfllwondocdraftitmuuid | /BOBF/UUID | Key | |||
| centralsupplierquotation | EBELN | Purchasing Doc. | ||||
| centralsupplierquotationitem | EBELP | Item | ||||
| procmthubplant | EWERK | Plant | ||||
| procmthubproduct | MATNR | Material | ||||
| procmthubmaterialname | MAKTX | Description | ||||
| procmthubdeliverydate | EEIND | Delivery Date | ||||
| procmthuborderquantity | BSTMG | PO Quantity | ||||
| procmthuborderquantityunit | BSTME | Order Unit | ||||
| procmthubnetpriceamount | BPREI | Net Price | ||||
| procmthubdocumentcurrency | WAERS | Currency | ||||
| procmthubnetpricequantity | EPEIN | Price Unit | ||||
| procmthuborderpriceunit | BBPRM | Order Price Un. | ||||
| procmthubpurchaserequisition | BANFN | Purchase Req. | ||||
| procmthubpurrequisitionitem | BNFPO | Requisn. item | ||||
| sourcingprojectquotation | EBELN | Purchasing Doc. | ||||
| sourcingprojectquotationitem | EBELP | Item | ||||
| sourcingprojectquotationuuid | VDM_SRCGPROJQUOTATIONUUID | Supplier Quotation UUID | ||||
| srcgprojqtnitemuuid | VDM_SRCGPROJQTNITEMUUID | Supplier Quotation Item UUID | ||||
| dummy_ekpo_incl_eew_ps | EKPO_INCL_EEW | Ext. Include |
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.
-- Item Data of Follow-on Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CQTNFOD_DI (
MANDT, -- Client [MANDT]
CNTRLQTANFLLWONDOCDRAFTHDRUUID, -- Key [/BOBF/UUID]
CNTRLQTANFLLWONDOCDRAFTITMUUID, -- Key [/BOBF/UUID]
CENTRALSUPPLIERQUOTATION, -- Purchasing Doc. [EBELN]
CENTRALSUPPLIERQUOTATIONITEM, -- Item [EBELP]
PROCMTHUBPLANT, -- Plant [EWERK]
PROCMTHUBPRODUCT, -- Material [MATNR]
PROCMTHUBMATERIALNAME, -- Description [MAKTX]
PROCMTHUBDELIVERYDATE, -- Delivery Date [EEIND]
PROCMTHUBORDERQUANTITY, -- PO Quantity [BSTMG]
PROCMTHUBORDERQUANTITYUNIT, -- Order Unit [BSTME]
PROCMTHUBNETPRICEAMOUNT, -- Net Price [BPREI]
PROCMTHUBDOCUMENTCURRENCY, -- Currency [WAERS]
PROCMTHUBNETPRICEQUANTITY, -- Price Unit [EPEIN]
PROCMTHUBORDERPRICEUNIT, -- Order Price Un. [BBPRM]
PROCMTHUBPURCHASEREQUISITION, -- Purchase Req. [BANFN]
PROCMTHUBPURREQUISITIONITEM, -- Requisn. item [BNFPO]
SOURCINGPROJECTQUOTATION, -- Purchasing Doc. [EBELN]
SOURCINGPROJECTQUOTATIONITEM, -- Item [EBELP]
SOURCINGPROJECTQUOTATIONUUID, -- Supplier Quotation UUID [VDM_SRCGPROJQUOTATIONUUID]
SRCGPROJQTNITEMUUID, -- Supplier Quotation Item UUID [VDM_SRCGPROJQTNITEMUUID]
DUMMY_EKPO_INCL_EEW_PS, -- Ext. Include [EKPO_INCL_EEW]
PRIMARY KEY (MANDT, CNTRLQTANFLLWONDOCDRAFTHDRUUID, CNTRLQTANFLLWONDOCDRAFTITMUUID)
);
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