I_DirectActivityAllocationItem

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_DirectActivityAllocationItem.
-- 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: IDRCTACTYITM

CREATE VIEW I_DirectActivityAllocationItem AS
SELECT
  FiscalYear,
  cast(ReferenceDocument as referencedocument) AS ReferenceDocument,
  ControllingArea,
  CompanyCode,
  LedgerGLLineItem,
  ReferenceDocumentItem,
  _Item.AccountingDocument AS AccountingDocument,
  cast(PartnerCompanyCode as sendercompanycode) AS SenderCompanyCode,
  SourceLedger,
  cast(PartnerAccountAssignment as sender_co_obj_k) AS AccountAssignment,
  cast(PartnerAccountAssignmentType as j_obart) AS AccountAssignmentType,
  cast(AccountAssignment as receiver_co_obj_k) AS PartnerAccountAssignment,
  cast(_Item.AccountAssignmentType as receiver_object_type) AS PartnerAccountAssignmentType,
  cast(PartnerCostCtrActivityType as lstar) AS CostCtrActivityType,
  cast(CostCenter as fis_skost) AS PartnerCostCenter,
  cast(PartnerCostCenter as sendercostcenter) AS OriginCostCenter,
  DocumentItemText,
  cast(GLAccount as fco_allocation_account) AS GLAccount,
  BaseUnit,
  cast(Quantity as lstxx) AS Quantity,
  TransactionCurrency,
  cast(AmountInTransactionCurrency as fis_wsl) AS AmountInTransactionCurrency,
  CompanyCodeCurrency,
  cast(AmountInCompanyCodeCurrency as fis_hsl) AS AmountInCompanyCodeCurrency,
  GlobalCurrency,
  cast(AmountInGlobalCurrency as fis_ksl) AS AmountInGlobalCurrency,
  cast(_WBSElementBasicData.WBSElementExternalID as fis_par_psp_pnr_ext ) AS PartnerWBSElementExternalID,
  cast(_WBSElementBasicData.WBSElementExternalID as fis_par_psp_pnr_ext) AS PartnerWBSElement,
  cast(WBSElementInternalID as fco_par_psp_pnr) AS PartnerWBSElementInternalID,
  cast(_ProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv) AS PartnerProjectExternalID,
  cast(Project as fis_part_project) AS PartnerProject,
  cast(ServiceDocumentType as fco_psrvdoc_type) AS PartnerServiceDocumentType,
  cast(ServiceDocument as fco_psrvdoc_id) AS PartnerServiceDocument,
  cast(ServiceDocumentItem as fco_psrvdoc_item_id) AS PartnerServiceDocumentItem,
  cast(ProjectNetwork as par_npln) AS PartnerProjectNetwork,
  cast(OrderID as fis_par_aufnr) AS PartnerOrder,
  cast(RelatedNetworkActivity as par_vornr_auf) AS PartnerProjectNetworkActivity,
  cast(CostCtrActivityType as fis_par_lstar) AS PartnerCostCtrActivityType,
  cast(CompanyCode as pbukrs) AS PartnerCompanyCode,
  cast(CostObject as par_kstrg) AS PartnerCostObject,
  cast(SalesDocument as fis_par_kdauf) AS PartnerSalesDocument,
  cast(SalesDocumentItem as fis_par_kdpos) AS PartnerSalesDocumentItem,
  WorkItem,
  PersonnelNumber,
  cast('' as ckml_f_procnr) AS ReceiverProcurementProcess,
  Product AS Material,
  cast(BusinessProcess as par_prznr) AS PartnerBusinessProcess,
  Product,
  cast(PartnerFund as fm_sfonds) AS Fund,
  cast(PartnerFunctionalArea as fm_sfarea) AS FunctionalArea,
  cast(PartnerGrant as gm_grant_sender) AS GrantID,
  cast(PartnerBudgetPeriod as fm_budget_period) AS BudgetPeriod,
  cast(Fund as fm_efonds) AS PartnerFund,
  cast(FunctionalArea as fm_efarea) AS PartnerFunctionalArea,
  cast(GrantID as gm_grant_receiver) AS PartnerGrant,
  cast(BudgetPeriod as fm_pbudget_period) AS PartnerBudgetPeriod,
  FinancialManagementArea,
  IsSettled,
  BillableControl,
  DocumentDate,
  PostingDate,
  AccountingDocCreatedByUser,
  JointVentureCostRecoveryCode,
  SenderCostRecoveryCode,
  IsReversal,
  IsReversed,
  ReferenceDocumentType,
  ReversalReferenceDocument,
  PredecessorReferenceDocument,
  OperatingConcern,
  PredecessorReferenceDocItem,
  IsSettlement,
  OrderOperation,
  cast(CompanyCode as pbukrs) AS ReceiverRECompanyCode,
  REBusinessEntity AS REPartnerBusinessEntity,
  RealEstateBuilding AS RealEstatePartnerBuilding,
  RealEstateProperty AS RealEstatePartnerProperty,
  RERentalObject AS REPartnerRentalObject,
  RealEstateContract AS RealEstatePartnerContract,
  REServiceChargeKey AS REPartnerServiceChargeKey,
  RESettlementUnitID AS REPartnerSettlementUnitID,
  SettlementReferenceDate AS PartnerSettlementReferenceDate,
  ControllingBusTransacType,
  PartnerProfitCenter,
  ProfitCenter,
  ServicesRenderedDate,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  ChartOfAccounts,
  TransactionSubitem,
  _Item.AccountingDocumentType AS AccountingDocumentType
FROM I_GLAccountLineItemRawData AS _Item
INNER JOIN I_AccountAssignmentType AS _AAT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementText ON PartnerWBSElementInternalID = _PartnerWBSElementText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _PartnerCostCtrActivityTypeTxt ON ControllingArea = _PartnerCostCtrActivityTypeTxt.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityTypeTxt.CostCtrActivityType AND PostingDate <= _PartnerCostCtrActivityTypeTxt.ValidityEndDate AND PostingDate >= _PartnerCostCtrActivityTypeTxt.ValidityStartDate AND _PartnerCostCtrActivityTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _PartnerCostCenterText ON ControllingArea = _PartnerCostCenterText.ControllingArea AND PartnerCostCenter = _PartnerCostCenterText.CostCenter AND PostingDate <= _PartnerCostCenterText.ValidityEndDate AND PostingDate >= _PartnerCostCenterText.ValidityStartDate AND _PartnerCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCtrActivityTypeTxt ON ControllingArea = _CostCtrActivityTypeTxt.ControllingArea AND CostCtrActivityType = _CostCtrActivityTypeTxt.CostCtrActivityType AND PostingDate <= _CostCtrActivityTypeTxt.ValidityEndDate AND PostingDate >= _CostCtrActivityTypeTxt.ValidityStartDate AND _CostCtrActivityTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND OriginCostCenter = _CostCenterText.CostCenter AND PostingDate <= _CostCenterText.ValidityEndDate AND PostingDate >= _CostCenterText.ValidityStartDate AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DrctActyAllocSuccssrRefItem AS _SuccessorReferenceItem ON ControllingArea = _SuccessorReferenceItem.ControllingArea AND ReferenceDocument = _SuccessorReferenceItem.PredecessorReferenceDocument AND ReferenceDocumentItem = _SuccessorReferenceItem.PredecessorReferenceDocItem  -- association [1..1]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _PartnerGrantText ON PartnerGrant = _PartnerGrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _PartnerBudgetPeriodText ON PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _PartnerFunctionalAreaText ON PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_BillableControlText AS _BillableControlText ON BillableControl = _BillableControlText.BillableControl  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON BaseUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
;