C_RO_SAFTJournalEntryItemQ

DDL: C_RO_SAFTJOURNALENTRYITEMQ SQL: CROSAFTJRNENITMQ Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO
45 Fields 1 Data Sources

GL Item and Header for RO SAFT - Query

C_RO_SAFTJournalEntryItemQ is a Consumption CDS View that provides data about "GL Item and Header for RO SAFT - Query" in SAP S/4HANA. It reads from 1 data source (C_RO_SAFTJournalEntryItemC) and exposes 45 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
C_RO_SAFTJournalEntryItemC C_RO_SAFTJournalEntryItemC from

Parameters (2)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag
P_VATRegistration stceg

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTJRNENITMQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label GL Item and Header for RO SAFT - Query view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
AccountingDocumentItem AccountingDocumentItem Posting View Item
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPartner BusinessPartner Issuing Authority
VATRegistration VATRegistration VAT Registration No.
CustomerTaxID5 CustomerTaxID5
SupplierTaxID5 SupplierTaxID5
DebitCreditCode DebitCreditCode Single-Character Flag
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountCurrency CreditAmountCurrency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountCurrency DebitAmountCurrency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
TaxCode TaxCode Tax Code
TaxCountry TaxCountry Tax Ctry/Reg.
GLAccount GLAccount General Ledger
GLAccountType GLAccountType G/L Account Type
RO_SAFTStandardAccount RO_SAFTStandardAccount
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
StatryRptCategory StatryRptCategory Report ID
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptRunID StatryRptRunID Report Run ID
RO_SAFTJournalTransaction RO_SAFTJournalTransaction
RO_SAFTJournalTransactionType RO_SAFTJournalTransactionType
RO_SAFTJournalTransDescription RO_SAFTJournalTransDescription
RO_SAFTSourceDocument RO_SAFTSourceDocument
ValueDate ValueDate Value Date
DocumentItemText DocumentItemText Text
TransactionTypeDetermination TransactionTypeDetermination Transaction Key

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_RO_SAFTJournalEntryItemQ.
-- 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: CROSAFTJRNENITMQ
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag, P_VATRegistration : stceg

CREATE VIEW C_RO_SAFTJournalEntryItemQ AS
SELECT
  SourceLedger,
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  Customer,
  Supplier,
  BusinessPartner,
  VATRegistration,
  CustomerTaxID5,
  SupplierTaxID5,
  DebitCreditCode,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  CreditAmountInCoCodeCrcy,
  CreditAmountCurrency,
  DebitAmountInCoCodeCrcy,
  DebitAmountCurrency,
  AmountInTransactionCurrency,
  TransactionCurrency,
  CreditAmountInTransCrcy,
  DebitAmountInTransCrcy,
  TaxCode,
  TaxCountry,
  GLAccount,
  GLAccountType,
  RO_SAFTStandardAccount,
  PostingDate,
  DocumentDate,
  AccountingDocumentCreationDate,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  AccountingDocCreatedByUser,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  RO_SAFTJournalTransaction,
  RO_SAFTJournalTransactionType,
  RO_SAFTJournalTransDescription,
  RO_SAFTSourceDocument,
  ValueDate,
  DocumentItemText,
  TransactionTypeDetermination
FROM C_RO_SAFTJournalEntryItemC
;

Learn More