I_BR_SIMPLESSupplierTaxRate

DDL: I_BR_SIMPLESSUPPLIERTAXRATE SQL: IBRSIMPLESSUPTAX Type: view BASIC
18 Fields 1 Data Sources 1 Associations

Brazil Simples Nac Supplier Tax Rate

I_BR_SIMPLESSupplierTaxRate (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_BR_SIMPLESSupplierTaxRate is a Basic CDS View that provides data about "Brazil Simples Nac Supplier Tax Rate" in SAP S/4HANA. It reads from 1 data source (logbr_mm_simples) and exposes 18 fields with key fields Supplier, FiscalYear, FiscalMonth, BR_SIMPLESClassCode. It has 1 association to related views.

SAP Help Documentation

CategoryElectronic Documents
StatusReleased
Purpose
This CDS view provides you a list of the tax rates a supplier under the Simples Nacional tax regime must pay each month.

Prerequisites
You have authorizations to access relevant nota fiscal data.

Structure
The key fields are: Supplier Fiscal Year Fiscal Month Simples Class Code Measures and attributes Some important measures and attributes are: Simples Nacional Classes Table ( BR_SIMPLESClassCode ) Tax Rate ( BR_SIMPLESTaxRate )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-LO-BR
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides you a list of the tax rates a supplier under the Simples Nacional tax regime must pay each month.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
logbr_mm_simples logbr_mm_simples from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier _Supplier.Supplier = $projection.Supplier

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBRSIMPLESSUPTAX view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Brazil Simples Nac Supplier Tax Rate view
VDM.viewType #BASIC view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Supplier supplier Account Number of Supplier
KEY FiscalYear fiscal_year Tax Item Fiscal Year
KEY FiscalMonth fiscal_month Fiscal period
KEY BR_SIMPLESClassCode class Simples Nacional Classes Table
BR_SIMPLESTaxRate rate Tax Rate
AuthorizationGroup _Supplier AuthorizationGroup Authorization Group
SupplierAccountGroup _Supplier SupplierAccountGroup Vendor account group
DataControllerSet _Supplier DataControllerSet BP: Data Controller Set Flag
DataController1 _Supplier DataController1 BP: Data Controller (Internal Use Only)
DataController2 _Supplier DataController2 BP: Data Controller (Internal Use Only)
DataController3 _Supplier DataController3 BP: Data Controller (Internal Use Only)
DataController4 _Supplier DataController4 BP: Data Controller (Internal Use Only)
DataController5 _Supplier DataController5 BP: Data Controller (Internal Use Only)
DataController6 _Supplier DataController6 BP: Data Controller (Internal Use Only)
DataController7 _Supplier DataController7 BP: Data Controller (Internal Use Only)
DataController8 _Supplier DataController8 BP: Data Controller (Internal Use Only)
DataController9 _Supplier DataController9 BP: Data Controller (Internal Use Only)
DataController10 _Supplier DataController10 BP: Data Controller (Internal Use Only)

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 I_BR_SIMPLESSupplierTaxRate.
-- 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: IBRSIMPLESSUPTAX

CREATE VIEW I_BR_SIMPLESSupplierTaxRate AS
SELECT
  Supplier,
  fiscal_year AS FiscalYear,
  fiscal_month AS FiscalMonth,
  class AS BR_SIMPLESClassCode,
  rate AS BR_SIMPLESTaxRate,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.DataControllerSet AS DataControllerSet,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10
FROM logbr_mm_simples
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [1..1]
;

Learn More