Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

P_BR_ReportingNFeActive

DDL: P_BR_REPORTINGNFEACTIVE SQL: PBRSPEDNFEACTV Type: view CONSUMPTION
14 Fields 1 Data Sources

EFD - NFe Actual Status and NFe Key

P_BR_ReportingNFeActive is a Consumption CDS View that provides data about "EFD - NFe Actual Status and NFe Key" in SAP S/4HANA. It reads from 1 data source (I_BR_NFeActive) and exposes 14 fields with key field BR_NotaFiscal.

Data Sources (1)

SourceAliasJoin Type
I_BR_NFeActive nfe from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName PBRSPEDNFEACTV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EFD - NFe Actual Status and NFe Key view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal I_BR_NFeActive BR_NotaFiscal Nota Fiscal
Region I_BR_NFeActive Region Venue Region
BR_NFeIssueYear I_BR_NFeActive BR_NFeIssueYear
BR_NFeIssueMonth I_BR_NFeActive BR_NFeIssueMonth Document Month
BR_NFeAccessKeyCNPJOrCPF I_BR_NFeActive BR_NFeAccessKeyCNPJOrCPF Tax Number 1
BR_NFeModel I_BR_NFeActive BR_NFeModel
BR_NFeSeries I_BR_NFeActive BR_NFeSeries
BR_NFeNumber I_BR_NFeActive BR_NFeNumber
BR_NFeRandomNumber I_BR_NFeActive BR_NFeRandomNumber
IssuingType I_BR_NFeActive IssuingType
BR_NFeCheckDigit I_BR_NFeActive BR_NFeCheckDigit
BR_NFActionRequestedCode I_BR_NFeActive BR_NFActionRequestedCode Process Step
BR_NFEnvironmentType I_BR_NFeActive BR_NFEnvironmentType Type Environment
BR_NFeCheckDigitasBR_NFeAccessKey

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_BR_ReportingNFeActive.
-- 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: PBRSPEDNFEACTV

CREATE VIEW P_BR_ReportingNFeActive AS
SELECT
  nfe.BR_NotaFiscal AS BR_NotaFiscal,
  nfe.Region AS Region,
  nfe.BR_NFeIssueYear AS BR_NFeIssueYear,
  nfe.BR_NFeIssueMonth AS BR_NFeIssueMonth,
  nfe.BR_NFeAccessKeyCNPJOrCPF AS BR_NFeAccessKeyCNPJOrCPF,
  nfe.BR_NFeModel AS BR_NFeModel,
  nfe.BR_NFeSeries AS BR_NFeSeries,
  nfe.BR_NFeNumber AS BR_NFeNumber,
  nfe.BR_NFeRandomNumber AS BR_NFeRandomNumber,
  nfe.IssuingType AS IssuingType,
  nfe.BR_NFeCheckDigit AS BR_NFeCheckDigit,
  nfe.BR_NFActionRequestedCode AS BR_NFActionRequestedCode,
  nfe.BR_NFEnvironmentType AS BR_NFEnvironmentType,
  concat(concat(concat(concat(concat(concat(concat(concat( lpad(nfe.Region,2,''), lpad(nfe.BR_NFeIssueYear,2,'')), lpad(nfe.BR_NFeIssueMonth,2,'')), lpad(nfe.BR_NFeAccessKeyCNPJOrCPF,14,'')), lpad(nfe.BR_NFeModel,2,'')), lpad(nfe.BR_NFeSeries,3,'')), lpad(nfe.BR_NFeNumber,9,'')), lpad(nfe.BR_NFeRandomNumber,9,'')), nfe.BR_NFeCheckDigit) as BR_NFeAccessKey AS BR_NFeCheckDigitasBR_NFeAccessKey
FROM I_BR_NFeActive AS nfe
;

Learn More