I_CostRevenueReassignmentItem

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 I_CostRevenueReassignmentItem.
-- 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: ICOSREVREASSITM

CREATE VIEW I_CostRevenueReassignmentItem AS
SELECT
  _Item.FiscalYear AS FiscalYear,
  cast(_Item.ReferenceDocument as referencedocument preserving type) AS ReferenceDocument,
  _Item.ControllingArea AS ControllingArea,
  cast(_Item.CompanyCode as receivercompanycode preserving type) AS CompanyCode,
  _Item.LedgerGLLineItem AS LedgerGLLineItem,
  _Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.SourceLedger AS SourceLedger,
  _Item.FiscalYear AS FiscalYearForEdit,
  cast(_Item.ReferenceDocument as referencedocument preserving type) AS ReferenceDocumentForEdit,
  _Item.ControllingArea AS ControllingAreaForEdit,
  _Item.CompanyCode AS CompanyCodeForEdit,
  _Item.LedgerGLLineItem AS LedgerGLLineItemForEdit,
  _Item.ReferenceDocumentItem AS ReferenceDocumentItemForEdit,
  _Item.DocumentItemText AS DocumentItemText,
  cast(_Item.GLAccount as fco_allocation_account preserving type) AS GLAccount,
  _Item.PersonnelNumber AS PersonnelNumber,
  cast(_Sender.AccountAssignment as sender_co_obj_k) AS AccountAssignment,
  cast(_Sender.AccountAssignmentType as j_obart preserving type) AS AccountAssignmentType,
  cast(_Item.AccountAssignment as receiver_co_obj_k) AS PartnerAccountAssignment,
  cast(_Item.AccountAssignmentType as receiver_object_type preserving type) AS PartnerAccountAssignmentType,
  cast(_Sender.CostCtrActivityType as lstar preserving type) AS CostCtrActivityType,
  cast(_Sender.CostCenter as sendercostcenter preserving type) AS OriginCostCenter,
  cast(_Item.CostCenter as fis_skost preserving type) AS PartnerCostCenter,
  cast(_Item.CostCtrActivityType as fis_par_lstar preserving type) AS PartnerCostCtrActivityType,
  cast(_Item.WBSElementInternalID as fis_partner_wbsint_no_conv preserving type) AS PartnerWBSElementInternalID,
  cast(_Sender.WBSElementInternalID as fis_wbsint_no_conv preserving type) AS WBSElementInternalID,
  cast(_Item._WBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type) AS PartnerWBSElementExternalID,
  cast(_Item._WBSElementBasicData.WBSElementExternalID as fis_par_psp_pnr_ext preserving type) AS PartnerWBSElement,
  cast(_Sender._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type) AS WBSElementExternalID,
  cast(_Sender._WBSElementBasicData.WBSElementExternalID as ps_posid_edit preserving type) AS WBSElement,
  cast(_Item.ServiceDocumentType as fco_psrvdoc_type preserving type) AS PartnerServiceDocumentType,
  cast(_Item.ServiceDocument as fco_psrvdoc_id preserving type) AS PartnerServiceDocument,
  cast(_Item.ServiceDocumentItem as fco_psrvdoc_item_id preserving type) AS PartnerServiceDocumentItem,
  cast(_Sender.ServiceDocumentType as fco_srvdoc_type preserving type) AS ServiceDocumentType,
  cast(_Sender.ServiceDocument as fco_srvdoc_id preserving type) AS ServiceDocument,
  cast(_Sender.ServiceDocumentItem as fco_srvdoc_item_id preserving type) AS ServiceDocumentItem,
  cast(_Item.ProjectNetwork as par_npln preserving type) AS PartnerProjectNetwork,
  cast(_Item.RelatedNetworkActivity as par_vornr_auf preserving type) AS PartnerProjectNetworkActivity,
  cast(_Sender.RelatedNetworkActivity as npvrg preserving type) AS RelatedNetworkActivity,
  cast(_Sender.ProjectNetwork as nplnr preserving type) AS ProjectNetwork,
  cast(_Item.OrderID as fis_par_aufnr preserving type) AS PartnerOrder,
  cast(_Sender.OrderID as fis_aufnr preserving type) AS OrderID,
  cast(_Item.OrderOperation as vdm_vornr preserving type) AS PartnerOrderOperation,
  cast(_Sender.OrderOperation as vdm_vornr preserving type) AS OrderOperation,
  cast(_Sender.CompanyCode as sendercompanycode preserving type) AS SenderCompanyCode,
  cast(_Item.CostObject as par_kstrg preserving type) AS PartnerCostObject,
  cast(_Sender.CostObject as kstrg preserving type) AS CostObject,
  cast(_Item.SalesDocument as fis_par_kdauf preserving type) AS PartnerSalesDocument,
  cast(_Item.SalesDocumentItem as fis_par_kdpos preserving type) AS PartnerSalesDocumentItem,
  cast(_Sender.SalesDocument as vbeln_va preserving type) AS SalesDocument,
  cast(_Sender.SalesDocumentItem as posnr_va preserving type) AS SalesDocumentItem,
  cast(_Item.BusinessProcess as par_prznr preserving type) AS PartnerBusinessProcess,
  cast(_Sender.BusinessProcess as sprznr preserving type) AS BusinessProcess,
  _Item.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  cast(_Sender.JointVentureCostRecoveryCode as jv_srecind_cds preserving type) AS SenderCostRecoveryCode,
  cast(_Sender.Fund as fm_sfonds preserving type) AS Fund,
  cast(_Sender.FunctionalArea as fm_sfarea preserving type) AS FunctionalArea,
  cast(_Sender.GrantID as gm_grant_sender preserving type) AS GrantID,
  cast(_Sender.BudgetPeriod as fm_budget_period preserving type) AS BudgetPeriod,
  cast(_Item.Fund as fm_efonds preserving type) AS PartnerFund,
  cast(_Item.FunctionalArea as fm_efarea preserving type) AS PartnerFunctionalArea,
  cast(_Item.GrantID as gm_grant_receiver preserving type) AS PartnerGrant,
  cast(_Item.BudgetPeriod as fm_pbudget_period preserving type) AS PartnerBudgetPeriod,
  _Sender.WorkItem AS WorkItem,
  _Item.WorkItem AS PartnerWorkItem,
  _Item.FinancialManagementArea AS FinancialManagementArea,
  cast(_Item.BillableControl as ebemot preserving type) AS RcvrAcctgIndCode,
  cast(_Sender.BillableControl as bemot preserving type) AS BillableControl,
  _Item.OperatingConcern AS OperatingConcern,
  _Item.BaseUnit AS BaseUnit,
  cast(_Item.Quantity as lstxx) AS Quantity,
  _Item.TransactionCurrency AS TransactionCurrency,
  cast(_Item.AmountInTransactionCurrency as fis_wsl preserving type) AS AmountInTransactionCurrency,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(_Item.AmountInCompanyCodeCurrency as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  _Item.GlobalCurrency AS GlobalCurrency,
  cast(_Item.AmountInGlobalCurrency as fis_ksl preserving type) AS AmountInGlobalCurrency,
  _Item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _Item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Item.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _Item.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Item.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _Item.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Item.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _Item.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Item.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _Item.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Item.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _Item.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Item.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _Item.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Item.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _Item.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _Item.FunctionalCurrency AS FunctionalCurrency,
  _Item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  cast(_Item.CompanyCode as pbukrs preserving type) AS ReceiverRECompanyCode,
  cast(_Item.REBusinessEntity as rebdvdmpbeno preserving type) AS REPartnerBusinessEntity,
  cast(_Item.RealEstateBuilding as rebdvdmpbuno preserving type) AS RealEstatePartnerBuilding,
  cast(_Item.RealEstateProperty as rebdvdmpprno preserving type) AS RealEstatePartnerProperty,
  cast(_Item.RERentalObject as rebdvdmprono preserving type) AS REPartnerRentalObject,
  cast(_Item.RealEstateContract as recnvdmpcnnr preserving type) AS RealEstatePartnerContract,
  cast(_Item.REServiceChargeKey as rescvdmpsckey preserving type) AS REPartnerServiceChargeKey,
  cast(_Item.RESettlementUnitID as rescvdmpsuid preserving type) AS REPartnerSettlementUnitID,
  cast(_Item.SettlementReferenceDate as fins_par_dabrbez preserving type) AS PartnerSettlementReferenceDate,
  cast(_Sender.CompanyCode as vvsbukrs preserving type) AS SenderRECompanyCode,
  cast(_Sender.REBusinessEntity as rebdvdmbeno preserving type) AS REBusinessEntity,
  cast(_Sender.RealEstateBuilding as rebdvdmbuno preserving type) AS RealEstateBuilding,
  cast(_Sender.RealEstateProperty as rebdvdmprno preserving type) AS RealEstateProperty,
  cast(_Sender.RERentalObject as rebdvdmrono preserving type) AS RERentalObject,
  cast(_Sender.RealEstateContract as recnvdmcnnr preserving type) AS RealEstateContract,
  cast(_Sender.REServiceChargeKey as rescvdmsckey preserving type) AS REServiceChargeKey,
  cast(_Sender.RESettlementUnitID as rescvdmsuid preserving type) AS RESettlementUnitID,
  cast(_Sender.SettlementReferenceDate as farp_dabrbez preserving type) AS SettlementReferenceDate,
  cast('' as fis_prctr) AS ProfitCenter,
  cast('' as fis_prctr) AS PartnerProfitCenter,
  _Item.ControllingBusTransacType AS ControllingBusTransacType,
  _Item.ChartOfAccounts AS ChartOfAccounts,
  _Item.PostingDate AS PostingDate,
  _Item.DocumentDate AS DocumentDate,
  _Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Item.IsReversal AS IsReversal,
  _Item.IsReversed AS IsReversed,
  _Item.ReferenceDocumentType AS ReferenceDocumentType,
  _Item.ReversalReferenceDocument AS ReversalReferenceDocument,
  _Item.ControllingObject AS PartnerControllingObject,
  _Sender.ControllingObject AS ControllingObject,
  _Item.TransactionSubitem AS TransactionSubitem,
  _Item.AccountingDocumentType AS AccountingDocumentType,
  _Item._CompanyCode AS _CompanyCodeText,
  _Item._BaseUnit AS _BaseUnit,
  _Item._JournalEntry AS _JournalEntry
FROM I_GLAccountLineItemRawData AS _Item
INNER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountLineItemRawData AS _Sender ON _Item.SourceLedger = _Sender.SourceLedger AND _Item.PartnerCompanyCode = _Sender.CompanyCode AND _Item.FiscalYear = _Sender.FiscalYear AND _Item.TransactionSubitem = _Sender.TransactionSubitem AND _Sender.OriginCtrlgDebitCreditCode = 'H' AND _Sender.ControllingBusTransacType = _Item.ControllingBusTransacType AND _Sender.ReferenceDocumentType = 'COBK' AND _Item.ReferenceDocument = _Sender.ReferenceDocument AND _Sender.BusinessTransactionCategory = _Item.BusinessTransactionCategory  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _PartnerBudgetPeriod ON PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;