C_CFinRpldPurOrdScheduleLine

DDL: C_CFINRPLDPURORDSCHEDULELINE Type: view CONSUMPTION Package: FINS_CFIN_ACC_VIEW
22 Fields 1 Data Sources 2 Associations 1 OData Services

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. It is exposed through 1 OData service (UI_CFINRPLDPURCHASEORDER). Part of development package FINS_CFIN_ACC_VIEW.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_CFINRPLDPURCHASEORDER UI_CFINRPLDPURCHASEORDER V2 C1 NOT_RELEASED

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem I_CFinRpldPurgDocScheduleLine SenderLogicalSystem Sender Logical System
KEY CFinReplicatedPurchaseOrder
KEY CFinRpldPurchaseOrderItem
KEY CFinRpldPurgDocScheduleLine
ScheduleLineDeliveryDate I_CFinRpldPurgDocScheduleLine ScheduleLineDeliveryDate Delivery Date
ScheduleLineOrderQuantity I_CFinRpldPurgDocScheduleLine ScheduleLineOrderQuantity Scheduled Qty
ScheduleLineOrderDate I_CFinRpldPurgDocScheduleLine ScheduleLineOrderDate PurchOrderDate
PerformancePeriodStartDate I_CFinRpldPurgDocScheduleLine PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_CFinRpldPurgDocScheduleLine PerformancePeriodEndDate End of Performance Period
SchedLineStscDeliveryDate I_CFinRpldPurgDocScheduleLine SchedLineStscDeliveryDate Stat. Del. Date
DelivDateCategory I_CFinRpldPurgDocScheduleLine DelivDateCategory Delivery Date
GoodsReceiptQuantity I_CFinRpldPurgDocScheduleLine GoodsReceiptQuantity Delivered
ScheduleLineIssuedQuantity I_CFinRpldPurgDocScheduleLine ScheduleLineIssuedQuantity Issued
ScheduleLineDeliveryTime I_CFinRpldPurgDocScheduleLine ScheduleLineDeliveryTime Time
PurchasingSchdLnNrOfReminders I_CFinRpldPurgDocScheduleLine PurchasingSchdLnNrOfReminders No. Rem./Exp.
StockTransferDeliveredQuantity I_CFinRpldPurgDocScheduleLine StockTransferDeliveredQuantity Qty Delivered
Batch I_CFinRpldPurgDocScheduleLine Batch Lot No.
ScheduleLineCommittedQuantity I_CFinRpldPurgDocScheduleLine ScheduleLineCommittedQuantity Committed Qty
CommittedDeliveryDate I_CFinRpldPurgDocScheduleLine CommittedDeliveryDate Finish date
OrderQuantityUnit I_CFinRpldPurgDocScheduleLine OrderQuantityUnit Sales Unit
_CFinRpldPurchaseOrder _CFinRpldPurchaseOrder
_CFinRpldPurchaseOrderItem _CFinRpldPurchaseOrderItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CFinRpldPurOrdScheduleLine.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_CFinRpldPurOrdScheduleLine AS
SELECT
  ScheduleLine.SenderLogicalSystem AS SenderLogicalSystem,
  cast( ScheduleLine.CFinRpldPurchasingDocument as fins_cfin_av_rpld_purord preserving type ) AS CFinReplicatedPurchaseOrder,
  cast( ScheduleLine.CFinRpldPurchasingDocumentItem as fins_cfin_av_rpld_purord_item preserving type ) AS CFinRpldPurchaseOrderItem,
  cast( ScheduleLine.CFinRpldPurgDocScheduleLine as eeten preserving type ) AS CFinRpldPurgDocScheduleLine,
  ScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  ScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  ScheduleLine.ScheduleLineOrderDate AS ScheduleLineOrderDate,
  ScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  ScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  ScheduleLine.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  ScheduleLine.DelivDateCategory AS DelivDateCategory,
  ScheduleLine.GoodsReceiptQuantity AS GoodsReceiptQuantity,
  ScheduleLine.ScheduleLineIssuedQuantity AS ScheduleLineIssuedQuantity,
  ScheduleLine.ScheduleLineDeliveryTime AS ScheduleLineDeliveryTime,
  ScheduleLine.PurchasingSchdLnNrOfReminders AS PurchasingSchdLnNrOfReminders,
  ScheduleLine.StockTransferDeliveredQuantity AS StockTransferDeliveredQuantity,
  ScheduleLine.Batch AS Batch,
  ScheduleLine.ScheduleLineCommittedQuantity AS ScheduleLineCommittedQuantity,
  ScheduleLine.CommittedDeliveryDate AS CommittedDeliveryDate,
  ScheduleLine.OrderQuantityUnit AS OrderQuantityUnit
FROM I_CFinRpldPurgDocScheduleLine AS ScheduleLine
LEFT OUTER JOIN C_CFinRpldPurchaseOrder AS _CFinRpldPurchaseOrder ON SenderLogicalSystem = _CFinRpldPurchaseOrder.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrder.CFinReplicatedPurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_CFinRpldPurchaseOrderItem AS _CFinRpldPurchaseOrderItem ON SenderLogicalSystem = _CFinRpldPurchaseOrderItem.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrderItem.CFinReplicatedPurchaseOrder AND CFinRpldPurchaseOrderItem = _CFinRpldPurchaseOrderItem.CFinRpldPurchaseOrderItem  -- association [1..1]
;

Learn More