PREQITEM

12 Fields

PREQITEM is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
BaseUnit PurchaseRequisitionUnit 1
DeliveryDate DeliveryDate 1
FixedSupplier FixedSupplier 1
Material Material 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
MRPController MRPController 1
Plant MRPPlant 1
PurchaseRequisitionReleaseDate PurchaseRequisitionReleaseDate 1
PurchasingDocumentItemCategory MaterialProcurementCategory 1
PurReqnReceivingCustomer Customer 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 PREQITEM (
    BASEUNIT,
    DELIVERYDATE,
    FIXEDSUPPLIER,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALPLANNEDDELIVERYDURN,
    MRPCONTROLLER,
    PLANT,
    PURCHASEREQUISITIONRELEASEDATE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURREQNRECEIVINGCUSTOMER,
    REQUESTEDQUANTITY
);

Learn More