I_CFinPurgDocScheduleLine

Q: Which tables does I_CFinPurgDocScheduleLine use?

I_CFinPurgDocScheduleLine reads from 3 data source(s): I_CFinRpldPurgDocScheduleLine, I_PurchasingDocumentItem, I_PurgDocScheduleLine.

Q: How many fields does I_CFinPurgDocScheduleLine have?

I_CFinPurgDocScheduleLine has 48 fields. Key fields: SenderLogicalSystem, CFinPurchasingDocument, CFinPurchasingDocumentItem, CFinPurgDocScheduleLine, CFinPurchasingDocument.

DDL: I_CFINPURGDOCSCHEDULELINE Type: view COMPOSITE

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 3 data sources (I_CFinRpldPurgDocScheduleLine, I_PurchasingDocumentItem, I_PurgDocScheduleLine) and exposes 48 fields with key fields SenderLogicalSystem, CFinPurchasingDocument, CFinPurchasingDocumentItem, CFinPurgDocScheduleLine, CFinPurchasingDocument. It has 4 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_CFinRpldPurgDocScheduleLine	CFinRpldPurgDocScheduleLine	from
I_PurchasingDocumentItem	PurchasingDocumentItem	inner
I_PurgDocScheduleLine	PurgDocScheduleLine	union_all

Associations (4)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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	#L	view

Fields (48)

Key	Field	Source Table	Source Field
KEY	SenderLogicalSystem		SenderLogicalSystem
KEY	CFinPurchasingDocument
KEY	CFinPurchasingDocumentItem
KEY	CFinPurgDocScheduleLine
	ScheduleLineDeliveryDate		ScheduleLineDeliveryDate
	SchedLineStscDeliveryDate		SchedLineStscDeliveryDate
	DelivDateCategory		DelivDateCategory
	ScheduleLineOrderQuantity		ScheduleLineOrderQuantity
	GoodsReceiptQuantity		GoodsReceiptQuantity
	ScheduleLineIssuedQuantity		ScheduleLineIssuedQuantity
	ScheduleLineDeliveryTime		ScheduleLineDeliveryTime
	PurchasingSchdLnNrOfReminders		PurchasingSchdLnNrOfReminders
	ScheduleLineOrderDate		ScheduleLineOrderDate
	StockTransferDeliveredQuantity		StockTransferDeliveredQuantity
	Batch		Batch
	ScheduleLineCommittedQuantity		ScheduleLineCommittedQuantity
	CommittedDeliveryDate		CommittedDeliveryDate
	PerformancePeriodStartDate		PerformancePeriodStartDate
	PerformancePeriodEndDate		PerformancePeriodEndDate
	OrderQuantityUnit		OrderQuantityUnit
	_CFinPurchasingDocument		_CFinPurchasingDocument
	_CFinPurchasingDocumentItem		_CFinPurchasingDocumentItem
	_DeliveryDateCategory		_DeliveryDateCategory
	_OrderQuantityUnit		_OrderQuantityUnit
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: #L
}
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_CFinPurgDocScheduleLine
  as select from I_CFinRpldPurgDocScheduleLine as CFinRpldPurgDocScheduleLine

  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
{

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


      _CFinPurchasingDocument,
      _CFinPurchasingDocumentItem,
      _DeliveryDateCategory,
      _OrderQuantityUnit,
      _LogicalSystem

}

union all 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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINRPLDPURGDOCSCHEDULELINE",
"I_PURCHASINGDOCUMENTITEM",
"I_PURGDOCSCHEDULELINE"
],
"ASSOCIATED":
[
"I_CFINPURCHASINGDOCUMENT",
"I_CFINPURCHASINGDOCUMENTITEM",
"I_DELIVERYDATECATEGORY",
"I_LOGICALSYSTEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_CFINRPLDPURGDOCSCHEDULELINE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_CFinPurgDocScheduleLine view