P_GLAcctCreditDebitBalance

DDL: P_GLACCTCREDITDEBITBALANCE SQL: PFIGLACCTCDBAL Type: view COMPOSITE

P_GLAcctCreditDebitBalance is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItem, P_FiscalYearPeriod) and exposes 383 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 18 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from
P_FiscalYearPeriod P_FiscalYearPeriod inner

Parameters (2)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Associations (18)

CardinalityTargetAliasCondition
[0..1] I_WBSElementByExternalID _WBSElementExternalID $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
[0..1] I_WBSElementByExternalID _WBSElementExternalIDText $projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID
[0..1] I_ProjectBasicData _ProjectBasicData $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
[0..1] I_ProjectBasicData _ProjectBasicDataText $projection.ProjectInternalID = _ProjectBasicDataText.ProjectInternalID
[0..1] I_ProjectBasicData _PartnerProjectBasicData $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
[0..1] I_ProjectBasicData _PartnerProjectBasicDataText $projection.PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_WBSElementBasicData _WBSElementBasicDataText $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID
[0..1] I_WBSElementBasicData _PartnerWBSElementBasicData $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID
[0..1] I_WBSElementBasicData _PartnerWBSElmntBasicDataText $projection.PartnerWBSElementInternalID = _PartnerWBSElmntBasicDataText.WBSElementInternalID
[0..1] I_WBSElementByExternalID _PartnerWBSElementExternalID $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
[0..1] I_WBSElementByExternalID _PartnerWBSElemntExtrnalIDText $projection.PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID
[0..1] I_ProjectByExternalID _PartnerProjectExternalID $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
[0..1] I_ProjectByExternalID _PartnerProjctExtrnalIDText $projection.PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID
[0..1] I_ProjectByExternalID _ProjectExternalID $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID
[0..1] I_ProjectByExternalID _ProjectExternalIDText $projection.ProjectExternalID = _ProjectExternalIDText.ProjectExternalID
[0..1] I_WBSElementBasicData _InvtrySpclStockWBSElmntBD $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBD.WBSElementInternalID
[0..1] I_WBSElementByExternalID _InvtrySpclStockWBSElmntExtID $projection.InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PFIGLACCTCDBAL view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (383)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY LedgerGLLineItem LedgerGLLineItem
KEY Ledger Ledger
LedgerFiscalYear LedgerFiscalYear
GLRecordType GLRecordType
ChartOfAccounts ChartOfAccounts
ControllingArea ControllingArea
FinancialTransactionType FinancialTransactionType
BusinessTransactionType BusinessTransactionType
ReferenceDocumentType ReferenceDocumentType
LogicalSystem LogicalSystem
ReferenceDocumentContext ReferenceDocumentContext
ReferenceDocument ReferenceDocument
ReferenceDocumentItem ReferenceDocumentItem
ReferenceDocumentItemGroup ReferenceDocumentItemGroup
IsReversal IsReversal
IsReversed IsReversed
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt
ReversalReferenceDocument ReversalReferenceDocument
IsSettlement IsSettlement
IsSettled IsSettled
PredecessorReferenceDocType PredecessorReferenceDocType
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt
PredecessorReferenceDocument PredecessorReferenceDocument
PredecessorReferenceDocItem PredecessorReferenceDocItem
SourceReferenceDocumentType SourceReferenceDocumentType
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument
SourceReferenceDocumentItem SourceReferenceDocumentItem
SourceReferenceDocSubitem SourceReferenceDocSubitem
IsCommitment IsCommitment
JrnlEntryItemObsoleteReason JrnlEntryItemObsoleteReason
GLAccount GLAccount
CostCenter CostCenter
ProfitCenter ProfitCenter
FunctionalArea FunctionalArea
BusinessArea BusinessArea
Segment Segment
PartnerCostCenter PartnerCostCenter
PartnerProfitCenter PartnerProfitCenter
PartnerFunctionalArea PartnerFunctionalArea
PartnerBusinessArea PartnerBusinessArea
PartnerCompany PartnerCompany
PartnerSegment PartnerSegment
BalanceTransactionCurrency BalanceTransactionCurrency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy
TransactionCurrency TransactionCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
GlobalCurrency GlobalCurrency
AmountInGlobalCurrency AmountInGlobalCurrency
FunctionalCurrency FunctionalCurrency
AmountInFunctionalCurrency AmountInFunctionalCurrency
FreeDefinedCurrency1 FreeDefinedCurrency1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1
FreeDefinedCurrency2 FreeDefinedCurrency2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2
FreeDefinedCurrency3 FreeDefinedCurrency3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3
FreeDefinedCurrency4 FreeDefinedCurrency4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4
FreeDefinedCurrency5 FreeDefinedCurrency5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5
FreeDefinedCurrency6 FreeDefinedCurrency6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6
FreeDefinedCurrency7 FreeDefinedCurrency7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7
FreeDefinedCurrency8 FreeDefinedCurrency8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy
GrpValnFixedAmtInGlobCrcy GrpValnFixedAmtInGlobCrcy
PrftCtrValnFxdAmtInGlobCrcy PrftCtrValnFxdAmtInGlobCrcy
TotalPriceVarcInGlobalCrcy TotalPriceVarcInGlobalCrcy
GrpValnTotPrcVarcInGlobCrcy GrpValnTotPrcVarcInGlobCrcy
PrftCtrValnTotPrcVarcInGlbCrcy PrftCtrValnTotPrcVarcInGlbCrcy
FixedPriceVarcInGlobalCrcy FixedPriceVarcInGlobalCrcy
GrpValnFixedPrcVarcInGlobCrcy GrpValnFixedPrcVarcInGlobCrcy
PrftCtrValnFxdPrcVarcInGlbCrcy PrftCtrValnFxdPrcVarcInGlbCrcy
ControllingObjectCurrency ControllingObjectCurrency
AmountInObjectCurrency AmountInObjectCurrency
BaseUnit BaseUnit
Quantity Quantity
FixedQuantity FixedQuantity
CostSourceUnit CostSourceUnit
ValuationQuantity ValuationQuantity
ValuationFixedQuantity ValuationFixedQuantity
AdditionalQuantity1Unit AdditionalQuantity1Unit
AdditionalQuantity1 AdditionalQuantity1
AdditionalQuantity2Unit AdditionalQuantity2Unit
AdditionalQuantity2 AdditionalQuantity2
AdditionalQuantity3Unit AdditionalQuantity3Unit
AdditionalQuantity3 AdditionalQuantity3
DebitCreditCode DebitCreditCode
FiscalPeriod FiscalPeriod
FiscalYearVariant FiscalYearVariant
FiscalYearPeriod FiscalYearPeriod
DocumentDate DocumentDate
AccountingDocumentType AccountingDocumentType
AccountingDocumentItem AccountingDocumentItem
AssignmentReference AssignmentReference
AccountingDocumentCategory AccountingDocumentCategory
PostingKey PostingKey
TransactionTypeDetermination TransactionTypeDetermination
SubLedgerAcctLineItemType SubLedgerAcctLineItemType
AccountingDocCreatedByUser AccountingDocCreatedByUser
LastChangeDateTime LastChangeDateTime
CreationDateTime CreationDateTime
CreationDate CreationDate
EliminationProfitCenter EliminationProfitCenter
OriginObjectType OriginObjectType
GLAccountType GLAccountType
AlternativeGLAccount AlternativeGLAccount
CountryChartOfAccounts CountryChartOfAccounts
InvoiceReference InvoiceReference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear
FollowOnDocumentType FollowOnDocumentType
InvoiceItemReference InvoiceItemReference
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory
PurchasingDocument PurchasingDocument
PurchasingDocumentItem PurchasingDocumentItem
AccountAssignmentNumber AccountAssignmentNumber
DocumentItemText DocumentItemText
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
Product Product
Material Material
SoldProduct SoldProduct
SoldMaterial SoldMaterial
SoldProductGroup SoldProductGroup
MaterialGroup MaterialGroup
ProductGroup ProductGroup
Plant Plant
Supplier Supplier
Customer Customer
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
TaxCode TaxCode
HouseBank HouseBank
HouseBankAccount HouseBankAccount
IsOpenItemManaged IsOpenItemManaged
ClearingDate ClearingDate
ClearingAccountingDocument ClearingAccountingDocument
ClearingDocFiscalYear ClearingDocFiscalYear
AssetDepreciationArea AssetDepreciationArea
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
AssetValueDate AssetValueDate
AssetTransactionType AssetTransactionType
AssetAcctTransClassfctn AssetAcctTransClassfctn
DepreciationFiscalPeriod DepreciationFiscalPeriod
GroupMasterFixedAsset GroupMasterFixedAsset
GroupFixedAsset GroupFixedAsset
CostEstimate CostEstimate
InventorySpecialStockValnType InventorySpecialStockValnType
InventorySpecialStockType InventorySpecialStockType
InventorySpclStkSalesDocument InventorySpclStkSalesDocument
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID
InvtrySpclStockWBSElmntExtID _InvtrySpclStockWBSElmntBD WBSElementExternalID
InventorySpclStockWBSElement InventorySpclStockWBSElement
InventorySpecialStockSupplier InventorySpecialStockSupplier
InventoryValuationType InventoryValuationType
ValuationArea ValuationArea
SenderCompanyCode SenderCompanyCode
SenderGLAccount SenderGLAccount
SenderAccountAssignment SenderAccountAssignment
SenderAccountAssignmentType SenderAccountAssignmentType
CostOriginGroup CostOriginGroup
OriginSenderObject OriginSenderObject
ControllingDebitCreditCode ControllingDebitCreditCode
ControllingObjectDebitType ControllingObjectDebitType
QuantityIsIncomplete QuantityIsIncomplete
OffsettingAccount OffsettingAccount
OffsettingAccountType OffsettingAccountType
OffsettingChartOfAccounts OffsettingChartOfAccounts
LineItemIsCompleted LineItemIsCompleted
PersonnelNumber PersonnelNumber
ControllingObjectClass ControllingObjectClass
PartnerCompanyCode PartnerCompanyCode
PartnerControllingObjectClass PartnerControllingObjectClass
OriginCostCenter OriginCostCenter
OriginProfitCenter OriginProfitCenter
OriginCostCtrActivityType OriginCostCtrActivityType
OriginProduct OriginProduct
VarianceOriginGLAccount VarianceOriginGLAccount
AccountAssignment AccountAssignment
AccountAssignmentType AccountAssignmentType
CostCtrActivityType CostCtrActivityType
OrderID OrderID
OrderCategory OrderCategory
WBSElementInternalID WBSElementInternalID
PartnerWBSElementInternalID PartnerWBSElementInternalID
WBSElementExternalID
PartnerWBSElementExternalID
WBSElement WBSElement
ProjectInternalID ProjectInternalID
PartnerProjectInternalID PartnerProjectInternalID
ProjectExternalID
PartnerProjectExternalID
Project Project
OperatingConcern OperatingConcern
ProjectNetwork ProjectNetwork
RelatedNetworkActivity RelatedNetworkActivity
BusinessProcess BusinessProcess
CostObject CostObject
CostAnalysisResource CostAnalysisResource
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
ServiceContract ServiceContract
ServiceContractType ServiceContractType
ServiceContractItem ServiceContractItem
PartnerServiceDocumentType PartnerServiceDocumentType
PartnerServiceDocument PartnerServiceDocument
PartnerServiceDocumentItem PartnerServiceDocumentItem
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
CustomerServiceNotification CustomerServiceNotification
PartnerAccountAssignment PartnerAccountAssignment
PartnerAccountAssignmentType PartnerAccountAssignmentType
PartnerCostCtrActivityType PartnerCostCtrActivityType
PartnerOrder PartnerOrder
PartnerOrder_2 PartnerOrder_2
PartnerOrderCategory PartnerOrderCategory
PartnerWBSElement PartnerWBSElement
PartnerProject PartnerProject
PartnerSalesDocument PartnerSalesDocument
PartnerSalesDocumentItem PartnerSalesDocumentItem
PartnerProjectNetwork PartnerProjectNetwork
PartnerProjectNetworkActivity PartnerProjectNetworkActivity
PartnerBusinessProcess PartnerBusinessProcess
PartnerCostObject PartnerCostObject
BillingDocumentType BillingDocumentType
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
CustomerGroup CustomerGroup
CustomerSupplierCountry CustomerSupplierCountry
CustomerSupplierIndustry CustomerSupplierIndustry
FinancialServicesProductGroup FinancialServicesProductGroup
FinancialServicesBranch FinancialServicesBranch
FinancialDataSource FinancialDataSource
SalesDistrict SalesDistrict
BillToParty BillToParty
ShipToParty ShipToParty
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup
JointVenture JointVenture
JointVentureEquityGroup JointVentureEquityGroup
JointVentureCostRecoveryCode JointVentureCostRecoveryCode
JointVentureEquityType JointVentureEquityType
SettlementReferenceDate SettlementReferenceDate
WorkCenterInternalID WorkCenterInternalID
OrderOperation OrderOperation
OrderItem OrderItem
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy
DebitAmountInTransCrcy DebitAmountInTransCrcy
CreditAmountInTransCrcy CreditAmountInTransCrcy
DebitAmountInBalanceTransCrcy DebitAmountInBalanceTransCrcy
CreditAmountInBalanceTransCrcy CreditAmountInBalanceTransCrcy
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy
DebitAmountInFunctionalCrcy DebitAmountInFunctionalCrcy
CreditAmountInFunctionalCrcy CreditAmountInFunctionalCrcy
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
IsStatisticalOrder IsStatisticalOrder
IsStatisticalCostCenter IsStatisticalCostCenter
IsStatisticalSalesDocument IsStatisticalSalesDocument
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement
GLAccountAuthorizationGroup GLAccountAuthorizationGroup
SupplierBasicAuthorizationGrp SupplierBasicAuthorizationGrp
CustomerBasicAuthorizationGrp CustomerBasicAuthorizationGrp
AcctgDocTypeAuthorizationGroup AcctgDocTypeAuthorizationGroup
OrderType OrderType
SalesOrderType SalesOrderType
AssetClass AssetClass
AccrualObjectType AccrualObjectType
AccrualObject AccrualObject
AccrualSubobject AccrualSubobject
AccrualItemType AccrualItemType
AccrualObjectLogicalSystem AccrualObjectLogicalSystem
AccrualReferenceObject AccrualReferenceObject
AccrualValueDate AccrualValueDate
CashLedgerCompanyCode CashLedgerCompanyCode
CashLedgerAccount CashLedgerAccount
FinancialManagementArea FinancialManagementArea
FundsCenter FundsCenter
FundedProgram FundedProgram
Fund Fund
GrantID GrantID
BudgetPeriod BudgetPeriod
PartnerFund PartnerFund
PartnerGrant PartnerGrant
PartnerBudgetPeriod PartnerBudgetPeriod
PubSecBudgetAccount PubSecBudgetAccount
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate
PubSecBudgetCnsmpnFsclPeriod PubSecBudgetCnsmpnFsclPeriod
PubSecBudgetCnsmpnFsclYear PubSecBudgetCnsmpnFsclYear
PubSecBudgetIsRelevant PubSecBudgetIsRelevant
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType
PubSecBudgetCnsmpnAmtType PubSecBudgetCnsmpnAmtType
ConsolidationUnit ConsolidationUnit
PartnerConsolidationUnit PartnerConsolidationUnit
Company Company
ConsolidationChartOfAccounts ConsolidationChartOfAccounts
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem
CnsldtnSubitemCategory CnsldtnSubitemCategory
CnsldtnSubitem CnsldtnSubitem
FlowOfFundsLedgerFiscalYear
_WBSElementExternalID _WBSElementExternalID
_WBSElementExternalIDText _WBSElementExternalIDText
_ProjectBasicData _ProjectBasicData
_ProjectBasicDataText _ProjectBasicDataText
_WBSElementBasicData _WBSElementBasicData
_WBSElementBasicDataText _WBSElementBasicDataText
_ProjectExternalID _ProjectExternalID
_ProjectExternalIDText _ProjectExternalIDText
_PartnerProjectExternalID _PartnerProjectExternalID
_PartnerProjctExtrnalIDText _PartnerProjctExtrnalIDText
_PartnerWBSElementExternalID _PartnerWBSElementExternalID
_PartnerWBSElemntExtrnalIDText _PartnerWBSElemntExtrnalIDText
_PartnerProjectBasicData _PartnerProjectBasicData
_PartnerProjectBasicDataText _PartnerProjectBasicDataText
_PartnerWBSElementBasicData _PartnerWBSElementBasicData
_PartnerWBSElmntBasicDataText _PartnerWBSElmntBasicDataText
_InvtrySpclStockWBSElmntBD _InvtrySpclStockWBSElmntBD
_InvtrySpclStockWBSElmntExtID _InvtrySpclStockWBSElmntExtID
_ServiceContract _ServiceContract
_ServiceContractType _ServiceContractType
_ServiceContractItem _ServiceContractItem
_TimeSheetOvertimeCat _TimeSheetOvertimeCat
_AccrualObjectType _AccrualObjectType
_AccrualObject _AccrualObject
_AccrualSubobject _AccrualSubobject
_AccrualItemType _AccrualItemType
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_FinancialManagementArea _FinancialManagementArea
_FundsCenter _FundsCenter
_FundedProgram _FundedProgram
_Fund _Fund
_BudgetPeriod _BudgetPeriod
_PartnerFund _PartnerFund
_PartnerBudgetPeriod _PartnerBudgetPeriod
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
_PubSecBudgetAccount _PubSecBudgetAccount
_PubSecBudgetCnsmpnDate _PubSecBudgetCnsmpnDate
_PubSecBudgetCnsmpnFsclPeriod _PubSecBudgetCnsmpnFsclPeriod
_PubSecBudgetCnsmpnFsclYear _PubSecBudgetCnsmpnFsclYear
_PubSecBudgetCnsmpnType _PubSecBudgetCnsmpnType
_PubSecBudgetCnsmpnAmtType _PubSecBudgetCnsmpnAmtType
_FunctionalCurrency _FunctionalCurrency
_ConsolidationUnit _ConsolidationUnit
_PartnerConsolidationUnit _PartnerConsolidationUnit
_Company _Company
_ConsolidationChartOfAccounts _ConsolidationChartOfAccounts
_CnsldtnFinancialStatementItem _CnsldtnFinancialStatementItem
_CnsldtnSubitemCategory _CnsldtnSubitemCategory
_CnsldtnSubitem _CnsldtnSubitem
_SupplierCompany _SupplierCompany
_CustomerCompany _CustomerCompany
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PFIGLACCTCDBAL'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED 
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_GLAcctCreditDebitBalance 
with parameters
  P_FromPostingDate       : fis_budat_from,
  P_ToPostingDate         : fis_budat_to  
