C_GLLineItemComprnQuery

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_GLLineItemComprnQuery.
-- 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.
-- Parameters: P_Language : sylangu, P_KeyDate : vdm_v_key_date, P_FromFiscalYearPeriod : fis_jahrper_c, P_ToFiscalYearPeriod : fis_jahrper_c, P_ShiftedCalendarDate : calendardate, P_ComprnFromFiscalYearPeriod : fis_jahrper, P_ComprnToFiscalYearPeriod : fis_jahrper

CREATE VIEW C_GLLineItemComprnQuery AS
SELECT
  lookupEntity: 'I_FiscalCalendarDate' AS lookupEntityI_FiscalCalendarDate,
  resultElement: 'FiscalYearPeriod' AS resultElementFiscalYearPeriod,
  resultElement: 'ShiftedCalendarDate' AS resultElementShiftedCalendarDate,
  binding: [ { targetElement : 'FiscalYearVariant' , type : #CONSTANT, value : 'K4' AS P_FromFiscalYearPeriod,
  P_ToFiscalYearPeriod: $parameters.P_ToFiscalYearPeriod AS P_ToFiscalYearPeriod,
  P_ComprnFromFiscalYearPeriod: $parameters.P_ComprnFromFiscalYearPeriod AS P_ComprnFromFiscalYearPeriod,
  CompanyCode,
  GLAccount,
  LedgerFiscalYear,
  FiscalPeriod,
  ReportingFiscalPeriod,
  PostingDate,
  FinancialTransactionType,
  GLRecordType,
  Segment,
  ProfitCenter,
  AccountingDocument,
  CompanyCodeCurrency,
  GlobalCurrency,
  BalanceTransactionCurrency,
  TransactionCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInCompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  ComprnAmountInCoCodeCrcy,
  ComprnDebitAmtInCoCodeCrcy,
  ComprnCreditAmtInCoCodeCrcy,
  cast( 1 as fis_diff_amt_hsl ) AS DifferenceAmtInCoCodeCrcy,
  cast( 1 as fis_diff_pct_hsl_ui ) AS CoCodeCrcyDifferencePct,
  AmountInGlobalCurrency,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  ComprnAmountInGlobalCrcy,
  ComprnDebitAmtInGlobalCrcy,
  ComprnCreditAmtInGlobalCrcy,
  cast( 1 as fis_diff_amt_ksl ) AS DifferenceAmtInGlobalCrcy,
  cast( 1 as fis_diff_pct_ksl_ui ) AS GlobalCrcyDifferencePct,
  AmountInTransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  ComprnAmountInTransCrcy,
  ComprnDebitAmtInTransCrcy,
  ComprnCreditAmtInTransCrcy,
  AmountInBalanceTransacCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  ComprnAmountInBalTransCrcy,
  ComprnDebitAmtInBalTransCrcy,
  ComprnCreditAmtInBalTransCrcy,
  AmountInFreeDefinedCurrency1,
  DebitAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy1,
  ComprnAmountInFreeDfndCrcy1,
  ComprnDebitAmtInFreeDfndCrcy1,
  ComprnCreditAmtInFreeDfndCrcy1,
  cast( 1 as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy1,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy1DifferencePct,
  AmountInFreeDefinedCurrency2,
  DebitAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy2,
  ComprnAmountInFreeDfndCrcy2,
  ComprnDebitAmtInFreeDfndCrcy2,
  ComprnCreditAmtInFreeDfndCrcy2,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy2,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy2DifferencePct,
  AmountInFreeDefinedCurrency3,
  DebitAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy3,
  ComprnAmountInFreeDfndCrcy3,
  ComprnDebitAmtInFreeDfndCrcy3,
  ComprnCreditAmtInFreeDfndCrcy3,
  cast( cast( 1 as abap.dec(23,2)) as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy3,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy3DifferencePct,
  AmountInFreeDefinedCurrency4,
  DebitAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy4,
  ComprnAmountInFreeDfndCrcy4,
  ComprnDebitAmtInFreeDfndCrcy4,
  ComprnCreditAmtInFreeDfndCrcy4,
  cast( 1 as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy4,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy4DifferencePct,
  AmountInFreeDefinedCurrency5,
  DebitAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy5,
  ComprnAmountInFreeDfndCrcy5,
  ComprnDebitAmtInFreeDfndCrcy5,
  ComprnCreditAmtInFreeDfndCrcy5,
  cast( 1 as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy5,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy5DifferencePct,
  AmountInFreeDefinedCurrency6,
  DebitAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy6,
  ComprnAmountInFreeDfndCrcy6,
  ComprnDebitAmtInFreeDfndCrcy6,
  ComprnCreditAmtInFreeDfndCrcy6,
  cast( 1 as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy6,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy6DifferencePct,
  AmountInFreeDefinedCurrency7,
  DebitAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy7,
  ComprnAmountInFreeDfndCrcy7,
  ComprnDebitAmtInFreeDfndCrcy7,
  ComprnCreditAmtInFreeDfndCrcy7,
  cast( 1 as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy7,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy7DifferencePct,
  AmountInFreeDefinedCurrency8,
  DebitAmountInFreeDfndCrcy8,
  CreditAmountInFreeDfndCrcy8,
  ComprnAmountInFreeDfndCrcy8,
  ComprnDebitAmtInFreeDfndCrcy8,
  ComprnCreditAmtInFreeDfndCrcy8,
  cast( 1 as fis_diff_amt_osl ) AS DifferenceAmtInFreeDfndCrcy8,
  cast( 1 as fis_diff_pct_osl_ui ) AS FreeDfndCrcy8DifferencePct,
  DebitCreditCode,
  AccountingDocumentType,
  PostingKey,
  OffsettingChartOfAccounts,
  OffsettingAccount,
  AssignmentReference,
  CostCenter,
  AccountingDocumentItem,
  DocumentDate,
  LedgerGLLineItem,
  TransactionTypeDetermination,
  AccountingDocCreatedByUser,
  CreationDate,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  CorporateGroupAccount,
  CorporateGroupChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  Plant,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventoryValuationType,
  ValuationArea,
  OffsettingAccountType,
  LineItemIsCompleted,
  PersonnelNumber,
  PartnerCompany,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  OperatingConcern,
  PartnerCostCtrActivityType,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  ControllingArea,
  FunctionalArea,
  AccountAssignment,
  AccountAssignmentType,
  AccountingDocumentCategory,
  AssetDepreciationArea,
  BudgetPeriod,
  BusinessProcess,
  BusinessTransactionType,
  ControllingObjectDebitType,
  CostEstimate,
  CostObject,
  CustomerGroup,
  CustomerServiceNotification,
  DepreciationFiscalPeriod,
  EliminationProfitCenter,
  AssetTransactionType,
  Fund,
  FinancialManagementArea,
  GLAccountType,
  GrantID,
  GroupFixedAsset,
  GroupMasterFixedAsset,
  InventorySpclStkSalesDocItm,
  InventorySpclStkSalesDocument,
  InvtrySpclStockWBSElmntIntID,
  InventorySpecialStockSupplier,
  IsReversal,
  IsReversed,
  IsSettled,
  IsSettlement,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  JointVentureEquityType,
  LogicalSystem,
  SoldProductGroup,
  OriginCostCenter,
  OriginCostCtrActivityType,
  OriginObjectType,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerBudgetPeriod,
  PartnerBusinessArea,
  PartnerBusinessProcess,
  PartnerCompanyCode,
  PartnerCostCenter,
  PartnerCostObject,
  PartnerFunctionalArea,
  PartnerFund,
  PartnerGrant,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerProfitCenter,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerSegment,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocument,
  ProjectNetwork,
  QuantityIsIncomplete,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  ReferenceDocumentType,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  SettlementReferenceDate,
  SoldProduct,
  BusinessArea,
  FiscalYear,
  FiscalYearPeriod,
  ReportingFiscalYearPeriod,
  FiscalYearVariant,
  LastChangeDateTime,
  CreationDateTime,
  AssetAcctTransClassfctn
FROM I_GLAccountLineItemComprnCube
;