P_BR_REPORTINGNFEXPORTKEY

CDS View

Nota Fiscal References by NFe Key

P_BR_REPORTINGNFEXPORTKEY is a CDS View in S/4HANA. Nota Fiscal References by NFe Key. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_BR_ReportingNFExport view union CONSUMPTION EFD - Nota Fiscal References

Fields (2)

KeyField CDS FieldsUsed in Views
BR_NFModel BR_NFModel 1
CompanyCode CompanyCode 1 
@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