P_GLE_ADB_KFC_CAL

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 P_GLE_ADB_KFC_CAL.
-- 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: PGADBKFCALC
-- Parameters: P_FiscalYearStartDate : gle_dte_adb_keydate, P_FiscalHalfYearStartDate : gle_dte_adb_keydate, P_FiscalQuarterStartDate : gle_dte_adb_keydate, P_FiscalMonthStartDate : gle_dte_adb_keydate, P_ReportingDate : gle_dte_adb_keydate, P_ArchiveDataIsIncluded : abap_boolean

CREATE VIEW P_GLE_ADB_KFC_CAL AS
SELECT
  rldnr AS SourceLedger,
  rldnr AS Ledger,
  rbukrs AS CompanyCode,
  rassc AS PartnerCompany,
  budat AS PostingDate,
  rtcur AS BalanceTransactionCurrency,
  runit AS BaseUnit,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  sbusa AS PartnerBusinessArea,
  rmvct AS FinancialTransactionType,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  rcntr AS CostCenter,
  racct AS GLAccount,
  prctr AS ProfitCenter,
  blart AS AccountingDocumentType,
  M2DAvgBal_T,
  Q2DAvgBal_T,
  HY2DAvgBal_T,
  Y2DAvgBal_T,
  M2DAvgBal_H,
  Q2DAvgBal_H,
  HY2DAvgBal_H,
  Y2DAvgBal_H,
  M2DAvgBal_K,
  Q2DAvgBal_K,
  HY2DAvgBal_K,
  Y2DAvgBal_K,
  M2DAvgBal_O,
  Q2DAvgBal_O,
  HY2DAvgBal_O,
  Y2DAvgBal_O,
  M2DAvgBal_V,
  Q2DAvgBal_V,
  HY2DAvgBal_V,
  Y2DAvgBal_V,
  M2DAvgBal_B,
  Q2DAvgBal_B,
  HY2DAvgBal_B,
  Y2DAvgBal_B,
  M2DAvgBal_C,
  Q2DAvgBal_C,
  HY2DAvgBal_C,
  Y2DAvgBal_C,
  M2DAvgBal_D,
  Q2DAvgBal_D,
  HY2DAvgBal_D,
  Y2DAvgBal_D,
  M2DAvgBal_E,
  Q2DAvgBal_E,
  Y2DAvgBal_E,
  HY2DAvgBal_E,
  M2DAvgBal_F,
  Q2DAvgBal_F,
  HY2DAvgBal_F,
  Y2DAvgBal_F,
  M2DAvgBal_G,
  Q2DAvgBal_G,
  HY2DAvgBal_G,
  Y2DAvgBal_G,
  awref AS ReferenceDocument,
  usnam AS AccountingDocCreatedByUser,
  awtyp AS ReferenceDocumentType,
  aworg AS ReferenceDocumentContext,
  awsys AS LogicalSystem,
  timestamp AS CreationDateTime,
  Segment,
  bstat AS AccountingDocumentCategory,
  poper AS FiscalPeriod,
  zuonr AS AssignmentReference,
  kokrs AS ControllingArea,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  psegment AS PartnerSegment,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  matnr AS Material,
  matkl_mm AS MaterialGroup,
  werks AS Plant,
  ps_posid AS WBSElementExternalID,
  ps_pspid AS Project,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup,
  ps_psp_pnr AS WBSElementInternalID
FROM gle_adb_kfc_calculation
;