C_ProdnOrderComponentJoule

DDL: C_PRODNORDERCOMPONENTJOULE Type: view_entity CONSUMPTION Package: PP_MFGORDER_CONF_AI
126 Fields 1 Data Sources 1 OData Services

Production Order Component

C_ProdnOrderComponentJoule is a Consumption CDS View that provides data about "Production Order Component" in SAP S/4HANA. It reads from 1 data source (R_ProductionOrderOpComponentTP) and exposes 126 fields with key fields Reservation, ReservationItem, ReservationRecordType. It is exposed through 1 OData service (PP_PO_CONF_SD). Part of development package PP_MFGORDER_CONF_AI.

Data Sources (1)

SourceAliasJoin Type
R_ProductionOrderOpComponentTP R_ProductionOrderOpComponentTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name ProductionOrderComponent view
OData.entitySet.name ProdnOrderComponent view
VDM.viewType #CONSUMPTION view
EndUserText.label Production Order Component view

OData Services (1)

ServiceBindingVersionContractRelease
PP_PO_CONF_SD PP_PO_CONF_SB V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (126)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
KEY ReservationRecordType ReservationRecordType Record type
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
Plant Plant Valuation Area
ProductionOrder ProductionOrder Order
ProductionOrderSequence ProductionOrderSequence
SequenceCategory SequenceCategory
ProductionOrderOperation ProductionOrderOperation Activity
OrderInternalID OrderInternalID Plan No.f.Oper.
OrderOperationInternalID OrderOperationInternalID
MaterialComponentText MaterialComponentText
MaterialComponentSecondText MaterialComponentSecondText
MaterialComponentHasLongText MaterialComponentHasLongText
LongTextLanguage LongTextLanguage Long Text Lang
MatlCompRequirementDate MatlCompRequirementDate Reqmts date
MatlCompRequirementTime MatlCompRequirementTime
LatestRequirementDate LatestRequirementDate Latest Requirement Date
ReservationItemCreationCode ReservationItemCreationCode Reserv. status
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
MatlCompIsMarkedForDeletion MatlCompIsMarkedForDeletion
MaterialComponentIsMissing MaterialComponentIsMissing
IsBulkMaterialComponent IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush Backflush
MatlCompIsTextItem MatlCompIsTextItem
MaterialPlanningRelevance MaterialPlanningRelevance
MatlCompIsConfigurable MatlCompIsConfigurable
MaterialCompCostingRelevancy MaterialCompCostingRelevancy CostingRelevncy
MaterialComponentIsClassified MaterialComponentIsClassified
MaterialCompIsIntraMaterial MaterialCompIsIntraMaterial
MaterialIsDirectlyProduced MaterialIsDirectlyProduced
MaterialIsDirectlyProcured MaterialIsDirectlyProcured
RequirementType RequirementType RequirementType
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProductConfiguration ProductConfiguration
ChangeNumber ChangeNumber Change Number
EffectivityParameterVariant EffectivityParameterVariant
MatlCompFreeDefinedAttribute MatlCompFreeDefinedAttribute Sort String
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialInternalID BillOfMaterialInternalID
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber Item node
BillOfMaterialVersion BillOfMaterialVersion BOM Version
BOMItemInternalChangeCount BOMItemInternalChangeCount Counter
InheritedBOMItemNode InheritedBOMItemNode
BillOfMaterialItemCategory BillOfMaterialItemCategory Item Category
BillOfMaterialItemNumber BillOfMaterialItemNumber Item
BOMExplosionDateID BOMExplosionDateID
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier Supplier Supplier
DeliveryDurationInDays DeliveryDurationInDays Del time (days)
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
ExternalProcessingPrice ExternalProcessingPrice
NumberOfOperationPriceUnits NumberOfOperationPriceUnits Price Unit
GoodsMovementIsAllowed GoodsMovementIsAllowed Mvt Allowed
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
BatchSplitType BatchSplitType
DebitCreditCode DebitCreditCode Single-Character Flag
GoodsMovementType GoodsMovementType Movement Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
ConsumptionPosting ConsumptionPosting Consumption Posting
SupplyArea SupplyArea Supply Area
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
StockSegment StockSegment Stock Segment
RequirementSegment RequirementSegment Req. Segment
BusinessArea BusinessArea Business Area
GLAccount GLAccount General Ledger
FunctionalArea FunctionalArea Sendr Fctl Area
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MaterialCompIsVariableSized MaterialCompIsVariableSized Var-Sized Item
VariableSizeItemUnit VariableSizeItemUnit VSI unit
VariableSizeItemQuantity VariableSizeItemQuantity VSI Quantity
VariableSizeComponentUnit VariableSizeComponentUnit VSI UoM
VariableSizeComponentQuantity VariableSizeComponentQuantity VSI Quantity
VariableSizeDimensionUnit VariableSizeDimensionUnit Size unit
VariableSizeDimension1 VariableSizeDimension1 Size 1
VariableSizeDimension2 VariableSizeDimension2 Size 2
VariableSizeDimension3 VariableSizeDimension3 Size 3
VariableSizeCompFormulaKey VariableSizeCompFormulaKey VSI Formula
MaterialComponentIsPhantomItem MaterialComponentIsPhantomItem Phantom Item
OrderPathValue OrderPathValue Order path
OrderLevelValue OrderLevelValue Order level
DiscontinuationGroup DiscontinuationGroup Discont. group
MatlCompDiscontinuationType MatlCompDiscontinuationType
MatlCompIsFollowUpMaterial MatlCompIsFollowUpMaterial
FollowUpGroup FollowUpGroup Follow-up group
FollowUpMaterial FollowUpMaterial
FollowUpMaterialIsActive FollowUpMaterialIsActive
MaterialCompIsAlternativeItem MaterialCompIsAlternativeItem
AlternativeItemGroup AlternativeItemGroup AltItemGroup
AlternativeItemStrategy AlternativeItemStrategy Strategy
AlternativeItemPriority AlternativeItemPriority Priority
UsageProbabilityPercent UsageProbabilityPercent Usage Prob.
MatlComponentSparePartType MatlComponentSparePartType Spare Part ID
MaterialProvisionType MaterialProvisionType Material Provision Type
LeadTimeOffset LeadTimeOffset Lead-tm offset
OperationLeadTimeOffsetUnit OperationLeadTimeOffsetUnit
OperationLeadTimeOffset OperationLeadTimeOffset Oper. LT offset
QuantityIsFixed QuantityIsFixed Qty. is fixed
IsNetScrap IsNetScrap Net Indicator
ComponentScrapInPercent ComponentScrapInPercent Component Scrap
OperationScrapInPercent OperationScrapInPercent Operation Scrap
MaterialQtyToBaseQtyNmrtr MaterialQtyToBaseQtyNmrtr Numerator
MaterialQtyToBaseQtyDnmntr MaterialQtyToBaseQtyDnmntr Denominator
BaseUnit BaseUnit Unit of Measure
RequiredQuantity RequiredQuantity Requirement qty
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
ConfirmedAvailableQuantity ConfirmedAvailableQuantity Available Quantity
MaterialCompOriginalQuantity MaterialCompOriginalQuantity
EntryUnit EntryUnit Unit of Entry
GoodsMovementEntryQty GoodsMovementEntryQty
Currency Currency Valuation Crcy
WithdrawnQuantityAmount WithdrawnQuantityAmount
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProdnOrderComponentJoule.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_ProdnOrderComponentJoule AS
SELECT
  Reservation,
  ReservationItem,
  ReservationRecordType,
  MaterialGroup,
  Material,
  Plant,
  ProductionOrder,
  ProductionOrderSequence,
  SequenceCategory,
  ProductionOrderOperation,
  OrderInternalID,
  OrderOperationInternalID,
  MaterialComponentText,
  MaterialComponentSecondText,
  MaterialComponentHasLongText,
  LongTextLanguage,
  MatlCompRequirementDate,
  MatlCompRequirementTime,
  LatestRequirementDate,
  ReservationItemCreationCode,
  ReservationIsFinallyIssued,
  MatlCompIsMarkedForDeletion,
  MaterialComponentIsMissing,
  IsBulkMaterialComponent,
  MatlCompIsMarkedForBackflush,
  MatlCompIsTextItem,
  MaterialPlanningRelevance,
  MatlCompIsConfigurable,
  MaterialCompCostingRelevancy,
  MaterialComponentIsClassified,
  MaterialCompIsIntraMaterial,
  MaterialIsDirectlyProduced,
  MaterialIsDirectlyProcured,
  RequirementType,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  ProductConfiguration,
  ChangeNumber,
  EffectivityParameterVariant,
  MatlCompFreeDefinedAttribute,
  BillOfMaterialCategory,
  BillOfMaterialInternalID,
  BillOfMaterialVariant,
  BillOfMaterialItemNodeNumber,
  BillOfMaterialVersion,
  BOMItemInternalChangeCount,
  InheritedBOMItemNode,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  BOMExplosionDateID,
  PurchasingInfoRecord,
  PurchasingGroup,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseOrder,
  PurchaseOrderItem,
  Supplier,
  DeliveryDurationInDays,
  MaterialGoodsReceiptDuration,
  ExternalProcessingPrice,
  NumberOfOperationPriceUnits,
  GoodsMovementIsAllowed,
  StorageLocation,
  Batch,
  BatchSplitType,
  DebitCreditCode,
  GoodsMovementType,
  InventorySpecialStockType,
  InventorySpecialStockValnType,
  ConsumptionPosting,
  SupplyArea,
  GoodsRecipientName,
  UnloadingPointName,
  StockSegment,
  RequirementSegment,
  BusinessArea,
  GLAccount,
  FunctionalArea,
  AccountAssignmentCategory,
  MaterialCompIsVariableSized,
  VariableSizeItemUnit,
  VariableSizeItemQuantity,
  VariableSizeComponentUnit,
  VariableSizeComponentQuantity,
  VariableSizeDimensionUnit,
  VariableSizeDimension1,
  VariableSizeDimension2,
  VariableSizeDimension3,
  VariableSizeCompFormulaKey,
  MaterialComponentIsPhantomItem,
  OrderPathValue,
  OrderLevelValue,
  DiscontinuationGroup,
  MatlCompDiscontinuationType,
  MatlCompIsFollowUpMaterial,
  FollowUpGroup,
  FollowUpMaterial,
  FollowUpMaterialIsActive,
  MaterialCompIsAlternativeItem,
  AlternativeItemGroup,
  AlternativeItemStrategy,
  AlternativeItemPriority,
  UsageProbabilityPercent,
  MatlComponentSparePartType,
  MaterialProvisionType,
  LeadTimeOffset,
  OperationLeadTimeOffsetUnit,
  OperationLeadTimeOffset,
  QuantityIsFixed,
  IsNetScrap,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  MaterialQtyToBaseQtyNmrtr,
  MaterialQtyToBaseQtyDnmntr,
  BaseUnit,
  RequiredQuantity,
  WithdrawnQuantity,
  ConfirmedAvailableQuantity,
  MaterialCompOriginalQuantity,
  EntryUnit,
  GoodsMovementEntryQty,
  Currency,
  WithdrawnQuantityAmount
FROM R_ProductionOrderOpComponentTP
;

Learn More