as select from I_GLAccountLineItem 
left outer to one join I_TrialBalanceUserParam
  on I_TrialBalanceUserParam.UserID = $session.user 
left outer to one join I_YrEndClsgPostingUserParam
  on I_YrEndClsgPostingUserParam.UserID = $session.user
inner join P_FiscalYearPeriod
on I_GLAccountLineItem.FiscalYearVariant = P_FiscalYearPeriod.fiscal_year_variant and
   I_GLAccountLineItem.LedgerFiscalYear = P_FiscalYearPeriod.fiscal_year and 
   I_GLAccountLineItem.FiscalPeriod = P_FiscalYearPeriod.fiscal_period 

association [0..1] to I_WBSElementByExternalID       as _WBSElementExternalID        on  $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
association [0..1] to I_WBSElementByExternalID       as _WBSElementExternalIDText    on  $projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID

association [0..1] to I_ProjectBasicData             as _ProjectBasicData              on  $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectBasicData             as _ProjectBasicDataText          on  $projection.ProjectInternalID = _ProjectBasicDataText.ProjectInternalID
association [0..1] to I_ProjectBasicData             as _PartnerProjectBasicData       on  $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
association [0..1] to I_ProjectBasicData             as _PartnerProjectBasicDataText   on  $projection.PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID
    
