I_EngmntProjJournalEntryItem

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_EngmntProjJournalEntryItem.
-- 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: IFEPRJJRNLENTIT

CREATE VIEW I_EngmntProjJournalEntryItem AS
SELECT
  rldnr_pers AS SourceLedger,
  rbukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  rldnr AS Ledger,
  ryear AS LedgerFiscalYear,
  rrcty AS GLRecordType,
  ktopl AS ChartOfAccounts,
  kokrs AS ControllingArea,
  rmvct AS FinancialTransactionType,
  vorgn AS BusinessTransactionType,
  awtyp AS ReferenceDocumentType,
  awsys AS LogicalSystem,
  aworg AS ReferenceDocumentContext,
  awref AS ReferenceDocument,
  awitem AS ReferenceDocumentItem,
  awitgrp AS ReferenceDocumentItemGroup,
  racct AS GLAccount,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  rwcur AS TransactionCurrency,
  wsl AS AmountInTransactionCurrency,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  rkcur AS GlobalCurrency,
  ksl AS AmountInGlobalCurrency,
  rco_ocur AS ControllingObjectCurrency,
  co_osl AS AmountInObjectCurrency,
  runit AS BaseUnit,
  msl AS Quantity,
  mfsl AS FixedQuantity,
  rvunit AS CostSourceUnit,
  vmsl AS ValuationQuantity,
  vmfsl AS ValuationFixedQuantity,
  drcrk AS DebitCreditCode,
  poper AS FiscalPeriod,
  periv AS FiscalYearVariant,
  fiscyearper AS FiscalYearPeriod,
  budat AS PostingDate,
  bldat AS DocumentDate,
  blart AS AccountingDocumentType,
  buzei AS AccountingDocumentItem,
  zuonr AS AssignmentReference,
  bstat AS AccountingDocumentCategory,
  bschl AS PostingKey,
  ktosl AS TransactionTypeDetermination,
  slalittype AS SubLedgerAcctLineItemType,
  usnam AS AccountingDocCreatedByUser,
  timestamp AS LastChangeDateTime,
  timestamp AS CreationDateTime,
  cast( cast(substring( cast(timestamp as abap.char(30)) , 1 , 8) as abap.dats(8)) as fis_cpdat ) AS CreationDate,
  eprctr AS EliminationProfitCenter,
  rhoart AS OriginObjectType,
  glaccount_type AS GLAccountType,
  lokkt AS AlternativeGLAccount,
  ktop2 AS CountryChartOfAccounts,
  rebzg AS InvoiceReference,
  rebzj AS InvoiceReferenceFiscalYear,
  rebzt AS FollowOnDocumentType,
  rebzz AS InvoiceItemReference,
  rbest AS ReferencePurchaseOrderCategory,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  zekkn AS AccountAssignmentNumber,
  sgtxt AS DocumentItemText,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  matnr AS Material,
  _Material.MaterialGroup AS MaterialGroup,
  cast (matnr as productnumber) AS Product,
  werks AS Plant,
  lifnr AS Supplier,
  kunnr AS Customer,
  fbuda AS ServicesRenderedDate,
  koart AS FinancialAccountType,
  umskz AS SpecialGLCode,
  mwskz AS TaxCode,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  xopvw AS IsOpenItemManaged,
  augdt AS ClearingDate,
  augbl AS ClearingAccountingDocument,
  auggj AS ClearingDocFiscalYear,
  racct_sender AS SenderGLAccount,
  accas_sender AS SenderAccountAssignment,
  accasty_sender AS SenderAccountAssignmentType,
  objnr AS ControllingObject,
  hkgrp AS CostOriginGroup,
  uspob AS OriginSenderObject,
  co_belkz AS ControllingDebitCreditCode,
  beltp AS ControllingObjectDebitType,
  muvflg AS QuantityIsIncomplete,
  gkont AS OffsettingAccount,
  gkoar AS OffsettingAccountType,
  gktopl AS OffsettingChartOfAccounts,
  erlkz AS LineItemIsCompleted,
  pernr AS PersonnelNumber,
  scope AS ControllingObjectClass,
  pbukrs AS PartnerCompanyCode,
  pscope AS PartnerControllingObjectClass,
  ukostl AS OriginCostCenter,
  uprctr AS OriginProfitCenter,
  ulstar AS OriginCostCtrActivityType,
  accas AS AccountAssignment,
  accasty AS AccountAssignmentType,
  lstar AS CostCtrActivityType,
  aufnr AS OrderID,
  autyp AS OrderCategory,
  ps_psp_pnr AS WBSElementInternalID,
  ps_posid AS WBSElement,
  ps_prj_pnr AS ProjectInternalID,
  cast( ps_posid as /cpd/plan_item_id ) AS WorkPackage,
  ps_pspid AS Project,
  erkrs AS OperatingConcern,
  nplnr AS ProjectNetwork,
  nplnr_vorgn AS RelatedNetworkActivity,
  prznr AS BusinessProcess,
  kstrg AS CostObject,
  rsrce AS CostAnalysisResource,
  qmnum AS CustomerServiceNotification,
  paccas AS PartnerAccountAssignment,
  paccasty AS PartnerAccountAssignmentType,
  plstar AS PartnerCostCtrActivityType,
  paufnr AS PartnerOrder,
  pautyp AS PartnerOrderCategory,
  pps_posid AS PartnerWBSElement,
  pps_pspid AS PartnerProject,
  pkdauf AS PartnerSalesDocument,
  pkdpos AS PartnerSalesDocumentItem,
  pnplnr AS PartnerProjectNetwork,
  pnplnr_vorgn AS PartnerProjectNetworkActivity,
  pprznr AS PartnerBusinessProcess,
  pkstrg AS PartnerCostObject,
  work_item_id AS WorkItem,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldMaterial,
  cast (matnr_copa as fins_matnr_pa preserving type) AS SoldProduct,
  cast (matkl as productgroup preserving type) AS ProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup
FROM P_Acdoca_Cube
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;