I_BR_NFTEXTSCOMPATIBILITY

CDS View

Brazil Compatibility Nota Fiscal Texts

I_BR_NFTEXTSCOMPATIBILITY is a CDS View in S/4HANA. Brazil Compatibility Nota Fiscal Texts. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_NFTextsAggregation view union_all COMPOSITE Brazil Nota Fiscal Texts Aggregation 
@AbapCatalog.sqlViewName: 'IBRNFTEXTSCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Brazil Compatibility Nota Fiscal Texts'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,#CDS_MODELING_DATA_SOURCE]
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_BR_NFTextsCompatibility
 as select from I_BR_NFMessage_C 
 association [0..1] to I_BR_NFTextType as _BR_NFTextType on _BR_NFTextType.BR_NFTextType = $projection.BR_NFTextType {
  key BR_NotaFiscal,
  key BR_NFMessageSequenceNumber,
  key BR_NFMessageLineNumber,
  key BR_NotaFiscalItem,
  BR_NFMessageText,
  BR_NFMessageIsManual,
  @ObjectModel.foreignKey.association: '_BR_NFTextType'
  case 
    when I_BR_NFMessage_C.BR_NFMessageIsManual = 'X'
      then cast('M' as logbr_nf_texttype preserving type)
    else cast('G' as logbr_nf_texttype preserving type)
  end as BR_NFTextType,
  _BR_NFTextType
}

Learn More