association [0..1] to I_WBSElementBasicData          as _WBSElementBasicData           on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  
association [0..1] to I_WBSElementBasicData          as _WBSElementBasicDataText       on  $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID 
association [0..1] to I_WBSElementBasicData          as _PartnerWBSElementBasicData    on  $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID
association [0..1] to I_WBSElementBasicData          as _PartnerWBSElmntBasicDataText  on  $projection.PartnerWBSElementInternalID = _PartnerWBSElmntBasicDataText.WBSElementInternalID

association [0..1] to I_WBSElementByExternalID       as _PartnerWBSElementExternalID        on  $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
association [0..1] to I_WBSElementByExternalID       as _PartnerWBSElemntExtrnalIDText    on  $projection.PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID
//

association [0..1] to I_ProjectByExternalID       as _PartnerProjectExternalID        on  $projection.PartnerProjectExternalID   = _PartnerProjectExternalID.ProjectExternalID  
association [0..1] to I_ProjectByExternalID       as _PartnerProjctExtrnalIDText    on  $projection.PartnerProjectExternalID   = _PartnerProjctExtrnalIDText.ProjectExternalID 

association [0..1] to I_ProjectByExternalID         as _ProjectExternalID             on  $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID
association [0..1] to I_ProjectByExternalID         as _ProjectExternalIDText         on  $projection.ProjectExternalID = _ProjectExternalIDText.ProjectExternalID


