C_SameAcctDescJrnlEntrItm

DDL: C_SAMEACCTDESCJRNLENTRITM SQL: CGRCSAMEACCTDESC Type: view CONSUMPTION Package: FINS_FIS_GRC_APPS
61 Fields 2 Data Sources 1 Associations

Same G/L Account and Description JE Item

C_SameAcctDescJrnlEntrItm is a Consumption CDS View that provides data about "Same G/L Account and Description JE Item" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItemRawData, P_SameAcctDescJrnlEntrItm) and exposes 61 fields with key fields CompanyCode, FiscalYear, JournalEntry, LedgerGLLineItem, Ledger. It has 1 association to related views. Part of development package FINS_FIS_GRC_APPS.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItemRawData JournalEntryItem from
P_SameAcctDescJrnlEntrItm P_SameAcctDescJrnlEntrItm inner

Parameters (2)

NameTypeDefault
P_ToKeyDateDays far_number
P_KeyDate vdm_v_key_date

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserContactCard JournalEntryItem.AccountingDocCreatedByUser = _UserContactCard.ContactCardID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CGRCSAMEACCTDESC view
EndUserText.label Same G/L Account and Description JE Item view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY JournalEntry I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
KEY Ledger
AccountingDocumentType I_GLAccountLineItemRawData AccountingDocumentType Journal Entry Type
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
AccountingDocumentHeaderText
NmbrOfDplJournalEntryItem _SameAcctDescJrnlEntrItm NmbrOfDplJournalEntryItem Number of Duplicate Journal Entry Item
AmountInTransactionCurrency I_GLAccountLineItemRawData AmountInTransactionCurrency Pt Crcy Amt
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
FiscalYearPeriod I_GLAccountLineItemRawData FiscalYearPeriod Period/Year
AccountingDocCreatedByUser I_GLAccountLineItemRawData AccountingDocCreatedByUser User which created overhead document
TransactionCode
ReverseDocument
DocumentReferenceID
AccountingDocumentCategory
BusinessTransactionType I_GLAccountLineItemRawData BusinessTransactionType Bus.transaction
ReferenceDocumentType I_GLAccountLineItemRawData ReferenceDocumentType Reference Document Type
TransactionCurrency I_GLAccountLineItemRawData TransactionCurrency Transaction Currency
CompanyCodeCurrency I_GLAccountLineItemRawData CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_GLAccountLineItemRawData AmountInCompanyCodeCurrency Local Crcy Amt
ChartOfAccounts I_GLAccountLineItemRawData ChartOfAccounts Node Class
ControllingArea I_GLAccountLineItemRawData ControllingArea Controlling Area
ControllingAreaName
ProfitCenter I_GLAccountLineItemRawData ProfitCenter Profit Center
CostCenter I_GLAccountLineItemRawData CostCenter Cost Center
DocumentDate I_GLAccountLineItemRawData DocumentDate Journal Entry Date
CreationDate I_GLAccountLineItemRawData CreationDate Time Stamp
LastChangeDateTime I_GLAccountLineItemRawData LastChangeDateTime Timestamp
LedgerFiscalYear I_GLAccountLineItemRawData LedgerFiscalYear Ref. Year1
CompanyCodeName
FullName _UserContactCard FullName Name
FiscalYearVariant I_GLAccountLineItemRawData FiscalYearVariant FY Variant
FiscalPeriod I_GLAccountLineItemRawData FiscalPeriod Tax period
DebitCreditCode I_GLAccountLineItemRawData DebitCreditCode Single-Character Flag
FinancialAccountType I_GLAccountLineItemRawData FinancialAccountType Fin. Account Type
Supplier I_GLAccountLineItemRawData Supplier Supplier
Customer I_GLAccountLineItemRawData Customer Sold-to Party
_CompanyCode I_GLAccountLineItemRawData _CompanyCode
_FiscalYear I_GLAccountLineItemRawData _FiscalYear
_JournalEntry I_GLAccountLineItemRawData _JournalEntry
_Ledger I_GLAccountLineItemRawData _Ledger
_AccountingDocumentType I_GLAccountLineItemRawData _AccountingDocumentType
_GLAccountInCompanyCode I_GLAccountLineItemRawData _GLAccountInCompanyCode
_UserContactCard _UserContactCard
_AccountingDocumentCategory
_BusinessTransactionType I_GLAccountLineItemRawData _BusinessTransactionType
_ReferenceDocumentType I_GLAccountLineItemRawData _ReferenceDocumentType
_TransactionCurrency I_GLAccountLineItemRawData _TransactionCurrency
_CompanyCodeCurrency I_GLAccountLineItemRawData _CompanyCodeCurrency
_ChartOfAccounts I_GLAccountLineItemRawData _ChartOfAccounts
_ControllingArea I_GLAccountLineItemRawData _ControllingArea
_ProfitCenter I_GLAccountLineItemRawData _ProfitCenter
_CostCenter I_GLAccountLineItemRawData _CostCenter
_LedgerFiscalYearForVariant I_GLAccountLineItemRawData _LedgerFiscalYearForVariant
_FiscalYearVariant I_GLAccountLineItemRawData _FiscalYearVariant
_DebitCreditCode I_GLAccountLineItemRawData _DebitCreditCode
_FinancialAccountType I_GLAccountLineItemRawData _FinancialAccountType
_Supplier I_GLAccountLineItemRawData _Supplier
_Customer I_GLAccountLineItemRawData _Customer

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 C_SameAcctDescJrnlEntrItm.
-- 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: CGRCSAMEACCTDESC
-- Parameters: P_ToKeyDateDays : far_number, P_KeyDate : vdm_v_key_date

