_PURCHASEREQITEM

13 Fields

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

Fields (13)

KeyField CDS FieldsUsed in Views
BaseUnit BaseUnit 1
DeliveryDate DeliveryDate 1
FixedSupplier Supplier 1
Material Material 1
MaterialGroup MaterialGroup 1
OrderedQuantity OrderedQuantity 1
PurchaseRequisitionItemText PurchaseRequisitionItemText 1
PurchaseRequisitionPrice PurchaseRequisitionPrice 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurReqnItemCurrency PurReqnItemCurrency 1
ReleaseCode ReleaseCode 1
RequestedQuantity RequestedQuantity 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 _PURCHASEREQITEM (
    BASEUNIT,
    DELIVERYDATE,
    FIXEDSUPPLIER,
    MATERIAL,
    MATERIALGROUP,
    ORDEREDQUANTITY,
    PURCHASEREQUISITIONITEMTEXT,
    PURCHASEREQUISITIONPRICE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURREQNITEMCURRENCY,
    RELEASECODE,
    REQUESTEDQUANTITY
);

Learn More