R_POSubcontractingComponentTP

DDL: R_POSUBCONTRACTINGCOMPONENTTP Type: view_entity TRANSACTIONAL

PO Subcontracting Components TP view

R_POSubcontractingComponentTP is a Transactional CDS View that provides data about "PO Subcontracting Components TP view" in SAP S/4HANA. It reads from 1 data source (R_POSubcontractingComponent) and exposes 65 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, ReservationItem, RecordType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_POSubcontractingComponent R_POSubcontractingComponent from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] R_PurchaseOrderItemTP _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label PO Subcontracting Components TP view view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine PurchaseOrderScheduleLine
KEY ReservationItem ReservationItem
KEY RecordType RecordType
Material Material
IsMaterialProvision IsMaterialProvision
MaterialProvisionType MaterialProvisionType
MaterialQtyToBaseQtyNmrtr MaterialQtyToBaseQtyNmrtr
MaterialQtyToBaseQtyDnmntr MaterialQtyToBaseQtyDnmntr
MaterialRevisionLevel
MaterialCompIsVariableSized MaterialCompIsVariableSized
MaterialComponentIsPhantomItem MaterialComponentIsPhantomItem
Reservation Reservation
RequiredQuantity RequiredQuantity
RequirementDate RequirementDate
RequirementTime RequirementTime
ReservationIsFinallyIssued ReservationIsFinallyIssued
BaseUnit BaseUnit
QuantityInEntryUnit QuantityInEntryUnit
EntryUnit EntryUnit
VariableSizeItemQuantity VariableSizeItemQuantity
VariableSizeItemUnit VariableSizeItemUnit
VariableSizeComponentUnit VariableSizeComponentUnit
VariableSizeComponentQuantity VariableSizeComponentQuantity
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3
Size1 Size1
Size2 Size2
Size3 Size3
Plant Plant
LatestRequirementDate LatestRequirementDate
OrderLevelValue OrderLevelValue
OrderPathValue OrderPathValue
BillOfMaterialItemNumber
MatlCompFreeDefinedAttribute SortField
BOMItemCategory BOMItemCategory
IsBulkMaterialComponent IsBulkMaterialComponent
AccountAssignmentCategory AccountAssignmentCategory
InventorySpecialStockType InventorySpecialStockType
ConsumptionPosting ConsumptionPosting
InventorySpecialStockValnType InventorySpecialStockValnType
DebitCreditCode DebitCreditCode
WithdrawnQuantity WithdrawnQuantity
QuantityIsFixed QuantityIsFixed
ComponentScrapInPercent ComponentScrapInPercent
OperationScrapInPercent OperationScrapInPercent
IsNetScrap IsNetScrap
LeadTimeOffset LeadTimeOffset
QuantityDistributionKey QuantityDistributionKey
FormulaKey FormulaKey
StorageLocation StorageLocation
ProductionSupplyArea ProductionSupplyArea
Batch Batch
BOMItemDescription BOMItemDescription
BOMItemText2 BOMItemText2
ChangeNumber ChangeNumber
_BaseUnit _BaseUnit
_EntryUnit _EntryUnit
_Material _Material
_Product _Product
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_ScheduleLine _ScheduleLine
_VariableSize1To3Unit _VariableSize1To3Unit
_VariableSizeCompUnit _VariableSizeCompUnit
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { authorizationCheck: #CHECK}
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'PO Subcontracting Components TP view'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_POSubcontractingComponentTP
  as select from R_POSubcontractingComponent

  association [1..1] to R_PurchaseOrderTP                    as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

  association [1..1] to R_PurchaseOrderItemTP                as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                                   and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

  association        to parent R_PurchaseOrderScheduleLineTP as _ScheduleLine      on  $projection.PurchaseOrder     = _ScheduleLine.PurchaseOrder
                                                                                   and $projection.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem
                                                                                   and $projection.ScheduleLine      = _ScheduleLine.ScheduleLine
{
      // Keys

  key PurchaseOrder,
  key PurchaseOrderItem,
  key PurchaseOrderScheduleLine                                     as ScheduleLine,
  key ReservationItem,
  key RecordType,

      // Material data

      Material,
      @Semantics.booleanIndicator: true
      IsMaterialProvision,
      MaterialProvisionType,
      MaterialQtyToBaseQtyNmrtr,
      MaterialQtyToBaseQtyDnmntr,
      cast( MaterialRevisionLevel as vdm_qm_revlv preserving type ) as MaterialRevisionLevel,
      MaterialCompIsVariableSized,
      MaterialComponentIsPhantomItem,

      // Reservation and Requirements

      Reservation,
      RequiredQuantity,
      RequirementDate,
      RequirementTime,
      ReservationIsFinallyIssued,

      // Amount and Units

      BaseUnit,
      QuantityInEntryUnit,

      EntryUnit,


      VariableSizeItemQuantity,
      VariableSizeItemUnit,
      VariableSizeComponentUnit,
      VariableSizeComponentQuantity,
      UnitOfMeasureForSize1To3,
      Size1,
      Size2,
      Size3,

      // The other fields

      Plant,
      LatestRequirementDate,
      OrderLevelValue,
      OrderPathValue,
      cast( BillOfMaterialItemNumber as vdm_sposn preserving type ) as BillOfMaterialItemNumber,
      SortField                                                     as MatlCompFreeDefinedAttribute,
      BOMItemCategory,
      IsBulkMaterialComponent,
      AccountAssignmentCategory,
      InventorySpecialStockType,
      ConsumptionPosting,
      InventorySpecialStockValnType,
      DebitCreditCode,
      WithdrawnQuantity,

      QuantityIsFixed,
      ComponentScrapInPercent,
      OperationScrapInPercent,
      IsNetScrap,
      LeadTimeOffset,
      QuantityDistributionKey,
      FormulaKey,
      StorageLocation,
      ProductionSupplyArea,
      Batch,
      BOMItemDescription,
      BOMItemText2,
      ChangeNumber,

      // TODO's

      // Fields exist in POPARTNER (BAPIEKKOP) and should be added to CDS view

      // ENTRY_UOM_ISO

      // CHANGE_ID

      // MATERIAL_EXTERNAL

      // MATERIAL_GUID

      // MATERIAL_VERSION

      // BASE_UOM

      // BASE_UOM_ISO

      // REQ_SEGMENT

      // MATERIAL_LONG

      // REQ_SEG_LONG


      /* Associations */
      _BaseUnit,
      _EntryUnit,
      _Material,
      _Product,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _ScheduleLine,
      _VariableSize1To3Unit,
      _VariableSizeCompUnit
}
where
  _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_POSUBCONTRACTINGCOMPONENT",
"R_PURCHASEORDERITEMTP"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PRODUCT",
"I_UNITOFMEASURE",
"R_PURCHASEORDERITEMTP",
"R_PURCHASEORDERSCHEDULELINETP",
"R_PURCHASEORDERTP"
],
"BASE":
[
"R_POSUBCONTRACTINGCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/