C_CFinRpldPurOrdScheduleLine

DDL: C_CFINRPLDPURORDSCHEDULELINE Type: view CONSUMPTION

CFin Rpld Purchase Order Schedule Line

C_CFinRpldPurOrdScheduleLine is a Consumption CDS View that provides data about "CFin Rpld Purchase Order Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_CFinRpldPurgDocScheduleLine) and exposes 22 fields with key fields SenderLogicalSystem, CFinReplicatedPurchaseOrder, CFinRpldPurchaseOrderItem, CFinRpldPurgDocScheduleLine. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CFinRpldPurgDocScheduleLine ScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_CFinRpldPurchaseOrder _CFinRpldPurchaseOrder $projection.SenderLogicalSystem = _CFinRpldPurchaseOrder.SenderLogicalSystem and $projection.CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrder.CFinReplicatedPurchaseOrder
[1..1] C_CFinRpldPurchaseOrderItem _CFinRpldPurchaseOrderItem $projection.SenderLogicalSystem = _CFinRpldPurchaseOrderItem.SenderLogicalSystem and $projection.CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrderItem.CFinReplicatedPurchaseOrder and $projection.CFinRpldPurchaseOrderItem = _CFinRpldPurchaseOrderItem.CFinRpldPurchaseOrderItem

Annotations (12)

NameValueLevelField
EndUserText.label CFin Rpld Purchase Order Schedule Line view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CCFINRPOSLN 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
Metadata.allowExtensions true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem I_CFinRpldPurgDocScheduleLine SenderLogicalSystem
KEY CFinReplicatedPurchaseOrder
KEY CFinRpldPurchaseOrderItem
KEY CFinRpldPurgDocScheduleLine
ScheduleLineDeliveryDate I_CFinRpldPurgDocScheduleLine ScheduleLineDeliveryDate
ScheduleLineOrderQuantity I_CFinRpldPurgDocScheduleLine ScheduleLineOrderQuantity
ScheduleLineOrderDate I_CFinRpldPurgDocScheduleLine ScheduleLineOrderDate
PerformancePeriodStartDate I_CFinRpldPurgDocScheduleLine PerformancePeriodStartDate
PerformancePeriodEndDate I_CFinRpldPurgDocScheduleLine PerformancePeriodEndDate
SchedLineStscDeliveryDate I_CFinRpldPurgDocScheduleLine SchedLineStscDeliveryDate
DelivDateCategory I_CFinRpldPurgDocScheduleLine DelivDateCategory
GoodsReceiptQuantity I_CFinRpldPurgDocScheduleLine GoodsReceiptQuantity
ScheduleLineIssuedQuantity I_CFinRpldPurgDocScheduleLine ScheduleLineIssuedQuantity
ScheduleLineDeliveryTime I_CFinRpldPurgDocScheduleLine ScheduleLineDeliveryTime
PurchasingSchdLnNrOfReminders I_CFinRpldPurgDocScheduleLine PurchasingSchdLnNrOfReminders
StockTransferDeliveredQuantity I_CFinRpldPurgDocScheduleLine StockTransferDeliveredQuantity
Batch I_CFinRpldPurgDocScheduleLine Batch
ScheduleLineCommittedQuantity I_CFinRpldPurgDocScheduleLine ScheduleLineCommittedQuantity
CommittedDeliveryDate I_CFinRpldPurgDocScheduleLine CommittedDeliveryDate
OrderQuantityUnit I_CFinRpldPurgDocScheduleLine OrderQuantityUnit
_CFinRpldPurchaseOrder _CFinRpldPurchaseOrder
_CFinRpldPurchaseOrderItem _CFinRpldPurchaseOrderItem
@EndUserText.label: 'CFin Rpld Purchase Order Schedule Line'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #CONSUMPTION,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'CCFINRPOSLN',
preserveKey: true,
compiler.compareFilter: true
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L
}
}
@Metadata.allowExtensions: true

@ObjectModel.semanticKey: ['SenderLogicalSystem','CFinReplicatedPurchaseOrder','CFinRpldPurchaseOrderItem', 'CFinRpldPurgDocScheduleLine']

