P_RO_SAFTOplAcctgDocItmExc

DDL: P_RO_SAFTOPLACCTGDOCITMEXC SQL: PROSAFTOADIE Type: view CONSUMPTION
49 Fields 2 Data Sources

Bseg Exclude 8/9 GL accounts

P_RO_SAFTOplAcctgDocItmExc is a Consumption CDS View that provides data about "Bseg Exclude 8/9 GL accounts" in SAP S/4HANA. It reads from 2 data sources (I_RO_SAFTAccountMapping, P_RO_SAFTOplAcctgDocItmBase) and exposes 49 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_RO_SAFTAccountMapping Account inner
P_RO_SAFTOplAcctgDocItmBase P_RO_SAFTOplAcctgDocItmBase from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTOADIE 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 Bseg Exclude 8/9 GL accounts view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Item CompanyCode Receiver Company Code
KEY FiscalYear Item FiscalYear G/L Fiscal Year
KEY AccountingDocument Item AccountingDocument Journal Entry
KEY AccountingDocumentItem Item AccountingDocumentItem Posting View Item
AccountingDocumentType Item AccountingDocumentType Journal Entry Type
Product Item Product Product Sold
BaseUnit Item BaseUnit Unit of Measure
TransactionTypeDetermination Item TransactionTypeDetermination Transaction Key
PostingDate Item PostingDate Posting Date for GR
CompanyCodeCurrency Item CompanyCodeCurrency Local Currency
TransactionCurrency Item TransactionCurrency Transaction Currency
IsNegativePosting Item IsNegativePosting Negative Posting
DebitCreditCode Item DebitCreditCode Single-Character Flag
BsegDebitCreditCode Item BsegDebitCreditCode
OriginalTaxBaseAmount Item OriginalTaxBaseAmount
AmountInTransactionCurrency Item AmountInTransactionCurrency Pt Crcy Amt
OriglTaxBaseAmountInCoCodeCrcy Item OriglTaxBaseAmountInCoCodeCrcy
AmountInCompanyCodeCurrency Item AmountInCompanyCodeCurrency Local Crcy Amt
DocumentItemText Item DocumentItemText Text
Quantity Item Quantity Value
ChartOfAccounts Item ChartOfAccounts Node Class
GLAccount Item GLAccount General Ledger
CountryChartOfAccounts Item CountryChartOfAccounts Chart of Accts
AlternativeGLAccount Item AlternativeGLAccount Group Account
ActiveChartOfAccounts Item ActiveChartOfAccounts
ActiveGLAccount Item ActiveGLAccount
FinancialAccountType Item FinancialAccountType Fin. Account Type
SpecialGLCode Item SpecialGLCode Special G/L Ind
AccountingDocumentItemType Item AccountingDocumentItemType Line Item ID
VATRegistration Item VATRegistration VAT Registration No.
Customer Item Customer Sold-to Party
Supplier Item Supplier Supplier
PaymentTerms Item PaymentTerms Pyt Terms
PaymentMethod Item PaymentMethod Pymt Meth.
TaxCode Item TaxCode Tax Code
ControllingArea Item ControllingArea Controlling Area
ProfitCenter Item ProfitCenter Profit Center
_ProfitCenterText Item _ProfitCenterText
CostCenter Item CostCenter Cost Center
_CostCenterText Item _CostCenterText
Segment Item Segment Segment number
_SegmentText Item _SegmentText
WBSElementInternalID Item WBSElementInternalID WBS Internal ID
_WBSElementBasicData Item _WBSElementBasicData
_WBSElementBasicDataText Item _WBSElementBasicDataText
OrderID Item OrderID Order ID
_Order Item _Order
RO_SAFTStandardAccount I_RO_SAFTAccountMapping RO_SAFTStandardAccount St. Account ID
RO_SAFTIsDefaultZeroQuantity I_RO_SAFTAccountMapping RO_SAFTIsDefaultZeroQuantity Def Zero Quantity

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_SAFTOplAcctgDocItmExc.
-- 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: PROSAFTOADIE
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTOplAcctgDocItmExc AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.Product AS Product,
  Item.BaseUnit AS BaseUnit,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  Item.PostingDate AS PostingDate,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.IsNegativePosting AS IsNegativePosting,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.BsegDebitCreditCode AS BsegDebitCreditCode,
  Item.OriginalTaxBaseAmount AS OriginalTaxBaseAmount,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.OriglTaxBaseAmountInCoCodeCrcy AS OriglTaxBaseAmountInCoCodeCrcy,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.DocumentItemText AS DocumentItemText,
  Item.Quantity AS Quantity,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.GLAccount AS GLAccount,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.ActiveChartOfAccounts AS ActiveChartOfAccounts,
  Item.ActiveGLAccount AS ActiveGLAccount,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.AccountingDocumentItemType AS AccountingDocumentItemType,
  Item.VATRegistration AS VATRegistration,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.PaymentTerms AS PaymentTerms,
  Item.PaymentMethod AS PaymentMethod,
  Item.TaxCode AS TaxCode,
  Item.ControllingArea AS ControllingArea,
  Item.ProfitCenter AS ProfitCenter,
  Item._ProfitCenterText AS _ProfitCenterText,
  Item.CostCenter AS CostCenter,
  Item._CostCenterText AS _CostCenterText,
  Item.Segment AS Segment,
  Item._SegmentText AS _SegmentText,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item._WBSElementBasicData AS _WBSElementBasicData,
  Item._WBSElementBasicDataText AS _WBSElementBasicDataText,
  Item.OrderID AS OrderID,
  Item._Order AS _Order,
  Account.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Account.RO_SAFTIsDefaultZeroQuantity AS RO_SAFTIsDefaultZeroQuantity
FROM P_RO_SAFTOplAcctgDocItmBase
INNER JOIN I_RO_SAFTAccountMapping AS Account ON /* join condition not captured in parsed metadata */
;

Learn More