association [0..1] to I_WBSElementBasicData          as _InvtrySpclStockWBSElmntBD   on  $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBD.WBSElementInternalID
association [0..1] to I_WBSElementByExternalID       as _InvtrySpclStockWBSElmntExtID  on  $projection.InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID
{
    //I_GLAccountLineItem 

    key SourceLedger, 
    key CompanyCode, 
    key FiscalYear, 
    key AccountingDocument, 
    key LedgerGLLineItem, 
    key Ledger, 
    LedgerFiscalYear, 
    GLRecordType, 
    ChartOfAccounts, 
    ControllingArea, 
    FinancialTransactionType, 
    BusinessTransactionType, 
    ReferenceDocumentType, 
    LogicalSystem, 
    ReferenceDocumentContext, 
    ReferenceDocument, 
    ReferenceDocumentItem, 
    ReferenceDocumentItemGroup, 
    IsReversal, 
    IsReversed, 
    ReversalReferenceDocumentCntxt, 
    ReversalReferenceDocument, 
    IsSettlement, 
    IsSettled, 
    PredecessorReferenceDocType, 
    PredecessorReferenceDocCntxt, 
    PredecessorReferenceDocument, 
    PredecessorReferenceDocItem, 
    SourceReferenceDocumentType, 
    SourceLogicalSystem, 
    SourceReferenceDocumentCntxt, 
    SourceReferenceDocument, 
    SourceReferenceDocumentItem, 
    SourceReferenceDocSubitem, 
    IsCommitment, 
    JrnlEntryItemObsoleteReason, 
    GLAccount, 
    CostCenter, 
    ProfitCenter, 
    FunctionalArea, 
    BusinessArea, 
    Segment, 
    PartnerCostCenter, 
    PartnerProfitCenter, 
    PartnerFunctionalArea, 
    PartnerBusinessArea, 
    PartnerCompany, 
    PartnerSegment, 
    BalanceTransactionCurrency, 
    AmountInBalanceTransacCrcy, 
    TransactionCurrency, 
    AmountInTransactionCurrency, 
    CompanyCodeCurrency, 
    AmountInCompanyCodeCurrency, 
    GlobalCurrency, 
    AmountInGlobalCurrency, 
    FunctionalCurrency,
    AmountInFunctionalCurrency,
    FreeDefinedCurrency1, 
    AmountInFreeDefinedCurrency1, 
    FreeDefinedCurrency2, 
    AmountInFreeDefinedCurrency2, 
    FreeDefinedCurrency3, 
    AmountInFreeDefinedCurrency3, 
    FreeDefinedCurrency4, 
    AmountInFreeDefinedCurrency4, 
    FreeDefinedCurrency5, 
    AmountInFreeDefinedCurrency5, 
    FreeDefinedCurrency6, 
    AmountInFreeDefinedCurrency6, 
    FreeDefinedCurrency7, 
    AmountInFreeDefinedCurrency7, 
    FreeDefinedCurrency8, 
    AmountInFreeDefinedCurrency8, 
    FixedAmountInGlobalCrcy, 
    GrpValnFixedAmtInGlobCrcy, 
    PrftCtrValnFxdAmtInGlobCrcy, 
    TotalPriceVarcInGlobalCrcy, 
    GrpValnTotPrcVarcInGlobCrcy, 
    PrftCtrValnTotPrcVarcInGlbCrcy, 
    FixedPriceVarcInGlobalCrcy, 
    GrpValnFixedPrcVarcInGlobCrcy, 
    PrftCtrValnFxdPrcVarcInGlbCrcy, 
    ControllingObjectCurrency, 
    AmountInObjectCurrency, 
    BaseUnit, 
    Quantity, 
    FixedQuantity, 
    CostSourceUnit, 
    ValuationQuantity, 
    ValuationFixedQuantity, 
    AdditionalQuantity1Unit, 
    AdditionalQuantity1, 
    AdditionalQuantity2Unit, 
    AdditionalQuantity2, 
    AdditionalQuantity3Unit, 
    AdditionalQuantity3, 
    DebitCreditCode, 
    FiscalPeriod, 
    FiscalYearVariant, 
    FiscalYearPeriod, 
    DocumentDate, 
    AccountingDocumentType, 
    AccountingDocumentItem, 
    AssignmentReference, 
    AccountingDocumentCategory, 
    PostingKey, 
    TransactionTypeDetermination, 
    SubLedgerAcctLineItemType, 
    AccountingDocCreatedByUser, 
    LastChangeDateTime, 
    CreationDateTime, 
    CreationDate, 
    EliminationProfitCenter, 
    OriginObjectType, 
    GLAccountType, 
    AlternativeGLAccount, 
    CountryChartOfAccounts, 
    InvoiceReference, 
    InvoiceReferenceFiscalYear, 
    FollowOnDocumentType, 
    InvoiceItemReference, 
    ReferencePurchaseOrderCategory, 
    PurchasingDocument, 
    PurchasingDocumentItem, 
    AccountAssignmentNumber, 
    DocumentItemText, 
    SalesOrder, 
    SalesOrderItem, 
    SalesDocument, 
    SalesDocumentItem, 
    Product,
    Material,

    SoldProduct,
    SoldMaterial,

    SoldProductGroup,
    MaterialGroup,

    ProductGroup,
    
    Plant, 
    Supplier, 
    Customer, 
    FinancialAccountType, 
    SpecialGLCode, 
    TaxCode, 
    HouseBank, 
    HouseBankAccount, 
    IsOpenItemManaged, 
    ClearingDate, 
    ClearingAccountingDocument, 
    ClearingDocFiscalYear, 
    AssetDepreciationArea, 
    MasterFixedAsset, 
    FixedAsset, 
    AssetValueDate, 
    AssetTransactionType, 
    AssetAcctTransClassfctn, 
    DepreciationFiscalPeriod, 
    GroupMasterFixedAsset, 
    GroupFixedAsset, 
    CostEstimate, 
    InventorySpecialStockValnType, 
    InventorySpecialStockType, 
    InventorySpclStkSalesDocument, 
    InventorySpclStkSalesDocItm, 
    InvtrySpclStockWBSElmntIntID, 
    @ObjectModel.foreignKey.association: '_InvtrySpclStockWBSElmntExtID'
    _InvtrySpclStockWBSElmntBD.WBSElementExternalID as InvtrySpclStockWBSElmntExtID,
    InventorySpclStockWBSElement, 
    InventorySpecialStockSupplier, 
    InventoryValuationType, 
    ValuationArea, 
    SenderCompanyCode,
    SenderGLAccount, 
    SenderAccountAssignment, 
    SenderAccountAssignmentType, 
    CostOriginGroup, 
    OriginSenderObject, 
    ControllingDebitCreditCode, 
    ControllingObjectDebitType, 
    QuantityIsIncomplete, 
    OffsettingAccount, 
    OffsettingAccountType, 
    OffsettingChartOfAccounts, 
    LineItemIsCompleted, 
    PersonnelNumber, 
    ControllingObjectClass, 
    PartnerCompanyCode, 
    PartnerControllingObjectClass, 
    OriginCostCenter, 
    OriginProfitCenter, 
    OriginCostCtrActivityType, 
    OriginProduct,
    VarianceOriginGLAccount,
    AccountAssignment, 
    AccountAssignmentType, 
    CostCtrActivityType, 
    OrderID, 
    OrderCategory, 
    WBSElementInternalID,
    @ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
    PartnerWBSElementInternalID,
    @ObjectModel.foreignKey.association: '_WBSElementExternalID'
    cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) as WBSElementExternalID, 
    @ObjectModel.foreignKey.association: '_PartnerWBSElementExternalID'
    cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) as PartnerWBSElementExternalID, 
    WBSElement, 
    ProjectInternalID, 
    @ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
    PartnerProjectInternalID,
    cast( _ProjectBasicData.ProjectExternalID  as fis_projectext_no_conv ) as ProjectExternalID,
    @ObjectModel.foreignKey.association: '_PartnerProjectExternalID'
    cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) as PartnerProjectExternalID,
    Project, 
    OperatingConcern, 
    ProjectNetwork, 
    RelatedNetworkActivity, 
    BusinessProcess, 
    CostObject, 
    CostAnalysisResource, 
    ServiceDocumentType,
    ServiceDocument,
    ServiceDocumentItem,
    ServiceContract,
    ServiceContractType,
    ServiceContractItem,
    PartnerServiceDocumentType,
    PartnerServiceDocument,
    PartnerServiceDocumentItem,
    TimeSheetOvertimeCategory,
    CustomerServiceNotification, 
    PartnerAccountAssignment, 
    PartnerAccountAssignmentType, 
    PartnerCostCtrActivityType, 
    PartnerOrder, 
    PartnerOrder_2, 
    PartnerOrderCategory, 
    PartnerWBSElement, 
    PartnerProject, 
    PartnerSalesDocument, 
    PartnerSalesDocumentItem, 
    PartnerProjectNetwork, 
    PartnerProjectNetworkActivity, 
    PartnerBusinessProcess, 
    PartnerCostObject, 
    BillingDocumentType, 
    SalesOrganization, 
    DistributionChannel, 
    OrganizationDivision, 
    CustomerGroup, 
    CustomerSupplierCountry, 
    CustomerSupplierIndustry, 
    FinancialServicesProductGroup,
    FinancialServicesBranch,
    FinancialDataSource,
    SalesDistrict, 
    BillToParty, 
    ShipToParty, 
    CustomerSupplierCorporateGroup, 
    JointVenture, 
    JointVentureEquityGroup, 
    JointVentureCostRecoveryCode, 
    JointVentureEquityType, 
    SettlementReferenceDate, 
    WorkCenterInternalID, 
    OrderOperation, 
    OrderItem, 
    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, 
    IsStatisticalOrder, 
    IsStatisticalCostCenter, 
    IsStatisticalSalesDocument, 
    WBSIsStatisticalWBSElement, 
    GLAccountAuthorizationGroup, 
    SupplierBasicAuthorizationGrp, 
    CustomerBasicAuthorizationGrp, 
    AcctgDocTypeAuthorizationGroup, 
    OrderType, 
    SalesOrderType, 
    AssetClass,
    
         // Period based reporting 

    ( case when (I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting is null or I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = '' or I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = 'X') then fiscal_period_end_date 
         // Daily based reporting and migrated items without posting date

             when (I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = 'D') and (I_GLAccountLineItem.PostingDate = '00000000') then P_FiscalYearPeriod.fiscal_period_start_date 
         // Daily based reporting with posting date

             when (I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = 'D') and (I_GLAccountLineItem.PostingDate <> '00000000') then PostingDate
         end )
    as PostingDate,
    //migrated items without posting date (BSTAT = C and MIG_SOURCE = C/U)

