I_ProcessOrderItemTP

DDL: I_PROCESSORDERITEMTP Type: view_entity TRANSACTIONAL
82 Fields 1 Data Sources

Process Order Item - TP

I_ProcessOrderItemTP is a Transactional CDS View that provides data about "Process Order Item - TP" in SAP S/4HANA. It reads from 1 data source (R_ProcessOrderItemTP) and exposes 82 fields with key fields ProcessOrder, ProcessOrderItem.

Data Sources (1)

SourceAliasJoin Type
R_ProcessOrderItemTP R_ProcessOrderItemTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ProcessOrderItem view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Process Order Item - TP view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder ProcessOrder Order
KEY ProcessOrderItem ProcessOrderItem Manufacturing Order Item
ManufacturingOrderCategory ManufacturingOrderCategory
ProcessOrderType ProcessOrderType
OrderIsReleased OrderIsReleased
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
OrderItemIsNotRelevantForMRP OrderItemIsNotRelevantForMRP
Product Product Product Sold
ProductionPlant ProductionPlant Prod plnt
PlanningPlant PlanningPlant
ProductionVersion ProductionVersion Version ID
MRPArea MRPArea MRP Area
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine SOrder schedule
WBSElementInternalID WBSElementInternalID WBS Internal ID
QuotaArrangement QuotaArrangement Quota arr.
QuotaArrangementItem QuotaArrangementItem Quota arr. item
SettlementReservation SettlementReservation
SettlementReservationItem SettlementReservationItem
CoProductReservation CoProductReservation
CoProductReservationItem CoProductReservationItem
MaterialProcurementCategory MaterialProcurementCategory Procurement
MaterialProcurementType MaterialProcurementType Spec. procuremt
SerialNumberProfile SerialNumberProfile SerialNoProfile
NumberOfSerialNumbers NumberOfSerialNumbers No.serial no.
ReplenishmentElementType ReplenishmentElementType
ProductConfiguration ProductConfiguration
ObjectInternalID ObjectInternalID Object number
QuantityDistributionKey QuantityDistributionKey Distribution
EffectivityParameterVariant EffectivityParameterVariant
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
InventoryValuationType InventoryValuationType Valuation Type
InventoryValuationCategory InventoryValuationCategory
InventoryUsabilityCode InventoryUsabilityCode Stock Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
ConsumptionPosting ConsumptionPosting Consumption Posting
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
StockSegment StockSegment Stock Segment
PlannedEndDate PlannedEndDate Ltst Planned Finish
ScheduledEndDate ScheduledEndDate
PlannedDeliveryDate PlannedDeliveryDate
ActualDeliveryDate ActualDeliveryDate Delivery Date
TotalCommitmentDate TotalCommitmentDate
ProductionUnit ProductionUnit
PlannedTotalQty PlannedTotalQty
PlannedScrapQuantity PlannedScrapQuantity
PlannedYieldQuantity PlannedYieldQuantity
GoodsReceiptQty GoodsReceiptQty Quantity
ActualDeviationQty ActualDeviationQty
OpenYieldQuantity OpenYieldQuantity
PlannedOrder PlannedOrder
PlndOrderPlannedStartDate PlndOrderPlannedStartDate
PlannedOrderOpeningDate PlannedOrderOpeningDate
BaseUnit BaseUnit Unit of Measure
PlndOrderPlannedTotalQty PlndOrderPlannedTotalQty
PlndOrderPlannedScrapQty PlndOrderPlannedScrapQty
BusinessArea BusinessArea Business Area
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy
BillOfMaterialItemNumber BillOfMaterialItemNumber Item
MaterialComponentText MaterialComponentText
MatlCompFreeDefinedAttribute MatlCompFreeDefinedAttribute Sort String
LeadTimeOffset LeadTimeOffset Lead-tm offset
OperationLeadTimeOffsetUnit OperationLeadTimeOffsetUnit
OperationLeadTimeOffset OperationLeadTimeOffset Oper. LT offset
BillOfMaterialItemCategory BillOfMaterialItemCategory Item Category
ProcessOrderOperation ProcessOrderOperation Operation or Phase
Plant Plant Valuation Area
_OrderredirectedtoparentI_ProcessOrderTP
_CoProductReservationItem _CoProductReservationItem

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 I_ProcessOrderItemTP.
-- 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 I_ProcessOrderItemTP AS
SELECT
  ProcessOrder,
  ProcessOrderItem,
  ManufacturingOrderCategory,
  ProcessOrderType,
  OrderIsReleased,
  IsMarkedForDeletion,
  OrderItemIsNotRelevantForMRP,
  Product,
  ProductionPlant,
  PlanningPlant,
  ProductionVersion,
  MRPArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  WBSElementInternalID,
  QuotaArrangement,
  QuotaArrangementItem,
  SettlementReservation,
  SettlementReservationItem,
  CoProductReservation,
  CoProductReservationItem,
  MaterialProcurementCategory,
  MaterialProcurementType,
  SerialNumberProfile,
  NumberOfSerialNumbers,
  ReplenishmentElementType,
  ProductConfiguration,
  ObjectInternalID,
  QuantityDistributionKey,
  EffectivityParameterVariant,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  IsCompletelyDelivered,
  MaterialGoodsReceiptDuration,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  StorageLocation,
  Batch,
  InventoryValuationType,
  InventoryValuationCategory,
  InventoryUsabilityCode,
  InventorySpecialStockType,
  InventorySpecialStockValnType,
  ConsumptionPosting,
  GoodsRecipientName,
  UnloadingPointName,
  StockSegment,
  PlannedEndDate,
  ScheduledEndDate,
  PlannedDeliveryDate,
  ActualDeliveryDate,
  TotalCommitmentDate,
  ProductionUnit,
  PlannedTotalQty,
  PlannedScrapQuantity,
  PlannedYieldQuantity,
  GoodsReceiptQty,
  ActualDeviationQty,
  OpenYieldQuantity,
  PlannedOrder,
  PlndOrderPlannedStartDate,
  PlannedOrderOpeningDate,
  BaseUnit,
  PlndOrderPlannedTotalQty,
  PlndOrderPlannedScrapQty,
  BusinessArea,
  AccountAssignmentCategory,
  CompanyCodeCurrency,
  GoodsReceiptAmountInCoCodeCrcy,
  BillOfMaterialItemNumber,
  MaterialComponentText,
  MatlCompFreeDefinedAttribute,
  LeadTimeOffset,
  OperationLeadTimeOffsetUnit,
  OperationLeadTimeOffset,
  BillOfMaterialItemCategory,
  ProcessOrderOperation,
  Plant
FROM R_ProcessOrderItemTP
;

Learn More