I_PROCMTHUBPURREQNOPENFORCONF

CDS View
20 Fields 2 CDS Views

External SSP requisitions open for conf

I_PROCMTHUBPURREQNOPENFORCONF is a CDS View in S/4HANA. External SSP requisitions open for conf. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProcmtHubPurReqnPriceCalc view from COMPOSITE Purchase requisition price calculation
I_PurOrdsOpenForConf view union COMPOSITE Union on all PO open for cnf

Fields (20)

KeyField CDS FieldsUsed in Views
KEY ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition 1
KEY ProcmtHubReferencePurOrder ProcmtHubReferencePurOrder 1
ExtCompanyCodeForPurg ExtCompanyCodeForPurg 1
ExtPlantForPurg ExtPlantForPurg 1
LastChangeDateTime LastChangeDateTime 1
PrmtHbRefPurchaseOrderStatus PrmtHbRefPurchaseOrderStatus 1
PrmtHbRefPurOrdItmIsDelivCmplt PrmtHbRefPurOrdItmIsDelivCmplt 1
ProcmtHubCreatedByUser ProcmtHubCreatedByUser 1
ProcmtHubCreationDate ProcmtHubCreationDate 1
ProcmtHubPurchasingGroup ProcmtHubPurchasingGroup 1
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem 1
ProcmtHubReferencePurOrderItm ProcmtHubReferencePurOrderItm 1
ProcmtHubRefPurOrderOpenQty ProcmtHubRefPurOrderOpenQty 1
ProcmtHubRefPurOrdItemMaterial ProcmtHubRefPurOrdItemMaterial 1
ProcmtHubRefPurOrdItemUoM ProcmtHubRefPurOrdItemUoM 1
ProcmtHubRefPurOrdItmIsDeleted ProcmtHubRefPurOrdItmIsDeleted 1
ProcmtHubRefPurOrdSupplier ProcmtHubRefPurOrdSupplier 1
ProcurementHubSourceSystem ProcurementHubSourceSystem 1
PurReqnRequestor PurReqnRequestor 1
SSPAuthorExternalBPIdnNumber SSPAuthorExternalBPIdnNumber 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.

-- External SSP requisitions open for conf
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROCMTHUBPURREQNOPENFORCONF (
    PROCMTHUBPURCHASEREQUISITION,
    PROCMTHUBREFERENCEPURORDER,
    EXTCOMPANYCODEFORPURG,
    EXTPLANTFORPURG,
    LASTCHANGEDATETIME,
    PRMTHBREFPURCHASEORDERSTATUS,
    PRMTHBREFPURORDITMISDELIVCMPLT,
    PROCMTHUBCREATEDBYUSER,
    PROCMTHUBCREATIONDATE,
    PROCMTHUBPURCHASINGGROUP,
    PROCMTHUBPURREQUISITIONITEM,
    PROCMTHUBREFERENCEPURORDERITM,
    PROCMTHUBREFPURORDEROPENQTY,
    PROCMTHUBREFPURORDITEMMATERIAL,
    PROCMTHUBREFPURORDITEMUOM,
    PROCMTHUBREFPURORDITMISDELETED,
    PROCMTHUBREFPURORDSUPPLIER,
    PROCUREMENTHUBSOURCESYSTEM,
    PURREQNREQUESTOR,
    SSPAUTHOREXTERNALBPIDNNUMBER,
    PRIMARY KEY (PROCMTHUBPURCHASEREQUISITION, PROCMTHUBREFERENCEPURORDER)
);

Learn More