A_POSubcontractingComponent

DDL: A_POSUBCONTRACTINGCOMPONENT SQL: APURORDSUBCOMP Type: view COMPOSITE

Subcontracting Components

A_POSubcontractingComponent is a Composite CDS View that provides data about "Subcontracting Components" in SAP S/4HANA. It reads from 1 data source (R_POSubcontractingComponent) and exposes 18 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] A_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] A_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName APURORDSUBCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Subcontracting Components view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name A_POSubcontractingComponent view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine PurchaseOrderScheduleLine
KEY ReservationItem ReservationItem
KEY RecordType RecordType
Material Material
BOMItemDescription
RequiredQuantity RequiredQuantity
BaseUnit BaseUnit
RequirementDate RequirementDate
QuantityInEntryUnit QuantityInEntryUnit
EntryUnit EntryUnit
WithdrawnQuantity WithdrawnQuantity
Plant Plant
Batch Batch
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_ScheduleLine _ScheduleLine
@AbapCatalog.sqlViewName: 'APURORDSUBCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Subcontracting Components'
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_POSubcontractingComponent'
////@Objectmodel.representativeKey: 'ReservationItem'

////@Objectmodel: {

// createEnabled: true,

// updateEnabled: true,

// deleteEnabled: true

//}


define view A_POSubcontractingComponent
  as select from R_POSubcontractingComponent
  association to parent A_PurchaseOrderScheduleLine as _ScheduleLine      on  $projection.PurchaseOrder     = _ScheduleLine.PurchasingDocument
                                                                          and $projection.PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem
                                                                          and $projection.ScheduleLine      = _ScheduleLine.ScheduleLine
  association [1..1] to A_PurchaseOrder             as _PurchaseOrder     on  $projection.PurchaseOrder     = _PurchaseOrder.PurchaseOrder
  association [1..1] to A_PurchaseOrderItem         as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                          and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
{
  key PurchaseOrder,
  key PurchaseOrderItem,
  key PurchaseOrderScheduleLine                     as ScheduleLine,
  //@Objectmodel.readOnly: null

  key ReservationItem,
  //@Objectmodel.readOnly: null

  key RecordType,
      Material,
      
      //BillOfMaterialItemNumber, // default value is 9999

      
      //@Objectmodel.readOnly: null

      cast(BOMItemDescription as potx1_ll preserving type ) as BOMItemDescription,
      //@Objectmodel.readOnly: null

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      RequiredQuantity,
      //@Objectmodel.readOnly: null

      @Semantics.unitOfMeasure: true
      BaseUnit,       
      @Semantics.businessDate.at:true     
      RequirementDate,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      EntryUnit,
      //@Objectmodel.readOnly: null

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      WithdrawnQuantity,      
      Plant,
      //@Objectmodel.readOnly: null

      Batch,



      //@Objectmodel.association.type: #TO_COMPOSITION_ROOT

      _PurchaseOrder,
      _PurchaseOrderItem,
      //@Objectmodel.association.type: #TO_COMPOSITION_PARENT

      _ScheduleLine
} where _PurchaseOrderItem.PurchaseOrderItemCategory = '3' and _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_PURCHASEORDERITEM",
"R_POSUBCONTRACTINGCOMPONENT"
],
"ASSOCIATED":
[
"A_PURCHASEORDER",
"A_PURCHASEORDERITEM",
"A_PURCHASEORDERSCHEDULELINE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/