C_ContractItemAcctMntr

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_ContractItemAcctMntr.
-- 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: CCTRITEMACCTMONI

CREATE VIEW C_ContractItemAcctMntr AS
SELECT
  AccountAssignment,
  PurchaseContract,
  PurchaseContractItem,
  cast( concat( PurchaseContract, concat( '/' , PurchaseContractItem)) as vdm_formattedpurchasectritm ) AS FormattedPurchaseContractItem,
  cast (_PurchaseContractItem.PurchaseContractItemText as vdm_purdocumentitemtext) AS PurchaseContractItemText,
  cast(_PurchaseContract._PurchasingDocumentType._Text[1: Language = $session.system_language].PurchasingDocumentTypeName as vdm_purdoctypename) AS DocumentTypeName,
  _PurchaseContractItem._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  cast(_PurchaseContract._Supplier.SupplierName as suppliername) AS SupplierName,
  cast(_PurchaseContractItem.AccountAssignmentCategory as knttp_ll) AS AccountAssignmentCategory,
  _PurchasingDocumentItem._AccountAssignmentCategory._Text [1: Language = $session.system_language ].AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  cast(Quantity as vdm_acctassignquantity) AS Quantity,
  CostCenter,
  _CostCenter._Text[1: Language = $session.system_language ].CostCenterName AS CostCenterName,
  OrderID,
  cast(_PurchaseContract.PurchasingOrganization as purchasingorganization_ll) AS PurchasingOrganization,
  cast(_PurchaseContract._PurchasingOrganization.PurchasingOrganizationName as vdm_purchasingorgname) AS PurchasingOrganizationName,
  cast(_PurchaseContract._PurchasingGroup.PurchasingGroupName as vdm_purchasinggroupname) AS PurchasingGroupName,
  WBSElementInternalID,
  MasterFixedAsset,
  cast (_PurchaseContract._CompanyCode._Currency.Currency as vdm_v_display_currency) AS DisplayCurrency,
  cast ( _PurchaseContractItem.DocumentCurrency as vdm_documentcurrency) AS DocumentCurrency,
  cast (_ContractStatusValueHelp.PurchaseContractValidityStatus as mm_contract_status_id) AS PurchaseContractValidityStatus,
  cast(_ContractStatusValueHelp.PurContrValidityStatusName as vdm_validity_status) AS PurContrValidityStatusName,
  cast (_PurchaseContractItem.ContractNetPriceAmount as netpr) AS ContractNetPriceAmount,
  _PurchaseContractItem._Plant.PlantName AS PlantName,
  cast( _PurchaseContractHistory.ReleaseOrderDate as vdm_latestreleasedate) AS ReleaseOrderDate,
  _PurchasingDocumentItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  cast(_PurchasingDocumentItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName as vdm_purdocitencategoryname) AS PurgDocItemCategoryName,
  cast(_PurchaseContractItem.PurgCatName as vdm_purcatname) AS PurgCatName,
  PurgCatUUID,
  _PurchaseContractItem._StorageLocation.StorageLocationName AS StorageLocationName,
  cast(_PurchaseContractItem._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName as ps_s4_wgbez) AS MaterialGroupName,
  case when _ReleasedQuantity.QuantityReleasedTillDate > _PurchaseContractItem.TargetQuantity then cast ('0' as abap.quan(13,3)) when _ReleasedQuantity.QuantityReleasedTillDate is null then TargetQuantity else cast (TargetQuantity - _ReleasedQuantity.QuantityReleasedTillDate as abap.quan(13,3)) end as OpenTargetQuantity AS quan133endasOpenTargetQuantity,
  cast( _PurchaseContract._ReleaseCode._ReleaseCodeText[1: Language = $session.system_language].ReleaseCodeName as vdm_releasecode) AS ReleaseCodeName,
  ControllingArea,
  cast( _ControllingArea.ControllingAreaName as vdm_controllingareaname) AS ControllingAreaName,
  SalesOrderItem,
  SalesOrder,
  ProjectNetwork,
  cast(FixedAsset as activefixedasset) AS FixedAsset,
  BusinessArea,
  _BusinessAreaText[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  GLAccount,
  _GLAccountText[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  ProfitCenter,
  ValidityDate,
  _ProfitCenterText[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  GrantID,
  _GrantText[1: Language = $session.system_language].GrantName AS GrantName,
  FundsCenter,
  BudgetPeriod,
  _BudgetPeriodText[1: Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  CommitmentItem,
  cast( 1 as mm_a_numberofpurchasecontracts ) AS NumberOfContractItems,
  Fund,
  _FundText[1: Language = $session.system_language].FundName AS FundName,
  ChartOfAccounts,
  cast (_PurchaseContract._Supplier.PurchasingIsBlocked as boolean) AS PurchasingIsBlockedForSupplier,
  _PurchaseContract._CompanyCode.CompanyCodeName AS PurgOrgCompanyCodeName,
  _PurchaseContract._CreatedByUser.UserDescription AS UserDescription,
  _FixedAssetWorklist.FixedAssetDescription AS FixedAssetDescription,
  _OrderMasterVH.OrderDescription AS OrderDescription,
  _ProjectNetworkVH.ProjectNetworkDescription AS ProjectNetworkDescription,
  _PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _PurchaseContract.Supplier AS Supplier,
  _PurchaseContract.PurchasingGroup AS PurchasingGroup,
  _PurchaseContract.CreationDate AS CreationDate,
  _PurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  _PurchaseContract.CompanyCode AS CompanyCode,
  _PurchaseContract.CreatedByUser AS CreatedByUser,
  _PurchaseContractItem.Material AS Material,
  _PurchaseContractItem.OrderPriceUnit AS OrderPriceUnit,
  _PurchaseContractItem.NetPriceQuantity AS NetPriceQuantity,
  _PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  _PurchaseContractItem.Plant AS Plant,
  _PurchaseContractItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurchaseContractItem.PurchasingCategory AS PurchasingCategory,
  _PurchaseContractItem.StorageLocation AS StorageLocation,
  _PurchaseContractItem.MaterialGroup AS MaterialGroup,
  _PurchaseContractItem.TargetQuantity AS TargetQuantity,
  _PurchaseContractItem.TaxCode AS TaxCode,
  _PurchasingDocumentItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _ReleasedQuantity.QuantityReleasedTillDate AS OrderQuantity,
  _SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription
FROM P_ContractItemAcctMntr
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseContract = _PurchasingDocumentItem.PurchasingDocument AND PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_OpenTargetQuantity AS _ReleasedQuantity ON PurchaseContract = _ReleasedQuantity.PurchaseContract AND PurchaseContractItem = _ReleasedQuantity.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN C_MM_PurchaseCtrTypeValHelp AS _PurDocTypeValHelp ON _PurDocTypeValHelp.PurchasingDocumentType = purchasecontracttype  -- association [0..1]
LEFT OUTER JOIN C_ContractStatusValueHelp AS _ContractStatusValueHelp ON _ContractStatusValueHelp.PurchaseContract = PurchaseContract AND _ContractStatusValueHelp.PurchaseContractItem = PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN C_PurContrMassValdtyStsDropDwn AS _ValidityStatusValueHelp ON _ValidityStatusValueHelp.Status = PurchaseContractValidityStatus  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN P_PurchaseContractHistory AS _PurchaseContractHistory ON PurchaseContract = _PurchaseContractHistory.PurchaseContract AND PurchaseContractItem = _PurchaseContractHistory.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_CurrencyStdVH AS _CurrencyVH ON DocumentCurrency = _CurrencyVH.Currency  -- association [0..1]
LEFT OUTER JOIN C_OrderMasterVH AS _OrderMasterVH ON OrderID = _OrderMasterVH.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetworkVH ON _ProjectNetworkVH.ProjectNetwork = ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN C_ProductUnitOfMeasureVH AS _ProductUnitOfMeasureVH ON _ProductUnitOfMeasureVH.UnitOfMeasure = orderquantityunit  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityDate <= _ProfitCenterText.ValidityEndDate AND ValidityDate >= _ProfitCenterText.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod AND _BudgetPeriodText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..*]
;