I_BPAddlCustCompanyCodeTP

DDL: I_BPADDLCUSTCOMPANYCODETP SQL: IBPADDCCCTP Type: view TRANSACTIONAL
44 Fields 3 Data Sources 5 Associations

BO view for Company Code of Customers

I_BPAddlCustCompanyCodeTP is a Transactional CDS View that provides data about "BO view for Company Code of Customers" in SAP S/4HANA. It reads from 3 data sources (I_BPMultipleAssignment, I_CustomerCompany, t047) and exposes 44 fields with key fields BusinessPartner, Customer, CompanyCode. It has 5 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_BPMultipleAssignment BPMultipleAssignment inner
I_CustomerCompany BusinessPartnerCustomerCo from
t047 CompanyCodeDunningControl left_outer

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BPAdditionalCustomerTP _BPAdditionalCustomer $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner and $projection.Customer = _BPAdditionalCustomer.Customer
[1..*] I_BPAddlCustWhldgTaxTP _BusinessPartnerCustWhdgTax $projection.BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner and $projection.Customer = _BusinessPartnerCustWhdgTax.Customer and $projection.CompanyCode = _BusinessPartnerCustWhdgTax.CompanyCode
[1..*] I_BPAddlCustDunningTP _BPAddlCustDunning $projection.BusinessPartner = _BPAddlCustDunning.BusinessPartner and $projection.Customer = _BPAddlCustDunning.Customer and $projection.CompanyCode = _BPAddlCustDunning.CompanyCode
[1..1] I_CompanyCode _Country $projection.CompanyCode = _Country.CompanyCode

Annotations (14)

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

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner Issuing Authority
KEY Customer I_CustomerCompany Customer Sold-to Party
KEY CompanyCode I_CustomerCompany CompanyCode Receiver Company Code
CompanyCodeForEdit I_CustomerCompany CompanyCode Receiver Company Code
CustomerForEdit I_CustomerCompany Customer Sold-to Party
BusinessPartnerForEdit I_BPMultipleAssignment BusinessPartner Issuing Authority
AccountingClerk I_CustomerCompany AccountingClerk Clerk Abbrev.
ReconciliationAccount I_CustomerCompany ReconciliationAccount Recon. account
AuthorizationGroup I_CustomerCompany AuthorizationGroup AuthorizGroup
CustomerHeadOffice I_CustomerCompany CustomerHeadOffice Head Office
AlternativePayerAccount I_CustomerCompany AlternativePayerAccount Alternat.payer
PaymentBlockingReason I_CustomerCompany PaymentBlockingReason Pmnt block
InterestCalculationCode I_CustomerCompany InterestCalculationCode Interest Indic.
InterestCalculationDate I_CustomerCompany InterestCalculationDate Last Key Date
IntrstCalcFrequencyInMonths I_CustomerCompany IntrstCalcFrequencyInMonths Int.Calc.Freq.
LastInterestCalcRunDate I_CustomerCompany LastInterestCalcRunDate Last Int. Calc.
CustomerAccountNote I_CustomerCompany CustomerAccountNote Account Memo
APARToleranceGroup I_CustomerCompany APARToleranceGroup Tolerance Group
HouseBank I_CustomerCompany HouseBank House Bank
ItemIsToBePaidSeparately I_CustomerCompany ItemIsToBePaidSeparately Individual Payt
PaytAdviceIsSentbyEDI I_CustomerCompany PaytAdviceIsSentbyEDI Pmt adv. by EDI
PhysicalInventoryBlockInd I_CustomerCompany PhysicalInventoryBlockInd Phys. Inv. Blk
UserAtCustomer I_CustomerCompany UserAtCustomer Customer user
AccountingClerkPhoneNumber I_CustomerCompany AccountingClerkPhoneNumber Act.clk tel.no.
AccountingClerkFaxNumber I_CustomerCompany AccountingClerkFaxNumber Clerk's fax
AccountingClerkInternetAddress I_CustomerCompany AccountingClerkInternetAddress Clrk's internet
AccountByCustomer I_CustomerCompany AccountByCustomer Acct at cust.
IsToBeLocallyProcessed I_CustomerCompany IsToBeLocallyProcessed Local Process.
CollectiveInvoiceVariant I_CustomerCompany CollectiveInvoiceVariant Coll.Invce.Var.
LayoutSortingRule I_CustomerCompany LayoutSortingRule Sort key
PaymentTerms I_CustomerCompany PaymentTerms Pyt Terms
CustomerSupplierClearingIsUsed I_CustomerCompany CustomerSupplierClearingIsUsed Clrg with vend.
RecordPaymentHistoryIndicator I_CustomerCompany RecordPaymentHistoryIndicator Rec.Payt Hist.
PaymentMethodsList I_CustomerCompany PaymentMethodsList Payment Methods
CashPlanningGroup I_CustomerCompany CashPlanningGroup Planning Group
ValueAdjustmentKey I_CustomerCompany ValueAdjustmentKey Value Adj. Key
KnownOrNegotiatedLeave I_CustomerCompany KnownOrNegotiatedLeave Known/Neg.Leave
Country _Country Country Venue: Ctry/Reg
CompanyCodeName _Country CompanyCodeName Company Name
CompanyCodeDunningIsByDunArea t047 xmabe Dun.by Dun.Area
_BusinessPartner _BusinessPartner
_BPAdditionalCustomer _BPAdditionalCustomer
_BusinessPartnerCustWhdgTax _BusinessPartnerCustWhdgTax
_BPAddlCustDunning _BPAddlCustDunning

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_BPAddlCustCompanyCodeTP.
-- 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: IBPADDCCCTP

