I_POSubcontractingCompAPI01

DDL: I_POSUBCONTRACTINGCOMPAPI01 SQL: IMMPOSUBCOMP Type: view BASIC Package: VDM_MM_PUR_PO_PUBLIC

Subcontracting Component in PurOrd

I_POSubcontractingCompAPI01 is a Basic CDS View that provides data about "Subcontracting Component in PurOrd" in SAP S/4HANA. It reads from 1 data source (R_POSubcontractingComponent) and exposes 69 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderScheduleLine, ReservationItem, RecordType. It has 3 associations to related views. Part of development package VDM_MM_PUR_PO_PUBLIC.

Data Sources (1)

SourceAliasJoin Type
R_POSubcontractingComponent R_POSubcontractingComponent from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderAPI01 _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItemAPI01 _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
[1..1] I_PurOrdScheduleLineAPI01 _ScheduleLine $projection.PurchaseOrder = _ScheduleLine.PurchaseOrder and $projection.PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem and $projection.PurchaseOrderScheduleLine = _ScheduleLine.PurchaseOrderScheduleLine

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IMMPOSUBCOMP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Subcontracting Component in PurOrd view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY PurchaseOrderScheduleLine PurchaseOrderScheduleLine
KEY ReservationItem ReservationItem
KEY RecordType RecordType
Reservation Reservation
Material Material
BaseUnit BaseUnit
RequiredQuantity RequiredQuantity
WithdrawnQuantity WithdrawnQuantity
QuantityIsFixed QuantityIsFixed
RequirementDate RequirementDate
RequirementTime RequirementTime
Plant Plant
LatestRequirementDate LatestRequirementDate
OrderLevelValue OrderLevelValue
OrderPathValue OrderPathValue
BillOfMaterialItemNumber
BillOfMaterialItemNumber_2 BillOfMaterialItemNumber
SortField SortField
BOMItemCategory BOMItemCategory
MaterialComponentIsPhantomItem MaterialComponentIsPhantomItem
IsBulkMaterialComponent IsBulkMaterialComponent
AccountAssignmentCategory AccountAssignmentCategory
InventorySpecialStockType InventorySpecialStockType
ConsumptionPosting ConsumptionPosting
InventorySpecialStockValnType InventorySpecialStockValnType
IsMaterialProvision IsMaterialProvision
MaterialProvisionType MaterialProvisionType
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementInternalID WBSElementInternalID
DebitCreditCode DebitCreditCode
ReservationIsFinallyIssued ReservationIsFinallyIssued
EntryUnit EntryUnit
QuantityInEntryUnit QuantityInEntryUnit
MaterialQtyToBaseQtyNmrtr MaterialQtyToBaseQtyNmrtr
MaterialQtyToBaseQtyDnmntr MaterialQtyToBaseQtyDnmntr
ComponentScrapInPercent ComponentScrapInPercent
OperationScrapInPercent OperationScrapInPercent
IsNetScrap IsNetScrap
LeadTimeOffset LeadTimeOffset
QuantityDistributionKey QuantityDistributionKey
MaterialRevisionLevel
MaterialRevisionLevel_2 MaterialRevisionLevel
MaterialCompIsVariableSized MaterialCompIsVariableSized
NumberOfVariableSizeComponents NumberOfVariableSizeComponents
VariableSizeItemUnit VariableSizeItemUnit
VariableSizeItemQuantity VariableSizeItemQuantity
VariableSizeComponentUnit VariableSizeComponentUnit
VariableSizeComponentQuantity VariableSizeComponentQuantity
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3
Size1 Size1
Size2 Size2
Size3 Size3
FormulaKey FormulaKey
StorageLocation StorageLocation
ProductionSupplyArea ProductionSupplyArea
Batch Batch
BOMItemDescription BOMItemDescription
BOMItemText2 BOMItemText2
ChangeNumber ChangeNumber
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_ScheduleLine _ScheduleLine
_VariableSize1To3Unit _VariableSize1To3Unit
_VariableSizeCompUnit _VariableSizeCompUnit
_BaseUnit _BaseUnit
_EntryUnit _EntryUnit
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IMMPOSUBCOMP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Subcontracting Component in PurOrd'

define view I_POSubcontractingCompAPI01
  as select from R_POSubcontractingComponent

  association [1..1] to I_PurchaseOrderAPI01      as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [1..1] to I_PurchaseOrderItemAPI01  as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                        and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [1..1] to I_PurOrdScheduleLineAPI01 as _ScheduleLine      on  $projection.PurchaseOrder             = _ScheduleLine.PurchaseOrder
                                                                        and $projection.PurchaseOrderItem         = _ScheduleLine.PurchaseOrderItem
                                                                        and $projection.PurchaseOrderScheduleLine = _ScheduleLine.PurchaseOrderScheduleLine



{

      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchaseOrder,
      @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
  key PurchaseOrderItem,
      @ObjectModel.foreignKey.association: '_ScheduleLine'
  key PurchaseOrderScheduleLine,
  key ReservationItem,
  key RecordType,
      Reservation,
      Material,
      @Semantics.unitOfMeasure: true
      BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      WithdrawnQuantity,
      QuantityIsFixed,
      RequirementDate,
      RequirementTime,
      Plant,
      LatestRequirementDate,
      OrderLevelValue,
      OrderPathValue,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'BillOfMaterialItemNumber_2'
      cast (BillOfMaterialItemNumber as aposn preserving type ) as BillOfMaterialItemNumber,
      BillOfMaterialItemNumber as BillOfMaterialItemNumber_2,
      SortField,
      BOMItemCategory,
      MaterialComponentIsPhantomItem,
      IsBulkMaterialComponent,
      AccountAssignmentCategory,
      InventorySpecialStockType,
      ConsumptionPosting,
      InventorySpecialStockValnType,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'MaterialProvisionType'
      IsMaterialProvision,
      MaterialProvisionType,
      SalesOrder,
      SalesOrderItem,
      WBSElementInternalID,
      DebitCreditCode,
      ReservationIsFinallyIssued,
      @Semantics.unitOfMeasure: true
      EntryUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      QuantityInEntryUnit,
      MaterialQtyToBaseQtyNmrtr,
      MaterialQtyToBaseQtyDnmntr,
      ComponentScrapInPercent,
      OperationScrapInPercent,
      IsNetScrap,
      LeadTimeOffset,
      QuantityDistributionKey,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'MaterialRevisionLevel_2'
      cast (MaterialRevisionLevel as revlv preserving type ) as MaterialRevisionLevel,
      MaterialRevisionLevel as MaterialRevisionLevel_2,
      MaterialCompIsVariableSized,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'VariableSizeItemQuantity'
      NumberOfVariableSizeComponents,
      @Semantics.unitOfMeasure: true
      VariableSizeItemUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      VariableSizeItemQuantity,      
      @Semantics.unitOfMeasure: true
      VariableSizeComponentUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      VariableSizeComponentQuantity,
      @Semantics.unitOfMeasure: true
      UnitOfMeasureForSize1To3,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      Size1,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      Size2,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      Size3,
      FormulaKey,
      StorageLocation,
      ProductionSupplyArea,
      Batch,
      BOMItemDescription,
      BOMItemText2,
      ChangeNumber,

      _PurchaseOrder,
      _PurchaseOrderItem,
      _ScheduleLine,
      _VariableSize1To3Unit,
      _VariableSizeCompUnit,
      _BaseUnit,
      _EntryUnit


}