I_SUPDMNDALLDOCASSGMT

CDS View
40 Fields 3 CDS Views

View for Assignment for all Modes

I_SUPDMNDALLDOCASSGMT is a CDS View in S/4HANA. View for Assignment for all Modes. It contains 40 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ARunAnlytsAllAssgmtCube view from COMPOSITE Demand and Assignments - Cube
I_ARunAnlytsSupAssgmtCube view from COMPOSITE Assignment Results - Cube
I_SupDmndAllDocAssgmtCube view from COMPOSITE Cube View for Assignment for all Modes

Fields (40)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 3
KEY Batch Batch 3
KEY Material Material,Product 3
KEY Plant Plant 3
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY RequestedDate RequestedDate 3
KEY RequirementDocumentItem RequirementDocumentItem 3
KEY RequirementDocumentNumber RequirementDocumentNumber 3
KEY RequirementType RequirementType 3
KEY StorageLocation StorageLocation 3
KEY SupplyAssignmentStatus SupplyAssignmentStatus 1
KEY SupplyDeliveryDate SupplyDeliveryDate 3
KEY SupplyItem SupplyItem 3
KEY SupplyNumber SupplyNumber 3
KEY SupplyScheduleLine SupplyScheduleLine 3
KEY SupProtTimeBucketUUID SupProtTimeBucketUUID 3
ARunTmpAssignedQuantityInBsUnt ARunTmpAssignedQuantityInBsUnt 3
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 3
BaseUnit BaseUnit 3
CalendarDay CalendarDay 3
CalendarMonth CalendarMonth 3
CalendarMonthName CalendarMonthName 3
CalendarWeek CalendarWeek 3
CalendarYear CalendarYear 3
CompanyCode CompanyCode 3
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
Customer Customer 3
DistributionChannel DistributionChannel 3
Division Division 3
DocumentCurrency DocumentCurrency 3
MaterialGroup MaterialGroup,ProductGroup 3
MaterialType MaterialType,ProductType 3
NetPriceAmount NetPriceAmount 3
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 3
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 3
RequestedDeliveryDate RequestedDeliveryDate 3
RequirementSegment RequirementSegment 2
SalesDistrict SalesDistrict 3
SalesOrganization SalesOrganization 3
SupplyProtectionName SupplyProtectionName 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 Assignment for all Modes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCASSGMT (
    ASSIGNEDSUPPLYTYPE,
    BATCH,
    MATERIAL,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    REQUESTEDDATE,
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTTYPE,
    STORAGELOCATION,
    SUPPLYASSIGNMENTSTATUS,
    SUPPLYDELIVERYDATE,
    SUPPLYITEM,
    SUPPLYNUMBER,
    SUPPLYSCHEDULELINE,
    SUPPROTTIMEBUCKETUUID,
    ARUNTMPASSIGNEDQUANTITYINBSUNT,
    ASSIGNEDQUANTITYINBASEUNIT,
    BASEUNIT,
    CALENDARDAY,
    CALENDARMONTH,
    CALENDARMONTHNAME,
    CALENDARWEEK,
    CALENDARYEAR,
    COMPANYCODE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    MATERIALGROUP,
    MATERIALTYPE,
    NETPRICEAMOUNT,
    NORMALASSIGNEDQUANTITYINBSUNT,
    PREVIEWASSIGNEDQUANTITYINBSUNT,
    REQUESTEDDELIVERYDATE,
    REQUIREMENTSEGMENT,
    SALESDISTRICT,
    SALESORGANIZATION,
    SUPPLYPROTECTIONNAME,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, BATCH, MATERIAL, PLANT, PRODUCTAVAILABILITYDATE, REQUESTEDDATE, REQUIREMENTDOCUMENTITEM, REQUIREMENTDOCUMENTNUMBER, REQUIREMENTTYPE, STORAGELOCATION, SUPPLYASSIGNMENTSTATUS, SUPPLYDELIVERYDATE, SUPPLYITEM, SUPPLYNUMBER, SUPPLYSCHEDULELINE, SUPPROTTIMEBUCKETUUID)
);

Learn More