R_ProductionRoutingTP_2

DDL: R_PRODUCTIONROUTINGTP_2 Type: view_entity TRANSACTIONAL

Production Routing

R_ProductionRoutingTP_2 is a Transactional CDS View that provides data about "Production Routing" in SAP S/4HANA. It reads from 1 data source (I_ProductionRouting) and exposes 18 fields with key fields ProductionRoutingGroup, ProductionRouting. It has 3 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductionRouting I_ProductionRouting from

Associations (3)

CardinalityTargetAliasCondition
[1..*] R_ProductionRoutingHeaderTP_2 _Header
[0..*] R_ProdnRoutingMatlAssgmtTP_2 _MatlAssgmt
[1..*] R_ProdnRtgNonHistoricSqncTP_2 _NonSqnc

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Routing view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProductionRouting view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ProductionRouting view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup BillOfOperationsGroup
KEY ProductionRouting BillOfOperationsVariant
BillOfOperationsVersionType BillOfOperationsVersionType
BillOfOperationsSubtype BillOfOperationsSubtype
LastUsageDate LastUsageDate
NumberOfUsages NumberOfUsages
HasChangeNumber HasChangeNumber
HasParameterEffectivity HasParameterEffectivity
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
LastChangedByUser LastChangedByUser
IsMarkedForDeletion IsMarkedForDeletion
RoutingIsReworkRouting RoutingIsReworkRouting
ProdnProcgIsFlexible ProdnProcgIsFlexible
clientNULLastzntstmpsasChangedDateTime
_Header _Header
_MatlAssgmt _MatlAssgmt
_NonSqnc _NonSqnc 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Production Routing'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.representativeKey: 'ProductionRouting'
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.sapObjectNodeType.name: 'ProductionRouting'
define root view entity R_ProductionRoutingTP_2
  as select from I_ProductionRouting
  composition [1..*] of R_ProductionRoutingHeaderTP_2 as _Header
  composition [0..*] of R_ProdnRoutingMatlAssgmtTP_2  as _MatlAssgmt
  composition [1..*] of R_ProdnRtgNonHistoricSqncTP_2 as _NonSqnc
{
  key BillOfOperationsGroup                     as ProductionRoutingGroup,
  key BillOfOperationsVariant                   as ProductionRouting,
      BillOfOperationsVersionType,
      BillOfOperationsSubtype,
      LastUsageDate,
      NumberOfUsages,
      HasChangeNumber,
      HasParameterEffectivity,
      LastChangeDate,
      LastChangeTime,
      LastChangedByUser,
      IsMarkedForDeletion,
      RoutingIsReworkRouting,
      ProdnProcgIsFlexible,
      cast( dats_tims_to_tstmp(I_ProductionRouting.LastChangeDate,
                         LastChangeTime,
                         abap_system_timezone($session.client, 'NULL'),
                         $session.client,
                         'NULL') as tzntstmps ) as ChangedDateTime,

      /*Associations*/
      _Header,
      _MatlAssgmt,
      _NonSqnc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTIONROUTING"
],
"ASSOCIATED":
[
"R_PRODNROUTINGMATLASSGMTTP_2",
"R_PRODNRTGNONHISTORICSQNCTP_2",
"R_PRODUCTIONROUTINGHEADERTP_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More