REQUISITIONITEM

13 Fields

REQUISITIONITEM is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition PurchaseRequisition 3
KEY PurchaseRequisitionItem PurchaseRequisitionItem 4
KEY Supplier Supplier 1
BaseUnit BaseUnit 2
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
Material Material 2
MaterialGroup MaterialGroup 4
Plant Plant 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
PurReqnSSPCatalog PurReqnSSPCatalog 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REQUISITIONITEM (
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    SUPPLIER,
    BASEUNIT,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURREQNSSPCATALOG,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, SUPPLIER)
);

Learn More