_SOURCINGPROJECTITEM

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

Fields (12)

KeyField CDS FieldsUsed in Views
DocumentCurrency DocumentCurrency 2
MATERIAL MATERIAL 1
MaximumRequestedQuantity MaximumRequestedQuantity 3
PLANT PLANT 1
RequestedQuantityUnit RequestedQuantityUnit 7
SrcgProjItemDemandConfCode SrcgProjItemDemandConfCode 4
SRCGPROJITEMDESCRIPTION SRCGPROJITEMDESCRIPTION 1
SrcgProjItemTargetAmount SrcgProjItemTargetAmount 2
SrcgProjItemTotalTargetAmount SrcgProjItemTotalTargetAmount 2
SrcgProjItemUnconfdDemandRsn SrcgProjItemUnconfdDemandRsn 2
SrcgProjItmTgtAmtQuantity SrcgProjItmTgtAmtQuantity 3
SupplierCostBreakdownIsEnabled SupplierCostBreakdownIsEnabled 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 _SOURCINGPROJECTITEM (
    DOCUMENTCURRENCY,
    MATERIAL,
    MAXIMUMREQUESTEDQUANTITY,
    PLANT,
    REQUESTEDQUANTITYUNIT,
    SRCGPROJITEMDEMANDCONFCODE,
    SRCGPROJITEMDESCRIPTION,
    SRCGPROJITEMTARGETAMOUNT,
    SRCGPROJITEMTOTALTARGETAMOUNT,
    SRCGPROJITEMUNCONFDDEMANDRSN,
    SRCGPROJITMTGTAMTQUANTITY,
    SUPPLIERCOSTBREAKDOWNISENABLED
);