R_ProductionModelComponentTP

DDL: R_PRODUCTIONMODELCOMPONENTTP Type: view_entity TRANSACTIONAL

Production Model Component

R_ProductionModelComponentTP is a Transactional CDS View that provides data about "Production Model Component" in SAP S/4HANA. It reads from 1 data source (I_ProductionModelComponent) and exposes 113 fields with key fields ProductionModelUUID, ProductionModelComponentUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductionModelComponent ProductionModelComponent from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_BillOfMaterialItemTP _BillOfMaterialItemExtension $projection.BillOfMaterial = _BillOfMaterialItemExtension.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory and $projection.BillOfMaterialItemNodeNumber = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount
[0..*] R_ProdnModComponentInstanceTP _HeaderComponentInstance

Annotations (11)

NameValueLevelField
EndUserText.label Production Model Component view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix PMC view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 2500 view

Fields (113)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID
KEY ProductionModelComponentUUID ProductionModelComponentUUID
BillOfMaterialCategory BillOfMaterialCategory
Material Material
Plant Plant
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterial BillOfMaterial
BillOfOperationsType BillOfOperationsType
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
EngineeringChangeDocument EngineeringChangeDocument
ChgToEngineeringChgDocument ChgToEngineeringChgDocument
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM
BOMItemInternalChangeCount BOMItemInternalChangeCount
BillOfMaterialComponent BillOfMaterialComponent
ComponentDescription ComponentDescription
BillOfMaterialItemCategory BillOfMaterialItemCategory
BillOfMaterialItemNumber BillOfMaterialItemNumber
BillOfMaterialItemUnit BillOfMaterialItemUnit
BillOfMaterialItemQuantity BillOfMaterialItemQuantity
IsAssembly IsAssembly
IsSubItem IsSubItem
IsDeleted IsDeleted
IdentifierBOMItem IdentifierBOMItem
BOMItemSorter BOMItemSorter
BOMItemHasFixedQuantity BOMItemHasFixedQuantity
ComponentScrapInPercent ComponentScrapInPercent
OperationScrapInPercent OperationScrapInPercent
IsNetScrap IsNetScrap
IsBulkMaterial IsBulkMaterial
IsBulkMaterialComponent IsBulkMaterialComponent
MaterialProvisionType MaterialProvisionType
MatlComponentSparePartType MatlComponentSparePartType
BOMItemSalesRelevancy BOMItemSalesRelevancy
IsEngineeringRelevant IsEngineeringRelevant
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant
IsProductionRelevant IsProductionRelevant
MaterialCompCostingRelevancy MaterialCompCostingRelevancy
BOMIsRecursive BOMIsRecursive
IsBOMRecursiveAllowed IsBOMRecursiveAllowed
FollowUpGroup FollowUpGroup
AlternativeItemGroup AlternativeItemGroup
MaterialIsCoProduct MaterialIsCoProduct
AlternativeItemPriority AlternativeItemPriority
AlternativeItemStrategy AlternativeItemStrategy
IsALE IsALE
UsageProbabilityPercent UsageProbabilityPercent
IsPMAssemblyRelevant IsPMAssemblyRelevant
DocumentIsCreatedByCAD DocumentIsCreatedByCAD
DependencyObjectNumber DependencyObjectNumber
DiscontinuationGroup DiscontinuationGroup
LeadTimeOffset LeadTimeOffset
OperationLeadTimeOffset OperationLeadTimeOffset
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit
DistrKeyCompConsumption DistrKeyCompConsumption
IsPhantomItem IsPhantomItem
PurchasingGroup PurchasingGroup
DeliveryDurationInDays DeliveryDurationInDays
Creditor Creditor
MaterialComponentPrice MaterialComponentPrice
Currency Currency
CostElement CostElement
MaterialGroup MaterialGroup
GoodsReceiptDuration GoodsReceiptDuration
PurchasingOrganization PurchasingOrganization
PreliminaryMaterial PreliminaryMaterial
Size1 Size1
Size2 Size2
Size3 Size3
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3
QuantityVariableSizeItem QuantityVariableSizeItem
VariableSizeItemQuantity VariableSizeItemQuantity
VariableSizeItemUnit VariableSizeItemUnit
VariableSizeCompUnitOfMeasure VariableSizeCompUnitOfMeasure
FormulaKey FormulaKey
BOMItemDescription BOMItemDescription
BOMItemText2 BOMItemText2
DocumentType DocumentType
DocNumber DocNumber
DocumentVersion DocumentVersion
DocumentPart DocumentPart
ProdOrderIssueLocation ProdOrderIssueLocation
ProductionSupplyArea ProductionSupplyArea
ExplosionType ExplosionType
SpecialProcurementType SpecialProcurementType
ReferencePoint ReferencePoint
BOMItemRecordCreationDate BOMItemRecordCreationDate
BOMItemCreatedByUser BOMItemCreatedByUser
BOMItemLastChangeDate BOMItemLastChangeDate
BOMItemLastChangedByUser BOMItemLastChangedByUser
DgtlMockUpCharcsValue DgtlMockUpCharcsValue
_BOMItemCategoryText _BOMItemCategoryText
_DistrKeyText _DistrKeyText
_ExplosionTypeText _ExplosionTypeText
_SpecialProcTypeText _SpecialProcTypeText
_AltItemStrategyText _AltItemStrategyText
_ReferencePointText _ReferencePointText
_CostingRelevantText _CostingRelevantText
_MatProvisionIndText _MatProvisionIndText
_IssueLocationText _IssueLocationText
_ProdSupplyAreaText _ProdSupplyAreaText
_SparePartText _SparePartText
_SalesRelevantText _SalesRelevantText
_PurchasingOrgText _PurchasingOrgText
_PurchasingGroupText _PurchasingGroupText
_MaterialGroupText _MaterialGroupText
_SupplierText _SupplierText
_CostElementText _CostElementText
_MaterialText _MaterialText
_ProductionModel _ProductionModel
_HeaderComponentInstance _HeaderComponentInstance
@EndUserText.label: 'Production Model Component'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_BillOfMaterialItemExtension'],
  elementSuffix: 'PMC',

  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}
