R_ProductionOrderTP

DDL: R_PRODUCTIONORDERTP Type: view_entity TRANSACTIONAL

Production Order Header - TP

R_ProductionOrderTP is a Transactional CDS View that provides data about "Production Order Header - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrder) and exposes 126 fields with key field ProductionOrder. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrder Header from

Associations (4)

CardinalityTargetAliasCondition
[0..*] R_ProductionOrderOperationTP _Operation _Operation.ProductionOrder = $projection.ProductionOrder and _Operation.ProductionOrderSequence = '000000'
[1..1] E_ProductionOrder _Extension $projection.ProductionOrder = _Extension.ProductionOrder
[0..*] R_ProductionOrderSequenceTP _Sequence
[0..*] R_ProductionOrderOpComponentTP _Component

Annotations (15)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name ProductionOrder view
ObjectModel.representativeKey ProductionOrder view
Analytics.technicalName RPRODNORDTP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Production Order Header - TP view

Fields (126)

KeyFieldSource TableSource FieldDescription
KEY ProductionOrder
ManufacturingOrder
ManufacturingOrderCategory ManufacturingOrderCategory
ProductionOrderType
ProductionOrderText ManufacturingOrderText
OrderHasLongText ManufacturingOrderHasLongText
LongTextLanguageCode LongTextLanguageCode
OrderImportance ManufacturingOrderImportance
IsMarkedForDeletion IsMarkedForDeletion
IsCompletelyDelivered IsCompletelyDelivered
OrderHasMultipleItems MfgOrderHasMultipleItems
OrderIsPartOfCollectiveOrder MfgOrderIsPartOfCollvOrder
OrderHierarchyLevelValue MfgOrderHierarchyLevel
OrderIsNotCostedAutomatically OrderIsNotCostedAutomatically
OrdIsNotSchedldAutomatically OrdIsNotSchedldAutomatically
ProdnProcgIsFlexible ProdnProcgIsFlexible
CreationDate CreationDate
CreationTime CreationTime
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
LastChangedByUser LastChangedByUser
Product Product
StorageLocation StorageLocation
Batch Batch
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
InventoryUsabilityCode InventoryUsabilityCode
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration
QuantityDistributionKey QuantityDistributionKey
StockSegment StockSegment
OrderInternalID MfgOrderInternalID
ReferenceOrder ReferenceOrder
LeadingOrder LeadingOrder
SuperiorOrder SuperiorOrder
Currency Currency
ProductionPlant ProductionPlant
PlanningPlant PlanningPlant
MRPArea
MRPController MRPController
ProductionSupervisor ProductionSupervisor
ProductionSchedulingProfile ProductionSchedulingProfile
ResponsiblePlannerGroup ResponsiblePlannerGroup
ProductionVersion ProductionVersion
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementInternalID
Reservation Reservation
SettlementReservation SettlementReservation
OrderConfirmationGroup MfgOrderConfirmation
NumberOfOrderConfirmations NumberOfMfgOrderConfirmations
PlannedOrder PlannedOrder
CapacityRequirement CapacityRequirement
InspectionLot InspectionLot
ChangeNumber ChangeNumber
BasicSchedulingType BasicSchedulingType
ObjectInternalID ObjectInternalID
ProductConfiguration ProductConfiguration
EffectivityParameterVariant EffectivityParameterVariant
ConditionApplication ConditionApplication
CapacityActiveVersion CapacityActiveVersion
CapacityRqmtHasNotToBeCreated CapacityRqmtHasNotToBeCreated
OrderSequenceNumber OrderSequenceNumber
BillOfOperationsMaterial BillOfOperationsMaterial
BillOfOperationsType BillOfOperationsType
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsVariant BillOfOperationsVariant
BOOInternalVersionCounter BOOInternalVersionCounter
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsVersion BillOfOperationsVersion
BOOExplosionDate BOOExplosionDate
BOOValidityStartDate BOOValidityStartDate
BillOfMaterialCategory BillOfMaterialCategory
BillOfMaterial
BillOfMaterialVariant BillOfMaterialVariant
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterialVersion BillOfMaterialVersion
BOMExplosionDate BOMExplosionDate
BOMValidityStartDate BOMValidityStartDate
BusinessArea BusinessArea
CompanyCode
ControllingArea ControllingArea
ProfitCenter ProfitCenter
CostCenter CostCenter
ResponsibleCostCenter
CostElement CostElement
CostingSheet CostingSheet
GLAccount GLAccount
ProductCostCollector ProductCostCollector
ActualCostsCostingVariant ActualCostsCostingVariant
PlannedCostsCostingVariant PlannedCostsCostingVariant
ControllingObjectClass ControllingObjectClass
FunctionalArea FunctionalArea
SchedulingFloatProfile SchedulingFloatProfile
FloatBeforeProductionInWrkDays FloatBeforeProductionInWrkDays
FloatAfterProductionInWorkDays FloatAfterProductionInWorkDays
ReleasePeriodInWorkDays ReleasePeriodInWorkDays
OrderPlannedStartDate MfgOrderPlannedStartDate
OrderPlannedStartTime MfgOrderPlannedStartTime
OrderPlannedEndDate MfgOrderPlannedEndDate
OrderPlannedEndTime MfgOrderPlannedEndTime
PlannedReleaseDate MfgOrderPlannedReleaseDate
OrderScheduledStartDate MfgOrderScheduledStartDate
OrderScheduledStartTime MfgOrderScheduledStartTime
OrderScheduledEndDate MfgOrderScheduledEndDate
OrderScheduledEndTime MfgOrderScheduledEndTime
OrderScheduledReleaseDate MfgOrderScheduledReleaseDate
OrderActualStartDate MfgOrderActualStartDate
OrderActualStartTime MfgOrderActualStartTime
OrderActualEndDate MfgOrderItemActualDeliveryDate
OrderActualReleaseDate MfgOrderActualReleaseDate
OrderConfirmedEndDate MfgOrderConfirmedEndDate
OrderConfirmedEndTime MfgOrderConfirmedEndTime
TotalCommitmentDate MfgOrderTotalCommitmentDate
TechnicalCompletionDate MfgOrderActualCompletionDate
ProductionUnit ProductionUnit
OrderPlannedTotalQty MfgOrderPlannedTotalQty
OrderPlannedScrapQty MfgOrderPlannedScrapQty
OrderConfirmedYieldQty MfgOrderConfirmedYieldQty
OrderConfirmedScrapQty MfgOrderConfirmedScrapQty
OrderConfirmedReworkQty MfgOrderConfirmedReworkQty
ExpectedDeviationQuantity ExpectedDeviationQuantity
ActualDeliveredQuantity ActualDeliveredQuantity
_Sequence _Sequence
_Component _Component
_Operation _Operation
@AbapCatalog.dataMaintenance: #RESTRICTED
//@AbapCatalog.extensibility: {

