C_BPAdditionalCustomer

DDL: C_BPADDITIONALCUSTOMER SQL: CBPADDCUST Type: view CONSUMPTION

C view for BP Additional Customers

C_BPAdditionalCustomer is a Consumption CDS View that provides data about "C view for BP Additional Customers" in SAP S/4HANA. It reads from 1 data source (I_BPAdditionalCustomerTP) and exposes 49 fields with key fields BusinessPartner, Customer. It has 18 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPAdditionalCustomerTP BPAdditionalCustomer from

Associations (18)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..*] C_BPAddlCustCompanyCode _BPAddlCustCompanyCode $projection.BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner and $projection.Customer = _BPAddlCustCompanyCode.Customer
[1..*] C_BPAddlCustSalesArea _BPAddlCustSalesArea $projection.BusinessPartner = _BPAddlCustSalesArea.BusinessPartner and $projection.Customer = _BPAddlCustSalesArea.Customer
[0..1] I_Supplier_VH _SupplierValueHelp $projection.Supplier = _SupplierValueHelp.Supplier
[0..1] I_Customer_VH _AlternativePayerValueHelp $projection.AlternativePayerAccount = _AlternativePayerValueHelp.Customer
[0..1] C_BPAddressValueHelp _BPAddressValueHelp $projection.BusinessPartner = _BPAddressValueHelp.BusinessPartner and $projection.AddressNumber = _BPAddressValueHelp.AddressNumber
[1..*] C_BPAddlCustTelNmbr _BPAddlCustTelNmbr $projection.BusinessPartner = _BPAddlCustTelNmbr.BusinessPartner and $projection.Customer = _BPAddlCustTelNmbr.Customer
[1..*] C_BPAddlCustMblPhNumber _BPAddlCustMblPhNumber $projection.BusinessPartner = _BPAddlCustMblPhNumber.BusinessPartner and $projection.Customer = _BPAddlCustMblPhNumber.Customer
[1..*] C_BPAddlCustFaxNumber _BPAddlCustFaxNumber $projection.BusinessPartner = _BPAddlCustFaxNumber.BusinessPartner and $projection.Customer = _BPAddlCustFaxNumber.Customer
[1..*] C_BPAddlCustWebsiteURL _BPAddlCustWebsiteURL $projection.BusinessPartner = _BPAddlCustWebsiteURL.BusinessPartner and $projection.Customer = _BPAddlCustWebsiteURL.Customer
[1..*] C_BPAddlCustEmailAddress _BPAddlCustEmailAddress $projection.BusinessPartner = _BPAddlCustEmailAddress.BusinessPartner and $projection.Customer = _BPAddlCustEmailAddress.Customer
[0..*] I_BillingBlockReasonText _BillingBlockReasonText $projection.BillingIsBlockedForCustomer = _BillingBlockReasonText.BillingBlockReason
[0..*] I_DeliveryBlockReasonText _DeliveryBlockReasonText $projection.DeliveryIsBlocked = _DeliveryBlockReasonText.DeliveryBlockReason
[1..*] I_BusPartAuthorizationGroupTxt _AuthorizationGroupText $projection.AuthorizationGroup = _AuthorizationGroupText.AuthorizationGroup and _AuthorizationGroupText.AuthorizationObject = 'CUST'
[0..*] I_DeliveryDateTypeRuleText _DeliveryDateTypeRuleText $projection.DeliveryDateTypeRule = _DeliveryDateTypeRuleText.DeliveryDateTypeRule
[0..*] C_CommMethTextVhTemp _CommMethText $projection.PrfrdCommMediumType = _CommMethText.CommunicationMediumType
[0..*] C_BPLanguageTextValueHelp _LanguageText $projection.CorrespondenceLanguage = _LanguageText.LanguageCode

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CBPADDCUST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label C view for BP Additional Customers view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Additional Customer view
UI.headerInfo.typeNamePlural Additional Customers view
UI.headerInfo.title.label Additonal Customer view
UI.headerInfo.title.value CustomerForEdit view
VDM.viewType #CONSUMPTION view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPAdditionalCustomerTP BusinessPartner
KEY Customer I_BPAdditionalCustomerTP Customer
BusinessPartnerForEdit I_BPAdditionalCustomerTP BusinessPartnerForEdit
CustomerForEdit I_BPAdditionalCustomerTP CustomerForEdit
BPAssignmentReasonID I_BPAdditionalCustomerTP BPAssignmentReasonID
CustomerAccountGroup I_BPAdditionalCustomerTP CustomerAccountGroup
AlternativePayerAccount I_BPAdditionalCustomerTP AlternativePayerAccount
DataMediumExchangeIndicator I_BPAdditionalCustomerTP DataMediumExchangeIndicator
Supplier I_BPAdditionalCustomerTP Supplier
CustomerClassification I_BPAdditionalCustomerTP CustomerClassification
VATLiability I_BPAdditionalCustomerTP VATLiability
PostingIsBlocked I_BPAdditionalCustomerTP PostingIsBlocked
DeliveryIsBlocked I_BPAdditionalCustomerTP DeliveryIsBlocked
BillingIsBlockedForCustomer I_BPAdditionalCustomerTP BillingIsBlockedForCustomer
OrderIsBlockedForCustomer I_BPAdditionalCustomerTP OrderIsBlockedForCustomer
AuthorizationGroup I_BPAdditionalCustomerTP AuthorizationGroup
AddressNumber I_BPAdditionalCustomerTP AddressNumber
StreetName I_BPAdditionalCustomerTP StreetName
HouseNumber I_BPAdditionalCustomerTP HouseNumber
PostalCode I_BPAdditionalCustomerTP PostalCode
CityName I_BPAdditionalCustomerTP CityName
Country I_BPAdditionalCustomerTP Country
Region I_BPAdditionalCustomerTP Region
POBoxPostalCode I_BPAdditionalCustomerTP POBoxPostalCode
POBox I_BPAdditionalCustomerTP POBox
CorrespondenceLanguage I_BPAdditionalCustomerTP CorrespondenceLanguage
PrfrdCommMediumType I_BPAdditionalCustomerTP PrfrdCommMediumType
DeliveryDateTypeRule I_BPAdditionalCustomerTP DeliveryDateTypeRule
DeletionIndicator I_BPAdditionalCustomerTP DeletionIndicator
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BPAddlCustCompanyCode _BPAddlCustCompanyCode
_BPAddlCustSalesArea _BPAddlCustSalesArea
_BPAddlCustTelNmbr _BPAddlCustTelNmbr
_BPAddlCustFaxNumber _BPAddlCustFaxNumber
_BPAddlCustWebsiteURL _BPAddlCustWebsiteURL
_BPAddlCustMblPhNumber _BPAddlCustMblPhNumber
_BPAddlCustEmailAddress _BPAddlCustEmailAddress
_SupplierValueHelp _SupplierValueHelp
_AlternativePayerValueHelp _AlternativePayerValueHelp
_BPAddressValueHelp _BPAddressValueHelp
_BillingBlockReasonText _BillingBlockReasonText
_DeliveryBlockReasonText _DeliveryBlockReasonText
_AuthorizationGroupText _AuthorizationGroupText
_DeliveryDateTypeRuleText _DeliveryDateTypeRuleText
_CustomerClassification _CustomerClassification
_CommMethText _CommMethText
_CustomerClassificationText _CustomerClassificationText
_LanguageText _LanguageText
@AbapCatalog.sqlViewName: 'CBPADDCUST'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'C view for BP Additional Customers'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: [ 'BusinessPartner', 'Customer' ],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@UI.headerInfo:{
  typeName: 'Additional Customer',
  typeNamePlural: 'Additional Customers',
  title:  { label:'Additonal Customer', value: 'CustomerForEdit' }
}

