C_RO_SAFTJournalEntryItemC

DDL: C_RO_SAFTJOURNALENTRYITEMC SQL: CROSAFTJRNENITMC Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO
69 Fields 1 Data Sources

GL Item and Header for RO SAFT - Cube

C_RO_SAFTJournalEntryItemC is a Consumption CDS View (Cube) that provides data about "GL Item and Header for RO SAFT - Cube" in SAP S/4HANA. It reads from 1 data source (P_RO_SAFTJournalEntryItem) and exposes 69 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptRunID, SourceLedger, CompanyCode. Part of development package GLO_FIN_IS_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
P_RO_SAFTJournalEntryItem P_RO_SAFTJournalEntryItem from

Parameters (2)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag
P_VATRegistration stceg

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTJRNENITMC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL 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 #CHECK view
EndUserText.label GL Item and Header for RO SAFT - Cube view
Metadata.allowExtensions true view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory Item StatryRptCategory Report ID
KEY StatryRptgEntity Item StatryRptgEntity Reporting Entity
KEY StatryRptRunID Item StatryRptRunID Report Run ID
KEY SourceLedger Item SourceLedger Source Ledger
KEY CompanyCode Item CompanyCode Receiver Company Code
KEY FiscalYear Item FiscalYear G/L Fiscal Year
KEY AccountingDocument Item AccountingDocument Journal Entry
KEY LedgerGLLineItem Item LedgerGLLineItem Journal Entry Item
KEY Ledger Item Ledger Ledger
AccountingDocumentItem Item AccountingDocumentItem Posting View Item
FinancialAccountType Item FinancialAccountType Fin. Account Type
Customer Item Customer Sold-to Party
Supplier Item Supplier Supplier
DebitCreditCode Item DebitCreditCode Single-Character Flag
TaxCode Item TaxCode Tax Code
TaxCountry Item TaxCountry Tax Ctry/Reg.
GLAccount Item GLAccount General Ledger
ChartOfAccounts Item ChartOfAccounts Node Class
AlternativeGLAccount Item AlternativeGLAccount Group Account
CountryChartOfAccounts Item CountryChartOfAccounts Chart of Accts
GLAccountType Item GLAccountType G/L Account Type
PostingDate Item PostingDate Posting Date for GR
DocumentDate Item DocumentDate Journal Entry Date
AccountingDocumentCreationDate Item AccountingDocumentCreationDate Journal Entry Date
AccountingDocCreatedByUser Item AccountingDocCreatedByUser User which created overhead document
AccountingDocumentType Item AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName Item AccountingDocumentTypeName
ValueDate Item ValueDate Value Date
DocumentItemText Item DocumentItemText Text
BaseUnit Item BaseUnit Unit of Measure
ControllingArea Item ControllingArea Controlling Area
ProfitCenter Item ProfitCenter Profit Center
_ProfitCenterTxt Item _ProfitCenterTxt
Segment Item Segment Segment number
_SegmentText Item _SegmentText
CostCenter Item CostCenter Cost Center
_CostCenterTxt Item _CostCenterTxt
OrderID Item OrderID Order ID
_Order Item _Order
WBSElement Item WBSElement WBS Internal ID
WBSElementInternalID Item WBSElementInternalID WBS Internal ID
_WBSElementBasicDataText Item _WBSElementBasicDataText
TransactionTypeDetermination Item TransactionTypeDetermination Transaction Key
CustomerTaxID5endasCustomerTaxID5
SupplierTaxID5endasSupplierTaxID5
BusinessPartner Item BusinessPartner Issuing Authority
CreditAmountInCoCodeCrcy Item CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountCurrency Item CreditAmountCurrency
DebitAmountInCoCodeCrcy Item DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountCurrency Item DebitAmountCurrency
AmountInCompanyCodeCurrency Item AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency Item CompanyCodeCurrency Local Currency
CreditAmountInTransCrcy Item CreditAmountInTransCrcy Credit Amt in DC
DebitAmountInTransCrcy Item DebitAmountInTransCrcy Debit Amt in DC
AmountInTransactionCurrency Item AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency Item TransactionCurrency Transaction Currency
VATRegistration
RO_SAFTStandardAccount Item RO_SAFTStandardAccount
RO_SAFTJournalTransaction Item RO_SAFTJournalTransaction
RO_SAFTSourceDocument Item RO_SAFTSourceDocument
RO_SAFTJournalTransactionType Item RO_SAFTJournalTransactionType
RO_SAFTJournalTransDescription Item RO_SAFTJournalTransDescription
TaxType
RO_SAFTCustomerTaxType Item RO_SAFTCustomerTaxType
RO_SAFTSupplierTaxType Item RO_SAFTSupplierTaxType
LogicalSystem Item LogicalSystem Logical System
RO_SAFTExchangeRate Item RO_SAFTExchangeRate
FiscalPeriod
TaxReportingDate

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

