I_SUPDMNDALLDOCRETSLSORD

CDS View
31 Fields 4 CDS Views

View for Return Sales Orders

I_SUPDMNDALLDOCRETSLSORD is a CDS View in S/4HANA. View for Return Sales Orders. It contains 31 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocRetSlsOrdAssgC view left_outer COMPOSITE Cube View for Return Sales Orders Assignment Details
I_SupDmndAllDocRetSlsOrdC view from COMPOSITE Cube View for Return Sales Orders Details
I_SupDmndAllDocSupAmt view union_all COMPOSITE View for Supply of All Documents
P_SupDmndAllDocRetSlsOrdAssgmt view from COMPOSITE

Fields (31)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 3
KEY Batch Batch 3
KEY Material Material 3
KEY Plant Plant 3
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY StorageLocation StorageLocation 3
KEY SupplyItem SupplyItem 3
KEY SupplyNumber SupplyNumber 3
KEY SupplyScheduleLine SupplyScheduleLine 3
BaseUnit BaseUnit 3
CompanyCode CompanyCode 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
Customer Customer 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentCurrency DocumentCurrency 3
MaterialGroup MaterialGroup 3
MaterialType MaterialType 1
NetPriceAmount NetPriceAmount 3
OrderType OrderType 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 1
RequestedDeliveryDate RequestedDeliveryDate 3
SalesDistrict SalesDistrict 1
SalesDocumentRjcnReason SalesDocumentRjcnReason 2
SalesOrganization SalesOrganization 1
SDDocumentReason SDDocumentReason 2
StockSegment StockSegment 2
SupAssgmtSource SupAssgmtSource 3
SupplyDeliveryDate SupplyDeliveryDate 1
TotalQuantity TotalQuantity 2

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 Return Sales Orders
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCRETSLSORD (
    ASSIGNEDSUPPLYTYPE,
    BATCH,
    MATERIAL,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    STORAGELOCATION,
    SUPPLYITEM,
    SUPPLYNUMBER,
    SUPPLYSCHEDULELINE,
    BASEUNIT,
    COMPANYCODE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    MATERIALGROUP,
    MATERIALTYPE,
    NETPRICEAMOUNT,
    ORDERTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REQUESTEDDELIVERYDATE,
    SALESDISTRICT,
    SALESDOCUMENTRJCNREASON,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    STOCKSEGMENT,
    SUPASSGMTSOURCE,
    SUPPLYDELIVERYDATE,
    TOTALQUANTITY,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, BATCH, MATERIAL, PLANT, PRODUCTAVAILABILITYDATE, STORAGELOCATION, SUPPLYITEM, SUPPLYNUMBER, SUPPLYSCHEDULELINE)
);

Learn More