//  extensible: true,

//  dataSources: ['_Extension'],

//  elementSuffix: 'ORD',

//  quota: {

//    maximumFields: 204, // calculated with formula for FINS_ORDER - 2* <Customer Percentage from SCFD_REGISTRY> * <max number of fields in SCFD_REGISTRY>

//    maximumBytes: 2040  // calculated with formula for FINS_ORDER - 2* <Customer Percentage from SCFD_REGISTRY> * <number of chars as defined in SCFD_REGISTRY>

//  }

//}

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true  // ====> Ist erben OK ??

@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.sapObjectNodeType.name: 'ProductionOrder'
@ObjectModel.representativeKey: 'ProductionOrder'
@Analytics.technicalName: 'RPRODNORDTP'
@ObjectModel.semanticKey: [ 'ProductionOrder']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL  // Still necessary???

@EndUserText.label: 'Production Order Header - TP'

//

//      ************************  DO NOT USE  ************************

//      *            This RAP BO is for testing purpose only         *

//      **************************************************************


define root view entity R_ProductionOrderTP
  as select from I_ManufacturingOrder as Header

  // BO relations

  composition [0..*] of R_ProductionOrderSequenceTP    as _Sequence
  composition [0..*] of R_ProductionOrderOpComponentTP as _Component

  association [0..*] to R_ProductionOrderOperationTP   as _Operation              on  _Operation.ProductionOrder         = $projection.ProductionOrder
                                                                                  and _Operation.ProductionOrderSequence = '000000'
  // extension association

  association [1..1] to E_ProductionOrder              as _Extension              on  $projection.ProductionOrder = _Extension.ProductionOrder

