P_RO_SAFTSlsInvoiceItemTaxBase

DDL: P_RO_SAFTSLSINVOICEITEMTAXBASE Type: view_entity CONSUMPTION
13 Fields 2 Data Sources

Sales Invoice Item Taxbase

P_RO_SAFTSlsInvoiceItemTaxBase is a Consumption CDS View that provides data about "Sales Invoice Item Taxbase" in SAP S/4HANA. It reads from 2 data sources (P_RO_SAFTSlsInvoiceItemAmount, I_TaxItem) and exposes 13 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptRunID, SourceLedger, CompanyCode.

Data Sources (2)

SourceAliasJoin Type
P_RO_SAFTSlsInvoiceItemAmount P_RO_SAFTSlsInvoiceItemAmount from
I_TaxItem TaxItem inner

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Sales Invoice Item Taxbase view

Fields (13)

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 Ledger Item Ledger Ledger
KEY TaxItemGroup Item TaxItemGroup Tax doc. item number
KEY TaxCode Item TaxCode Tax Code
PostingDate Item PostingDate Posting Date for GR
DebitCreditCode Item DebitCreditCode Single-Character Flag
CountryCurrency I_TaxItem CountryCurrency 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_SAFTSlsInvoiceItemTaxBase.
-- 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.
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTSlsInvoiceItemTaxBase 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.Ledger AS Ledger,
  Item.TaxItemGroup AS TaxItemGroup,
  Item.TaxCode AS TaxCode,
  Item.PostingDate AS PostingDate,
  Item.DebitCreditCode AS DebitCreditCode,
  TaxItem.CountryCurrency AS CountryCurrency
FROM P_RO_SAFTSlsInvoiceItemAmount
INNER JOIN I_TaxItem AS TaxItem ON /* join condition not captured in parsed metadata */
;

Learn More