P_GLAcctCreditDebitBalance
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)
| Source | Alias | Join Type |
|---|---|---|
| I_GLAccountLineItem | I_GLAccountLineItem | from |
| P_FiscalYearPeriod | P_FiscalYearPeriod | inner |
Parameters (2)
| Name | Type | Default |
|---|---|---|
| P_FromPostingDate | fis_budat_from | |
| P_ToPostingDate | fis_budat_to |
Associations (18)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA