A_JournalEntryItemBasic

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 A_JournalEntryItemBasic.
-- 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: AFIJRNLBASIC

CREATE VIEW A_JournalEntryItemBasic AS
SELECT
  Ledger,
  LedgerName,
  SourceLedger,
  LedgerFiscalYear,
  ControllingArea,
  ControllingAreaName,
  CompanyCode,
  CompanyCodeName,
  GLAccount,
  GLAccountName,
  FinancialTransactionType,
  BusinessTransactionCategory,
  BusinessTransactionType,
  SourceReferenceDocumentType,
  JrnlEntryItemObsoleteReason,
  CostCenter,
  CostCenterName,
  ProfitCenter,
  ProfitCenterName,
  FunctionalArea,
  FunctionalAreaName,
  BusinessArea,
  BusinessAreaName,
  Segment,
  SegmentName,
  PartnerCostCenter,
  PartnerCostCenterName,
  PartnerProfitCenter,
  PartnerProfitCenterName,
  PartnerFunctionalArea,
  PartnerFunctionalAreaName,
  PartnerBusinessArea,
  PartnerBusinessAreaName,
  PartnerCompany,
  PartnerCompanyName,
  PartnerSegment,
  PartnerSegmentName,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FixedAmountInGlobalCrcy,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  ReferenceQuantityUnit,
  ReferenceQuantity,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  BaseUnit,
  Quantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  AccountingDocumentCategory,
  FiscalPeriod,
  FiscalYearVariant,
  cast( cast(FiscalYearPeriod as abap.char(7)) as fis_jahrper_c preserving type ) AS FiscalYearPeriod,
  ChartOfAccounts,
  Plant,
  PlantName,
  Customer,
  CustomerName,
  ControllingDebitCreditCode,
  ProjectExternalID,
  Project,
  ProjectDescription,
  WBSElementExternalID,
  WBSElement,
  WBSElementDescription,
  PartnerCompanyCode,
  PartnerCompanyCodeName,
  CostCtrActivityType,
  CostCtrActivityTypeName,
  OrderID,
  PartnerOrder_2 AS PartnerOrder,
  PartnerCostCtrActivityType,
  PartnerCostCtrActivityTypeName,
  PartnerProject,
  PartnerProjectDescription,
  PartnerWBSElement,
  PartnerWBSElementDescription,
  SalesOrganization,
  SalesOrganizationName,
  DistributionChannel,
  DistributionChannelName,
  OrganizationDivision,
  DivisionName,
  Product,
  ProductName,
  SoldMaterial,
  SoldMaterialName,
  MaterialGroup,
  MaterialGroupName,
  CustomerGroup,
  CustomerGroupName,
  CustomerSupplierCountry,
  CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  CustomerSupplierIndustryName,
  SalesDistrict,
  SalesDistrictName,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  I_JournalEntryItemCube.JointVenture AS JointVenture,
  I_JournalEntryItemCube.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_JournalEntryItemCube.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_JournalEntryItemCube.JointVenturePartner AS JointVenturePartner,
  I_JournalEntryItemCube.JointVentureBillingType AS JointVentureBillingType,
  I_JournalEntryItemCube.JointVentureEquityType AS JointVentureEquityType,
  I_JournalEntryItemCube.JointVentureProductionDate AS JointVentureProductionDate,
  I_JournalEntryItemCube.JointVentureBillingDate AS JointVentureBillingDate,
  I_JournalEntryItemCube.JointVentureOperationalDate AS JointVentureOperationalDate,
  I_JournalEntryItemCube.CutbackRun AS CutbackRun,
  I_JournalEntryItemCube.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_JournalEntryItemCube.PartnerVenture AS PartnerVenture,
  I_JournalEntryItemCube.PartnerEquityGroup AS PartnerEquityGroup,
  I_JournalEntryItemCube.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_JournalEntryItemCube.CutbackAccount AS CutbackAccount,
  I_JournalEntryItemCube.CutbackCostObject AS CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate
FROM I_JournalEntryItemCube
LEFT OUTER JOIN A_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN A_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN A_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN A_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
;