P_BR_RptgOneTimePartner

DDL: P_BR_RPTGONETIMEPARTNER SQL: PBRSPED1TMEPART Type: view CONSUMPTION

EFD - One Time Partner

P_BR_RptgOneTimePartner is a Consumption CDS View that provides data about "EFD - One Time Partner" in SAP S/4HANA. It reads from 3 data sources (I_BR_BCBCountryCode, I_BR_NFDocument, I_BR_OneTimePartner) and exposes 12 fields.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
I_BR_BCBCountryCode bcb inner
I_BR_NFDocument doc inner
I_BR_OneTimePartner otp from

Annotations (14)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PBRSPED1TMEPART view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EFD - One Time Partner view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (12)

KeyFieldSource TableSource FieldDescription
BusinessPartner
BusinessPartner
BusinessPartnerName
BR_BCBCountryCode I_BR_BCBCountryCode BR_BCBCountryCode
BR_PartnerCNPJ I_BR_OneTimePartner BR_PartnerCNPJ
BR_PartnerCPF I_BR_OneTimePartner BR_PartnerCPF
BR_PartnerStateTaxNumberST I_BR_OneTimePartner BR_PartnerStateTaxNumberST
TaxJurisdiction
BR_SUFRAMACode I_BR_NFDocument BR_SUFRAMACode
HouseNumber I_BR_OneTimePartner BusinessPartnerHouseNumber
HouseNumberSupplementText I_BR_OneTimePartner BPHsNmbrSuplmntTxt
District I_BR_OneTimePartner BusinessPartnerDistrict 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PBRSPED1TMEPART'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'EFD - One Time Partner'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType: { sizeCategory: #L, serviceQuality: #X, dataClass: #TRANSACTIONAL }
@VDM: { private: true, viewType: #CONSUMPTION }
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '' 

define view P_BR_RptgOneTimePartner
  as select from I_BR_OneTimePartner as otp
      inner join I_BR_NFDocument     as doc on doc.BR_NotaFiscal = otp.BR_NotaFiscal
      inner join I_BR_BCBCountryCode as bcb on doc.BR_NFPartnerCountryCode = bcb.CountryCode
{
  concat(doc.BR_NFPartnerType,doc.BR_NFPartner) as BusinessPartner,
  --otp.NotaFiscal as BusinessPartner,
  concat_with_space(otp.BusinessPartnerName1,otp.BusinessPartnerName2,1) as BusinessPartnerName,
  bcb.BR_BCBCountryCode,
  otp.BR_PartnerCNPJ,
  otp.BR_PartnerCPF,
  otp.BR_PartnerStateTaxNumberST,
  right(otp.BusinessPartnerTaxJurisdiction,7) as TaxJurisdiction,
  doc.BR_SUFRAMACode,
  case when otp.BusinessPartnerStreetNameOnly = ''
       then otp.BusinessPartnerStreetName
       else otp.BusinessPartnerStreetNameOnly
       end as StreetName, 
  otp.BusinessPartnerHouseNumber as HouseNumber,
  otp.BPHsNmbrSuplmntTxt as HouseNumberSupplementText,
  otp.BusinessPartnerDistrict as District
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_BCBCOUNTRYCODE",
"I_BR_NFDOCUMENT",
"I_BR_ONETIMEPARTNER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More