R_CFinRpldPurgDocSchdLnTP_2

DDL: R_CFINRPLDPURGDOCSCHDLNTP_2 Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 2 Associations

CFin Rpld Purchasing Doc ScheduleLn - TP

R_CFinRpldPurgDocSchdLnTP_2 is a Transactional CDS View that provides data about "CFin Rpld Purchasing Doc ScheduleLn - TP" in SAP S/4HANA. It reads from 1 data source (R_CFinRpldPurgDocScheduleLine) and exposes 26 fields with key field CFinRpldPurgDocSchdLnUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CFinRpldPurgDocScheduleLine R_CFinRpldPurgDocScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_CFinRpldPurchasingDocTP_2 _CFinRpldPurchasingDoc $projection.CFinRpldPurchasingDocUUID = _CFinRpldPurchasingDoc.CFinRpldPurchasingDocUUID
[1..1] E_CFinRpldPurgDocScheduleLine _Extension $projection.CFinRpldPurgDocSchdLnUUID = _Extension.CFinRpldPurgDocSchdLnUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CFin Rpld Purchasing Doc ScheduleLn - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CFinRpldPurgDocSchdLnUUID CFinRpldPurgDocSchdLnUUID UUID
CFinRpldPurchasingDocUUID CFinRpldPurchasingDocUUID UUID
CFinRpldPurchasingDocItemUUID CFinRpldPurchasingDocItemUUID UUID
SourceSystemLogicalSystem SourceSystemLogicalSystem Sender Log Sys.
CFinRpldPurchasingDocument CFinRpldPurchasingDocument Purchasing Doc.
CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem Item
CFinRpldPurgDocScheduleLine CFinRpldPurgDocScheduleLine
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
DelivDateCategory DelivDateCategory Delivery Date
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
GoodsReceiptQuantity GoodsReceiptQuantity Delivered
ScheduleLineIssuedQuantity ScheduleLineIssuedQuantity Issued
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
PurchasingSchdLnNrOfReminders PurchasingSchdLnNrOfReminders No. Rem./Exp.
ScheduleLineOrderDate ScheduleLineOrderDate PurchOrderDate
StockTransferDeliveredQuantity StockTransferDeliveredQuantity Qty Delivered
MRPRelevantQuantity MRPRelevantQuantity Qty Reduced
Batch Batch Lot No.
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity Committed Qty
CommittedDeliveryDate CommittedDeliveryDate Finish date
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
OrderQuantityUnit OrderQuantityUnit Sales Unit
_CFinRpldPurchasingDoc _CFinRpldPurchasingDoc
_CFinRpldPurgDocItem _CFinRpldPurgDocItem

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 R_CFinRpldPurgDocSchdLnTP_2.
-- 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 R_CFinRpldPurgDocSchdLnTP_2 AS
SELECT
  CFinRpldPurgDocSchdLnUUID,
  CFinRpldPurchasingDocUUID,
  CFinRpldPurchasingDocItemUUID,
  SourceSystemLogicalSystem,
  CFinRpldPurchasingDocument,
  CFinRpldPurchasingDocumentItem,
  CFinRpldPurgDocScheduleLine,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  DelivDateCategory,
  ScheduleLineOrderQuantity,
  GoodsReceiptQuantity,
  ScheduleLineIssuedQuantity,
  ScheduleLineDeliveryTime,
  PurchasingSchdLnNrOfReminders,
  ScheduleLineOrderDate,
  StockTransferDeliveredQuantity,
  MRPRelevantQuantity,
  Batch,
  ScheduleLineCommittedQuantity,
  CommittedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderQuantityUnit
FROM R_CFinRpldPurgDocScheduleLine
LEFT OUTER JOIN R_CFinRpldPurchasingDocTP_2 AS _CFinRpldPurchasingDoc ON CFinRpldPurchasingDocUUID = _CFinRpldPurchasingDoc.CFinRpldPurchasingDocUUID  -- association [1..1]
LEFT OUTER JOIN E_CFinRpldPurgDocScheduleLine AS _Extension ON CFinRpldPurgDocSchdLnUUID = _Extension.CFinRpldPurgDocSchdLnUUID  -- association [1..1]
;

Learn More