//    case when I_GLAccountLineItem.PostingDate = '00000000' then P_FiscalYearPeriod.fiscal_period_start_date

//                                                           else PostingDate

//    end as PostingDate,   


         // Period based reporting 

    cast( ( case when (I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting is null or I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = '' or I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = 'X') then concat( P_FiscalYearPeriod.fiscal_period_end_date, P_FiscalYearPeriod.fiscal_period  ) 
         // Daily based reporting and migrated items without posting date

             when (I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = 'D') and (I_GLAccountLineItem.PostingDate = '00000000') then concat( P_FiscalYearPeriod.fiscal_period_start_date, P_FiscalYearPeriod.fiscal_period  ) 
         // Daily based reporting with posting date

             when (I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting = 'D') and (I_GLAccountLineItem.PostingDate <> '00000000') then concat( PostingDate, P_FiscalYearPeriod.fiscal_period  )
         end )
    as fis_fiscalperiod_date ) as FiscalPeriodDate,

//    Coalesce( I_TrialBalanceUserParam.IsPeriodBasedBalanceReporting, 'X' )  as IsPeriodBasedBalanceReporting,

    
    AccrualObjectType,
    AccrualObject,
    AccrualSubobject,
    AccrualItemType,
    AccrualObjectLogicalSystem,
    AccrualReferenceObject,
    AccrualValueDate,   
    
    CashLedgerCompanyCode,
    CashLedgerAccount,
    FinancialManagementArea,
    FundsCenter,
    FundedProgram,
    Fund,
    GrantID,
    BudgetPeriod,
    PartnerFund,
    PartnerGrant,
    PartnerBudgetPeriod,
    PubSecBudgetAccount,
    PubSecBudgetAccountCoCode,
    PubSecBudgetCnsmpnDate,
    PubSecBudgetCnsmpnFsclPeriod,
    PubSecBudgetCnsmpnFsclYear,
    PubSecBudgetIsRelevant,
    PubSecBudgetCnsmpnType,
    PubSecBudgetCnsmpnAmtType,
       
    ConsolidationUnit,
    PartnerConsolidationUnit,
    Company, 
    ConsolidationChartOfAccounts,
    CnsldtnFinancialStatementItem,
    CnsldtnSubitemCategory,
    CnsldtnSubitem,  
 
    cast( LedgerFiscalYear as fis_ryear_flow preserving type ) as FlowOfFundsLedgerFiscalYear,

    _WBSElementExternalID,
    _WBSElementExternalIDText,
    _ProjectBasicData,
    _ProjectBasicDataText,
    _WBSElementBasicData,
    _WBSElementBasicDataText,
    _ProjectExternalID,
    _ProjectExternalIDText,
    
    _PartnerProjectExternalID,
    _PartnerProjctExtrnalIDText,
    _PartnerWBSElementExternalID,
    _PartnerWBSElemntExtrnalIDText,
    _PartnerProjectBasicData,
    _PartnerProjectBasicDataText,
    _PartnerWBSElementBasicData,
    _PartnerWBSElmntBasicDataText,
    
    _InvtrySpclStockWBSElmntBD,
    _InvtrySpclStockWBSElmntExtID,
    
    _ServiceContract,
    _ServiceContractType,
    _ServiceContractItem,
    _TimeSheetOvertimeCat,
    
    _AccrualObjectType,
    _AccrualObject,
    _AccrualSubobject,
    _AccrualItemType,
    
    _CashLedgerCompanyCode,
    _CashLedgerAccount,
    _FinancialManagementArea,
    _FundsCenter,
    _FundedProgram,
    _Fund,
