A_BR_NFExportDocument

DDL: A_BR_NFEXPORTDOCUMENT SQL: ABRNFITEMEXPORT Type: view BASIC

Brazil Nota Fiscal Export Document

A_BR_NFExportDocument is a Basic CDS View that provides data about "Brazil Nota Fiscal Export Document" in SAP S/4HANA. It reads from 1 data source (I_BR_NFExportDocument) and exposes 11 fields with key fields BR_NotaFiscal, BR_NotaFiscalItem, BR_NFItemExprtSqncNumber. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_BR_NFExportDocument I_BR_NFExportDocument from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_BR_NFDocument _BR_NFDoc $projection.BR_NotaFiscal = _BR_NFDoc.BR_NotaFiscal

Annotations (18)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ABRNFITEMEXPORT view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Brazil Nota Fiscal Export Document view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name A_BR_NFExportDocument view
ObjectModel.representativeKey BR_NFItemExprtSqncNumber view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal BR_NotaFiscal
KEY BR_NotaFiscalItem BR_NotaFiscalItem
KEY BR_NFItemExprtSqncNumber BR_NFItemExprtSqncNumber
BaseUnit BaseUnit
BR_NFItemExprtRegNumber BR_NFItemExprtRegNumber
BR_NFItemExprtNFeAccessKey BR_NFItemExprtNFeAccessKey
BR_NFItemExportRealQty BR_NFItemExportRealQty
BR_NFItmExprtDrwbkConcession
BR_NFExportDrawbackConcession BR_NFExportDrawbackConcession
_BR_NFDoc _BR_NFDoc
_BR_NFItem _BR_NFItem 
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ABRNFITEMEXPORT'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Brazil Nota Fiscal Export Document'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_BR_NFExportDocument'
@ObjectModel: {
  representativeKey: 'BR_NFItemExprtSqncNumber',
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: false
}
define view A_BR_NFExportDocument
  as select from I_BR_NFExportDocument
  association        to parent A_BR_NFItem as _BR_NFItem on  $projection.BR_NotaFiscal     = _BR_NFItem.BR_NotaFiscal
                                                         and $projection.BR_NotaFiscalItem = _BR_NFItem.BR_NotaFiscalItem
  association [1..1] to A_BR_NFDocument    as _BR_NFDoc  on  $projection.BR_NotaFiscal = _BR_NFDoc.BR_NotaFiscal
{
      //I_BR_NFExportDocument

      @ObjectModel.foreignKey.association: '_BR_NFDoc'
  key BR_NotaFiscal,
      @ObjectModel.foreignKey.association: '_BR_NFItem'
  key BR_NotaFiscalItem,
  key BR_NFItemExprtSqncNumber,
      BaseUnit,
      BR_NFItemExprtRegNumber,
      BR_NFItemExprtNFeAccessKey,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      BR_NFItemExportRealQty,
      cast('' as j_1bnfe_exp_draw_back) as BR_NFItmExprtDrwbkConcession,
      BR_NFExportDrawbackConcession,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BR_NFDoc,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BR_NFItem
}

Learn More