A_BusinessPartner

DDL: A_BUSINESSPARTNER SQL: ABUSINESSPARTNER Type: view BASIC

Business Partner

A_BusinessPartner is a Basic CDS View that provides data about "Business Partner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 103 fields with key field BusinessPartner. It has 25 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner I_BusinessPartner from

Associations (25)

CardinalityTargetAliasCondition
[0..1] E_BP_D _PartnerExtension $projection.BusinessPartner = _PartnerExtension.BusinessPartner
[0..1] I_CustomerToBusinessPartner _CustomerToBusinessPartner I_BusinessPartner.BusinessPartnerUUID = _CustomerToBusinessPartner.BusinessPartnerUUID
[0..1] I_SupplierToBusinessPartner _SupplierToBusinessPartner I_BusinessPartner.BusinessPartnerUUID = _SupplierToBusinessPartner.BusinessPartnerUUID
[0..1] A_Customer _Customer $projection.customer = _Customer.Customer
[0..1] A_Supplier _Supplier $projection.supplier = _Supplier.Supplier
[0..*] A_BusinessPartnerAddress _BusinessPartnerAddress $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
[0..*] A_BusinessPartnerRole _BusinessPartnerRole $projection.BusinessPartner = _BusinessPartnerRole.BusinessPartner
[0..*] A_BusinessPartnerTaxNumber _BusinessPartnerTax $projection.BusinessPartner = _BusinessPartnerTax.BusinessPartner
[0..*] A_BusinessPartnerBank _BusinessPartnerBank $projection.BusinessPartner = _BusinessPartnerBank.BusinessPartner
[0..*] A_BuPaIdentification _BuPaIdentification $projection.BusinessPartner = _BuPaIdentification.BusinessPartner
[0..*] A_BusinessPartnerContact _BusinessPartnerContact $projection.BusinessPartner = _BusinessPartnerContact.BusinessPartnerCompany
[0..*] A_BPRelationship _BPRelationship $projection.BusinessPartner = _BPRelationship.BusinessPartner1
[0..*] A_BuPaIndustry _BuPaIndustry $projection.BusinessPartner = _BuPaIndustry.BusinessPartner
[0..*] A_BusPartAddrDepdntTaxNmbr _BusPartAddrDepdntTaxNmbr $projection.BusinessPartner = _BusPartAddrDepdntTaxNmbr.BusinessPartner
[0..*] A_BusinessPartnerPaymentCard _PaymentCard $projection.BusinessPartner = _PaymentCard.BusinessPartner
[0..1] A_BPFinancialServicesExtn _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] A_BPFinancialServicesReporting _BPFinServicesReporting $projection.BusinessPartner = _BPFinServicesReporting.BusinessPartner
[0..1] A_BPCreditWorthiness _BPCreditWorthiness $projection.BusinessPartner = _BPCreditWorthiness.BusinessPartner
[0..*] A_BusinessPartnerRating _BusinessPartnerRating $projection.BusinessPartner = _BusinessPartnerRating.BusinessPartner
[0..*] A_BPFiscalYearInformation _BPFiscalYearInformation $projection.BusinessPartner = _BPFiscalYearInformation.BusinessPartner
[0..*] A_BPEmployment _BPEmployment $projection.BusinessPartner = _BPEmployment.BusinessPartner
[0..*] A_BPTaxCompliance _BPTaxCompliance $projection.BusinessPartner = _BPTaxCompliance.BusinessPartner
[0..*] A_BusinessPartnerAlias _BusinessPartnerAlias $projection.BusinessPartner = _BusinessPartnerAlias.BusinessPartner
[0..1] A_BusinessPartnerIsBank _BusinessPartnerIsBank $projection.BusinessPartner = _BusinessPartnerIsBank.BusinessPartner
[0..*] A_BPDataController _BPDataController $projection.BusinessPartner = _BPDataController.BusinessPartner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ABUSINESSPARTNER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Partner view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (103)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
Customer _CustomerToBusinessPartner Customer
Supplier _SupplierToBusinessPartner Supplier
AcademicTitle AcademicTitle
AuthorizationGroup AuthorizationGroup
BusinessPartnerCategory BusinessPartnerCategory
BusinessPartnerFullName BusinessPartnerFullName
BusinessPartnerGrouping BusinessPartnerGrouping
BusinessPartnerName BusinessPartnerName
BusinessPartnerUUID BusinessPartnerUUID
CorrespondenceLanguage CorrespondenceLanguage
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
FirstName FirstName
FormOfAddress FormOfAddress
Industry Industry
InternationalLocationNumber1 InternationalLocationNumber1
InternationalLocationNumber2 InternationalLocationNumber2
IsFemale IsFemale
IsMale IsMale
IsNaturalPerson IsNaturalPerson
IsSexUnknown IsSexUnknown
GenderCodeName GenderCodeName
Language Language
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
LastChangedByUser LastChangedByUser
LastName LastName
LegalForm LegalForm
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
OrganizationBPName3 OrganizationBPName3
OrganizationBPName4 OrganizationBPName4
OrganizationFoundationDate OrganizationFoundationDate
OrganizationLiquidationDate OrganizationLiquidationDate
SearchTerm1 SearchTerm1
SearchTerm2 SearchTerm2
AdditionalLastName AdditionalLastName
BirthDate BirthDate
BusinessPartnerBirthDateStatus BusinessPartnerBirthDateStatus
BusinessPartnerBirthplaceName BusinessPartnerBirthplaceName
BusinessPartnerDeathDate BusinessPartnerDeathDate
BusinessPartnerIsBlocked BusinessPartnerIsBlocked
BusinessPartnerType BusinessPartnerType
ETag ETag
GroupBusinessPartnerName1 GroupBusinessPartnerName1
GroupBusinessPartnerName2 GroupBusinessPartnerName2
IndependentAddressID IndependentAddressID
InternationalLocationNumber3 InternationalLocationNumber3
MiddleName MiddleName
NameCountry NameCountry
NameFormat NameFormat
PersonFullName PersonFullName
PersonNumber PersonNumber
IsMarkedForArchiving IsMarkedForArchiving
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem
BusinessPartnerPrintFormat BusinessPartnerPrintFormat
BusinessPartnerOccupation BusinessPartnerOccupation
BusPartMaritalStatus BusPartMaritalStatus
BusPartNationality BusPartNationality
BusinessPartnerBirthName BusinessPartnerBirthName
BusinessPartnerSupplementName BusinessPartnerSupplementName
NaturalPersonEmployerName NaturalPersonEmployerName
LastNamePrefix LastNamePrefix
LastNameSecondPrefix LastNameSecondPrefix
Initials Initials
BPDataControllerIsNotRequired BPDataControllerIsNotRequired
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
TradingPartner _BusinessPartner TradingPartner
_Customer _Customer
_Supplier _Supplier
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerRole _BusinessPartnerRole
_BusinessPartnerTax _BusinessPartnerTax
_BusinessPartnerBank _BusinessPartnerBank
_BuPaIdentification _BuPaIdentification
_BusinessPartnerContact _BusinessPartnerContact
_BPRelationship _BPRelationship
_BuPaIndustry _BuPaIndustry
_BusPartAddrDepdntTaxNmbr _BusPartAddrDepdntTaxNmbr
_PaymentCard _PaymentCard
_BusinessPartner _BusinessPartner
_BPFinServicesReporting _BPFinServicesReporting
_BPCreditWorthiness _BPCreditWorthiness
_BusinessPartnerRating _BusinessPartnerRating
_BPFiscalYearInformation _BPFiscalYearInformation
_BPEmployment _BPEmployment
_BPTaxCompliance _BPTaxCompliance
_BusinessPartnerAlias _BusinessPartnerAlias
_BusinessPartnerIsBank _BusinessPartnerIsBank
_BPDataController _BPDataController
@AbapCatalog.sqlViewName: 'ABUSINESSPARTNER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Business Partner'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_BusinessPartner as select from I_BusinessPartner

  association [0..1] to E_BP_D as _PartnerExtension on $projection.BusinessPartner = _PartnerExtension.BusinessPartner

  association [0..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on I_BusinessPartner.BusinessPartnerUUID = _CustomerToBusinessPartner.BusinessPartnerUUID

  association [0..1] to I_SupplierToBusinessPartner as _SupplierToBusinessPartner on I_BusinessPartner.BusinessPartnerUUID = _SupplierToBusinessPartner.BusinessPartnerUUID

  association [0..1] to A_Customer as _Customer on $projection.customer = _Customer.Customer

  association [0..1] to A_Supplier as _Supplier on $projection.supplier = _Supplier.Supplier

  association [0..*] to A_BusinessPartnerAddress as _BusinessPartnerAddress on $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner

  association [0..*] to A_BusinessPartnerRole as _BusinessPartnerRole on $projection.BusinessPartner = _BusinessPartnerRole.BusinessPartner

  association [0..*] to A_BusinessPartnerTaxNumber as _BusinessPartnerTax on $projection.BusinessPartner = _BusinessPartnerTax.BusinessPartner

  association [0..*] to A_BusinessPartnerBank as _BusinessPartnerBank on $projection.BusinessPartner = _BusinessPartnerBank.BusinessPartner

  association [0..*] to A_BuPaIdentification as _BuPaIdentification on $projection.BusinessPartner = _BuPaIdentification.BusinessPartner

  association [0..*] to A_BusinessPartnerContact as _BusinessPartnerContact on $projection.BusinessPartner = _BusinessPartnerContact.BusinessPartnerCompany

  association [0..*] to A_BPRelationship as _BPRelationship on $projection.BusinessPartner = _BPRelationship.BusinessPartner1

  association [0..*] to A_BuPaIndustry as _BuPaIndustry on $projection.BusinessPartner = _BuPaIndustry.BusinessPartner

  association [0..*] to A_BusPartAddrDepdntTaxNmbr as _BusPartAddrDepdntTaxNmbr on $projection.BusinessPartner = _BusPartAddrDepdntTaxNmbr.BusinessPartner

  association [0..*] to A_BusinessPartnerPaymentCard as _PaymentCard on $projection.BusinessPartner = _PaymentCard.BusinessPartner

  association [0..1] to A_BPFinancialServicesExtn as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [0..1] to A_BPFinancialServicesReporting as _BPFinServicesReporting on $projection.BusinessPartner = _BPFinServicesReporting.BusinessPartner

  association [0..1] to A_BPCreditWorthiness as _BPCreditWorthiness on $projection.BusinessPartner = _BPCreditWorthiness.BusinessPartner

  association [0..*] to A_BusinessPartnerRating as _BusinessPartnerRating on $projection.BusinessPartner = _BusinessPartnerRating.BusinessPartner

  association [0..*] to A_BPFiscalYearInformation as _BPFiscalYearInformation on $projection.BusinessPartner = _BPFiscalYearInformation.BusinessPartner

  association [0..*] to A_BPEmployment as _BPEmployment on $projection.BusinessPartner = _BPEmployment.BusinessPartner

  association [0..*] to A_BPTaxCompliance as _BPTaxCompliance on $projection.BusinessPartner = _BPTaxCompliance.BusinessPartner

  association [0..*] to A_BusinessPartnerAlias as _BusinessPartnerAlias on $projection.BusinessPartner = _BusinessPartnerAlias.BusinessPartner

  association [0..1] to A_BusinessPartnerIsBank as _BusinessPartnerIsBank on $projection.BusinessPartner = _BusinessPartnerIsBank.BusinessPartner

  association [0..*] to A_BPDataController as _BPDataController on $projection.BusinessPartner = _BPDataController.BusinessPartner

{
  key BusinessPartner,
      @ObjectModel.readOnly: true
      _CustomerToBusinessPartner.Customer,
      @ObjectModel.readOnly: true
      _SupplierToBusinessPartner.Supplier,
      AcademicTitle,
      AuthorizationGroup,
      BusinessPartnerCategory,
      @ObjectModel.readOnly: true
      BusinessPartnerFullName,
      BusinessPartnerGrouping,
      @ObjectModel.readOnly: true
      BusinessPartnerName,
      @ObjectModel.readOnly: true
      BusinessPartnerUUID,
      CorrespondenceLanguage,
      @ObjectModel.readOnly: true
      CreatedByUser,
      @ObjectModel.readOnly: true
      CreationDate,
      @ObjectModel.readOnly: true
      CreationTime,
      FirstName,
      FormOfAddress,
      Industry,
      InternationalLocationNumber1,
      InternationalLocationNumber2,
      IsFemale,
      IsMale,
      IsNaturalPerson,
      IsSexUnknown,
      GenderCodeName,
      Language,
      @ObjectModel.readOnly: true
      LastChangeDate,
      @ObjectModel.readOnly: true
      LastChangeTime,
      @ObjectModel.readOnly: true
      LastChangedByUser,
      LastName,
      LegalForm,
      OrganizationBPName1,
      OrganizationBPName2,
      OrganizationBPName3,
      OrganizationBPName4,
      OrganizationFoundationDate,
      OrganizationLiquidationDate,
      SearchTerm1,
      SearchTerm2,
      AdditionalLastName,
      BirthDate,
      BusinessPartnerBirthDateStatus,
      BusinessPartnerBirthplaceName,
      BusinessPartnerDeathDate,
      BusinessPartnerIsBlocked,
      BusinessPartnerType,
      @ObjectModel.readOnly: true
      ETag,
      GroupBusinessPartnerName1,
      GroupBusinessPartnerName2,
      @ObjectModel.readOnly: true
      IndependentAddressID,
      InternationalLocationNumber3,
      MiddleName,
      NameCountry,
      NameFormat,
      PersonFullName,
      @ObjectModel.readOnly: true
      PersonNumber,
      IsMarkedForArchiving,
      @Consumption.hidden: true
      IsBusinessPurposeCompleted,
      BusinessPartnerIDByExtSystem,
      BusinessPartnerPrintFormat,
      BusinessPartnerOccupation,
      BusPartMaritalStatus,
      BusPartNationality,
      BusinessPartnerBirthName,
      BusinessPartnerSupplementName,
      NaturalPersonEmployerName,
      LastNamePrefix,
      LastNameSecondPrefix,
      Initials,
      BPDataControllerIsNotRequired,
      @Consumption.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      DataController1,
      @Consumption.hidden:true
      DataController2,
      @Consumption.hidden:true
      DataController3,
      @Consumption.hidden:true
      DataController4,
      @Consumption.hidden:true
      DataController5,
      @Consumption.hidden:true
      DataController6,
      @Consumption.hidden:true
      DataController7,
      @Consumption.hidden:true
      DataController8,
      @Consumption.hidden:true
      DataController9,
      @Consumption.hidden:true
      DataController10,
      _BusinessPartner.TradingPartner,
      _Customer,
      _Supplier,
      _BusinessPartnerAddress,
      _BusinessPartnerRole,
      _BusinessPartnerTax,
      _BusinessPartnerBank,
      _BuPaIdentification,
      _BusinessPartnerContact,
      _BPRelationship,
      _BuPaIndustry,
      _BusPartAddrDepdntTaxNmbr,
      _PaymentCard,
      _BusinessPartner,
      _BPFinServicesReporting,
      _BPCreditWorthiness,
      _BusinessPartnerRating,
      _BPFiscalYearInformation,
      _BPEmployment,
      _BPTaxCompliance,
      _BusinessPartnerAlias,
      _BusinessPartnerIsBank,
      _BPDataController
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_BPFINANCIALSERVICESEXTN",
"I_BUSINESSPARTNER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_SUPPLIERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"A_BPCREDITWORTHINESS",
"A_BPDATACONTROLLER",
"A_BPEMPLOYMENT",
"A_BPFINANCIALSERVICESEXTN",
"A_BPFINANCIALSERVICESREPORTING",
"A_BPFISCALYEARINFORMATION",
"A_BPRELATIONSHIP",
"A_BPTAXCOMPLIANCE",
"A_BUPAIDENTIFICATION",
"A_BUPAINDUSTRY",
"A_BUSINESSPARTNERADDRESS",
"A_BUSINESSPARTNERALIAS",
"A_BUSINESSPARTNERBANK",
"A_BUSINESSPARTNERCONTACT",
"A_BUSINESSPARTNERISBANK",
"A_BUSINESSPARTNERPAYMENTCARD",
"A_BUSINESSPARTNERRATING",
"A_BUSINESSPARTNERROLE",
"A_BUSINESSPARTNERTAXNUMBER",
"A_BUSPARTADDRDEPDNTTAXNMBR",
"A_CUSTOMER",
"A_SUPPLIER",
"E_BP_D",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_SUPPLIERTOBUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/