A_BR_NFePharmaceutical

DDL: A_BR_NFEPHARMACEUTICAL SQL: ABRNFEPHARMA Type: view BASIC

Brazil Nota Fiscal Pharmaceutical Item

A_BR_NFePharmaceutical is a Basic CDS View that provides data about "Brazil Nota Fiscal Pharmaceutical Item" in SAP S/4HANA. It reads from 1 data source (I_BR_NFePharmaceutical) and exposes 8 fields with key fields BR_NotaFiscal, BR_NotaFiscalItem. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_BR_NFePharmaceutical I_BR_NFePharmaceutical 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 ABRNFEPHARMA view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Brazil Nota Fiscal Pharmaceutical Item view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name A_BR_NFePharmaceutical view
ObjectModel.representativeKey BR_NotaFiscalItem view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal BR_NotaFiscal
KEY BR_NotaFiscalItem BR_NotaFiscalItem
BR_ANVISACode BR_ANVISACode
MedicineConsumerMaxPrice MedicineConsumerMaxPrice
BR_ANVISAExemptionReasonText BR_ANVISAExemptionReasonText
SalesDocumentCurrency SalesDocumentCurrency
_BR_NFDoc _BR_NFDoc
_BR_NFItem _BR_NFItem 
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ABRNFEPHARMA'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Brazil Nota Fiscal Pharmaceutical Item'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_BR_NFePharmaceutical'
@ObjectModel: {
  representativeKey: 'BR_NotaFiscalItem',
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: false
}
define view A_BR_NFePharmaceutical
  as select from I_BR_NFePharmaceutical
  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_NFePharmaceutical

      @ObjectModel.foreignKey.association: '_BR_NFDoc'
  key BR_NotaFiscal,
      @ObjectModel.foreignKey.association: '_BR_NFItem'
  key BR_NotaFiscalItem,
      BR_ANVISACode,
      MedicineConsumerMaxPrice,
      BR_ANVISAExemptionReasonText,
      SalesDocumentCurrency,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BR_NFDoc,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BR_NFItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_NFEPHARMACEUTICAL"
],
"ASSOCIATED":
[
"A_BR_NFDOCUMENT",
"A_BR_NFITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More