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.
CREATE VIEW C_ContractItemAcctMntr AS
SELECT
P_ContractItemAcctMntr.AccountAssignment AS AccountAssignment,
P_ContractItemAcctMntr.PurchaseContract AS PurchaseContract,
P_ContractItemAcctMntr.PurchaseContractItem AS PurchaseContractItem,
cast( concat( P_ContractItemAcctMntr.PurchaseContract, concat( '/' , P_ContractItemAcctMntr.PurchaseContractItem)) as vdm_formattedpurchasectritm ) AS FormattedPurchaseContractItem,
cast (P_ContractItemAcctMntr.PurchaseContractItemText as vdm_purdocumentitemtext) AS PurchaseContractItemText,
P_ContractItemAcctMntr.PurchaseContractType AS PurchaseContractType,
cast(P_ContractItemAcctMntr._PurchaseContract._PurchasingDocumentType._Text[1: Language = $session.system_language].PurchasingDocumentTypeName as vdm_purdoctypename) AS DocumentTypeName,
P_ContractItemAcctMntr.Material AS Material,
P_ContractItemAcctMntr._PurchaseContractItem._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
P_ContractItemAcctMntr.Supplier AS Supplier,
cast(P_ContractItemAcctMntr.SupplierName as suppliername) AS SupplierName,
cast(P_ContractItemAcctMntr.AccountAssignmentCategory as knttp_ll) AS AccountAssignmentCategory,
P_ContractItemAcctMntr._AccountAssignmentCategory._Text [1: Language = $session.system_language ].AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
P_ContractItemAcctMntr.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
P_ContractItemAcctMntr.PurgDocNetAmount AS PurgDocNetAmount,
_ReleasedQuantity.QuantityReleasedTillDate AS OrderQuantity,
cast(P_ContractItemAcctMntr.Quantity as vdm_acctassignquantity) AS Quantity,
P_ContractItemAcctMntr.OrderPriceUnit AS OrderPriceUnit,
P_ContractItemAcctMntr.NetPriceQuantity AS NetPriceQuantity,
P_ContractItemAcctMntr.CostCenter AS CostCenter,
P_ContractItemAcctMntr._CostCenter._Text[1: Language = $session.system_language ].CostCenterName AS CostCenterName,
P_ContractItemAcctMntr.OrderID AS OrderID,
_OrderMasterVH.OrderDescription AS OrderDescription,
cast(P_ContractItemAcctMntr.PurchasingOrganization as purchasingorganization_ll) AS PurchasingOrganization,
cast(P_ContractItemAcctMntr.PurchasingOrganizationName as vdm_purchasingorgname) AS PurchasingOrganizationName,
P_ContractItemAcctMntr.PurchasingGroup AS PurchasingGroup,
cast(P_ContractItemAcctMntr.PurchasingGroupName as vdm_purchasinggroupname) AS PurchasingGroupName,
_WBSElement.WBSElement AS WBSElement,
_WBSElement.WBSElementExternalID AS WBSElementExternalID,
P_ContractItemAcctMntr.WBSElementInternalID AS WBSElementInternalID,
_WBSElement.WBSDescription AS WBSDescription,
P_ContractItemAcctMntr.MasterFixedAsset AS MasterFixedAsset,
P_ContractItemAcctMntr._FixedAssetWorklist.FixedAssetDescription AS FixedAssetDescription,
cast (P_ContractItemAcctMntr.Currency as vdm_v_display_currency) AS DisplayCurrency,
P_ContractItemAcctMntr.OrderQuantityUnit AS OrderQuantityUnit,
cast (P_ContractItemAcctMntr.DocumentCurrency as vdm_documentcurrency) AS DocumentCurrency,
P_ContractItemAcctMntr.ValidityEndDate AS ValidityEndDate,
P_ContractItemAcctMntr.ValidityStartDate AS ValidityStartDate,
P_ContractItemAcctMntr.CreationDate AS CreationDate,
cast (_ContractStatusValueHelp.PurchaseContractValidityStatus as mm_contract_status_id) AS PurchaseContractValidityStatus,
cast(_ContractStatusValueHelp.PurContrValidityStatusName as vdm_validity_status) AS PurContrValidityStatusName,
cast (P_ContractItemAcctMntr.ContractNetPriceAmount as netpr) AS ContractNetPriceAmount,
P_ContractItemAcctMntr.Plant AS Plant,
P_ContractItemAcctMntr.PlantName AS PlantName,
cast( _PurchaseContractHistory.ReleaseOrderDate as vdm_latestreleasedate) AS ReleaseOrderDate,
P_ContractItemAcctMntr._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
cast(P_ContractItemAcctMntr._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName as vdm_purdocitencategoryname) AS PurgDocItemCategoryName,
P_ContractItemAcctMntr.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
P_ContractItemAcctMntr.PurchasingCategory AS PurchasingCategory,
cast(P_ContractItemAcctMntr.PurgCatName as vdm_purcatname) AS PurgCatName,
I_PurchasingCategoryMatlGroup.PurgCatUUID AS PurgCatUUID,
P_ContractItemAcctMntr.StorageLocation AS StorageLocation,
P_ContractItemAcctMntr.StorageLocationName AS StorageLocationName,
P_ContractItemAcctMntr.MaterialGroup AS MaterialGroup,
cast(P_ContractItemAcctMntr._PurchaseContractItem._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName as ps_s4_wgbez) AS MaterialGroupName,
P_ContractItemAcctMntr.TargetQuantity AS TargetQuantity,
case when _ReleasedQuantity.QuantityReleasedTillDate > P_ContractItemAcctMntr.TargetQuantity then cast ('0' as abap.quan(13,3)) when _ReleasedQuantity.QuantityReleasedTillDate is null then P_ContractItemAcctMntr.TargetQuantity else cast (P_ContractItemAcctMntr.TargetQuantity - _ReleasedQuantity.QuantityReleasedTillDate as abap.quan(13,3)) end as OpenTargetQuantity AS quan133endasOpenTargetQuantity,
P_ContractItemAcctMntr.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
P_ContractItemAcctMntr.PurchasingInfoRecord AS PurchasingInfoRecord,
P_ContractItemAcctMntr.CompanyCode AS CompanyCode,
P_ContractItemAcctMntr.TaxCode AS TaxCode,
cast( P_ContractItemAcctMntr._PurchaseContract._ReleaseCode._ReleaseCodeText[1: Language = $session.system_language].ReleaseCodeName as vdm_releasecode) AS ReleaseCodeName,
P_ContractItemAcctMntr.ControllingArea AS ControllingArea,
cast( P_ContractItemAcctMntr._ControllingArea.ControllingAreaName as vdm_controllingareaname) AS ControllingAreaName,
P_ContractItemAcctMntr.SalesOrderItem AS SalesOrderItem,
P_ContractItemAcctMntr.SalesOrder AS SalesOrder,
P_ContractItemAcctMntr._SalesOrderItem.SalesOrderItemText AS SalesOrderItemText,
P_ContractItemAcctMntr.ProjectNetwork AS ProjectNetwork,
_ProjectNetworkVH.ProjectNetworkDescription AS ProjectNetworkDescription,
cast(P_ContractItemAcctMntr.FixedAsset as activefixedasset) AS FixedAsset,
P_ContractItemAcctMntr.BusinessArea AS BusinessArea,
P_ContractItemAcctMntr._BusinessAreaText[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
P_ContractItemAcctMntr.GLAccount AS GLAccount,
_GLAccountText[1: Language = $session.system_language].GLAccountName AS GLAccountName,
P_ContractItemAcctMntr.ProfitCenter AS ProfitCenter,
P_ContractItemAcctMntr.ValidityDate AS ValidityDate,
_ProfitCenterText[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
P_ContractItemAcctMntr.GrantID AS GrantID,
_GrantText[1: Language = $session.system_language].GrantName AS GrantName,
P_ContractItemAcctMntr.FundsCenter AS FundsCenter,
P_ContractItemAcctMntr.BudgetPeriod AS BudgetPeriod,
_BudgetPeriodText[1: Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
P_ContractItemAcctMntr.CommitmentItem AS CommitmentItem,
cast( 1 as mm_a_numberofpurchasecontracts ) AS NumberOfContractItems,
P_ContractItemAcctMntr.Fund AS Fund,
_FundText[1: Language = $session.system_language].FundName AS FundName,
P_ContractItemAcctMntr.ChartOfAccounts AS ChartOfAccounts,
cast (P_ContractItemAcctMntr.PurchasingIsBlocked as boolean) AS PurchasingIsBlockedForSupplier,
P_ContractItemAcctMntr.CompanyCodeName AS PurgOrgCompanyCodeName,
P_ContractItemAcctMntr.CreatedByUser AS CreatedByUser,
P_ContractItemAcctMntr.UserDescription AS UserDescription
FROM P_ContractItemAcctMntr
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..*]
;