{
  key cast(ManufacturingOrder as vdm_manufacturingorder preserving type) as ProductionOrder,

      cast(ManufacturingOrder as manufacturingorder preserving type)     as ManufacturingOrder, // still needed for business event


      // Category and Type

      ManufacturingOrderCategory,
      cast(ManufacturingOrderType as aufart preserving type )            as ProductionOrderType,

      // Text

      @Semantics.text: true
      ManufacturingOrderText                                             as ProductionOrderText,
      ManufacturingOrderHasLongText                                      as OrderHasLongText,
      LongTextLanguageCode,

      // Attributes

      ManufacturingOrderImportance                                       as OrderImportance,
      IsMarkedForDeletion,
      IsCompletelyDelivered,
      @Semantics.booleanIndicator
      MfgOrderHasMultipleItems                                           as OrderHasMultipleItems,
      @Semantics.booleanIndicator
      MfgOrderIsPartOfCollvOrder                                         as OrderIsPartOfCollectiveOrder,
      MfgOrderHierarchyLevel                                             as OrderHierarchyLevelValue,
      @Semantics.booleanIndicator
      OrderIsNotCostedAutomatically,
      @Semantics.booleanIndicator
      OrdIsNotSchedldAutomatically,
      ProdnProcgIsFlexible,
      // OrderIsEventBasedPosting,  Invalid name as this is a code => Replace when new name is available


      // Admin data

      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemTime.createdAt: true
      CreationTime,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      LastChangeTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      // ETag

      @Semantics.systemDateTime.lastChangedAt: true
      case when LastChangeDate > '00000000' then
             cast( dats_tims_to_tstmp( LastChangeDate, LastChangeTime, '', $session.client, 'NULL' ) as timestampl )
           when LastChangeDate = '00000000' then
             cast( 0 as timestampl )
           end                                                           as LastChangeDateTime,

      // Header Material data

      Product,
      StorageLocation,
      Batch,
      @Semantics.text: true
      GoodsRecipientName,
      @Semantics.text: true
      UnloadingPointName,
      InventoryUsabilityCode,
      MaterialGoodsReceiptDuration,
      QuantityDistributionKey,
      StockSegment,

      // Assignments

      MfgOrderInternalID                                                 as OrderInternalID,
      ReferenceOrder,
      LeadingOrder,
      SuperiorOrder,
      Currency,
      ProductionPlant,
      PlanningPlant,
      cast(MRPArea as berid preserving type )                            as MRPArea,
      MRPController,
      ProductionSupervisor,
      ProductionSchedulingProfile,
      ResponsiblePlannerGroup,
      ProductionVersion,
      SalesOrder,
      SalesOrderItem,
      cast( WBSElementInternalID as  ps_s4_pspnr preserving type )       as WBSElementInternalID,
      Reservation,
      SettlementReservation,
      MfgOrderConfirmation                                               as OrderConfirmationGroup,
      NumberOfMfgOrderConfirmations                                      as NumberOfOrderConfirmations,
      PlannedOrder,
      CapacityRequirement,
      InspectionLot,
      ChangeNumber,
      BasicSchedulingType,
      ForecastSchedulingType,
      ObjectInternalID,
      ProductConfiguration,
      EffectivityParameterVariant,
      ConditionApplication,
      CapacityActiveVersion,
      CapacityRqmtHasNotToBeCreated,
      OrderSequenceNumber,

      // Assignments BOO

      BillOfOperationsMaterial,
      BillOfOperationsType,
      BillOfOperationsGroup,
      BillOfOperationsVariant,
      BOOInternalVersionCounter,
      BillOfOperationsUsage,
      BillOfOperationsVersion,
      BOOExplosionDate,
      BOOValidityStartDate,

      // Assignments BOM

      BillOfMaterialCategory,
      cast(BillOfMaterial as pph_stnum preserving type )                 as BillOfMaterial,
      BillOfMaterialVariant,
      BillOfMaterialVariantUsage,
      BillOfMaterialVersion,
      BOMExplosionDate,
      BOMValidityStartDate,

      // Assignments FI/CO

      BusinessArea,
      cast(CompanyCode as bukrs preserving type )                        as CompanyCode,
      ControllingArea,
      ProfitCenter,
      CostCenter,
      cast(ResponsibleCostCenter as pph_kostl preserving type )          as ResponsibleCostCenter,
      CostElement,
      CostingSheet,
      GLAccount,
      ProductCostCollector,
      ActualCostsCostingVariant,
      PlannedCostsCostingVariant,
      ControllingObjectClass,
      FunctionalArea,

      // Scheduling

      SchedulingFloatProfile,
      FloatBeforeProductionInWrkDays,
      FloatAfterProductionInWorkDays,
      ReleasePeriodInWorkDays,

      // Dates and Times

      MfgOrderPlannedStartDate                                           as OrderPlannedStartDate,
      MfgOrderPlannedStartTime                                           as OrderPlannedStartTime,
      MfgOrderPlannedEndDate                                             as OrderPlannedEndDate,
      MfgOrderPlannedEndTime                                             as OrderPlannedEndTime,
      MfgOrderPlannedReleaseDate                                         as PlannedReleaseDate,
      MfgOrderScheduledStartDate                                         as OrderScheduledStartDate,
      MfgOrderScheduledStartTime                                         as OrderScheduledStartTime,
      MfgOrderScheduledEndDate                                           as OrderScheduledEndDate,
      MfgOrderScheduledEndTime                                           as OrderScheduledEndTime,
      MfgOrderScheduledReleaseDate                                       as OrderScheduledReleaseDate,
      MfgOrderActualStartDate                                            as OrderActualStartDate,
      MfgOrderActualStartTime                                            as OrderActualStartTime,
      // as mapped in CO03 (MfgOrderItemActualDeliveryDate is not directly visible there)

      MfgOrderItemActualDeliveryDate                                     as OrderActualEndDate,
      MfgOrderActualReleaseDate                                          as OrderActualReleaseDate,
      MfgOrderConfirmedEndDate                                           as OrderConfirmedEndDate,
      MfgOrderConfirmedEndTime                                           as OrderConfirmedEndTime,
      MfgOrderTotalCommitmentDate                                        as TotalCommitmentDate,
      MfgOrderActualCompletionDate                                       as TechnicalCompletionDate,

      // Quantities and UoM

      ProductionUnit,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderPlannedTotalQty                                            as OrderPlannedTotalQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderPlannedScrapQty                                            as OrderPlannedScrapQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderConfirmedYieldQty                                          as OrderConfirmedYieldQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderConfirmedScrapQty                                          as OrderConfirmedScrapQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderConfirmedReworkQty                                         as OrderConfirmedReworkQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      ExpectedDeviationQuantity,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      ActualDeliveredQuantity,

      // Associations

      _Sequence,
      _Component,
      _Operation
}
where
  ManufacturingOrderCategory = '10'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDER"
],
"ASSOCIATED":
[
"R_PRODUCTIONORDEROPCOMPONENTTP",
"R_PRODUCTIONORDEROPERATIONTP",
"R_PRODUCTIONORDERSEQUENCETP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/