//    _Grant,

    _BudgetPeriod,
    _PartnerFund,
//    _PartnerGrant,

    _PartnerBudgetPeriod,
    _PubSecBudgetAccountCoCode,
    _PubSecBudgetAccount,
    _PubSecBudgetCnsmpnDate,
    _PubSecBudgetCnsmpnFsclPeriod,
    _PubSecBudgetCnsmpnFsclYear,
    _PubSecBudgetCnsmpnType,
    _PubSecBudgetCnsmpnAmtType,
    _FunctionalCurrency,
    _ConsolidationUnit,
    _PartnerConsolidationUnit,
    _Company,
    _ConsolidationChartOfAccounts,
    _CnsldtnFinancialStatementItem,
    _CnsldtnSubitemCategory,
    _CnsldtnSubitem,
    _SupplierCompany,
    _CustomerCompany  
}
where 
    (
    I_GLAccountLineItem.PostingDate between $parameters.P_FromPostingDate and $parameters.P_ToPostingDate
        and ( 
        // exclude opening/closing postings

                ( I_GLAccountLineItem.GLRecordType <> '5' 
        // exclude BCF  -> not required as Inner Join P_FiscalPeriod removes FiscalPeriod 000 from the result

//                and I_GLAccountLineItem.FiscalPeriod > '000' 

                )
        // or include also closing postings if enabled

            or ( I_YrEndClsgPostingUserParam.UserParameterValue = 'X' and I_GLAccountLineItem.GLRecordType = '5' and
        // and exclude opening posting

                 I_GLAccountLineItem.FiscalPeriod > '000' and                  
                    ( I_GLAccountLineItem.AccountingDocumentCategory = 'J' or I_GLAccountLineItem.AccountingDocumentCategory = 'L' )
                )
            )
    )
