PLANNEDORDERCOMPONENT

43 Fields

PLANNEDORDERCOMPONENT is an SAP database table in S/4HANA. It contains 43 fields.

Fields (43)

KeyField CDS FieldsUsed in Views
KEY PlannedOrder PlannedOrder 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
Assembly Assembly 2
AssemblyOrderLevelValue AssemblyOrderLevelValue 2
AssemblyOrderPathValue AssemblyOrderPathValue 2
BaseUnit BaseUnit 2
BillOfMaterialCategory BillOfMaterialCategory 2
BillOfMaterialInternalID BillOfMaterialInternalID 2
BillOfMaterialItemNumber BillOfMaterialItemNumber 2
BillOfMaterialVariant BillOfMaterialVariant 2
BOMItem BOMItem 2
BOMItemCategory BOMItemCategory 2
BOMItemDescription BOMItemDescription 2
BOMItemDescriptionLine2 BOMItemDescriptionLine2 2
BOMItemSorter BOMItemSorter 2
ComponentScrapInPercent ComponentScrapInPercent 2
CriticalComponentLevel CriticalComponentLevel 1
CriticalComponentType CriticalComponentType 1
DebitCreditCode DebitCreditCode 2
DiscontinuationGroup DiscontinuationGroup 2
EntryUnit EntryUnit 2
FollowUpGroup FollowUpGroup 2
FollowUpMaterial FollowUpMaterial 2
FollowUpMaterialIsNotActive FollowUpMaterialIsNotActive 2
GoodsMovementEntryQty GoodsMovementEntryQty 2
Material Material 2
MaterialComponentIsPhantomItem MaterialComponentIsPhantomItem 2
MatlCompDiscontinuationType MatlCompDiscontinuationType 2
MatlCompIsFollowUpMaterial MatlCompIsFollowUpMaterial 2
MatlCompRequirementDate MatlCompRequirementDate 2
MRPController MRPController 2
OrderLevelValue OrderLevelValue 2
OrderPathValue OrderPathValue 2
PlannedOrderLastChangeDateTime PlannedOrderLastChangeDateTime 2
Plant Plant 2
QuantityIsFixed QuantityIsFixed 2
RequiredQuantity RequiredQuantity 2
RequirementSegment RequirementSegment 1
StockSegment StockSegment 1
StorageLocation StorageLocation 2
SupplyArea SupplyArea 2
WithdrawnQuantity WithdrawnQuantity 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLANNEDORDERCOMPONENT (
    PLANNEDORDER,
    RESERVATION,
    RESERVATIONITEM,
    ASSEMBLY,
    ASSEMBLYORDERLEVELVALUE,
    ASSEMBLYORDERPATHVALUE,
    BASEUNIT,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMDESCRIPTION,
    BOMITEMDESCRIPTIONLINE2,
    BOMITEMSORTER,
    COMPONENTSCRAPINPERCENT,
    CRITICALCOMPONENTLEVEL,
    CRITICALCOMPONENTTYPE,
    DEBITCREDITCODE,
    DISCONTINUATIONGROUP,
    ENTRYUNIT,
    FOLLOWUPGROUP,
    FOLLOWUPMATERIAL,
    FOLLOWUPMATERIALISNOTACTIVE,
    GOODSMOVEMENTENTRYQTY,
    MATERIAL,
    MATERIALCOMPONENTISPHANTOMITEM,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPISFOLLOWUPMATERIAL,
    MATLCOMPREQUIREMENTDATE,
    MRPCONTROLLER,
    ORDERLEVELVALUE,
    ORDERPATHVALUE,
    PLANNEDORDERLASTCHANGEDATETIME,
    PLANT,
    QUANTITYISFIXED,
    REQUIREDQUANTITY,
    REQUIREMENTSEGMENT,
    STOCKSEGMENT,
    STORAGELOCATION,
    SUPPLYAREA,
    WITHDRAWNQUANTITY,
    PRIMARY KEY (PLANNEDORDER, RESERVATION, RESERVATIONITEM)
);

Learn More