C_ContractHistoryFs

DDL: C_CONTRACTHISTORYFS SQL: CCTRHISTORYFS Type: view CONSUMPTION
30 Fields 1 Data Sources 2 Associations

Purchase Order

C_ContractHistoryFs is a Consumption CDS View that provides data about "Purchase Order" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractHistory) and exposes 30 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory I_PurchaseContractHistory from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderEnhanced _PurchaseOrder $projection.ReleaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseContractItem _PurchaseContract $projection.PurchaseContract = _PurchaseContract.PurchaseContract and $projection.PurchaseContractItem = _PurchaseContract.PurchaseContractItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCTRHISTORYFS view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Order view
AccessControl.authorizationCheck #CHECK view
UI.headerInfo.title.value ReleaseOrder view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY ReleaseOrder ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem ReleaseOrderItem Item
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity PO Quantity
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount Net Value
ReleaseOrderItemIsDeleted ReleaseOrderItemIsDeleted Del. Indicator
ReleaseOrderDate PO Date
ReleaseOrderItemQuantityUnit ReleaseOrderItemQuantityUnit Order Unit
ReleaseOrderCurrency ReleaseOrderCurrency Currency
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate Changed On
PurchaseOrderType _PurchaseOrder PurchaseOrderType PO Type
PurchasingDocumentCategory
PurchasingDocumentType
Supplier _PurchaseOrder Supplier Supplier
SupplierName
SupplierAddressID _PurchaseOrder SupplierAddressID Address Number
SupplyingSupplier _PurchaseOrder SupplyingSupplier Goods Supplier
SupplyingPlant _PurchaseOrder SupplyingPlant Supplying Plant
InvoicingParty _PurchaseOrder InvoicingParty Supplier
PurchasingDocumentStatus
_Text
_StatusText
_SupplyingSupplier _PurchaseOrder _SupplyingSupplier
_SupplyingPlant _PurchaseOrder _SupplyingPlant
_InvoicingParty _PurchaseOrder _InvoicingParty
_Supplier _PurchaseOrder _Supplier
AddedforDCLPlant
PlantName
_PurchaseContract _PurchaseContract

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_ContractHistoryFs.
-- 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.
-- SQL view name: CCTRHISTORYFS

CREATE VIEW C_ContractHistoryFs AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ReleaseOrder,
  ReleaseOrderItem,
  ReleaseOrderItemOrderQuantity,
  ReleaseOrderItemNetAmount,
  ReleaseOrderItemIsDeleted,
  cast ( ReleaseOrderDate as ordered_on ) AS ReleaseOrderDate,
  ReleaseOrderItemQuantityUnit,
  ReleaseOrderCurrency,
  ReleaseOrderItemLastChgDate,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  cast ('F' as bstyp) AS PurchasingDocumentCategory,
  _PurchaseOrder._PurchaseOrderType.PurchaseOrderType AS PurchasingDocumentType,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  _PurchaseOrder.SupplierAddressID AS SupplierAddressID,
  _PurchaseOrder.SupplyingSupplier AS SupplyingSupplier,
  _PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  _PurchaseOrder.InvoicingParty AS InvoicingParty,
  _PurchaseOrder._Status.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _PurchaseOrder._PurchaseOrderType._Text AS _Text,
  _PurchaseOrder._Status._Text AS _StatusText,
  _PurchaseOrder._SupplyingSupplier AS _SupplyingSupplier,
  _PurchaseOrder._SupplyingPlant AS _SupplyingPlant,
  _PurchaseOrder._InvoicingParty AS _InvoicingParty,
  _PurchaseOrder._Supplier AS _Supplier,
  _PurchaseContract._Plant.PlantName AS PlantName
FROM I_PurchaseContractHistory
LEFT OUTER JOIN I_PurchaseOrderEnhanced AS _PurchaseOrder ON ReleaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract AND PurchaseContractItem = _PurchaseContract.PurchaseContractItem  -- association [1..1]
;

Learn More