I_BR_NFDocumentTypeText

DDL: I_BR_NFDOCUMENTTYPETEXT SQL: IBRNFDOCTYPETEXT Type: view BASIC

Brazil Nota Fiscal Document Type - Text

I_BR_NFDocumentTypeText (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_NFDocumentTypeText is a Basic CDS View that provides data about "Brazil Nota Fiscal Document Type - Text" in SAP S/4HANA. It reads from 1 data source (j_1bdoctypest) and exposes 5 fields with key fields Language, BR_NFDocumentType. It has 2 associations to related views.

SAP Help Documentation

CategoryElectronic Documents
StatusReleased
Purpose
This CDS view provides you with the document type description according to the language parameter of the nota fiscal.

Prerequisites
You have authorizations to access relevant nota fiscal data.

Structure
The key fields are Language and BR_NFDocumentType . Measures and attributes Some important measures and attributes are: Language ( Language ) Document Type ( BR_NFDocumentType ) Document Type Description ( BR_NFDocumentTypeDesc )

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 with the document type description according to the language parameter of the nota fiscal.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
j_1bdoctypest _BR_NFDocumentTypeText from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BR_NFDocumentType _BR_NFDocumentType $projection.BR_NFDocumentType = _BR_NFDocumentType.BR_NFDocumentType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBRNFDOCTYPETEXT view
EndUserText.label Brazil Nota Fiscal Document Type - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey BR_NFDocumentType view
AbapCatalog.preserveKey true view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language j_1bdoctypest spras Off. Language
KEY BR_NFDocumentType j_1bdoctypest doctyp Single-Character Flag
BR_NFDocumentTypeDesc Document Type
_BR_NFDocumentType _BR_NFDocumentType
_Language _Language

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_NFDocumentTypeText.
-- 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: IBRNFDOCTYPETEXT

CREATE VIEW I_BR_NFDocumentTypeText AS
SELECT
  _BR_NFDocumentTypeText.spras AS Language,
  _BR_NFDocumentTypeText.doctyp AS BR_NFDocumentType,
  cast(_BR_NFDocumentTypeText.text as logbr_nf_doc_type_desc) AS BR_NFDocumentTypeDesc
FROM j_1bdoctypest AS _BR_NFDocumentTypeText
LEFT OUTER JOIN I_BR_NFDocumentType AS _BR_NFDocumentType ON BR_NFDocumentType = _BR_NFDocumentType.BR_NFDocumentType  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;