P_BR_ReportingNFExportKey

DDL: P_BR_REPORTINGNFEXPORTKEY SQL: PBRSPEDNFEXKEY Type: view CONSUMPTION

Nota Fiscal References by NFe Key

P_BR_ReportingNFExportKey is a Consumption CDS View that provides data about "Nota Fiscal References by NFe Key" in SAP S/4HANA. It reads from 5 data sources (I_BR_NFDocument, I_BR_NFDocument, I_BR_NFItem, P_BR_ReportingNFeActive, I_BR_NFExportDocument) and exposes 13 fields with key field BR_NotaFiscal.

5 data source(s) 13 fields

Data Sources (5)

SourceAliasJoin Type
I_BR_NFDocument docMain inner
I_BR_NFDocument docRef inner
I_BR_NFItem itmMain from
P_BR_ReportingNFeActive nfeActive inner
I_BR_NFExportDocument nfeExp inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName PBRSPEDNFEXKEY view
EndUserText.label Nota Fiscal References by NFe Key view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK 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 (13)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal I_BR_NFDocument BR_NotaFiscal
BR_NFDirection
BR_NFIssuedBy
BR_NFPartner
BR_NFModel
BR_NFSeries
BR_NFSubSeries
BR_NFeNumber
BR_NFIssueDate
CompanyCode
BusinessPlace
BusinessPlaceStateTaxNumber
BR_NFPostingDateasBR_NFPostingDate 
@AbapCatalog.sqlViewName: 'PBRSPEDNFEXKEY'
@EndUserText.label: 'Nota Fiscal References by NFe Key'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM: { private: true, viewType: #CONSUMPTION }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType: { sizeCategory: #L, serviceQuality: #X, dataClass: #TRANSACTIONAL }
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: ''

-- PRV_NF_DOC_FISCAL_REF_EXPORT --
define view P_BR_ReportingNFExportKey
  as select from I_BR_NFItem             as itmMain
  -- J_GET_CHV_NFE --
    inner join   I_BR_NFExportDocument   as nfeExp    on  itmMain.BR_NotaFiscal     = nfeExp.BR_NotaFiscal
                                                      and itmMain.BR_NotaFiscalItem = nfeExp.BR_NotaFiscalItem
    inner join   I_BR_NFDocument         as docMain   on docMain.BR_NotaFiscal = nfeExp.BR_NotaFiscal

  -- J_GET_REFERENCE --
    inner join   P_BR_ReportingNFeActive as nfeActive on nfeExp.BR_NFItemExprtNFeAccessKey = nfeActive.BR_NFeAccessKey
    inner join   I_BR_NFDocument         as docRef    on docRef.BR_NotaFiscal = nfeActive.BR_NotaFiscal
{
  key docRef.BR_NotaFiscal                       as BR_NotaFiscal,    -- NF_ID
      docRef.BR_NFDirection,                                          -- IND_OPER
      docRef.BR_NFIssuedBy,                                           -- IND_EMIT
      docRef.BR_NFPartner,                                            -- COD_PART
      docRef.BR_NFModel,                                              -- COD_MOD
      docRef.BR_NFSeries,                                             -- SER
      docRef.BR_NFSubSeries,                                          -- SUB
      docRef.BR_NFeNumber,                                            -- NUM_DOC
      docRef.BR_NFIssueDate,                                          -- DT_DOC
      docMain.CompanyCode,                                            -- EMPRESA
      docMain.BusinessPlace,                                          -- FILIAL
      docRef.BusinessPlaceStateTaxNumber,                             -- IE
      docRef.BR_NFPostingDate                    as BR_NFPostingDate, -- DT_E_S
      nfeExp.BR_NFItemExprtNFeAccessKey          as BR_NFeAccessKey -- CHV_NFE
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_NFDOCUMENT",
"I_BR_NFEXPORTDOCUMENT",
"I_BR_NFITEM",
"P_BR_REPORTINGNFEACTIVE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More