CREATE VIEW C_RO_SAFTJournalEntryItemC AS
SELECT
  Item.StatryRptCategory AS StatryRptCategory,
  Item.StatryRptgEntity AS StatryRptgEntity,
  Item.StatryRptRunID AS StatryRptRunID,
  Item.SourceLedger AS SourceLedger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.Ledger AS Ledger,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.TaxCode AS TaxCode,
  Item.TaxCountry AS TaxCountry,
  Item.GLAccount AS GLAccount,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.GLAccountType AS GLAccountType,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  Item.ValueDate AS ValueDate,
  Item.DocumentItemText AS DocumentItemText,
  Item.BaseUnit AS BaseUnit,
  Item.ControllingArea AS ControllingArea,
  Item.ProfitCenter AS ProfitCenter,
  Item._ProfitCenterTxt AS _ProfitCenterTxt,
  Item.Segment AS Segment,
  Item._SegmentText AS _SegmentText,
  Item.CostCenter AS CostCenter,
  Item._CostCenterTxt AS _CostCenterTxt,
  Item.OrderID AS OrderID,
  Item._Order AS _Order,
  Item.WBSElement AS WBSElement,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item._WBSElementBasicDataText AS _WBSElementBasicDataText,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  case when Item.CustomerTaxID5 = '0' and Item.SupplierTaxID5 = '0' then cast( $parameters.P_VATRegistration as stcd5 ) else Item.CustomerTaxID5 end as CustomerTaxID5 AS CustomerTaxID5endasCustomerTaxID5,
  case when Item.CustomerTaxID5 = '0' and Item.SupplierTaxID5 = '0' then cast( $parameters.P_VATRegistration as stcd5 ) else Item.SupplierTaxID5 end as SupplierTaxID5 AS SupplierTaxID5endasSupplierTaxID5,
  Item.BusinessPartner AS BusinessPartner,
  Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  Item.CreditAmountCurrency AS CreditAmountCurrency,
  Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Item.DebitAmountCurrency AS DebitAmountCurrency,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  Item.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  ' ' AS VATRegistration,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Item.RO_SAFTJournalTransaction AS RO_SAFTJournalTransaction,
  Item.RO_SAFTSourceDocument AS RO_SAFTSourceDocument,
  Item.RO_SAFTJournalTransactionType AS RO_SAFTJournalTransactionType,
  Item.RO_SAFTJournalTransDescription AS RO_SAFTJournalTransDescription,
  ' ' AS TaxType,
  Item.RO_SAFTCustomerTaxType AS RO_SAFTCustomerTaxType,
  Item.RO_SAFTSupplierTaxType AS RO_SAFTSupplierTaxType,
  Item.LogicalSystem AS LogicalSystem,
  Item.RO_SAFTExchangeRate AS RO_SAFTExchangeRate,
  Item._JournalEntry.FiscalPeriod AS FiscalPeriod,
  Item._JournalEntry.TaxReportingDate AS TaxReportingDate
FROM P_RO_SAFTJournalEntryItem
;

Learn More