I_BPAdditionalCustomerTP

DDL: I_BPADDITIONALCUSTOMERTP SQL: IBPADDCUSTTP Type: view TRANSACTIONAL
44 Fields 2 Data Sources 8 Associations

BO view for Additional Customers of BP

I_BPAdditionalCustomerTP is a Transactional CDS View that provides data about "BO view for Additional Customers of BP" in SAP S/4HANA. It reads from 2 data sources (I_BPMultipleAssignment, I_Customer) and exposes 44 fields with key fields BusinessPartner, Customer. It has 8 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BPMultipleAssignment BPAdditionalCustomer from
I_Customer Customer inner

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..*] I_BPAddlCustCompanyCodeTP _BPAddlCustCompanyCode $projection.BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner and $projection.Customer = _BPAddlCustCompanyCode.Customer
[1..*] I_BPAddlCustSalesAreaTP _BPAddlCustSalesArea $projection.BusinessPartner = _BPAddlCustSalesArea.BusinessPartner and $projection.Customer = _BPAddlCustSalesArea.Customer
[1..*] I_BPAddlCustTelNmbrTP _BPAddlCustTelNmbr $projection.BusinessPartner = _BPAddlCustTelNmbr.BusinessPartner and $projection.Customer = _BPAddlCustTelNmbr.Customer
[1..*] I_BPAddlCustEmailAddressTP _BPAddlCustEmailAddress $projection.BusinessPartner = _BPAddlCustEmailAddress.BusinessPartner and $projection.Customer = _BPAddlCustEmailAddress.Customer
[1..*] I_BPAddlCustMblPhNumberTP _BPAddlCustMblPhNumber $projection.BusinessPartner = _BPAddlCustMblPhNumber.BusinessPartner and $projection.Customer = _BPAddlCustMblPhNumber.Customer
[1..*] I_BPAddlCustWebsiteURLTP _BPAddlCustWebsiteURL $projection.BusinessPartner = _BPAddlCustWebsiteURL.BusinessPartner and $projection.Customer = _BPAddlCustWebsiteURL.Customer
[1..*] I_BPAddlCustFaxNumberTP _BPAddlCustFaxNumber $projection.BusinessPartner = _BPAddlCustFaxNumber.BusinessPartner and $projection.Customer = _BPAddlCustFaxNumber.Customer

Annotations (14)

NameValueLevelField
EndUserText.label BO view for Additional Customers of BP view
AbapCatalog.sqlViewName IBPADDCUSTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BPADDCUST_D view
ObjectModel.draftEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner Issuing Authority
KEY Customer I_Customer Customer Sold-to Party
BusinessPartnerForEdit I_BPMultipleAssignment BusinessPartner Issuing Authority
CustomerForEdit I_Customer Customer Sold-to Party
BPAssignmentID I_BPMultipleAssignment BPAssignmentID Assignment ID
BPAssignmentCategory I_BPMultipleAssignment BPAssignmentCategory Assignment Category
BPAssignmentReasonID I_BPMultipleAssignment BPAssignmentReasonID Reason
IsStandardAssignment I_BPMultipleAssignment IsStandardAssignment Quality Standard
AddressNumber I_BPMultipleAssignment AddressNumber Src Address No
CustomerAccountGroup I_Customer CustomerAccountGroup Account group
AlternativePayerAccount I_Customer AlternativePayerAccount Alternat.payer
DataMediumExchangeIndicator I_Customer DataMediumExchangeIndicator DME Rec. Code
Supplier I_Customer Supplier Supplier
CustomerClassification I_Customer CustomerClassification Customer Class.
VATLiability I_Customer VATLiability Liable for VAT
PostingIsBlocked I_Customer PostingIsBlocked Posting Block
DeliveryIsBlocked I_Customer DeliveryIsBlocked Delivery block
BillingIsBlockedForCustomer I_Customer BillingIsBlockedForCustomer Billing block
OrderIsBlockedForCustomer I_Customer OrderIsBlockedForCustomer Order block
AuthorizationGroup I_Customer AuthorizationGroup AuthorizGroup
CustomerName I_Customer CustomerName Name of Customer
BPCustomerName I_Customer BPCustomerName Name of Customer
DeliveryDateTypeRule I_Customer DeliveryDateTypeRule Deliv Date Rule
DeletionIndicator I_Customer DeletionIndicator Deletion Ind.
PostalCode
StreetName
HouseNumber
CityName
Country
Region
POBoxPostalCode
POBox
CorrespondenceLanguage
PrfrdCommMediumType
_CustomerClassification I_Customer _CustomerClassification
_CustomerClassificationText I_Customer _CustomerClassificationText
_BusinessPartner _BusinessPartner
_BPAddlCustCompanyCode _BPAddlCustCompanyCode
_BPAddlCustSalesArea _BPAddlCustSalesArea
_BPAddlCustTelNmbr _BPAddlCustTelNmbr
_BPAddlCustFaxNumber _BPAddlCustFaxNumber
_BPAddlCustMblPhNumber _BPAddlCustMblPhNumber
_BPAddlCustEmailAddress _BPAddlCustEmailAddress
_BPAddlCustWebsiteURL _BPAddlCustWebsiteURL

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPAdditionalCustomerTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IBPADDCUSTTP

