P_GlAcctBalanceComprn

DDL: P_GLACCTBALANCECOMPRN SQL: PFIGLBALCOMP Type: view COMPOSITE
340 Fields 1 Data Sources

P_GlAcctBalanceComprn is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_GlAcctBalanceComprn1) and exposes 340 fields with key fields Ledger, CompanyCode, FiscalYear, SourceLedger, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
P_GlAcctBalanceComprn1 P_GlAcctBalanceComprn1 from

Parameters (4)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_ComprnFromPostingDate fis_comprn_budat_from
P_ComprnToPostingDate fis_comprn_budat_to

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PFIGLBALCOMP view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (340)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SourceLedger SourceLedger Source Ledger
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY GLAccountFlowType GLAccountFlowType
KEY FiscalPeriodDate FiscalPeriodDate
KEY ComprnFiscalPeriodDate ComprnFiscalPeriodDate
LedgerFiscalYear LedgerFiscalYear
FinancialTransactionType FinancialTransactionType Transact. Type
BusinessTransactionType BusinessTransactionType Bus.transaction
ReferenceDocumentType ReferenceDocumentType Reference Document Type
LogicalSystem LogicalSystem Logical System
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentItemGroup ReferenceDocumentItemGroup Reference Document Item Group
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
IsSettlement IsSettlement Is Settling
IsSettled IsSettled Is Settled
PredecessorReferenceDocType PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem PredecessorReferenceDocItem Prec. Ref. Doc. Item
GLAccount GLAccount General Ledger
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerCompany PartnerCompany Trading Partner
PartnerSegment PartnerSegment Partner Segment
DebitCreditCode DebitCreditCode Single-Character Flag
FiscalYearVariant FiscalYearVariant FY Variant
FiscalYearPeriod FiscalYearPeriod Period/Year
PostingDate PostingDate Posting Date for GR
AccountingDocumentType AccountingDocumentType Journal Entry Type
AssignmentReference AssignmentReference Assignment Reference
PostingKey PostingKey Posting Key
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
EliminationProfitCenter EliminationProfitCenter
OriginObjectType OriginObjectType Origin
GLAccountType GLAccountType G/L Account Type
ChartOfAccounts ChartOfAccounts Node Class
AlternativeGLAccount AlternativeGLAccount Group Account
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
InvoiceItemReference InvoiceItemReference Item
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
DocumentItemText DocumentItemText Text
Material Material Vehicle Model
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
Plant Plant Valuation Area
Supplier Supplier Supplier
Customer Customer Sold-to Party
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
TaxCode TaxCode Tax Code
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
IsOpenItemManaged IsOpenItemManaged Open Item Management
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
AssetDepreciationArea AssetDepreciationArea Deprec. Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetValueDate AssetValueDate Reference date
AssetTransactionType AssetTransactionType Trans.Type
AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
DepreciationFiscalPeriod DepreciationFiscalPeriod Deprec. Period
GroupMasterFixedAsset GroupMasterFixedAsset
GroupFixedAsset GroupFixedAsset
CostEstimate CostEstimate Cost EstimateNo
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpclStkSalesDocument InventorySpclStkSalesDocument
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID
InventorySpclStockWBSElement InventorySpclStockWBSElement
InventorySpecialStockSupplier InventorySpecialStockSupplier
InventoryValuationType InventoryValuationType Valuation Type
ValuationArea ValuationArea Valuation Area
SenderGLAccount SenderGLAccount
SenderAccountAssignment SenderAccountAssignment
SenderAccountAssignmentType SenderAccountAssignmentType
ControllingObjectDebitType ControllingObjectDebitType
QuantityIsIncomplete QuantityIsIncomplete
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
LineItemIsCompleted LineItemIsCompleted Item Completed
PersonnelNumber PersonnelNumber Personnel No.
ControllingObjectClass ControllingObjectClass Object Class
PartnerCompanyCode PartnerCompanyCode Partner Company Code
PartnerControllingObjectClass PartnerControllingObjectClass
OriginCostCenter OriginCostCenter
OriginCostCtrActivityType OriginCostCtrActivityType
AccountAssignment AccountAssignment Sender Acct Assgmt
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
ProjectNetwork ProjectNetwork Order
RelatedNetworkActivity RelatedNetworkActivity Netwk activity
BusinessProcess BusinessProcess Business Process
CostObject CostObject Cost Object
CustomerServiceNotification CustomerServiceNotification
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
PartnerServiceDocumentType PartnerServiceDocumentType Par. Service DocType
PartnerServiceDocument PartnerServiceDocument Partner Service Doc.
PartnerServiceDocumentItem PartnerServiceDocumentItem Par. Service DocItem
OperatingConcern OperatingConcern Operating concern
PartnerAccountAssignment PartnerAccountAssignment Partner Account Assignment
PartnerAccountAssignmentType PartnerAccountAssignmentType Partner Account Assignment Type
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerOrder PartnerOrder Partner Order
PartnerOrderCategory PartnerOrderCategory
PartnerWBSElement PartnerWBSElement WBS Element
PartnerProject PartnerProject
PartnerSalesDocument PartnerSalesDocument Partner Sales Doc.
PartnerSalesDocumentItem PartnerSalesDocumentItem Partner Sales Document Item
PartnerProjectNetwork PartnerProjectNetwork Part. Proj. Network
PartnerProjectNetworkActivity PartnerProjectNetworkActivity Partner Project Network Activity
PartnerBusinessProcess PartnerBusinessProcess Part. Bus. Process
PartnerCostObject PartnerCostObject Partner Cost Object
BillingDocumentType BillingDocumentType Billing Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SoldMaterial SoldMaterial Product Sold
SoldProduct SoldProduct Product Sold
MaterialGroup MaterialGroup Product Group
SoldProductGroup SoldProductGroup Product Sold Group
CustomerGroup CustomerGroup Customer Group
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry CustomerSupplierIndustry Industry
FinancialServicesProductGroup FinancialServicesProductGroup Product Group (FS)
FinancialServicesBranch FinancialServicesBranch Branch (FS)
FinancialDataSource FinancialDataSource Data Source
FinancialManagementArea FinancialManagementArea FM Area
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
PartnerFund PartnerFund Receiver Fund
PartnerGrant PartnerGrant Receiver Grant
PartnerBudgetPeriod PartnerBudgetPeriod Partner Budget Period
JointVenture JointVenture Joint venture
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
SettlementReferenceDate SettlementReferenceDate Reference date
CostCenter CostCenter Cost Center
CostCtrActivityType CostCtrActivityType Activity Type
OrderID OrderID Order ID
OrderCategory OrderCategory Order Category
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElement WBSElement WBS Internal ID
PartnerWBSElementInternalID PartnerWBSElementInternalID Partner WBS Element Internal ID
Project Project WBS Element
ProjectInternalID ProjectInternalID Project Def.
PartnerProjectInternalID PartnerProjectInternalID
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ClearingDate ClearingDate Clearing Date
BalanceTransactionCurrency BalanceTransactionCurrency Currency
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
FunctionalCurrency FunctionalCurrency Functional Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
ComprnAmountInBalTransCrcy ComprnAmountInBalTransCrcy Amount in Balance Transaction Currency
ComprnAmountInTransCrcy ComprnAmountInTransCrcy Pt Crcy Amt
ComprnAmountInCoCodeCrcy ComprnAmountInCoCodeCrcy Local Crcy Amt
ComprnAmountInGlobalCrcy ComprnAmountInGlobalCrcy Amount in Global Currency
ComprnAmountInFunctionalCrcy ComprnAmountInFunctionalCrcy Amount in Functional Currency
ComprnAmountInFreeDfndCrcy1 ComprnAmountInFreeDfndCrcy1 Amount in Freely Defined Currency 1
ComprnAmountInFreeDfndCrcy2 ComprnAmountInFreeDfndCrcy2 Amount in Freely Defined Currency 2
ComprnAmountInFreeDfndCrcy3 ComprnAmountInFreeDfndCrcy3 Amount in Freely Defined Currency 3
ComprnAmountInFreeDfndCrcy4 ComprnAmountInFreeDfndCrcy4 Amount in Freely Defined Currency 4
ComprnAmountInFreeDfndCrcy5 ComprnAmountInFreeDfndCrcy5 Amount in Freely Defined Currency 5
ComprnAmountInFreeDfndCrcy6 ComprnAmountInFreeDfndCrcy6 Amount in Freely Defined Currency 6
ComprnAmountInFreeDfndCrcy7 ComprnAmountInFreeDfndCrcy7 Amount in Freely Defined Currency 7
ComprnAmountInFreeDfndCrcy8 ComprnAmountInFreeDfndCrcy8 Amount in Freely Defined Currency 8
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
DebitAmountInBalanceTransCrcy DebitAmountInBalanceTransCrcy Debit Amount in Balance Trans. Currency
CreditAmountInBalanceTransCrcy CreditAmountInBalanceTransCrcy Credit Amount in Balance Trans. Currency
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy
DebitAmountInFunctionalCrcy DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
DebitAmountInFreeDefinedCrcy1 DebitAmountInFreeDefinedCrcy1
CreditAmountInFreeDefinedCrcy1 CreditAmountInFreeDefinedCrcy1
DebitAmountInFreeDefinedCrcy2 DebitAmountInFreeDefinedCrcy2
CreditAmountInFreeDefinedCrcy2 CreditAmountInFreeDefinedCrcy2
DebitAmountInFreeDefinedCrcy3 DebitAmountInFreeDefinedCrcy3
CreditAmountInFreeDefinedCrcy3 CreditAmountInFreeDefinedCrcy3
DebitAmountInFreeDefinedCrcy4 DebitAmountInFreeDefinedCrcy4
CreditAmountInFreeDefinedCrcy4 CreditAmountInFreeDefinedCrcy4
DebitAmountInFreeDefinedCrcy5 DebitAmountInFreeDefinedCrcy5
CreditAmountInFreeDefinedCrcy5 CreditAmountInFreeDefinedCrcy5
DebitAmountInFreeDefinedCrcy6 DebitAmountInFreeDefinedCrcy6
CreditAmountInFreeDefinedCrcy6 CreditAmountInFreeDefinedCrcy6
DebitAmountInFreeDefinedCrcy7 DebitAmountInFreeDefinedCrcy7
CreditAmountInFreeDefinedCrcy7 CreditAmountInFreeDefinedCrcy7
DebitAmountInFreeDefinedCrcy8 DebitAmountInFreeDefinedCrcy8
CreditAmountInFreeDefinedCrcy8 CreditAmountInFreeDefinedCrcy8
ComprnDebitAmtInCoCodeCrcy ComprnDebitAmtInCoCodeCrcy Debit Amount in Company Code Currency
ComprnCreditAmtInCoCodeCrcy ComprnCreditAmtInCoCodeCrcy Credit Amount in Company Code Currency
ComprnDebitAmtInTransCrcy ComprnDebitAmtInTransCrcy Debit Amt in DC
ComprnCreditAmtInTransCrcy ComprnCreditAmtInTransCrcy Credit Amt in DC
ComprnDebitAmtInBalTransCrcy ComprnDebitAmtInBalTransCrcy Debit Amount in Balance Trans. Currency
ComprnCreditAmtInBalTransCrcy ComprnCreditAmtInBalTransCrcy Credit Amount in Balance Trans. Currency
ComprnDebitAmtInGlobalCrcy ComprnDebitAmtInGlobalCrcy
ComprnCreditAmtInGlobalCrcy ComprnCreditAmtInGlobalCrcy
ComprnDebitAmtInFunctionalCrcy ComprnDebitAmtInFunctionalCrcy Debit Amount in Functional Currency
ComprnCreditAmtInFuncnlCrcy ComprnCreditAmtInFuncnlCrcy Credit Amount in Functional Currency
ComprnDebitAmtInFreeDfndCrcy1 ComprnDebitAmtInFreeDfndCrcy1
ComprnCreditAmtInFreeDfndCrcy1 ComprnCreditAmtInFreeDfndCrcy1
ComprnDebitAmtInFreeDfndCrcy2 ComprnDebitAmtInFreeDfndCrcy2
ComprnCreditAmtInFreeDfndCrcy2 ComprnCreditAmtInFreeDfndCrcy2
ComprnDebitAmtInFreeDfndCrcy3 ComprnDebitAmtInFreeDfndCrcy3
ComprnCreditAmtInFreeDfndCrcy3 ComprnCreditAmtInFreeDfndCrcy3
ComprnDebitAmtInFreeDfndCrcy4 ComprnDebitAmtInFreeDfndCrcy4
ComprnCreditAmtInFreeDfndCrcy4 ComprnCreditAmtInFreeDfndCrcy4
ComprnDebitAmtInFreeDfndCrcy5 ComprnDebitAmtInFreeDfndCrcy5
ComprnCreditAmtInFreeDfndCrcy5 ComprnCreditAmtInFreeDfndCrcy5
ComprnDebitAmtInFreeDfndCrcy6 ComprnDebitAmtInFreeDfndCrcy6
ComprnCreditAmtInFreeDfndCrcy6 ComprnCreditAmtInFreeDfndCrcy6
ComprnDebitAmtInFreeDfndCrcy7 ComprnDebitAmtInFreeDfndCrcy7
ComprnCreditAmtInFreeDfndCrcy7 ComprnCreditAmtInFreeDfndCrcy7
ComprnDebitAmtInFreeDfndCrcy8 ComprnDebitAmtInFreeDfndCrcy8
ComprnCreditAmtInFreeDfndCrcy8 ComprnCreditAmtInFreeDfndCrcy8
FiscalPeriod FiscalPeriod Tax period
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy
EndingBalanceAmtInTransCrcy EndingBalanceAmtInTransCrcy
EndingBalanceAmtInBalTransCrcy EndingBalanceAmtInBalTransCrcy
EndingBalanceAmtInGlobalCrcy EndingBalanceAmtInGlobalCrcy
EndingBalanceAmtInFuncnlCrcy EndingBalanceAmtInFuncnlCrcy
EndingBalAmtInFreeDfndCrcy1 EndingBalAmtInFreeDfndCrcy1
EndingBalAmtInFreeDfndCrcy2 EndingBalAmtInFreeDfndCrcy2
EndingBalAmtInFreeDfndCrcy3 EndingBalAmtInFreeDfndCrcy3
EndingBalAmtInFreeDfndCrcy4 EndingBalAmtInFreeDfndCrcy4
EndingBalAmtInFreeDfndCrcy5 EndingBalAmtInFreeDfndCrcy5
EndingBalAmtInFreeDfndCrcy6 EndingBalAmtInFreeDfndCrcy6
EndingBalAmtInFreeDfndCrcy7 EndingBalAmtInFreeDfndCrcy7
EndingBalAmtInFreeDfndCrcy8 EndingBalAmtInFreeDfndCrcy8
ComprnEndingBalInCoCodeCrcy ComprnEndingBalInCoCodeCrcy
ComprnEndingBalInTransCrcy ComprnEndingBalInTransCrcy
ComprnEndingBalInBalTransCrcy ComprnEndingBalInBalTransCrcy
ComprnEndingBalInGlobalCrcy ComprnEndingBalInGlobalCrcy
ComprnEndingBalInFuncnlCrcy ComprnEndingBalInFuncnlCrcy
ComprnEndingBalInFreeDfndCrcy1 ComprnEndingBalInFreeDfndCrcy1
ComprnEndingBalInFreeDfndCrcy2 ComprnEndingBalInFreeDfndCrcy2
ComprnEndingBalInFreeDfndCrcy3 ComprnEndingBalInFreeDfndCrcy3
ComprnEndingBalInFreeDfndCrcy4 ComprnEndingBalInFreeDfndCrcy4
ComprnEndingBalInFreeDfndCrcy5 ComprnEndingBalInFreeDfndCrcy5
ComprnEndingBalInFreeDfndCrcy6 ComprnEndingBalInFreeDfndCrcy6
ComprnEndingBalInFreeDfndCrcy7 ComprnEndingBalInFreeDfndCrcy7
ComprnEndingBalInFreeDfndCrcy8 ComprnEndingBalInFreeDfndCrcy8
FromPostingDate FromPostingDate
ToPostingDate ToPostingDate
ComprnFromPostingDate ComprnFromPostingDate
ComprnToPostingDate ComprnToPostingDate
FlowOfFundsLedgerFiscalYear P_GlAcctBalanceComprn1 FlowOfFundsLedgerFiscalYear
FundsCenter FundsCenter Funds Center
ServiceContractType ServiceContractType
ServiceContract ServiceContract Transaction ID
ServiceContractItem ServiceContractItem Item Number in Doc.
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
FundedProgram FundedProgram Funded Program
PubSecBudgetAccount PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate
PubSecBudgetCnsmpnFsclPeriod PubSecBudgetCnsmpnFsclPeriod
PubSecBudgetCnsmpnFsclYear PubSecBudgetCnsmpnFsclYear
PubSecBudgetIsRelevant PubSecBudgetIsRelevant
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType Budget Consumption Type
PubSecBudgetCnsmpnAmtType PubSecBudgetCnsmpnAmtType
ConsolidationUnit ConsolidationUnit Consolidation Unit
PartnerConsolidationUnit PartnerConsolidationUnit Partner Unit
Company Company Owner
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem
CnsldtnSubitemCategory CnsldtnSubitemCategory
CnsldtnSubitem CnsldtnSubitem
AccrualObjectType AccrualObjectType Accrual Object Type
AccrualObject AccrualObject External Reference of Accrual Object
AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
AccrualItemType AccrualItemType Accrual Item Type
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount CashLedgerAccount Cash Origin Account
_CustomerCompany _CustomerCompany
_SupplierCompany _SupplierCompany
_GLAccountFlowType _GLAccountFlowType
_FinServicesProductGroup _FinServicesProductGroup
_FinancialServicesBranch _FinancialServicesBranch
_FinancialDataSource _FinancialDataSource
_CustomerSupplierIndustry _CustomerSupplierIndustry
_CustomerSupplierCountry _CustomerSupplierCountry

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_GlAcctBalanceComprn.
-- 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: PFIGLBALCOMP
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to