define view C_CFinRpldPurOrdScheduleLine
  as select from I_CFinRpldPurgDocScheduleLine as ScheduleLine
  association [1..1] to C_CFinRpldPurchaseOrder     as _CFinRpldPurchaseOrder     on  $projection.SenderLogicalSystem         = _CFinRpldPurchaseOrder.SenderLogicalSystem
                                                                                  and $projection.CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrder.CFinReplicatedPurchaseOrder
  association [1..1] to C_CFinRpldPurchaseOrderItem as _CFinRpldPurchaseOrderItem on  $projection.SenderLogicalSystem         = _CFinRpldPurchaseOrderItem.SenderLogicalSystem
                                                                                  and $projection.CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrderItem.CFinReplicatedPurchaseOrder
                                                                                  and $projection.CFinRpldPurchaseOrderItem   = _CFinRpldPurchaseOrderItem.CFinRpldPurchaseOrderItem
{
      @UI.hidden: true
  key ScheduleLine.SenderLogicalSystem,
      @UI.hidden: true
  key cast( ScheduleLine.CFinRpldPurchasingDocument as fins_cfin_av_rpld_purord preserving type )          as CFinReplicatedPurchaseOrder,
      @UI.hidden: true
  key cast( ScheduleLine.CFinRpldPurchasingDocumentItem as fins_cfin_av_rpld_purord_item preserving type ) as CFinRpldPurchaseOrderItem,
      @EndUserText: { quickInfo: 'Delivery Schedule Line Counter'}
      @UI: { lineItem: [ { position: 10, importance: #HIGH } ] }
  key cast( ScheduleLine.CFinRpldPurgDocScheduleLine as eeten preserving type )                            as CFinRpldPurgDocScheduleLine,
      @EndUserText: { quickInfo: 'Delivery Date'}
      @UI: { lineItem: [ { position: 20, importance: #HIGH } ] }
      ScheduleLine.ScheduleLineDeliveryDate                                                                as ScheduleLineDeliveryDate,
      @UI: { lineItem: [ { position: 30, importance: #HIGH } ] }
      ScheduleLine.ScheduleLineOrderQuantity,
      @EndUserText: { quickInfo: 'Order Date of Schedule Line' }
      @UI: { lineItem: [ { position: 40, importance: #HIGH } ] }
      ScheduleLine.ScheduleLineOrderDate,
      @EndUserText: {
        label    : 'Start of Performance Period',
        quickInfo: 'Start of Performance Period'
      }
      @UI: { lineItem: [ { position: 50, importance: #HIGH } ] }
      ScheduleLine.PerformancePeriodStartDate                                                              as PerformancePeriodStartDate,
      @EndUserText: {
              label    : 'End of Performance Period',
              quickInfo: 'End of Performance Period'
            }
      @UI: { lineItem: [ { position: 60, importance: #HIGH } ] }
      ScheduleLine.PerformancePeriodEndDate                                                                as PerformancePeriodEndDate,

      @UI.hidden: true
      ScheduleLine.SchedLineStscDeliveryDate,
      @UI.hidden: true
      ScheduleLine.DelivDateCategory,
      @UI.hidden: true
      ScheduleLine.GoodsReceiptQuantity,
      @UI.hidden: true
      ScheduleLine.ScheduleLineIssuedQuantity,
      @UI.hidden: true
      ScheduleLine.ScheduleLineDeliveryTime,
      @UI.hidden: true
      ScheduleLine.PurchasingSchdLnNrOfReminders,
      @UI.hidden: true
      ScheduleLine.StockTransferDeliveredQuantity,
      @UI.hidden: true
      ScheduleLine.Batch,
      @UI.hidden: true
      ScheduleLine.ScheduleLineCommittedQuantity,
      @UI.hidden: true
      ScheduleLine.CommittedDeliveryDate,

      @UI.hidden: true
      ScheduleLine.OrderQuantityUnit,

      _CFinRpldPurchaseOrder,
      _CFinRpldPurchaseOrderItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINRPLDPURGDOCSCHEDULELINE"
],
"ASSOCIATED":
[
"C_CFINRPLDPURCHASEORDER",
"C_CFINRPLDPURCHASEORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/