I_CFinPurgDocScheduleLine

DDL: I_CFINPURGDOCSCHEDULELINE Type: view COMPOSITE Package: FINS_CFIN_ACC_VIEW_API

CFin Purchasing Document: Schedule Line

I_CFinPurgDocScheduleLine is a Composite CDS View that provides data about "CFin Purchasing Document: Schedule Line" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentItem, I_PurgDocScheduleLine) and exposes 25 fields with key fields SenderLogicalSystem, CFinPurchasingDocument, CFinPurchasingDocumentItem, CFinPurgDocScheduleLine. It has 4 associations to related views. Part of development package FINS_CFIN_ACC_VIEW_API.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentItem PurchasingDocumentItem inner
I_PurgDocScheduleLine PurgDocScheduleLine from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CFinPurchasingDocument _CFinPurchasingDocument $projection.CFinPurchasingDocument = _CFinPurchasingDocument.CFinPurchasingDocument and $projection.SenderLogicalSystem = _CFinPurchasingDocument.SenderLogicalSystem
[1..1] I_CFinPurchasingDocumentItem _CFinPurchasingDocumentItem $projection.SenderLogicalSystem = _CFinPurchasingDocumentItem.SenderLogicalSystem and $projection.CFinPurchasingDocument = _CFinPurchasingDocumentItem.CFinPurchasingDocument and $projection.CFinPurchasingDocumentItem = _CFinPurchasingDocumentItem.CFinPurchasingDocumentItem
[0..1] I_UnitOfMeasure _OrderQuantityUnit $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
[0..1] I_LogicalSystem _LogicalSystem $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

Annotations (11)

NameValueLevelField
EndUserText.label CFin Purchasing Document: Schedule Line view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICFINPOSLN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem
KEY CFinPurchasingDocument
KEY CFinPurchasingDocumentItem
KEY CFinPurgDocScheduleLine
ScheduleLineDeliveryDate I_PurgDocScheduleLine ScheduleLineDeliveryDate
SchedLineStscDeliveryDate I_PurgDocScheduleLine SchedLineStscDeliveryDate
DelivDateCategory I_PurgDocScheduleLine DelivDateCategory
ScheduleLineOrderQuantity I_PurgDocScheduleLine ScheduleLineOrderQuantity
GoodsReceiptQuantity I_PurgDocScheduleLine GoodsReceiptQuantity
ScheduleLineIssuedQuantity I_PurgDocScheduleLine ScheduleLineIssuedQuantity
ScheduleLineDeliveryTime I_PurgDocScheduleLine ScheduleLineDeliveryTime
PurchasingSchdLnNrOfReminders I_PurgDocScheduleLine NoOfRemindersOfScheduleLine
ScheduleLineOrderDate I_PurgDocScheduleLine ScheduleLineOrderDate
StockTransferDeliveredQuantity I_PurgDocScheduleLine StockTransferDeliveredQuantity
Batch I_PurgDocScheduleLine Batch
ScheduleLineCommittedQuantity I_PurgDocScheduleLine ScheduleLineCommittedQuantity
CommittedDeliveryDate I_PurgDocScheduleLine CommittedDeliveryDate
PerformancePeriodStartDate I_PurgDocScheduleLine PerformancePeriodStartDate
PerformancePeriodEndDate I_PurgDocScheduleLine PerformancePeriodEndDate
OrderQuantityUnit I_PurchasingDocumentItem OrderQuantityUnit
_CFinPurchasingDocument _CFinPurchasingDocument
_CFinPurchasingDocumentItem _CFinPurchasingDocumentItem
_DeliveryDateCategory _DeliveryDateCategory
_OrderQuantityUnit _OrderQuantityUnit
_LogicalSystem _LogicalSystem 
@EndUserText.label: 'CFin Purchasing Document: Schedule Line'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'ICFINPOSLN',
preserveKey: true,
compiler.compareFilter: true
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
}
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_CFinPurgDocScheduleLine
  as select from I_PurgDocScheduleLine    as PurgDocScheduleLine
    inner join   I_PurchasingDocumentItem as PurchasingDocumentItem on  PurgDocScheduleLine.PurchasingDocument     = PurchasingDocumentItem.PurchasingDocument
                                                                    and PurgDocScheduleLine.PurchasingDocumentItem = PurchasingDocumentItem.PurchasingDocumentItem

  association [1..1] to I_CFinPurchasingDocument     as _CFinPurchasingDocument     on  $projection.CFinPurchasingDocument = _CFinPurchasingDocument.CFinPurchasingDocument
                                                                                    and $projection.SenderLogicalSystem    = _CFinPurchasingDocument.SenderLogicalSystem

  association [1..1] to I_CFinPurchasingDocumentItem as _CFinPurchasingDocumentItem on  $projection.SenderLogicalSystem        = _CFinPurchasingDocumentItem.SenderLogicalSystem
                                                                                    and $projection.CFinPurchasingDocument     = _CFinPurchasingDocumentItem.CFinPurchasingDocument
                                                                                    and $projection.CFinPurchasingDocumentItem = _CFinPurchasingDocumentItem.CFinPurchasingDocumentItem

  association [0..1] to I_UnitOfMeasure              as _OrderQuantityUnit          on  $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure


  association [0..1] to I_LogicalSystem              as _LogicalSystem              on  $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem

{

      @ObjectModel.foreignKey.association: '_LogicalSystem'
  key cast( '          ' as logsys preserving type  )                                                       as SenderLogicalSystem,
      @ObjectModel.foreignKey.association: '_CFinPurchasingDocument'
  key cast( PurgDocScheduleLine.PurchasingDocument as fins_cfin_av_purchasing_doc preserving type )         as CFinPurchasingDocument,
      @ObjectModel.foreignKey.association: '_CFinPurchasingDocumentItem'
  key cast( PurgDocScheduleLine.PurchasingDocumentItem as fins_cfin_av_purg_document_itm preserving type  ) as CFinPurchasingDocumentItem,
  key cast( PurgDocScheduleLine.ScheduleLine as fins_cfin_av_purg_doc_sln preserving type )                 as CFinPurgDocScheduleLine,
      PurgDocScheduleLine.ScheduleLineDeliveryDate,
      PurgDocScheduleLine.SchedLineStscDeliveryDate,
      @ObjectModel.foreignKey.association: '_DeliveryDateCategory'
      PurgDocScheduleLine.DelivDateCategory,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PurgDocScheduleLine.ScheduleLineOrderQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PurgDocScheduleLine.GoodsReceiptQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PurgDocScheduleLine.ScheduleLineIssuedQuantity,
      PurgDocScheduleLine.ScheduleLineDeliveryTime,
      PurgDocScheduleLine.NoOfRemindersOfScheduleLine                                                       as PurchasingSchdLnNrOfReminders,
      PurgDocScheduleLine.ScheduleLineOrderDate,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PurgDocScheduleLine.StockTransferDeliveredQuantity,
      PurgDocScheduleLine.Batch,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PurgDocScheduleLine.ScheduleLineCommittedQuantity,
      PurgDocScheduleLine.CommittedDeliveryDate,
      PurgDocScheduleLine.PerformancePeriodStartDate,
      PurgDocScheduleLine.PerformancePeriodEndDate,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      PurchasingDocumentItem.OrderQuantityUnit,


      _CFinPurchasingDocument,
      _CFinPurchasingDocumentItem,
      _DeliveryDateCategory,
      _OrderQuantityUnit,
      _LogicalSystem

}

Learn More