I_SOURCINGPROJECTITEMDEX

CDS View
21 Fields 1 CDS Views

Sourcing Project Item Data Extraction

I_SOURCINGPROJECTITEMDEX is a CDS View in S/4HANA. Sourcing Project Item Data Extraction. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SourcingProjectItemDEX view_entity from CONSUMPTION Sourcing Project Item Data Extraction

Fields (21)

KeyField CDS FieldsUsed in Views
KEY SourcingProjectItemUUID SourcingProjectItemUUID 1
ItemVolumeUnit ItemVolumeUnit 1
ItemWeightUnit ItemWeightUnit 1
Material Material 1
MaterialGroup MaterialGroup 1
MaximumRequestedQuantity MaximumRequestedQuantity 1
ProcurementHubSourceSystem ProcurementHubSourceSystem 1
RequestedDeliveryDate RequestedDeliveryDate 1
RequestedQuantity RequestedQuantity 1
RequestedQuantityUnit RequestedQuantityUnit 1
SourcingProjectItem SourcingProjectItem 1
SourcingProjectItemType SourcingProjectItemType 1
SourcingProjectUUID SourcingProjectUUID 1
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat 1
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType 1
SrcgProjItemClassification SrcgProjItemClassification 1
SrcgProjItemDemandConfCode SrcgProjItemDemandConfCode 1
SrcgProjItemDescription SrcgProjItemDescription 1
SrcgProjItemTargetAmount SrcgProjItemTargetAmount 1
SrcgProjItemTotalTargetAmount SrcgProjItemTotalTargetAmount 1
SrcgProjItmTgtAmtQuantity SrcgProjItmTgtAmtQuantity 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.

-- Sourcing Project Item Data Extraction
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SOURCINGPROJECTITEMDEX (
    SOURCINGPROJECTITEMUUID,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIAL,
    MATERIALGROUP,
    MAXIMUMREQUESTEDQUANTITY,
    PROCUREMENTHUBSOURCESYSTEM,
    REQUESTEDDELIVERYDATE,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    SOURCINGPROJECTITEM,
    SOURCINGPROJECTITEMTYPE,
    SOURCINGPROJECTUUID,
    SRCGPROJFOLLOWONDOCUMENTCAT,
    SRCGPROJFOLLOWONDOCUMENTTYPE,
    SRCGPROJITEMCLASSIFICATION,
    SRCGPROJITEMDEMANDCONFCODE,
    SRCGPROJITEMDESCRIPTION,
    SRCGPROJITEMTARGETAMOUNT,
    SRCGPROJITEMTOTALTARGETAMOUNT,
    SRCGPROJITMTGTAMTQUANTITY,
    PRIMARY KEY (SOURCINGPROJECTITEMUUID)
);

Learn More