CREATE VIEW I_BPAddlCustCompanyCodeTP AS
SELECT
  BPMultipleAssignment.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustomerCo.Customer AS Customer,
  BusinessPartnerCustomerCo.CompanyCode AS CompanyCode,
  BusinessPartnerCustomerCo.CompanyCode AS CompanyCodeForEdit,
  BusinessPartnerCustomerCo.Customer AS CustomerForEdit,
  BPMultipleAssignment.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerCustomerCo.AccountingClerk AS AccountingClerk,
  BusinessPartnerCustomerCo.ReconciliationAccount AS ReconciliationAccount,
  BusinessPartnerCustomerCo.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerCustomerCo.CustomerHeadOffice AS CustomerHeadOffice,
  BusinessPartnerCustomerCo.AlternativePayerAccount AS AlternativePayerAccount,
  BusinessPartnerCustomerCo.PaymentBlockingReason AS PaymentBlockingReason,
  BusinessPartnerCustomerCo.InterestCalculationCode AS InterestCalculationCode,
  BusinessPartnerCustomerCo.InterestCalculationDate AS InterestCalculationDate,
  BusinessPartnerCustomerCo.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  BusinessPartnerCustomerCo.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  BusinessPartnerCustomerCo.CustomerAccountNote AS CustomerAccountNote,
  BusinessPartnerCustomerCo.APARToleranceGroup AS APARToleranceGroup,
  BusinessPartnerCustomerCo.HouseBank AS HouseBank,
  BusinessPartnerCustomerCo.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  BusinessPartnerCustomerCo.PaytAdviceIsSentbyEDI AS PaytAdviceIsSentbyEDI,
  BusinessPartnerCustomerCo.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  BusinessPartnerCustomerCo.UserAtCustomer AS UserAtCustomer,
  BusinessPartnerCustomerCo.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  BusinessPartnerCustomerCo.AccountingClerkFaxNumber AS AccountingClerkFaxNumber,
  BusinessPartnerCustomerCo.AccountingClerkInternetAddress AS AccountingClerkInternetAddress,
  BusinessPartnerCustomerCo.AccountByCustomer AS AccountByCustomer,
  BusinessPartnerCustomerCo.IsToBeLocallyProcessed AS IsToBeLocallyProcessed,
  BusinessPartnerCustomerCo.CollectiveInvoiceVariant AS CollectiveInvoiceVariant,
  BusinessPartnerCustomerCo.LayoutSortingRule AS LayoutSortingRule,
  BusinessPartnerCustomerCo.PaymentTerms AS PaymentTerms,
  BusinessPartnerCustomerCo.CustomerSupplierClearingIsUsed AS CustomerSupplierClearingIsUsed,
  BusinessPartnerCustomerCo.RecordPaymentHistoryIndicator AS RecordPaymentHistoryIndicator,
  BusinessPartnerCustomerCo.PaymentMethodsList AS PaymentMethodsList,
  BusinessPartnerCustomerCo.CashPlanningGroup AS CashPlanningGroup,
  BusinessPartnerCustomerCo.ValueAdjustmentKey AS ValueAdjustmentKey,
  BusinessPartnerCustomerCo.KnownOrNegotiatedLeave AS KnownOrNegotiatedLeave,
  _Country.Country AS Country,
  _Country.CompanyCodeName AS CompanyCodeName,
  CompanyCodeDunningControl.xmabe AS CompanyCodeDunningIsByDunArea
FROM I_CustomerCompany AS BusinessPartnerCustomerCo
INNER JOIN I_BPMultipleAssignment AS BPMultipleAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t047 AS CompanyCodeDunningControl 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_BPAdditionalCustomerTP AS _BPAdditionalCustomer ON BusinessPartner = _BPAdditionalCustomer.BusinessPartner AND Customer = _BPAdditionalCustomer.Customer  -- association [1..1]
LEFT OUTER JOIN I_BPAddlCustWhldgTaxTP AS _BusinessPartnerCustWhdgTax ON BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner AND Customer = _BusinessPartnerCustWhdgTax.Customer AND CompanyCode = _BusinessPartnerCustWhdgTax.CompanyCode  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustDunningTP AS _BPAddlCustDunning ON BusinessPartner = _BPAddlCustDunning.BusinessPartner AND Customer = _BPAddlCustDunning.Customer AND CompanyCode = _BPAddlCustDunning.CompanyCode  -- association [1..*]
LEFT OUTER JOIN I_CompanyCode AS _Country ON CompanyCode = _Country.CompanyCode  -- association [1..1]
;

Learn More