I_PURGDOCSUPPLIERCONFIRMATION

CDS View

Purchasing Document Confirmation

I_PURGDOCSUPPLIERCONFIRMATION is a CDS View in S/4HANA. Purchasing Document Confirmation. It contains 11 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_PurgDocSuplrConfObj view from CONSUMPTION Supplier Confirmations Object Page
MMIM_Inbound_Delivery_Items view from Help-View for Inbound Delivery Items
P_BUSSOLNORDSLSORDFLWLVL13 view inner CONSUMPTION Solution Order Sales Order Flow Level 13
P_ConfirmationDate view from CONSUMPTION Confirmation Date calculation
P_PurgDocSuplrConfQtyAggrgn view from CONSUMPTION
P_PurgDocSupplierConfCount view from COMPOSITE
P_SchedgAgrmtOrds view left_outer COMPOSITE
P_UniquePOWithSupplierConf view from CONSUMPTION
R_PurOrdSupplierConfirmation view from BASIC Supplier Confirmation for Purchase Order

Fields (11)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument,SubsequentDocument 3
KEY DeliveryDocumentItem DeliveryDocumentItem,SubsequentDocumentItem 2
KEY PurchasingDocument PurchasingDocument 3
KEY PurchasingDocumentItem PurchasingDocumentItem 3
KEY SequentialNmbrOfSuplrConf SequentialNmbrOfSuplrConf 1
Batch Batch 1
ConfirmedQuantity ConfirmedQuantity 1
CreationDate CreationDate 2
DeliveryDate DeliveryDate 1
MRPRelevantQuantity MRPRelevantQuantity 1
SupplierConfirmationCategory SupplierConfirmationCategory 4

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.

-- Purchasing Document Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGDOCSUPPLIERCONFIRMATION (
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    SEQUENTIALNMBROFSUPLRCONF,
    BATCH,
    CONFIRMEDQUANTITY,
    CREATIONDATE,
    DELIVERYDATE,
    MRPRELEVANTQUANTITY,
    SUPPLIERCONFIRMATIONCATEGORY,
    PRIMARY KEY (DELIVERYDOCUMENT, DELIVERYDOCUMENTITEM, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, SEQUENTIALNMBROFSUPLRCONF)
);