P_AvgDailyBalACDOCAItem

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_AvgDailyBalACDOCAItem.
-- 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: PADBKFCITEM

CREATE VIEW P_AvgDailyBalACDOCAItem AS
SELECT
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  cast( I_GLAccountLineItem.LedgerFiscalYear as fis_ryear_flow preserving type ) AS FlowOfFundsLedgerFiscalYear,
  I_GLAccountLineItem.GLRecordType AS GLRecordType,
  I_GLAccountLineItem.FinancialTransactionType AS FinancialTransactionType,
  I_GLAccountLineItem.ControllingBusTransacType AS ControllingBusTransacType,
  I_GLAccountLineItem.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAccountLineItem.ReferenceDocument AS ReferenceDocument,
  I_GLAccountLineItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAccountLineItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  TransactionSubitem,
  I_GLAccountLineItem.IsReversal AS IsReversal,
  I_GLAccountLineItem.IsReversed AS IsReversed,
  I_GLAccountLineItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAccountLineItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAccountLineItem.IsSettlement AS IsSettlement,
  I_GLAccountLineItem.IsSettled AS IsSettled,
  I_GLAccountLineItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAccountLineItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  I_GLAccountLineItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  I_GLAccountLineItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  I_GLAccountLineItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  I_GLAccountLineItem.SourceLogicalSystem AS SourceLogicalSystem,
  I_GLAccountLineItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  I_GLAccountLineItem.SourceReferenceDocument AS SourceReferenceDocument,
  I_GLAccountLineItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  I_GLAccountLineItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  I_GLAccountLineItem.IsCommitment AS IsCommitment,
  I_GLAccountLineItem.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  I_GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.FunctionalCurrency AS FunctionalCurrency,
  I_GLAccountLineItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountLineItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountLineItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountLineItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountLineItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountLineItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountLineItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountLineItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountLineItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_GLAccountLineItem.BaseUnit AS BaseUnit,
  I_GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItem.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAccountLineItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountLineItem.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountLineItem.PartnerCompany AS PartnerCompany,
  I_GLAccountLineItem.PartnerSegment AS PartnerSegment,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountLineItem.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  I_GLAccountLineItem.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  I_GLAccountLineItem.Quantity AS Quantity,
  I_GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  I_GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItem.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountLineItem.DocumentDate AS DocumentDate,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_GLAccountLineItem.AssignmentReference AS AssignmentReference,
  I_GLAccountLineItem.PostingKey AS PostingKey,
  I_GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_GLAccountLineItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAccountLineItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAccountLineItem.CreationDateTime AS CreationDateTime,
  I_GLAccountLineItem.LastChangeDateTime AS LastChangeDateTime,
  I_GLAccountLineItem.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAccountLineItem.OriginObjectType AS OriginObjectType,
  I_GLAccountLineItem.GLAccountType AS GLAccountType,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountLineItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAccountLineItem.InvoiceReference AS InvoiceReference,
  I_GLAccountLineItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_GLAccountLineItem.FollowOnDocumentType AS FollowOnDocumentType,
  I_GLAccountLineItem.InvoiceItemReference AS InvoiceItemReference,
  I_GLAccountLineItem.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  I_GLAccountLineItem.PurchasingDocument AS PurchasingDocument,
  I_GLAccountLineItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAccountLineItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAccountLineItem.DocumentItemText AS DocumentItemText,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItem.Product AS Product,
  I_GLAccountLineItem.Plant AS Plant,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.ServicesRenderedDate AS ServicesRenderedDate,
  I_GLAccountLineItem.ConditionContract AS ConditionContract,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.SpecialGLCode AS SpecialGLCode,
  I_GLAccountLineItem.TaxCode AS TaxCode,
  I_GLAccountLineItem.HouseBank AS HouseBank,
  I_GLAccountLineItem.HouseBankAccount AS HouseBankAccount,
  I_GLAccountLineItem.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccountLineItem.ClearingDate AS ClearingDate,
  I_GLAccountLineItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAccountLineItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  I_GLAccountLineItem.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.FixedAsset AS FixedAsset,
  I_GLAccountLineItem.AssetValueDate AS AssetValueDate,
  I_GLAccountLineItem.AssetTransactionType AS AssetTransactionType,
  I_GLAccountLineItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  I_GLAccountLineItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_GLAccountLineItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAccountLineItem.GroupFixedAsset AS GroupFixedAsset,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.CostEstimate AS CostEstimate,
  I_GLAccountLineItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAccountLineItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountLineItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountLineItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  cast( I_GLAccountLineItem.InventorySpclStockWBSElement as fis_invspstock_wbs preserving type ) AS InventorySpclStockWBSElement,
  I_GLAccountLineItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountLineItem.InventoryValuationType AS InventoryValuationType,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.SenderGLAccount AS SenderGLAccount,
  I_GLAccountLineItem.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAccountLineItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAccountLineItem.CostOriginGroup AS CostOriginGroup,
  I_GLAccountLineItem.OriginSenderObject AS OriginSenderObject,
  I_GLAccountLineItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  I_GLAccountLineItem.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAccountLineItem.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAccountLineItem.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItem.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountLineItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItem.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAccountLineItem.PersonnelNumber AS PersonnelNumber,
  I_GLAccountLineItem.ControllingObjectClass AS ControllingObjectClass,
  I_GLAccountLineItem.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountLineItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAccountLineItem.OriginCostCenter AS OriginCostCenter,
  I_GLAccountLineItem.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountLineItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountLineItem.AccountAssignment AS AccountAssignment,
  I_GLAccountLineItem.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountLineItem.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.OrderCategory AS OrderCategory,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItem.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItem.RelatedNetworkActivity AS RelatedNetworkActivity,
  I_GLAccountLineItem.BusinessProcess AS BusinessProcess,
  I_GLAccountLineItem.CostObject AS CostObject,
  I_GLAccountLineItem.BillableControl AS BillableControl,
  I_GLAccountLineItem.CostAnalysisResource AS CostAnalysisResource,
  I_GLAccountLineItem.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAccountLineItem.OperatingConcern AS OperatingConcern,
  I_GLAccountLineItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountLineItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountLineItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountLineItem.PartnerOrder AS PartnerOrder,
  I_GLAccountLineItem.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItem.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAccountLineItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAccountLineItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountLineItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAccountLineItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItem.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItem.WorkItem AS WorkItem,
  I_GLAccountLineItem.WorkCenterInternalID AS WorkCenterInternalID,
  I_GLAccountLineItem.OrderOperation AS OrderOperation,
  I_GLAccountLineItem.OrderItem AS OrderItem,
  I_GLAccountLineItem.OrderSuboperation AS OrderSuboperation,
  I_GLAccountLineItem.Equipment AS Equipment,
  I_GLAccountLineItem.FunctionalLocation AS FunctionalLocation,
  I_GLAccountLineItem.Assembly AS Assembly,
  I_GLAccountLineItem.MaintenanceActivityType AS MaintenanceActivityType,
  I_GLAccountLineItem.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  I_GLAccountLineItem.MaintPriorityType AS MaintPriorityType,
  I_GLAccountLineItem.MaintPriority AS MaintPriority,
  I_GLAccountLineItem.SuperiorOrder AS SuperiorOrder,
  I_GLAccountLineItem.ProductGroup AS ProductGroup,
  I_GLAccountLineItem.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned,
  I_GLAccountLineItem.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.SoldProduct AS SoldProduct,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItem.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItem.SalesDistrict AS SalesDistrict,
  I_GLAccountLineItem.BillToParty AS BillToParty,
  I_GLAccountLineItem.ShipToParty AS ShipToParty,
  I_GLAccountLineItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  I_GLAccountLineItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  I_GLAccountLineItem.CashLedgerAccount AS CashLedgerAccount,
  I_GLAccountLineItem.FinancialManagementArea AS FinancialManagementArea,
  I_GLAccountLineItem.FundsCenter AS FundsCenter,
  I_GLAccountLineItem.FundedProgram AS FundedProgram,
  I_GLAccountLineItem.Fund AS Fund,
  I_GLAccountLineItem.GrantID AS GrantID,
  I_GLAccountLineItem.BudgetPeriod AS BudgetPeriod,
  I_GLAccountLineItem.PartnerFund AS PartnerFund,
  I_GLAccountLineItem.PartnerGrant AS PartnerGrant,
  I_GLAccountLineItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAccountLineItem.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  I_GLAccountLineItem.FinancialServicesBranch AS FinancialServicesBranch,
  I_GLAccountLineItem.FinancialDataSource AS FinancialDataSource,
  I_GLAccountLineItem.JointVenture AS JointVenture,
  I_GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountLineItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAccountLineItem.JointVenturePartner AS JointVenturePartner,
  I_GLAccountLineItem.JointVentureBillingType AS JointVentureBillingType,
  I_GLAccountLineItem.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountLineItem.JointVentureProductionDate AS JointVentureProductionDate,
  I_GLAccountLineItem.JointVentureBillingDate AS JointVentureBillingDate,
  I_GLAccountLineItem.JointVentureOperationalDate AS JointVentureOperationalDate,
  I_GLAccountLineItem.CutbackRun AS CutbackRun,
  I_GLAccountLineItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAccountLineItem.PartnerVenture AS PartnerVenture,
  I_GLAccountLineItem.PartnerEquityGroup AS PartnerEquityGroup,
  I_GLAccountLineItem.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_GLAccountLineItem.CutbackAccount AS CutbackAccount,
  I_GLAccountLineItem.CutbackCostObject AS CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  I_GLAccountLineItem.AccrualObjectType AS AccrualObjectType,
  I_GLAccountLineItem.AccrualObject AS AccrualObject,
  I_GLAccountLineItem.AccrualSubobject AS AccrualSubobject,
  I_GLAccountLineItem.AccrualItemType AS AccrualItemType,
  I_GLAccountLineItem.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItem.ConsolidationUnit AS ConsolidationUnit,
  I_GLAccountLineItem.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  I_GLAccountLineItem.Company AS Company,
  I_GLAccountLineItem.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  I_GLAccountLineItem.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  I_GLAccountLineItem.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  I_GLAccountLineItem.CnsldtnSubitem AS CnsldtnSubitem
FROM I_GLAccountLineItem
;