R_ProductionOrderSequenceTP

DDL: R_PRODUCTIONORDERSEQUENCETP Type: view_entity TRANSACTIONAL

Production Order Sequence - TP

R_ProductionOrderSequenceTP is a Transactional CDS View that provides data about "Production Order Sequence - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrderSequence) and exposes 18 fields with key fields ProductionOrder, ProductionOrderSequence. It has 1 association to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrderSequence sequence from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_ProductionOrderOperationTP _Operation

Annotations (10)

NameValueLevelField
EndUserText.label Production Order Sequence - TP view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProductionOrder
KEY ProductionOrderSequence
OrderInternalID OrderInternalID
SequenceInternalID SequenceInternalID
SequenceText MfgOrderSequenceText
SequenceHasLongText MfgOrderSequenceHasLongText
LongTextLanguage LongTextLanguage
SequenceBranchOperation MfgOrderSequenceBrnchOperation
SequenceReturnOperation MfgOrderSequenceRetOperation
SequenceCategory MfgOrderSequenceCategory
ReferenceSequence ReferenceSequence
SequenceSchedulingAlignment SequenceSchedulingAlignment
ObjectInternalID ObjectInternalID
BillOfOperationsUnit BillOfOperationsUnit
MinimumLotSizeQuantity MinimumLotSizeQuantity
MaximumLotSizeQuantity MaximumLotSizeQuantity
_ProductionOrder _ProductionOrder
_Operation _Operation 
@EndUserText.label: 'Production Order Sequence - TP'
@AbapCatalog.dataMaintenance: #RESTRICTED
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
//@AccessControl.privilegedAssociations:  //check


@Metadata.ignorePropagatedAnnotations: true //check


@ObjectModel.modelingPattern: #TRANSACTIONAL_PROJECTED_ENTITY
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
//@ObjectModel.representativeKey: 'OrderOperationInternalID' //check

//@ObjectModel.semanticKey: 'ProductionOrderOperation' //check

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_ProductionOrderSequenceTP
  as select from I_ManufacturingOrderSequence as sequence

  // BO relation

  association to parent R_ProductionOrderTP          as _ProductionOrder on $projection.ProductionOrder = _ProductionOrder.ProductionOrder

  composition [0..*] of R_ProductionOrderOperationTP as _Operation

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

      // Internal Key

      OrderInternalID,

      SequenceInternalID,

      // Text

      MfgOrderSequenceText                                               as SequenceText,
      MfgOrderSequenceHasLongText                                        as SequenceHasLongText,
      LongTextLanguage,

      MfgOrderSequenceBrnchOperation                                     as SequenceBranchOperation,
      MfgOrderSequenceRetOperation                                       as SequenceReturnOperation,

      MfgOrderSequenceCategory                                           as SequenceCategory,
      ReferenceSequence,
      SequenceSchedulingAlignment,
      ObjectInternalID,

      // Quantity and UoM

      BillOfOperationsUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      MaximumLotSizeQuantity,

      _ProductionOrder,
      _Operation

}

where
  ManufacturingOrderCategory = '10'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDERSEQUENCE"
],
"ASSOCIATED":
[
"R_PRODUCTIONORDEROPERATIONTP",
"R_PRODUCTIONORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More