I_BR_OneTimePartner

DDL: I_BR_ONETIMEPARTNER SQL: IBRONETIMEPART Type: view BASIC Package: GLO_LOG_BR

Brazil Nota Fiscal One Time Partner

I_BR_OneTimePartner (Basic)

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

Country or Region-Specific Functions for Finance

I_BR_OneTimePartner is a Basic CDS View that provides data about "Brazil Nota Fiscal One Time Partner" in SAP S/4HANA. It reads from 1 data source (j_1bnfcpd) and exposes 13 fields with key fields BR_NotaFiscal, BR_PartnerFunction. Part of development package GLO_LOG_BR.

SAP Help Documentation

CategoryElectronic Documents
StatusReleased
Purpose
This CDS view provides the prerequisites for answering business questions about relevant aspects of nota fiscal one time partner account.

Prerequisites
You have authorizations to access relevant nota fiscal data.

Structure
The key fields are BR_NotaFiscal and BR_PartnerFunction . Measures and attributes Some important measures and attributes are: Business Partner Name 1 ( BusinessPartnerName1 ) Business Partner Name 2 ( BusinessPartnerName2 ) Business Partner CNPJ ( BR_PartnerCNPJ ) Business Partner CPF ( BR_PartnerCPF ) Business Partner State Tax Number ( BR_PartnerStateTaxNumberST ) Business Partner State Tax Number ( BR_PartnerStateTaxNumberS T)

View on SAP Help Portal →

SAP API Hub

CategoryBasic
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
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCountry/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering business questions about relevant aspects of nota fiscal one time partner account.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
j_1bnfcpd OneTimePartner from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBRONETIMEPART view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Brazil Nota Fiscal One Time Partner view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal j_1bnfcpd docnum Ref. Doc Number
KEY BR_PartnerFunction j_1bnfcpd parvw Nota Fiscal Partner Function
BusinessPartnerName1 j_1bnfcpd name1 PA text
BusinessPartnerName2 j_1bnfcpd name2 Name2/First nme
BR_PartnerCNPJ j_1bnfcpd stcd1 Tax Number 1
BR_PartnerCPF j_1bnfcpd stcd2 Tax Number 2
BR_PartnerStateTaxNumberST j_1bnfcpd j_1bstains State Tax Number
BusinessPartnerTaxJurisdiction j_1bnfcpd taxjurcode Tax Jurisdiction
BusinessPartnerStreetNameOnly j_1bnfcpd street Street Code
BusinessPartnerStreetName j_1bnfcpd stras Street and House Number
BusinessPartnerHouseNumber j_1bnfcpd house_num1 House Number
BPHsNmbrSuplmntTxt j_1bnfcpd house_num2 House number supplement
BusinessPartnerDistrict j_1bnfcpd city2 District

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_OneTimePartner.
-- 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: IBRONETIMEPART

CREATE VIEW I_BR_OneTimePartner AS
SELECT
  OneTimePartner.docnum AS BR_NotaFiscal,
  OneTimePartner.parvw AS BR_PartnerFunction,
  OneTimePartner.name1 AS BusinessPartnerName1,
  OneTimePartner.name2 AS BusinessPartnerName2,
  OneTimePartner.stcd1 AS BR_PartnerCNPJ,
  OneTimePartner.stcd2 AS BR_PartnerCPF,
  OneTimePartner.j_1bstains AS BR_PartnerStateTaxNumberST,
  OneTimePartner.taxjurcode AS BusinessPartnerTaxJurisdiction,
  OneTimePartner.street AS BusinessPartnerStreetNameOnly,
  OneTimePartner.stras AS BusinessPartnerStreetName,
  OneTimePartner.house_num1 AS BusinessPartnerHouseNumber,
  OneTimePartner.house_num2 AS BPHsNmbrSuplmntTxt,
  OneTimePartner.city2 AS BusinessPartnerDistrict
FROM j_1bnfcpd AS OneTimePartner
;