I_PURGDOCSCHEDULELINEENHANCED

CDS View

Schedule Line of Purchasing Document – Enhanced

I_PURGDOCSCHEDULELINEENHANCED is a CDS View in S/4HANA. Schedule Line of Purchasing Document – Enhanced. It contains 17 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
P_InspLotPurgDocsScr view inner CONSUMPTION Inspection lot purchasing documents
P_PurchaseOrderEnhanced view from CONSUMPTION Purchase Order from Extented EBAN
P_PurchDocAttributes view from CONSUMPTION Scheduled Purchase Orders
P_PurgDocExclServiceItms view from CONSUMPTION
P_PurgDocumentConvertedValues view from CONSUMPTION
P_PurgDocumentConvertedValues view union_all CONSUMPTION
P_PurOrdSchedFutureExtnd view from CONSUMPTION Sched Future PO from Extnd Anlytc Table
P_PurOrdSchedLineEnhdDocCat view union_all CONSUMPTION Time Variance details for various document categoty
P_QltyNotifPurgDocsScr1 view from CONSUMPTION Supplier Eval by Quality Notification
P_QltyNotifPurgDocsScr1 view union_all CONSUMPTION Supplier Eval by Quality Notification
P_SchedgAgrmtExtnd view from CONSUMPTION Scheduling Agreement with Extended Table

Fields (17)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
CompanyCode CompanyCode 3
DocumentCurrency DocumentCurrency 3
Material Material 3
MaterialGroup MaterialGroup 3
NetAmount NetAmount 3
Plant Plant 3
PurchaseOrderDate PurchaseOrderDate 2
PurchasingDocumentCategory PurchaseOrderCategory,PurchasingDocumentCategory 5
PurchasingDocumentItemCategory PurchaseOrderItemCategory 2
PurchasingDocumentOrderDate PurchasingDocumentOrderDate 1
PurchasingDocumentType PURCHASEORDERTYPE,PurchasingDocumentType 3
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
StorageLocation StorageLocation 1
Supplier Supplier 3

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.

-- Schedule Line of Purchasing Document – Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGDOCSCHEDULELINEENHANCED (
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    PLANT,
    PURCHASEORDERDATE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    STORAGELOCATION,
    SUPPLIER,
    PRIMARY KEY (PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);