_MNGPROJDMNDSRVCPURREQNORD

_MNGPROJDMNDSRVCPURREQNORD is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
BaseUnit BaseUnit 1
DocumentCurrency DocumentCurrency 1
FormattedPurRequisitionItem FormattedPurRequisitionItem 1
GoodsReceiptAmount GoodsReceiptAmount 1
InvoiceReceiptAmount InvoiceReceiptAmount 1
IsPurOrderAllwdForInbDeliv IsPurOrderAllwdForInbDeliv 1
NetValueAmountInDocCurrency NetValueAmountInDocCurrency 1
OpenQuantity OpenQuantity 1
OrderedQuantity OrderedQuantity 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 1
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 1
StillToBeDeliveredQuantity StillToBeDeliveredQuantity 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 _MNGPROJDMNDSRVCPURREQNORD (
    BASEUNIT,
    DOCUMENTCURRENCY,
    FORMATTEDPURREQUISITIONITEM,
    GOODSRECEIPTAMOUNT,
    INVOICERECEIPTAMOUNT,
    ISPURORDERALLWDFORINBDELIV,
    NETVALUEAMOUNTINDOCCURRENCY,
    OPENQUANTITY,
    ORDEREDQUANTITY,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    SCHEDLINESTSCDELIVERYDATE,
    SCHEDULELINEDELIVERYDATE,
    STILLTOBEDELIVEREDQUANTITY
);