I_SUPDMNDALLDOCSTOITM

CDS View
30 Fields 5 CDS Views

View for Stock Transport Order Item

I_SUPDMNDALLDOCSTOITM is a CDS View in S/4HANA. View for Stock Transport Order Item. It contains 30 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_SupDmndAllDocDemand view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocDmndAmt view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocSTO view from COMPOSITE View for Stock Transport Order
I_SupDmndAllDocSTOAssgC view inner COMPOSITE Cube View for Stock Transport Order Assignment Details
I_SupDmndAllDocSTOCube view from COMPOSITE Cube View for Stock Transport Order Details

Fields (30)

KeyField CDS FieldsUsed in Views
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY RequestedDate RequestedDate 3
KEY RequirementDocumentItem RequirementDocumentItem 3
KEY RequirementDocumentNumber RequirementDocumentNumber 3
KEY RequirementType RequirementType 3
BaseUnit BaseUnit 3
CompanyCode CompanyCode 1
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentCurrency DocumentCurrency 2
Material Material 3
MaterialGroup MaterialGroup 3
NetPriceAmount NetPriceAmount 2
OrderType OrderType 1
Plant Plant 3
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurgReleaseSequenceStatus PurgReleaseSequenceStatus 1
RequestedDeliveryDate RequestedDeliveryDate 3
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit 1
RequirementSegment RequirementSegment 1
SalesDistrict SalesDistrict 1
SalesOrganization SalesOrganization 1
SegmentationStrategy SegmentationStrategy 1
SegmentationStrategyScope SegmentationStrategyScope 1
SoldToParty SoldToParty 1
StorageLocation StorageLocation 3

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.

-- View for Stock Transport Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCSTOITM (
    PRODUCTAVAILABILITYDATE,
    REQUESTEDDATE,
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTTYPE,
    BASEUNIT,
    COMPANYCODE,
    CONFIRMEDRQMTQTYINBASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    DELIVEREDQUANTITYINBASEUNIT,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    NETPRICEAMOUNT,
    ORDERTYPE,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGRELEASESEQUENCESTATUS,
    REQUESTEDDELIVERYDATE,
    REQUESTEDRQMTQTYINBASEUNIT,
    REQUIREMENTSEGMENT,
    SALESDISTRICT,
    SALESORGANIZATION,
    SEGMENTATIONSTRATEGY,
    SEGMENTATIONSTRATEGYSCOPE,
    SOLDTOPARTY,
    STORAGELOCATION,
    PRIMARY KEY (PRODUCTAVAILABILITYDATE, REQUESTEDDATE, REQUIREMENTDOCUMENTITEM, REQUIREMENTDOCUMENTNUMBER, REQUIREMENTTYPE)
);

Learn More