@VDM.viewType: #CONSUMPTION

define view C_BPAdditionalCustomer
  as select from I_BPAdditionalCustomerTP as BPAdditionalCustomer

  association [1..1] to C_BusinessPartnerCustomer      as _BusinessPartnerCustomer   on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

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

  association [1..*] to C_BPAddlCustCompanyCode        as _BPAddlCustCompanyCode     on  $projection.BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustCompanyCode.Customer

  association [1..*] to C_BPAddlCustSalesArea          as _BPAddlCustSalesArea       on  $projection.BusinessPartner = _BPAddlCustSalesArea.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustSalesArea.Customer

  association [0..1] to I_Supplier_VH                  as _SupplierValueHelp         on  $projection.Supplier = _SupplierValueHelp.Supplier

  association [0..1] to I_Customer_VH                  as _AlternativePayerValueHelp on  $projection.AlternativePayerAccount = _AlternativePayerValueHelp.Customer

  association [0..1] to C_BPAddressValueHelp           as _BPAddressValueHelp        on  $projection.BusinessPartner = _BPAddressValueHelp.BusinessPartner
                                                                                     and $projection.AddressNumber   = _BPAddressValueHelp.AddressNumber

  association [1..*] to C_BPAddlCustTelNmbr            as _BPAddlCustTelNmbr         on  $projection.BusinessPartner = _BPAddlCustTelNmbr.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustTelNmbr.Customer

  association [1..*] to C_BPAddlCustMblPhNumber        as _BPAddlCustMblPhNumber     on  $projection.BusinessPartner = _BPAddlCustMblPhNumber.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustMblPhNumber.Customer

  association [1..*] to C_BPAddlCustFaxNumber          as _BPAddlCustFaxNumber       on  $projection.BusinessPartner = _BPAddlCustFaxNumber.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustFaxNumber.Customer

  association [1..*] to C_BPAddlCustWebsiteURL         as _BPAddlCustWebsiteURL      on  $projection.BusinessPartner = _BPAddlCustWebsiteURL.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustWebsiteURL.Customer

  association [1..*] to C_BPAddlCustEmailAddress       as _BPAddlCustEmailAddress    on  $projection.BusinessPartner = _BPAddlCustEmailAddress.BusinessPartner
                                                                                     and $projection.Customer        = _BPAddlCustEmailAddress.Customer

  association [0..*] to I_BillingBlockReasonText       as _BillingBlockReasonText    on  $projection.BillingIsBlockedForCustomer = _BillingBlockReasonText.BillingBlockReason

  association [0..*] to I_DeliveryBlockReasonText      as _DeliveryBlockReasonText   on  $projection.DeliveryIsBlocked = _DeliveryBlockReasonText.DeliveryBlockReason

  association [1..*] to I_BusPartAuthorizationGroupTxt as _AuthorizationGroupText    on  $projection.AuthorizationGroup              = _AuthorizationGroupText.AuthorizationGroup
                                                                                     and _AuthorizationGroupText.AuthorizationObject = 'CUST'

  association [0..*] to I_DeliveryDateTypeRuleText     as _DeliveryDateTypeRuleText  on  $projection.DeliveryDateTypeRule = _DeliveryDateTypeRuleText.DeliveryDateTypeRule
  association [0..*] to C_CommMethTextVhTemp           as _CommMethText             on  $projection.PrfrdCommMediumType = _CommMethText.CommunicationMediumType
  association [0..*] to C_BPLanguageTextValueHelp      as _LanguageText             on  $projection.CorrespondenceLanguage = _LanguageText.LanguageCode
{

  key BPAdditionalCustomer.BusinessPartner,
  key BPAdditionalCustomer.Customer,
      BPAdditionalCustomer.BusinessPartnerForEdit,
      BPAdditionalCustomer.CustomerForEdit,
      BPAdditionalCustomer.BPAssignmentReasonID,
      BPAdditionalCustomer.CustomerAccountGroup,
      @ObjectModel: {
                      foreignKey.association: '_AlternativePayerValueHelp'
                    }
      @Consumption.valueHelp: '_AlternativePayerValueHelp'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.AlternativePayerAccount,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.DataMediumExchangeIndicator,
      @ObjectModel: {
                         foreignKey.association: '_SupplierValueHelp'
                       }
      @Consumption.valueHelp: '_SupplierValueHelp'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.Supplier,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.CustomerClassification,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.VATLiability,
      BPAdditionalCustomer.PostingIsBlocked,
      @ObjectModel.text.association: '_DeliveryBlockReasonText'
      BPAdditionalCustomer.DeliveryIsBlocked,
      @ObjectModel.text.association: '_BillingBlockReasonText'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.BillingIsBlockedForCustomer,
      BPAdditionalCustomer.OrderIsBlockedForCustomer,
      @ObjectModel.text.association: '_AuthorizationGroupText'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BPAdditionalCustomer.AuthorizationGroup,
      @ObjectModel.foreignKey.association: '_BPAddressValueHelp'
      BPAdditionalCustomer.AddressNumber,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.StreetName,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.HouseNumber,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.PostalCode,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.CityName,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.Country,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.Region,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.POBoxPostalCode,
      @ObjectModel.readOnly: true
      BPAdditionalCustomer.POBox,
      @ObjectModel.readOnly: true
      @ObjectModel.text.association: '_LanguageText'
      BPAdditionalCustomer.CorrespondenceLanguage,
      @ObjectModel.readOnly: true
      @ObjectModel.text.association: '_CommMethText'
      BPAdditionalCustomer.PrfrdCommMediumType,
      @ObjectModel.text.association: '_DeliveryDateTypeRuleText'
      BPAdditionalCustomer.DeliveryDateTypeRule,
      BPAdditionalCustomer.DeletionIndicator,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD]
      _BPAddlCustCompanyCode,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD]
      _BPAddlCustSalesArea,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlCustTelNmbr,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlCustFaxNumber,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlCustWebsiteURL,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlCustMblPhNumber,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlCustEmailAddress,

      _SupplierValueHelp,
      _AlternativePayerValueHelp,
      _BPAddressValueHelp,
      _BillingBlockReasonText,
      _DeliveryBlockReasonText,
      _AuthorizationGroupText,
      _DeliveryDateTypeRuleText,
      _CustomerClassification,
      _CommMethText,
      _CustomerClassificationText,
      _LanguageText
}