I_PURORDSOPENFORCONF

CDS View
16 Fields 2 CDS Views

Union on all PO open for cnf

I_PURORDSOPENFORCONF is a CDS View in S/4HANA. Union on all PO open for cnf. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PurOrdsOpenForConfTP view from TRANSACTIONAL PR items open for confirmation
R_SSPOpenItemGoodsReceiptTP view_entity from TRANSACTIONAL Self Service Procurement GR API

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ProcuringPlant ProcuringPlant 1
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
KEY PurchaseRequisition PurchaseRequisition 2
KEY PurchaseRequisitionItem PurchaseRequisitionItem 2
IsExtPurgScenario IsExtPurgScenario 1
Material Material 1
OpenQuantity OpenQuantity 1
Plant Plant 2
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 2
PurchaseReqnItemUniqueID PurchaseReqnItemUniqueID 1
PurchasingDocumentItemText PurchaseOrderItemText 1
PurReqnSSPAuthor PurReqnSSPAuthor 1
PurReqnSSPRequestor PurReqnSSPRequestor 1
ReferenceDocumentPlant ReferenceDocumentPlant 2
Supplier Supplier 1

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.

-- Union on all PO open for cnf
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURORDSOPENFORCONF (
    PROCURINGPLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    ISEXTPURGSCENARIO,
    MATERIAL,
    OPENQUANTITY,
    PLANT,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASEREQNITEMUNIQUEID,
    PURCHASINGDOCUMENTITEMTEXT,
    PURREQNSSPAUTHOR,
    PURREQNSSPREQUESTOR,
    REFERENCEDOCUMENTPLANT,
    SUPPLIER,
    PRIMARY KEY (PROCURINGPLANT, PURCHASEORDER, PURCHASEORDERITEM, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More