FAC_DART_Z3_GL_LEDGER_ITEM
Audit Z3 G/L Accounts-Line Items
FAC_DART_Z3_GL_LEDGER_ITEM is a CDS View that provides data about "Audit Z3 G/L Accounts-Line Items" in SAP S/4HANA. It reads from 3 data sources (I_GLAccountLineItemCube, I_LedgerCompanyCodeCrcyRoles, P_Bset) and exposes 153 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 9 associations to related views.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| I_GLAccountLineItemCube | I_GLAccountLineItemCube | from |
| I_LedgerCompanyCodeCrcyRoles | I_LedgerCompanyCodeCrcyRoles | inner |
| P_Bset | P_Bset | left_outer |
Parameters (4)
| Name | Type | Default |
|---|---|---|
| P_FiscalYear | fins_gjahr | |
| P_FromFiscalPeriod | fins_fagl_fiscper_from | |
| P_ToFiscalPeriod | fins_fagl_fiscper_to | |
| P_Language | sylangu |
Associations (9)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_GLAccountText | _GLAcctInChartOfAccountsText | $projection.ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts and $projection.GLAccount = _GLAcctInChartOfAccountsText.GLAccount |
| [0..1] | I_FiscalPeriodForVariant | _FromFiscalPeriodForVariant | _FromFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod |
| [0..1] | I_FiscalPeriodForVariant | _ToFiscalPeriodForVariant | _ToFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod |
| [0..1] | I_OperationalAcctgDocItem | _OperationalAcctgDocItem | $projection.CompanyCode = _OperationalAcctgDocItem.CompanyCode and $projection.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument and $projection.FiscalYear = _OperationalAcctgDocItem.FiscalYear and $projection.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem |
| [1..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [1..1] | I_FiscalYearVariant | _FiscalYearVariant | $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant |
| [1..1] | I_Ledger | _Ledger | $projection.Ledger = _Ledger.Ledger |
| [0..*] | I_FunctionalAreaText | _FunctionAreaText | _FunctionAreaText.FunctionalArea = $projection.FunctionalArea |
| [0..*] | I_AccountingDocumentTypeText | _AccountingDocumentTypeText | _AccountingDocumentTypeText.AccountingDocumentType = $projection.AccountingDocumentType |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | FAC_DZGLLDGRITEM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Audit Z3 G/L Accounts-Line Items | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view |
Fields (153)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Ledger | I_GLAccountLineItemCube | Ledger | Ledger |
| KEY | SourceLedger | SourceLedger | Source Ledger | |
| KEY | CompanyCode | I_GLAccountLineItemCube | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | I_GLAccountLineItemCube | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | I_GLAccountLineItemCube | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | I_GLAccountLineItemCube | LedgerGLLineItem | Journal Entry Item |
| GLAccount | I_GLAccountLineItemCube | GLAccount | General Ledger | |
| FiscalPeriod | FiscalPeriod | Tax period | ||
| PostingDate | PostingDate | Posting Date for GR | ||
| AccountingDocumentHeaderText | ||||
| OriginalReferenceDocument | Original Reference Document | |||
| ReferenceDocument | ReferenceDocument | Reference Document | ||
| ReferenceDocumentType | ReferenceDocumentType | Reference Document Type | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| Customer | Customer | Customer | ||
| Supplier | Supplier | Supplier | ||
| OffsettingAccount | OffsettingAccount | Offsetting Account | ||
| OffsettingAccountName | OffsettingAccountName | |||
| DocumentItemText | DocumentItemText | Text | ||
| ReverseDocument | ||||
| ReverseDocumentFiscalYear | ||||
| TaxCode | I_GLAccountLineItemCube | TaxCode | Tax Code | |
| TaxCountry | I_GLAccountLineItemCube | TaxCountry | Tax Ctry/Reg. | |
| TaxDeterminationDate | P_Bset | TaxDeterminationDate | Tx Determination Dte | |
| TaxRateValidityStartDate | P_Bset | TaxRateValidityStartDate | Tax Rate Validity Start Date | |
| TaxItemGroup | P_Bset | TaxItemGroup | Tax doc. item number | |
| DebitCreditCode | I_GLAccountLineItemCube | DebitCreditCode | Single-Character Flag | |
| DebitAmountInCoCodeCrcy | DebitAmountInCoCodeCrcy | Debit Amt in CoCode Currency | ||
| DebitCompanyCodeCurrency | I_GLAccountLineItemCube | CompanyCodeCurrency | Local Currency | |
| CreditAmountInCoCodeCrcy | Credit Amt in CoCode Currency | |||
| CreditCompanyCodeCurrency | I_GLAccountLineItemCube | CompanyCodeCurrency | Local Currency | |
| CompanyCodeCurrency | I_GLAccountLineItemCube | CompanyCodeCurrency | Local Currency | |
| AddressAndBankIsSetManually | _OperationalAcctgDocItem | AddressAndBankIsSetManually | Address and Bank is Set Manually | |
| DebitAmountInTransCrcy | AmountInTransactionCurrency | Debit Amt in Transac Currency | ||
| DebitTransactionCurrency | ||||
| CreditAmountInTransCrcy | Credit Amt in Transac Currency | |||
| CreditTransactionCurrency | ||||
| BalTransactionCurrency | ||||
| IntercompanyTransaction | ||||
| ExchangeRateDate | Translation date | |||
| TransactionCurrency | Transaction Currency | |||
| ExchangeRate | ||||
| BusinessTransactionType | Business Transaction Type | |||
| BusinessTransactionTypeName | Business Transaction Type Name | |||
| AccountingDocCreatedByUser | ||||
| AccountingDocumentCreationDate | ||||
| LedgerGroup | ||||
| TaxReportingDate | ||||
| TaxIsCalculatedAutomatically | ||||
| DocumentReferenceID | Document Reference ID | |||
| SourceReferenceDocument | SourceReferenceDocument | Reference Doc. | ||
| SourceReferenceDocumentType | SourceReferenceDocumentType | Ref. procedure | ||
| CorporateGroupAccount | _OperationalAcctgDocItem | CorporateGroupAccount | Group Account Number | |
| Reference1IDByBusinessPartner | _OperationalAcctgDocItem | Reference1IDByBusinessPartner | Reference Key 1 | |
| AdditionalCurrency1 | _OperationalAcctgDocItem | AdditionalCurrency1 | Local curr. 2 | |
| AdditionalCurrency2 | _OperationalAcctgDocItem | AdditionalCurrency2 | Local curr. 3 | |
| PaymentMethod | _OperationalAcctgDocItem | PaymentMethod | Pymt Meth. | |
| PaymentMethodSupplement | _OperationalAcctgDocItem | PaymentMethodSupplement | Pmnt Meth. Sup. | |
| AccountingDocumentType | AccountingDocumentType | Journal Entry Type | ||
| AccountingDocumentTypeName | Accounting Document Type Name | |||
| CreationDate | CreationDate | Time Stamp | ||
| AssetValueDate | AssetValueDate | Reference date | ||
| SettlementReferenceDate | SettlementReferenceDate | Reference date | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| DocumentDate | DocumentDate | Journal Entry Date | ||
| IsReversed | IsReversed | Reversed? | ||
| ReversalReferenceDocument | ReversalReferenceDocument | Reversal Reference Document | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| OffsettingAccountType | OffsettingAccountType | Offset Acct Type | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingAccountingDocument | ClearingAccountingDocument | Clearing Journal Entry | ||
| PostingKey | PostingKey | Posting Key | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| FunctionalAreaName | FunctionalArea Name | |||
| TransactionCode | ||||
| RecurringAccountingDocument | ||||
| CostElement | _OperationalAcctgDocItem | CostElement | G/L Account | |
| ControllingBusTransacType | ControllingBusTransacType | CO Bus. Transaction | ||
| WithholdingTaxReportingDate | ||||
| LedgerFiscalYear | LedgerFiscalYear | |||
| ChartOfAccounts | ChartOfAccounts | Node Class | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| FinancialTransactionType | FinancialTransactionType | Transact. Type | ||
| LogicalSystem | LogicalSystem | Logical System | ||
| ReferenceDocumentContext | ReferenceDocumentContext | Reference Document Context | ||
| ReferenceDocumentItem | ReferenceDocumentItem | Reference item | ||
| ReferenceDocumentItemGroup | ReferenceDocumentItemGroup | Reference Document Item Group | ||
| IsReversal | IsReversal | Reversal doc. | ||
| ReversalReferenceDocumentCntxt | ReversalReferenceDocumentCntxt | Reversal Reference Document Context | ||
| 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 | ||
| SourceReferenceDocumentCntxt | SourceReferenceDocumentCntxt | |||
| SourceReferenceDocumentItem | SourceReferenceDocumentItem | Ref. Doc. Item | ||
| SourceReferenceDocSubitem | SourceReferenceDocSubitem | |||
| IsCommitment | IsCommitment | |||
| JrnlEntryItemObsoleteReason | JrnlEntryItemObsoleteReason | |||
| CostCenter | CostCenter | Cost Center | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| BusinessArea | BusinessArea | Business 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 | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Local Crcy Amt | ||
| GlobalCurrency | GlobalCurrency | GM Billing Element: Global Currency | ||
| AmountInGlobalCurrency | AmountInGlobalCurrency | Amount in Global Currency | ||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | Freely Defined Currency 1 | ||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | ||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | Freely Defined Currency 2 | ||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | ||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | Freely Defined Currency 3 | ||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | ||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | Freely Defined Currency 4 | ||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | ||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | Freely Defined Currency 5 | ||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | ||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | Freely Defined Currency 6 | ||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | ||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | Freely Defined Currency 7 | ||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | ||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | Freely Defined Currency 8 | ||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | ||
| FixedAmountInGlobalCrcy | FixedAmountInGlobalCrcy | |||
| GrpValnFixedAmtInGlobCrcy | GrpValnFixedAmtInGlobCrcy | |||
| PrftCtrValnFxdAmtInGlobCrcy | PrftCtrValnFxdAmtInGlobCrcy | |||
| TotalPriceVarcInGlobalCrcy | TotalPriceVarcInGlobalCrcy | |||
| GrpValnTotPrcVarcInGlobCrcy | GrpValnTotPrcVarcInGlobCrcy | |||
| PrftCtrValnTotPrcVarcInGlbCrcy | PrftCtrValnTotPrcVarcInGlbCrcy | |||
| FixedPriceVarcInGlobalCrcy | FixedPriceVarcInGlobalCrcy | |||
| GrpValnFixedPrcVarcInGlobCrcy | GrpValnFixedPrcVarcInGlobCrcy | |||
| PrftCtrValnFxdPrcVarcInGlbCrcy | PrftCtrValnFxdPrcVarcInGlbCrcy | |||
| ControllingObjectCurrency | ControllingObjectCurrency | CO Object Currency | ||
| AmountInObjectCurrency | AmountInObjectCurrency | Amount in Obj Crcy | ||
| BaseUnit | BaseUnit | Unit of Measure | ||
| Quantity | Quantity | Value | ||
| FixedQuantity | FixedQuantity | Fixed Quantity | ||
| CostSourceUnit | CostSourceUnit | |||
| ValuationQuantity | ValuationQuantity | |||
| ValuationFixedQuantity | ValuationFixedQuantity | |||
| AdditionalQuantity1Unit | AdditionalQuantity1Unit | Add Unit Meas 1 | ||
| AdditionalQuantity1 | AdditionalQuantity1 | |||
| AdditionalQuantity2Unit | AdditionalQuantity2Unit | Add Unit Meas 2 | ||
| AdditionalQuantity2 | AdditionalQuantity2 | |||
| AdditionalQuantity3Unit | AdditionalQuantity3Unit | Add Unit Meas 3 |
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 FAC_DART_Z3_GL_LEDGER_ITEM.
-- 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: FAC_DZGLLDGRITEM
-- Parameters: P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu
CREATE VIEW FAC_DART_Z3_GL_LEDGER_ITEM AS
SELECT
I_GLAccountLineItemCube.Ledger AS Ledger,
SourceLedger,
I_GLAccountLineItemCube.CompanyCode AS CompanyCode,
I_GLAccountLineItemCube.FiscalYear AS FiscalYear,
I_GLAccountLineItemCube.AccountingDocument AS AccountingDocument,
I_GLAccountLineItemCube.LedgerGLLineItem AS LedgerGLLineItem,
I_GLAccountLineItemCube.GLAccount AS GLAccount,
FiscalPeriod,
PostingDate,
I_GLAccountLineItemCube._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
I_GLAccountLineItemCube._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
ReferenceDocument,
ReferenceDocumentType,
FunctionalArea,
Customer,
Supplier,
OffsettingAccount,
OffsettingAccountName,
DocumentItemText,
I_GLAccountLineItemCube._JournalEntry.ReverseDocument AS ReverseDocument,
I_GLAccountLineItemCube._JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
I_GLAccountLineItemCube.TaxCode AS TaxCode,
I_GLAccountLineItemCube.TaxCountry AS TaxCountry,
P_Bset.TaxDeterminationDate AS TaxDeterminationDate,
P_Bset.TaxRateValidityStartDate AS TaxRateValidityStartDate,
P_Bset.TaxItemGroup AS TaxItemGroup,
I_GLAccountLineItemCube.DebitCreditCode AS DebitCreditCode,
DebitAmountInCoCodeCrcy,
I_GLAccountLineItemCube.CompanyCodeCurrency AS DebitCompanyCodeCurrency,
cast( (-1) * CreditAmountInCoCodeCrcy as fis_cr_hsl) AS CreditAmountInCoCodeCrcy,
I_GLAccountLineItemCube.CompanyCodeCurrency AS CreditCompanyCodeCurrency,
I_GLAccountLineItemCube.CompanyCodeCurrency AS CompanyCodeCurrency,
_OperationalAcctgDocItem.AddressAndBankIsSetManually AS AddressAndBankIsSetManually,
AmountInTransactionCurrency AS DebitAmountInTransCrcy,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS DebitTransactionCurrency,
cast( (-1) * CreditAmountInTransCrcy as fis_cr_wsl) AS CreditAmountInTransCrcy,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS CreditTransactionCurrency,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS BalTransactionCurrency,
I_GLAccountLineItemCube._JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
I_GLAccountLineItemCube._JournalEntry.ExchangeRateDate AS ExchangeRateDate,
I_GLAccountLineItemCube._JournalEntry.TransactionCurrency AS TransactionCurrency,
I_GLAccountLineItemCube._JournalEntry.ExchangeRate AS ExchangeRate,
I_GLAccountLineItemCube._JournalEntry.BusinessTransactionType AS BusinessTransactionType,
_JournalEntry._BusinessTransactionType._Text[1: Language = $parameters.P_Language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
I_GLAccountLineItemCube._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
I_GLAccountLineItemCube._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
I_GLAccountLineItemCube._JournalEntry.LedgerGroup AS LedgerGroup,
I_GLAccountLineItemCube._JournalEntry.TaxReportingDate AS TaxReportingDate,
I_GLAccountLineItemCube._JournalEntry.TaxIsCalculatedAutomatically AS TaxIsCalculatedAutomatically,
I_GLAccountLineItemCube._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
SourceReferenceDocument,
SourceReferenceDocumentType,
_OperationalAcctgDocItem.CorporateGroupAccount AS CorporateGroupAccount,
_OperationalAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
_OperationalAcctgDocItem.AdditionalCurrency1 AS AdditionalCurrency1,
_OperationalAcctgDocItem.AdditionalCurrency2 AS AdditionalCurrency2,
_OperationalAcctgDocItem.PaymentMethod AS PaymentMethod,
_OperationalAcctgDocItem.PaymentMethodSupplement AS PaymentMethodSupplement,
AccountingDocumentType,
_AccountingDocumentTypeText[1: Language = $parameters.P_Language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
CreationDate,
AssetValueDate,
SettlementReferenceDate,
InvoiceReference,
DocumentDate,
IsReversed,
ReversalReferenceDocument,
FinancialAccountType,
OffsettingAccountType,
ClearingDate,
ClearingAccountingDocument,
PostingKey,
FollowOnDocumentType,
_FunctionAreaText[1: Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
I_GLAccountLineItemCube._JournalEntry.TransactionCode AS TransactionCode,
I_GLAccountLineItemCube._JournalEntry.RecurringAccountingDocument AS RecurringAccountingDocument,
_OperationalAcctgDocItem.CostElement AS CostElement,
ControllingBusTransacType,
I_GLAccountLineItemCube._JournalEntry.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
LedgerFiscalYear,
ChartOfAccounts,
ControllingArea,
FinancialTransactionType,
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
IsReversal,
ReversalReferenceDocumentCntxt,
IsSettlement,
IsSettled,
PredecessorReferenceDocType,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocument,
PredecessorReferenceDocItem,
SourceReferenceDocumentCntxt,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
JrnlEntryItemObsoleteReason,
CostCenter,
ProfitCenter,
BusinessArea,
Segment,
PartnerCostCenter,
PartnerProfitCenter,
PartnerFunctionalArea,
PartnerBusinessArea,
PartnerCompany,
PartnerSegment,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
AmountInCompanyCodeCurrency,
GlobalCurrency,
AmountInGlobalCurrency,
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
FROM I_GLAccountLineItemCube
LEFT OUTER JOIN P_Bset ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount -- association [0..*]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode -- association [1..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger -- association [1..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionAreaText ON _FunctionAreaText.FunctionalArea = FunctionalArea -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON _AccountingDocumentTypeText.AccountingDocumentType = AccountingDocumentType -- association [0..*]
;Learn More
- CDS View Annotations — A Complete Guide
- 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 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA