C_ContractItemFs

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_ContractItemFs.
-- 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: CCONTRITEMFS

CREATE VIEW C_ContractItemFs AS
SELECT
  I_PurchaseContractItem.PurchaseContract AS PurchaseContract,
  I_PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  _ContractFs.ActivePurchasingDocument AS ActivePurchasingDocument,
  I_PurchaseContractItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  cast (concat_with_space(concat_with_space( _ContractFs.ActivePurchasingDocument, '/', 1), PurchaseContractItem, 1) as formattedcontractitem ) AS FormattedPurchaseContractItem,
  _ContractFs.SupplierName AS SupplierName,
  _ContractFs.CreatedByUser AS CreatedByUser,
  _ContractFs.SupplierAddressID AS SupplierAddressID,
  _ContractFs.Supplier AS Supplier,
  _ContractFs.SupplyingSupplier AS SupplyingSupplier,
  _ContractFs.InvoicingParty AS InvoicingParty,
  _ContractFs._IncotermsClassification.IncotermsClassification AS IncotermsClassification,
  _ContractFs.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_PurchaseContractItem._Material.Material AS Material,
  PurchaseContractItemText,
  ContractNetPriceAmount,
  NetPriceQuantity,
  cast (OrderPriceUnit as orderpriceunit) AS OrderPriceUnit,
  OrderQuantityUnit,
  cast (_ReleasedQuantity.ReleasedQuantity as relquan) AS ReleasedQuantity,
  I_PurchaseContractItem._MaterialGroup.MaterialGroup AS MaterialGroup,
  I_PurchaseContractItem.ProductTypeCode AS ProductTypeCode,
  _ContractProductTypeVH.ProductTypeName AS ProductTypeName,
  Plant,
  I_PurchaseContractItem._Plant.PlantName AS PlantName,
  StorageLocation,
  I_PurchaseContractItem._StorageLocation.StorageLocationName AS StorageLocationName,
  GoodsReceiptIsExpected,
  MultipleAcctAssgmtDistribution,
  TargetQuantity,
  cast (TargetAmount as targetamount) AS TargetAmount,
  DocumentCurrency,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  ManualDeliveryAddressID,
  DeliveryAddressID,
  I_PurchaseContractItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurContrItemCategoryVH.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  I_PurchaseContractItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurContrAcctAssgmtCatVH.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  I_PurchaseContractItem.PurchasingParentItem AS PurchasingParentItem
FROM I_PurchaseContractItem
LEFT OUTER JOIN P_ContractItemRelQuan AS _ReleasedQuantity ON PurchaseContract = _ReleasedQuantity.PurchaseContract AND PurchaseContractItem = _ReleasedQuantity.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_ContractFs AS _ContractFs ON PurchaseContract = _ContractFs.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_ContractHistoryFs AS _PurchaseOrder ON PurchaseContract = _PurchaseOrder.PurchaseContract AND PurchaseContractItem = _PurchaseOrder.PurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON incotermsclassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON materialgroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN C_ContractFactSheetItemText AS _ContractFactSheetItemText ON PurchaseContract = _ContractFactSheetItemText.PurchaseContract AND PurchaseContractItem = _ContractFactSheetItemText.PurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN C_PurContrItemCategoryVH AS _PurContrItemCategoryVH ON PurchasingDocumentItemCategory = _PurContrItemCategoryVH.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN C_PurContrAcctAssgmtCatVH AS _PurContrAcctAssgmtCatVH ON AccountAssignmentCategory = _PurContrAcctAssgmtCatVH.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN C_ContractPrdTypeVH AS _ContractProductTypeVH ON ProductTypeCode = _ContractProductTypeVH.ProductType  -- association [0..1]
LEFT OUTER JOIN C_ContractFactSheetAcctAssgmt AS _ContractFactSheetAcctAssgmt ON PurchaseContractItem = _ContractFactSheetAcctAssgmt.PurchaseContractItem AND PurchaseContract = _ContractFactSheetAcctAssgmt.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _Extension ON PurchaseContract = _Extension.PurchasingDocument AND PurchaseContractItem = _Extension.PurchasingDocumentItem  -- association [1]
;