CREATE VIEW C_SameAcctDescJrnlEntrItm AS
SELECT
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS JournalEntry,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  cast(JournalEntryItem.SourceLedger as rldnr preserving type ) AS Ledger,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _SameAcctDescJrnlEntrItm.NmbrOfDplJournalEntryItem AS NmbrOfDplJournalEntryItem,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalEntryItem._JournalEntry.TransactionCode AS TransactionCode,
  JournalEntryItem._JournalEntry.ReverseDocument AS ReverseDocument,
  JournalEntryItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntryItem._JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntryItem.BusinessTransactionType AS BusinessTransactionType,
  JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem._ControllingArea.ControllingAreaName AS ControllingAreaName,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.DocumentDate AS DocumentDate,
  JournalEntryItem.CreationDate AS CreationDate,
  JournalEntryItem.LastChangeDateTime AS LastChangeDateTime,
  JournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  JournalEntryItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _UserContactCard.FullName AS FullName,
  JournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  JournalEntryItem.FiscalPeriod AS FiscalPeriod,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._FiscalYear AS _FiscalYear,
  JournalEntryItem._JournalEntry AS _JournalEntry,
  JournalEntryItem._Ledger AS _Ledger,
  JournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  JournalEntryItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  JournalEntryItem._JournalEntry._AccountingDocumentCategory AS _AccountingDocumentCategory,
  JournalEntryItem._BusinessTransactionType AS _BusinessTransactionType,
  JournalEntryItem._ReferenceDocumentType AS _ReferenceDocumentType,
  JournalEntryItem._TransactionCurrency AS _TransactionCurrency,
  JournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  JournalEntryItem._ControllingArea AS _ControllingArea,
  JournalEntryItem._ProfitCenter AS _ProfitCenter,
  JournalEntryItem._CostCenter AS _CostCenter,
  JournalEntryItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  JournalEntryItem._FiscalYearVariant AS _FiscalYearVariant,
  JournalEntryItem._DebitCreditCode AS _DebitCreditCode,
  JournalEntryItem._FinancialAccountType AS _FinancialAccountType,
  JournalEntryItem._Supplier AS _Supplier,
  JournalEntryItem._Customer AS _Customer
FROM I_GLAccountLineItemRawData AS JournalEntryItem
INNER JOIN P_SameAcctDescJrnlEntrItm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON JournalEntryItem.AccountingDocCreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
;

Learn More