//include also migrated items

    or 
    ( 
        I_GLAccountLineItem.PostingDate = '00000000' and 
        I_GLAccountLineItem.FiscalPeriod <> '000' and 
        P_FiscalYearPeriod.fiscal_period_start_date <= $parameters.P_ToPostingDate and 
        P_FiscalYearPeriod.fiscal_period_start_date >= $parameters.P_FromPostingDate
    )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEM",
"I_PROJECTBASICDATA",
"I_TRIALBALANCEUSERPARAM",
"I_WBSELEMENTBASICDATA",
"I_YRENDCLSGPOSTINGUSERPARAM",
"P_FISCALYEARPERIOD"
],
"ASSOCIATED":
[
"I_ACCRUALITEMTYPE",
"I_ACCRUALOBJECT",
"I_ACCRUALOBJECTTYPE",
"I_ACCRUALSUBOBJECT",
"I_BUDGETPERIOD",
"I_CNSLDTNCHARTOFACCOUNTS",
"I_CNSLDTNFINSTMNTITEM",
"I_CNSLDTNSUBITEM",
"I_CNSLDTNSUBITEMCATEGORY",
"I_CNSLDTNUNIT_3",
"I_COMPANYCODE",
"I_CURRENCY",
"I_CUSTOMERCOMPANY",
"I_FINANCIALMANAGEMENTAREA",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_FISCCALENDARDATEFORCOMPCODE",
"I_FUND",
"I_FUNDEDPROGRAM",
"I_FUNDSCENTER",
"I_GLACCOUNTINCOMPANYCODE",
"I_GLOBALCOMPANY",
"I_PROJECTBASICDATA",
"I_PROJECTBYEXTERNALID",
"I_PUBSECBDGTCNSMPNAMTTYPE",
"I_PUBSECBDGTCNSMPNTYPE",
"I_PUBSECBUDGETACCOUNT",
"I_SERVICEDOCUMENTTYPE",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SRVCDOCITEMBYDOCUMENTTYPE",
"I_SUPPLIERCOMPANY",
"I_TIMESHEETOVERTIMECAT",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYEXTERNALID"
],
"BASE":
[
"I_GLACCOUNTLINEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/