define view entity R_ProductionModelComponentTP
  as select from I_ProductionModelComponent as ProductionModelComponent
  association [1..1] to E_BillOfMaterialItemTP        as _BillOfMaterialItemExtension on  $projection.BillOfMaterial               = _BillOfMaterialItemExtension.BillOfMaterial
                                                                                      and $projection.BillOfMaterialCategory       = _BillOfMaterialItemExtension.BillOfMaterialCategory
                                                                                      and $projection.BillOfMaterialItemNodeNumber = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber
                                                                                      and $projection.BOMItemInternalChangeCount   = _BillOfMaterialItemExtension.BOMItemInternalChangeCount
  association        to parent R_ProductionModelTP    as _ProductionModel             on  _ProductionModel.ProductionModelUUID = $projection.ProductionModelUUID
  composition [0..*] of R_ProdnModComponentInstanceTP as _HeaderComponentInstance
{
  key ProductionModelUUID,
  key ProductionModelComponentUUID,
      BillOfMaterialCategory,
      Material,
      Plant,
      BillOfMaterialVariantUsage,
      BillOfMaterial,
      BillOfOperationsType,
      BillOfMaterialItemNodeNumber,
      ValidityStartDate,
      ValidityEndDate,
      EngineeringChangeDocument,
      ChgToEngineeringChgDocument,
      InheritedNodeNumberForBOMItem,
      InheritedNodeNumberVersionBOM,
      BOMItemInternalChangeCount,
      BillOfMaterialComponent,
      ComponentDescription,
      BillOfMaterialItemCategory,
      BillOfMaterialItemNumber,
      BillOfMaterialItemUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      BillOfMaterialItemQuantity,
      IsAssembly,
      IsSubItem,
      IsDeleted,
      IdentifierBOMItem,
      BOMItemSorter,
      BOMItemHasFixedQuantity,
      ComponentScrapInPercent,
      OperationScrapInPercent,
      IsNetScrap,
      IsBulkMaterial,
      IsBulkMaterialComponent,
      MaterialProvisionType,
      MatlComponentSparePartType,
      BOMItemSalesRelevancy,
      IsEngineeringRelevant,
      BOMItemIsPlantMaintRelevant,
      IsProductionRelevant,
      MaterialCompCostingRelevancy,
      BOMIsRecursive,
      IsBOMRecursiveAllowed,
      FollowUpGroup,
      AlternativeItemGroup,
      MaterialIsCoProduct,
      AlternativeItemPriority,
      AlternativeItemStrategy,
      IsALE,
      UsageProbabilityPercent,
      IsPMAssemblyRelevant,
      DocumentIsCreatedByCAD,
      DependencyObjectNumber,
      DiscontinuationGroup,
      LeadTimeOffset,
      OperationLeadTimeOffset,
      OpsLeadTimeOffsetUnit,
      DistrKeyCompConsumption,
      IsPhantomItem,
      PurchasingGroup,
      DeliveryDurationInDays,
      Creditor,
      @Semantics.amount.currencyCode : 'Currency'
      MaterialComponentPrice,
      //     MaterialPriceUnitQty,

      Currency,
      CostElement,
      MaterialGroup,
      GoodsReceiptDuration,
      PurchasingOrganization,
      PreliminaryMaterial,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      Size1,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      Size2,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      Size3,
      UnitOfMeasureForSize1To3,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeCompUnitOfMeasure'
      QuantityVariableSizeItem,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      VariableSizeItemQuantity,
      VariableSizeItemUnit,
      VariableSizeCompUnitOfMeasure,
      FormulaKey,
      BOMItemDescription,
      BOMItemText2,
      DocumentType,
      DocNumber,
      DocumentVersion,
      DocumentPart,
      ProdOrderIssueLocation,
      ProductionSupplyArea,
      ExplosionType,
      SpecialProcurementType,
      ReferencePoint,
      BOMItemRecordCreationDate,
      BOMItemCreatedByUser,
      BOMItemLastChangeDate,
      BOMItemLastChangedByUser,
      DgtlMockUpCharcsValue,
      /* Associations */
      _BOMItemCategoryText,
      _DistrKeyText,
      _ExplosionTypeText,
      _SpecialProcTypeText,
      _AltItemStrategyText,
      _ReferencePointText,
      _CostingRelevantText,
      _MatProvisionIndText,
      _IssueLocationText,
      _ProdSupplyAreaText,
      _SparePartText,
      _SalesRelevantText,
      _PurchasingOrgText,
      _PurchasingGroupText,
      _MaterialGroupText,
      _SupplierText,
      _CostElementText,
      _MaterialText,
      _ProductionModel,
      /* Compositions */
      _HeaderComponentInstance
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTIONMODELCOMPONENT"
],
"ASSOCIATED":
[
"I_ALTITEMSTRATEGYVH",
"I_BOMITEMCATEGORYTEXT",
"I_BOMITEMCOSTINGRELEVANT",
"I_BOMITEMSALESRELEVANT",
"I_BOMITEMSPAREPART",
"I_COSTELEMENTTEXT",
"I_EXPLOSIONTYPEVH",
"I_MATERIALGROUPTEXT",
"I_MATERIALTEXT",
"I_MATPROVISIONINDICATORVH",
"I_MRPQUANTITYDISTRKEYTEXT",
"I_PRODUCTIONSUPPLYAREATEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_REFERENCEPOINTVH",
"I_SPECIALPROCUREMENTTYPE",
"I_STORAGELOCATION",
"I_SUPPLIER",
"R_PRODNMODCOMPONENTINSTANCETP",
"R_PRODUCTIONMODELTP"
],
"BASE":
[
"I_PRODUCTIONMODELCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/