P_RO_SAFTBalanceBaseExc

DDL: P_RO_SAFTBALANCEBASEEXC SQL: PROSAFTBALBE Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO
24 Fields 1 Data Sources

Acdoca Exclude 8/9 GL accounts

P_RO_SAFTBalanceBaseExc is a Consumption CDS View that provides data about "Acdoca Exclude 8/9 GL accounts" in SAP S/4HANA. It reads from 1 data source (P_RO_SAFTBalanceBase) and exposes 24 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package GLO_FIN_IS_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
P_RO_SAFTBalanceBase P_RO_SAFTBalanceBase from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTBALBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private 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 #NOT_REQUIRED view
EndUserText.label Acdoca Exclude 8/9 GL accounts view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source 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
KEY Ledger Ledger Ledger
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocumentItem AccountingDocumentItem Posting View Item
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
Supplier Supplier Supplier
DebitCreditCode DebitCreditCode Single-Character Flag
ChartOfAccounts ChartOfAccounts Node Class
ActiveChartOfAccounts ActiveChartOfAccounts
GLAccount GLAccount General Ledger
ActiveGLAccount ActiveGLAccount
GLAccountType GLAccountType G/L Account Type
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
AlternativeGLAccount AlternativeGLAccount Group Account
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency

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 P_RO_SAFTBalanceBaseExc.
-- 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: PROSAFTBALBE
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTBalanceBaseExc AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  AccountingDocumentCategory,
  AccountingDocumentItem,
  FinancialAccountType,
  Customer,
  Supplier,
  DebitCreditCode,
  ChartOfAccounts,
  ActiveChartOfAccounts,
  GLAccount,
  ActiveGLAccount,
  GLAccountType,
  CountryChartOfAccounts,
  AlternativeGLAccount,
  PostingDate,
  DocumentDate,
  CompanyCodeCurrency,
  CreditAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy
FROM P_RO_SAFTBalanceBase
;

Learn More