P_AvgDailyBalKeyFig

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_AvgDailyBalKeyFig.
-- 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: PADBKFC
-- Parameters: P_ReportingDate : gle_dte_adb_keydate, P_CreationTime : gle_dte_adb_creation_time, P_CreationDate : gle_dte_adb_creation_date

CREATE VIEW P_AvgDailyBalKeyFig AS
SELECT
  AccountingDocument,
  LedgerGLLineItem,
  SourceLedger,
  LedgerFiscalYear,
  FlowOfFundsLedgerFiscalYear,
  GLRecordType,
  FinancialTransactionType,
  ControllingBusTransacType,
  BusinessTransactionType,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  TransactionSubitem,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  ControllingObjectCurrency,
  BaseUnit,
  CostSourceUnit,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  Quantity,
  ValuationQuantity,
  DebitCreditCode,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  PostingKey,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  Plant,
  Supplier,
  Customer,
  ServicesRenderedDate,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  AssetClass,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  OriginProfitCenter,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  BillableControl,
  CostAnalysisResource,
  CustomerServiceNotification,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  ProductGroup,
  MaintenanceOrderIsPlanned,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  CutbackRun,
  JointVentureAccountingActivity,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  ServiceDocument,
  ServiceDocumentType,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  AmountInBalanceTransacCrcy AS YTDBalInBalTransCrcy,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  AmountInCompanyCodeCurrency AS YTDBalInCCCrcy,
  GlobalCurrency,
  AmountInGlobalCurrency,
  AmountInGlobalCurrency AS YTDBalInGlobCrcy,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  AmountInFunctionalCurrency AS YTDBalInFuncnlCrcy,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1 AS YTDBalInFDCrcy1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2 AS YTDBalInFDCrcy2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3 AS YTDBalInFDCrcy3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4 AS YTDBalInFDCrcy4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5 AS YTDBalInFDCrcy5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6 AS YTDBalInFDCrcy6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7 AS YTDBalInFDCrcy7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8 AS YTDBalInFDCrcy8,
  case when ( PostingDate >= calDates.FiscalQuarterStartDate and item.FiscalPeriod <> '000' ) then AmountInFreeDefinedCurrency8 else 0 end as QTDActyInFDCrcy8 AS P_CreationDate,
  $parameters.P_CreationTime AS P_CreationTime,
  abap_user_timezone( $session.user, $session.client,'NULL' ) AS clientNULL,
  $session.client AS client,
  rbukrs AS CompanyCode,
  gjahr AS FiscalYear,
  poper AS FiscalPeriod,
  periv AS FiscalYearVariant,
  fiscyearper AS FiscalYearPeriod,
  0 AS PriorDayBalInBalTransCrcy,
  0 AS CurrentDayActyInBalTransCrcy,
  0 AS PriorMonthBalInBalTransCrcy,
  0 AS CurrentMonthActyInBalTransCrcy,
  0 AS QTDActyInBalTransCrcy,
  0 AS PriorDayBalInCCCrcy,
  0 AS CurrentDayActyInCCCrcy,
  0 AS PriorMonthBalInCCCrcy,
  0 AS CurrentMonthActyInCCCrcy,
  0 AS QTDActyInCCCrcy,
  0 AS PriorDayBalInGlobCrcy,
  0 AS CurrentDayActyInGlobCrcy,
  0 AS PriorMonthBalInGlobCrcy,
  0 AS CurrentMonthActyInGlobCrcy,
  0 AS QTDActyInGlobCrcy,
  0 AS PriorDayBalInFuncnlCrcy,
  0 AS CurrentDayActyInFuncnlCrcy,
  0 AS PriorMonthBalInFuncnlCrcy,
  0 AS CurrentMonthActyInFuncnlCrcy,
  0 AS QTDActyInFuncnlCrcy,
  0 AS PriorDayBalInFDCrcy1,
  0 AS CurrentDayActyInFDCrcy1,
  0 AS PriorMonthBalInFDCrcy1,
  0 AS CurrentMonthActyInFDCrcy1,
  0 AS QTDActyInFDCrcy1,
  0 AS PriorDayBalInFDCrcy2,
  0 AS CurrentDayActyInFDCrcy2,
  0 AS PriorMonthBalInFDCrcy2,
  0 AS CurrentMonthActyInFDCrcy2,
  0 AS QTDActyInFDCrcy2,
  0 AS PriorDayBalInFDCrcy3,
  0 AS CurrentDayActyInFDCrcy3,
  0 AS PriorMonthBalInFDCrcy3,
  0 AS CurrentMonthActyInFDCrcy3,
  0 AS QTDActyInFDCrcy3,
  0 AS PriorDayBalInFDCrcy4,
  0 AS CurrentDayActyInFDCrcy4,
  0 AS PriorMonthBalInFDCrcy4,
  0 AS CurrentMonthActyInFDCrcy4,
  0 AS QTDActyInFDCrcy4,
  0 AS PriorDayBalInFDCrcy5,
  0 AS CurrentDayActyInFDCrcy5,
  0 AS PriorMonthBalInFDCrcy5,
  0 AS CurrentMonthActyInFDCrcy5,
  0 AS QTDActyInFDCrcy5,
  0 AS PriorDayBalInFDCrcy6,
  0 AS CurrentDayActyInFDCrcy6,
  0 AS PriorMonthBalInFDCrcy6,
  0 AS CurrentMonthActyInFDCrcy6,
  0 AS QTDActyInFDCrcy6,
  0 AS PriorDayBalInFDCrcy7,
  0 AS CurrentDayActyInFDCrcy7,
  0 AS PriorMonthBalInFDCrcy7,
  0 AS CurrentMonthActyInFDCrcy7,
  0 AS QTDActyInFDCrcy7,
  0 AS PriorDayBalInFDCrcy8,
  0 AS CurrentDayActyInFDCrcy8,
  0 AS PriorMonthBalInFDCrcy8,
  0 AS CurrentMonthActyInFDCrcy8,
  0 AS QTDActyInFDCrcy8,
  item.Ledger AS Ledger,
  item.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  item.FinancialServicesBranch AS FinancialServicesBranch,
  item.FinancialDataSource AS FinancialDataSource
FROM P_AvgDailyBalACDOCAItem AS item
INNER JOIN I_FiscalYearForLedger AS fyvar ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate AS calDates ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): gle_adb_kfc_avg_sl_gen
;