P_BR_REPORTINGNFEACTIVE

CDS View

EFD - NFe Actual Status and NFe Key

P_BR_REPORTINGNFEACTIVE is a CDS View in S/4HANA. EFD - NFe Actual Status and NFe Key. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_BR_ReportigNFDocumentItemTax view left_outer CONSUMPTION EFD - NF Document Item Tax Cube
P_BR_ReportingNFExport view inner CONSUMPTION EFD - Nota Fiscal References
P_BR_ReportingNFExportKey view inner CONSUMPTION Nota Fiscal References by NFe Key 
@AbapCatalog.sqlViewName: 'PBRSPEDNFEACTV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'EFD - NFe Actual Status and NFe Key'
@VDM: { private: true, viewType: #CONSUMPTION }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: ''

define view P_BR_ReportingNFeActive
  as select from I_BR_NFeActive as nfe
{
  key nfe.BR_NotaFiscal,
      nfe.Region,
      nfe.BR_NFeIssueYear,
      nfe.BR_NFeIssueMonth,
      nfe.BR_NFeAccessKeyCNPJOrCPF,
      nfe.BR_NFeModel,
      nfe.BR_NFeSeries,
      nfe.BR_NFeNumber,
      nfe.BR_NFeRandomNumber,
      nfe.IssuingType,
      nfe.BR_NFeCheckDigit,
      nfe.BR_NFActionRequestedCode,
      nfe.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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_NFEACTIVE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More