I_ARUNNORMAL

CDS View
21 Fields 9 CDS Views

Basic View for Normal Run data

I_ARUNNORMAL is a CDS View in S/4HANA. Basic View for Normal Run data. It contains 21 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_ARunRelChkOnlineRunAssgmt view from BASIC Normal Assignments
I_ARunRelChkPreviewRunAssgmt view from BASIC Normal and Preview Assignments
I_ARunReleaseCheckRunAnalysis view left_outer COMPOSITE Release Run Analysis cube view
I_ARunSalesDocItmAssgdQty view from BASIC Assigned Quantity for Sales Document Item
I_ARunSTOItmAssgdQty view from BASIC Assigned Quantity for Stock Transport Order Item
I_SupAssgmtDmndMntrAssgmtDets view from COMPOSITE Supply Assignment Details
P_ArunNormalAssigned view left_outer COMPOSITE
P_SupAssgmtByDmnd view from COMPOSITE
P_SupAssgmtDetails view from COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY Material Material 4
KEY Plant Plant 4
KEY RequirementDocumentItem RequirementDocumentItem 4
KEY RequirementDocumentNumber RequirementDocumentNumber 4
KEY RequirementType RequirementType 4
KEY StorageLocation StorageLocation 1
ARunPhysSupAssgdQtyInBsUnt ARunPhysSupAssgdQtyInBsUnt 1
ARunPhysSupReservedQtyInBsUnt ARunPhysSupReservedQtyInBsUnt 1
ARunUUID ARunUUID 2
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 4
AssignedSupplyType AssignedSupplyType 2
BaseUnit BaseUnit 4
FixedQuantityInBaseUnit FixedQuantityInBaseUnit 1
InboundAssignedQuantityInBsUnt InboundAssignedQuantityInBsUnt 1
OnHoldQuantityInBaseUnit OnHoldQuantityInBaseUnit 1
ProductAvailabilityDate ProductAvailabilityDate 3
ReadyForReleaseQtyInBaseUnit ReadyForReleaseQtyInBaseUnit 1
RequestedDate RequestedDate 3
RequirementSegment RequirementSegment 1
SupAssgmtReservedQtyInBaseUnit SupAssgmtReservedQtyInBaseUnit 1
SupplyAssignmentStatus SupplyAssignmentStatus 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.

-- Basic View for Normal Run data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ARUNNORMAL (
    MATERIAL,
    PLANT,
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTTYPE,
    STORAGELOCATION,
    ARUNPHYSSUPASSGDQTYINBSUNT,
    ARUNPHYSSUPRESERVEDQTYINBSUNT,
    ARUNUUID,
    ASSIGNEDQUANTITYINBASEUNIT,
    ASSIGNEDSUPPLYTYPE,
    BASEUNIT,
    FIXEDQUANTITYINBASEUNIT,
    INBOUNDASSIGNEDQUANTITYINBSUNT,
    ONHOLDQUANTITYINBASEUNIT,
    PRODUCTAVAILABILITYDATE,
    READYFORRELEASEQTYINBASEUNIT,
    REQUESTEDDATE,
    REQUIREMENTSEGMENT,
    SUPASSGMTRESERVEDQTYINBASEUNIT,
    SUPPLYASSIGNMENTSTATUS,
    PRIMARY KEY (MATERIAL, PLANT, REQUIREMENTDOCUMENTITEM, REQUIREMENTDOCUMENTNUMBER, REQUIREMENTTYPE, STORAGELOCATION)
);

Learn More