I_BR_NFPartner_VendCust

DDL: I_BR_NFPARTNER_VENDCUST SQL: IBRNFPTNVENDCUST Type: view COMPOSITE

Brazil Nota Fiscal Customer and Supplier

I_BR_NFPartner_VendCust is a Composite CDS View that provides data about "Brazil Nota Fiscal Customer and Supplier" in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_Supplier) and exposes 9 fields with key fields BR_NFPartner, BR_NFPartnerNameFrmtdDesc, PartnerType, BR_NFPartnerNameFrmtdDesc, PartnerType.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_Customer Customer union
I_Supplier Vendor from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBRNFPTNVENDCUST view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Brazil Nota Fiscal Customer and Supplier view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BR_NFPartner I_Supplier Supplier
KEY BR_NFPartnerNameFrmtdDesc
KEY PartnerType
AuthorizationGroup I_Supplier AuthorizationGroup
CustomerasBR_NFPartner
KEY BR_NFPartnerNameFrmtdDesc
KEY PartnerType
AuthorizationGroup I_Customer AuthorizationGroup
IsBusinessPurposeCompleted I_Customer IsBusinessPurposeCompleted 
@AbapCatalog.sqlViewName: 'IBRNFPTNVENDCUST'
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Brazil Nota Fiscal Customer and Supplier'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.preserveKey:true
@Metadata.ignorePropagatedAnnotations: true

define view I_BR_NFPartner_VendCust 
  as select from I_Supplier as Vendor
{
  key Vendor.Supplier as BR_NFPartner,
  key concat(Vendor.OrganizationBPName1, Vendor.OrganizationBPName2) as BR_NFPartnerNameFrmtdDesc,
  key 'V' as PartnerType,
  Vendor.AuthorizationGroup,
  @Semantics.booleanIndicator: true
  Vendor.IsBusinessPurposeCompleted
} 
  union select from I_Customer as Customer 
{
  key Customer.Customer as BR_NFPartner,
  key concat(Customer.OrganizationBPName1, Customer.OrganizationBPName2) as BR_NFPartnerNameFrmtdDesc,
  key 'C' as PartnerType,
  Customer.AuthorizationGroup,
  @Semantics.booleanIndicator: true
  Customer.IsBusinessPurposeCompleted
}

Learn More