CREATE VIEW I_BPAdditionalCustomerTP AS
SELECT
  BPAdditionalCustomer.BusinessPartner AS BusinessPartner,
  Customer.Customer AS Customer,
  BPAdditionalCustomer.BusinessPartner AS BusinessPartnerForEdit,
  Customer.Customer AS CustomerForEdit,
  BPAdditionalCustomer.BPAssignmentID AS BPAssignmentID,
  BPAdditionalCustomer.BPAssignmentCategory AS BPAssignmentCategory,
  BPAdditionalCustomer.BPAssignmentReasonID AS BPAssignmentReasonID,
  BPAdditionalCustomer.IsStandardAssignment AS IsStandardAssignment,
  BPAdditionalCustomer.AddressNumber AS AddressNumber,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  Customer.AlternativePayerAccount AS AlternativePayerAccount,
  Customer.DataMediumExchangeIndicator AS DataMediumExchangeIndicator,
  Customer.Supplier AS Supplier,
  Customer.CustomerClassification AS CustomerClassification,
  Customer.VATLiability AS VATLiability,
  Customer.PostingIsBlocked AS PostingIsBlocked,
  Customer.DeliveryIsBlocked AS DeliveryIsBlocked,
  Customer.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  Customer.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  Customer.CustomerName AS CustomerName,
  Customer.BPCustomerName AS BPCustomerName,
  Customer.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  Customer.DeletionIndicator AS DeletionIndicator,
  Customer._AddressDefaultRepresentation.PostalCode AS PostalCode,
  Customer._AddressDefaultRepresentation.StreetName AS StreetName,
  Customer._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  Customer._AddressDefaultRepresentation.CityName AS CityName,
  Customer._AddressDefaultRepresentation.Country AS Country,
  Customer._AddressDefaultRepresentation.Region AS Region,
  Customer._AddressDefaultRepresentation.POBoxPostalCode AS POBoxPostalCode,
  Customer._AddressDefaultRepresentation.POBox AS POBox,
  Customer._AddressDefaultRepresentation.CorrespondenceLanguage AS CorrespondenceLanguage,
  Customer._AddressDefaultRepresentation.PrfrdCommMediumType AS PrfrdCommMediumType,
  Customer._CustomerClassification AS _CustomerClassification,
  Customer._CustomerClassificationText AS _CustomerClassificationText
FROM I_BPMultipleAssignment AS BPAdditionalCustomer
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPAddlCustCompanyCodeTP AS _BPAddlCustCompanyCode ON BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner AND Customer = _BPAddlCustCompanyCode.Customer  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustSalesAreaTP AS _BPAddlCustSalesArea ON BusinessPartner = _BPAddlCustSalesArea.BusinessPartner AND Customer = _BPAddlCustSalesArea.Customer  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustTelNmbrTP AS _BPAddlCustTelNmbr ON BusinessPartner = _BPAddlCustTelNmbr.BusinessPartner AND Customer = _BPAddlCustTelNmbr.Customer  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustEmailAddressTP AS _BPAddlCustEmailAddress ON BusinessPartner = _BPAddlCustEmailAddress.BusinessPartner AND Customer = _BPAddlCustEmailAddress.Customer  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustMblPhNumberTP AS _BPAddlCustMblPhNumber ON BusinessPartner = _BPAddlCustMblPhNumber.BusinessPartner AND Customer = _BPAddlCustMblPhNumber.Customer  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustWebsiteURLTP AS _BPAddlCustWebsiteURL ON BusinessPartner = _BPAddlCustWebsiteURL.BusinessPartner AND Customer = _BPAddlCustWebsiteURL.Customer  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustFaxNumberTP AS _BPAddlCustFaxNumber ON BusinessPartner = _BPAddlCustFaxNumber.BusinessPartner AND Customer = _BPAddlCustFaxNumber.Customer  -- association [1..*]
;

Learn More