I_BR_NFADDITIONIMPORTDOC

CDS View

Brazil Nota Fiscal Additional Import Doc

I_BR_NFADDITIONIMPORTDOC is a CDS View in S/4HANA. Brazil Nota Fiscal Additional Import Doc. It contains 1 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_BR_NFAdditionImportDoc view from BASIC Brazil NF Import Document Additions
I_BR_NFAdditionImportDoc_C view from COMPOSITE Brazil Nota Fiscal Import Document

Fields (1)

KeyField CDS FieldsUsed in Views
SalesDocumentCurrency SalesDocumentCurrency 1
@AbapCatalog.sqlViewName: 'IBRNFADDIMPDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Brazil Nota Fiscal Additional Import Doc'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_BR_NFAdditionImportDoc as 
  select from j_1bnfimport_adi as NFAdditionImportDocument 
  association [1..1] to I_BR_NFDocumentCurrency as _BR_NotaFiscal         on $projection.BR_NotaFiscal = _BR_NotaFiscal.BR_NotaFiscal
{
  key NFAdditionImportDocument.docnum as BR_NotaFiscal,
  key NFAdditionImportDocument.itmnum as BR_NotaFiscalItem,
  key cast(NFAdditionImportDocument.ndi as logbr_nfimportdocument preserving type) as BR_NFImportDocument,
  key cast(NFAdditionImportDocument.nadicao as logbr_impdocadditionnumber preserving type) as BR_NFAddition,
  key NFAdditionImportDocument.nseqadic as BR_NFItemSequenceNumber,
  
  cast(NFAdditionImportDocument.cfabricante as logbr_nfe_foreign_manufacturer preserving type)  as BR_NFForeignManufacturer,
  @Semantics.amount.currencyCode:'SalesDocumentCurrency'
  cast(NFAdditionImportDocument.vdescdi as logbr_discountaddimportitem preserving type) as BR_NFAdditionItemDiscountAmt,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: 'BR_NFImportDrawbackConcession'
  cast('' as j_1bnfe_imp_draw_back) as BR_NFDrawbackConcession,
  cast(NFAdditionImportDocument.draw_back as logbr_additionimportdrawback preserving type) as BR_NFImportDrawbackConcession,
   
  @Semantics.currencyCode:true
  _BR_NotaFiscal.SalesDocumentCurrency as SalesDocumentCurrency,
  
  _BR_NotaFiscal._SalesDocumentCurrency
}