I_BR_NFEXPORTDECLARATION

CDS View

Brazil Export Declaration Data for NF

I_BR_NFEXPORTDECLARATION is a CDS View in S/4HANA. Brazil Export Declaration Data for NF. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_BR_NFExportDeclaration view from BASIC BR Export Declaration Data for NF 
@AbapCatalog.sqlViewName: 'IBRNFDUE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Brazil Export Declaration Data for NF'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,#CDS_MODELING_DATA_SOURCE]

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_BR_NFExportDeclaration as select from logbr_nf_due 
  
  association [0..1] to I_BR_DUEType          as _BR_DUEType          on _BR_DUEType.BR_DUEType = $projection.BR_DUEType
  association [0..1] to I_BR_BillOfLadingType as _BR_BillOfLadingType on _BR_BillOfLadingType.BR_BillOfLadingType = $projection.BR_BillOfLadingType
  
{
  
  key docnum                                                    as BR_NotaFiscal,
  due_number                                                    as BR_DUE, 
  due_issued_date                                               as BR_DUEIssuedDate,
  @ObjectModel.foreignKey.association: '_BR_DUEType'
  due_type                                                      as BR_DUEType,
  bill_lading_number                                            as BR_BillOfLading,
  bill_lading_date                                              as BR_BillOfLadingDate,
  @ObjectModel.foreignKey.association: '_BR_BillOfLadingType'
  bill_lading_type                                              as BR_BillOfLadingType,
  export_confirmation_date                                      as BR_DUEExportConfirmationDate,
  
  _BR_DUEType,
  _BR_BillOfLadingType
  
}

Learn More