_PURCHASEREQUISITION

_PURCHASEREQUISITION is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition ARunSupplySelRuleAttribVal,PurchaseRequisition 3
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
MaterialGroup MaterialGroup 1
Plant Plant 1
ProcmtHubPurRequisitionType ProcmtHubPurRequisitionType 2
ProcurementHubSourceSystem ProcurementHubSourceSystem 2
PurchaseRequisitionType PurchaseRequisitionType 2
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurReqnDescription PurReqnDescription 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PURCHASEREQUISITION (
    PURCHASEREQUISITION,
    ISENDOFPURPOSEBLOCKED,
    MATERIALGROUP,
    PLANT,
    PROCMTHUBPURREQUISITIONTYPE,
    PROCUREMENTHUBSOURCESYSTEM,
    PURCHASEREQUISITIONTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURREQNDESCRIPTION,
    PRIMARY KEY (PURCHASEREQUISITION)
);