I_BR_NFDocumentReference

DDL: I_BR_NFDOCUMENTREFERENCE SQL: IBRNFDOCREF Type: view BASIC

Brazil Nota Fiscal Document Reference

I_BR_NFDocumentReference (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_NFDocumentReference is a Basic CDS View that provides data about "Brazil Nota Fiscal Document Reference" in SAP S/4HANA. It reads from 1 data source (j_1bnf_docref) and exposes 4 fields with key fields BR_NotaFiscal, BR_NFDocRefSequenceNumber.

SAP Help Documentation

CategoryElectronic Documents
Purpose
This CDS view displays the NF-e referred in the nota fiscal document. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization object assigned: LOBR_NFCDS (Authorization objects for Nota Fiscal CDS Views)

Structure
Important Fields Important fields in this view include the following: Field Name Description BR_NOTAFISCAL Document Number BR_NFDOCREFSEQUENCENUMBER Counter BR_NFDOCUMENTREFERENCETYPE Document Reference Type BR_NFDOCREFERENCEACCESSKEY 44-Digit Access Key

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 for Defining CDS Entities, Data Source in SQL Select
PackageCountry or Region-Specific Functions for Finance for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view displays the NF-e referred in the nota fiscal document.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
j_1bnf_docref j_1bnf_docref from

Annotations (12)

NameValueLevelField
EndUserText.label Brazil Nota Fiscal Document Reference view
AbapCatalog.sqlViewName IBRNFDOCREF view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal docnum Ref. Doc Number
KEY BR_NFDocRefSequenceNumber counter Version
BR_NFDocumentReferenceType Document Reference Type
BR_NFDocReferenceAccessKey 44-Digit Access Key

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_NFDocumentReference.
-- 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: IBRNFDOCREF

CREATE VIEW I_BR_NFDocumentReference AS
SELECT
  docnum AS BR_NotaFiscal,
  counter AS BR_NFDocRefSequenceNumber,
  cast(docref_type as logbr_documentreferencetype preserving type ) AS BR_NFDocumentReferenceType,
  cast(access_key as logbr_documentrefaccesskey preserving type ) AS BR_NFDocReferenceAccessKey
FROM j_1bnf_docref
;