CREATE VIEW P_GlAcctBalanceComprn AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountFlowType,
  FiscalPeriodDate,
  ComprnFiscalPeriodDate,
  LedgerFiscalYear,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  GLAccount,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  DebitCreditCode,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  AccountingDocumentType,
  AssignmentReference,
  PostingKey,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  AccountingDocCreatedByUser,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  Material,
  Product,
  ProductGroup,
  Plant,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  CostCenter,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  WBSElement,
  PartnerWBSElementInternalID,
  Project,
  ProjectInternalID,
  PartnerProjectInternalID,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  ClearingDate,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInBalanceTransacCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFunctionalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  ComprnAmountInBalTransCrcy,
  ComprnAmountInTransCrcy,
  ComprnAmountInCoCodeCrcy,
  ComprnAmountInGlobalCrcy,
  ComprnAmountInFunctionalCrcy,
  ComprnAmountInFreeDfndCrcy1,
  ComprnAmountInFreeDfndCrcy2,
  ComprnAmountInFreeDfndCrcy3,
  ComprnAmountInFreeDfndCrcy4,
  ComprnAmountInFreeDfndCrcy5,
  ComprnAmountInFreeDfndCrcy6,
  ComprnAmountInFreeDfndCrcy7,
  ComprnAmountInFreeDfndCrcy8,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8,
  ComprnDebitAmtInCoCodeCrcy,
  ComprnCreditAmtInCoCodeCrcy,
  ComprnDebitAmtInTransCrcy,
  ComprnCreditAmtInTransCrcy,
  ComprnDebitAmtInBalTransCrcy,
  ComprnCreditAmtInBalTransCrcy,
  ComprnDebitAmtInGlobalCrcy,
  ComprnCreditAmtInGlobalCrcy,
  ComprnDebitAmtInFunctionalCrcy,
  ComprnCreditAmtInFuncnlCrcy,
  ComprnDebitAmtInFreeDfndCrcy1,
  ComprnCreditAmtInFreeDfndCrcy1,
  ComprnDebitAmtInFreeDfndCrcy2,
  ComprnCreditAmtInFreeDfndCrcy2,
  ComprnDebitAmtInFreeDfndCrcy3,
  ComprnCreditAmtInFreeDfndCrcy3,
  ComprnDebitAmtInFreeDfndCrcy4,
  ComprnCreditAmtInFreeDfndCrcy4,
  ComprnDebitAmtInFreeDfndCrcy5,
  ComprnCreditAmtInFreeDfndCrcy5,
  ComprnDebitAmtInFreeDfndCrcy6,
  ComprnCreditAmtInFreeDfndCrcy6,
  ComprnDebitAmtInFreeDfndCrcy7,
  ComprnCreditAmtInFreeDfndCrcy7,
  ComprnDebitAmtInFreeDfndCrcy8,
  ComprnCreditAmtInFreeDfndCrcy8,
  FiscalPeriod,
  EndingBalanceAmtInCoCodeCrcy,
  EndingBalanceAmtInTransCrcy,
  EndingBalanceAmtInBalTransCrcy,
  EndingBalanceAmtInGlobalCrcy,
  EndingBalanceAmtInFuncnlCrcy,
  EndingBalAmtInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy8,
  ComprnEndingBalInCoCodeCrcy,
  ComprnEndingBalInTransCrcy,
  ComprnEndingBalInBalTransCrcy,
  ComprnEndingBalInGlobalCrcy,
  ComprnEndingBalInFuncnlCrcy,
  ComprnEndingBalInFreeDfndCrcy1,
  ComprnEndingBalInFreeDfndCrcy2,
  ComprnEndingBalInFreeDfndCrcy3,
  ComprnEndingBalInFreeDfndCrcy4,
  ComprnEndingBalInFreeDfndCrcy5,
  ComprnEndingBalInFreeDfndCrcy6,
  ComprnEndingBalInFreeDfndCrcy7,
  ComprnEndingBalInFreeDfndCrcy8,
  FromPostingDate,
  ToPostingDate,
  ComprnFromPostingDate,
  ComprnToPostingDate,
  P_GlAcctBalanceComprn1.FlowOfFundsLedgerFiscalYear AS FlowOfFundsLedgerFiscalYear,
  FundsCenter,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  FundedProgram,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  CashLedgerCompanyCode,
  CashLedgerAccount
FROM P_GlAcctBalanceComprn1
;

Learn More