PLANNEDORDERCOMPONENT

53 Fields

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

Fields (53)

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
AssemblyProductText AssemblyProductText 1
BaseUnit BaseUnit 2
BillOfMaterialCategory BillOfMaterialCategory 2
BillOfMaterialCategoryDesc BillOfMaterialCategoryDesc 1
BillOfMaterialInternalID BillOfMaterialInternalID 2
BillOfMaterialItemCategoryDesc BillOfMaterialItemCategoryDesc 1
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
DebitCreditCodeName DebitCreditCodeName 1
DiscontinuationGroup DiscontinuationGroup 2
EntryUnit EntryUnit 2
FollowUpGroup FollowUpGroup 2
FollowUpMaterial FollowUpMaterial 2
FollowUpMaterialIsNotActive FollowUpMaterialIsNotActive 2
FollowUpMaterialText FollowUpMaterialText 1
GoodsMovementEntryQty GoodsMovementEntryQty 2
Material Material 2
MaterialComponentIsPhantomItem MaterialComponentIsPhantomItem 2
MatlCompDiscontinuationType MatlCompDiscontinuationType 2
MatlCompIsFollowUpMaterial MatlCompIsFollowUpMaterial 2
MatlCompRequirementDate MatlCompRequirementDate 2
MRPController MRPController 2
MRPControllerName MRPControllerName 1
OrderLevelValue OrderLevelValue 2
OrderPathValue OrderPathValue 2
PlannedOrderLastChangeDateTime PlannedOrderLastChangeDateTime 2
Plant Plant 2
PlantName PlantName 1
ProductionSupplyAreaName ProductionSupplyAreaName 1
ProductName ProductName 1
QuantityIsFixed QuantityIsFixed 2
RequiredQuantity RequiredQuantity 2
RequirementSegment RequirementSegment 1
StockSegment StockSegment 1
StorageLocation StorageLocation 2
StorageLocationName StorageLocationName 1
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,
    ASSEMBLYPRODUCTTEXT,
    BASEUNIT,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALCATEGORYDESC,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMCATEGORYDESC,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMDESCRIPTION,
    BOMITEMDESCRIPTIONLINE2,
    BOMITEMSORTER,
    COMPONENTSCRAPINPERCENT,
    CRITICALCOMPONENTLEVEL,
    CRITICALCOMPONENTTYPE,
    DEBITCREDITCODE,
    DEBITCREDITCODENAME,
    DISCONTINUATIONGROUP,
    ENTRYUNIT,
    FOLLOWUPGROUP,
    FOLLOWUPMATERIAL,
    FOLLOWUPMATERIALISNOTACTIVE,
    FOLLOWUPMATERIALTEXT,
    GOODSMOVEMENTENTRYQTY,
    MATERIAL,
    MATERIALCOMPONENTISPHANTOMITEM,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPISFOLLOWUPMATERIAL,
    MATLCOMPREQUIREMENTDATE,
    MRPCONTROLLER,
    MRPCONTROLLERNAME,
    ORDERLEVELVALUE,
    ORDERPATHVALUE,
    PLANNEDORDERLASTCHANGEDATETIME,
    PLANT,
    PLANTNAME,
    PRODUCTIONSUPPLYAREANAME,
    PRODUCTNAME,
    QUANTITYISFIXED,
    REQUIREDQUANTITY,
    REQUIREMENTSEGMENT,
    STOCKSEGMENT,
    STORAGELOCATION,
    STORAGELOCATIONNAME,
    SUPPLYAREA,
    WITHDRAWNQUANTITY,
    PRIMARY KEY (PLANNEDORDER, RESERVATION, RESERVATIONITEM)
);

Learn More