Which tables does I_BusinessPartnerCustCoTP use?

I_BusinessPartnerCustCoTP reads from 2 data source(s): I_BusinessPartnerCustCo, t047.

How many fields does I_BusinessPartnerCustCoTP have?

I_BusinessPartnerCustCoTP has 61 fields. Key fields: BusinessPartner, CompanyCode.

I_BusinessPartnerCustCoTP

DDL: I_BUSINESSPARTNERCUSTCOTP SQL: IBUPACUSTCOTP Type: view TRANSACTIONAL

BO view for customer companycode

I_BusinessPartnerCustCoTP is a Transactional CDS View that provides data about "BO view for customer companycode" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartnerCustCo, t047) and exposes 61 fields with key fields BusinessPartner, CompanyCode. It has 6 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_BusinessPartnerCustCo	BusinessPartnerCustomerCo	from
t047	CompanyCodeDunningControl	left_outer

Associations (6)

Cardinality	Target	Alias	Condition
[0..1]	E_CUSCO_D	_DraftExtension	`$projection.CompanyCode = _DraftExtension.CompanyCode and $projection.Customer = _DraftExtension.Customer`
[0..1]	E_CUSCO_D	_ActiveExtension	`$projection.CompanyCode = _ActiveExtension.CompanyCode and $projection.Customer = _ActiveExtension.Customer`
[0..*]	I_BusinessPartnerCustWhdgTaxTP	_BusinessPartnerCustWhdgTax	`$projection.BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner and $projection.CompanyCode = _BusinessPartnerCustWhdgTax.CompanyCode`
[1..1]	I_BusinessPartnerTP	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[0..*]	I_BPCustomerDunningTP	_BPCustomerDunning	`$projection.BusinessPartner = _BPCustomerDunning.BusinessPartner and $projection.CompanyCode = _BPCustomerDunning.CompanyCode`
[0..*]	I_BusinessPartnerCustCoTextTP	_BusinessPartnerCustCoText	`$projection.BusinessPartner = _BusinessPartnerCustCoText.BusinessPartner and $projection.CompanyCode = _BusinessPartnerCustCoText.CompanyCode`

Annotations (15)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	IBUPACUSTCOTP	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientDependent	true	view
EndUserText.label	BO view for customer companycode	view
ObjectModel.writeEnabled	true	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.writeDraftPersistence	CUSCOMPANYCODE_D	view
ObjectModel.draftEnabled	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
VDM.viewType	#TRANSACTIONAL	view

Fields (61)

Key	Field	Source Table	Source Field
KEY	BusinessPartner	I_BusinessPartnerCustCo	BusinessPartner
KEY	CompanyCode	I_BusinessPartnerCustCo	CompanyCode
	CompanyCodeForEdit	I_BusinessPartnerCustCo	CompanyCode
	BusinessPartnerForEdit	I_BusinessPartnerCustCo	BusinessPartner
	BusinessPartnerUUID	I_BusinessPartnerCustCo	BusinessPartnerUUID
	Customer	I_BusinessPartnerCustCo	Customer
	AccountingClerk	I_BusinessPartnerCustCo	AccountingClerk
	ReconciliationAccount	I_BusinessPartnerCustCo	ReconciliationAccount
	AuthorizationGroup	I_BusinessPartnerCustCo	AuthorizationGroup
	CustomerHeadOffice	I_BusinessPartnerCustCo	CustomerHeadOffice
	AlternativePayerAccount	I_BusinessPartnerCustCo	AlternativePayerAccount
	PaymentBlockingReason	I_BusinessPartnerCustCo	PaymentBlockingReason
	InterestCalculationCode	I_BusinessPartnerCustCo	InterestCalculationCode
	InterestCalculationDate	I_BusinessPartnerCustCo	InterestCalculationDate
	IntrstCalcFrequencyInMonths	I_BusinessPartnerCustCo	IntrstCalcFrequencyInMonths
	LastInterestCalcRunDate	I_BusinessPartnerCustCo	LastInterestCalcRunDate
	CustomerAccountNote	I_BusinessPartnerCustCo	CustomerAccountNote
	APARToleranceGroup	I_BusinessPartnerCustCo	APARToleranceGroup
	HouseBank	I_BusinessPartnerCustCo	HouseBank
	ItemIsToBePaidSeparately	I_BusinessPartnerCustCo	ItemIsToBePaidSeparately
	PaytAdviceIsSentbyEDI	I_BusinessPartnerCustCo	PaytAdviceIsSentbyEDI
	PhysicalInventoryBlockInd	I_BusinessPartnerCustCo	PhysicalInventoryBlockInd
	UserAtCustomer	I_BusinessPartnerCustCo	UserAtCustomer
	AccountingClerkPhoneNumber	I_BusinessPartnerCustCo	AccountingClerkPhoneNumber
	AccountingClerkFaxNumber	I_BusinessPartnerCustCo	AccountingClerkFaxNumber
	AccountingClerkInternetAddress	I_BusinessPartnerCustCo	AccountingClerkInternetAddress
	AccountByCustomer	I_BusinessPartnerCustCo	AccountByCustomer
	IsToBeLocallyProcessed	I_BusinessPartnerCustCo	IsToBeLocallyProcessed
	CollectiveInvoiceVariant	I_BusinessPartnerCustCo	CollectiveInvoiceVariant
	LayoutSortingRule	I_BusinessPartnerCustCo	LayoutSortingRule
	PaymentTerms	I_BusinessPartnerCustCo	PaymentTerms
	CreditMemoPaymentTerms	I_BusinessPartnerCustCo	CreditMemoPaymentTerms
	CustomerSupplierClearingIsUsed	I_BusinessPartnerCustCo	CustomerSupplierClearingIsUsed
	RecordPaymentHistoryIndicator	I_BusinessPartnerCustCo	RecordPaymentHistoryIndicator
	PaymentMethodsList	I_BusinessPartnerCustCo	PaymentMethodsList
	CashPlanningGroup	I_BusinessPartnerCustCo	CashPlanningGroup
	ValueAdjustmentKey	I_BusinessPartnerCustCo	ValueAdjustmentKey
	KnownOrNegotiatedLeave	I_BusinessPartnerCustCo	KnownOrNegotiatedLeave
	Country	I_BusinessPartnerCustCo	Country
	CompanyCodeDunningIsByDunArea	t047	xmabe
	SupplierReleaseGroup	I_BusinessPartnerCustCo	SupplierReleaseGroup
	PersonnelNumber	I_BusinessPartnerCustCo	PersonnelNumber
	BuyingGroupAccountNumber	I_BusinessPartnerCustCo	BuyingGroupAccountNumber
	BillExchChargePaymentTerms	I_BusinessPartnerCustCo	BillExchChargePaymentTerms
	CheckPaidDurationInDays	I_BusinessPartnerCustCo	CheckPaidDurationInDays
	CustomerPaymentBlockingReason	I_BusinessPartnerCustCo	CustomerPaymentBlockingReason
	PaymentMethodSupplement	I_BusinessPartnerCustCo	PaymentMethodSupplement
	AcctsReceivablePledgingCode	I_BusinessPartnerCustCo	AcctsReceivablePledgingCode
	LockboxInternalID	I_BusinessPartnerCustCo	LockboxInternalID
	CustPreviousMasterRecordNumber	I_BusinessPartnerCustCo	CustPreviousMasterRecordNumber
	PaymentClearingGroup	I_BusinessPartnerCustCo	PaymentClearingGroup
	ExtendedWhldgTaxIsActive	I_BusinessPartnerCustCo	ExtendedWhldgTaxIsActive
	CompanyCodeName	I_BusinessPartnerCustCo	CompanyCodeName
	PaymentReason	I_BusinessPartnerCustCo	PaymentReason
	DeletionIsBlocked	I_BusinessPartnerCustCo	DeletionIsBlocked
	_BusinessPartner		_BusinessPartner
	_BusinessPartnerCustWhdgTax		_BusinessPartnerCustWhdgTax
	_BPCustomerDunning		_BPCustomerDunning
	_BusinessPartnerCustCoText		_BusinessPartnerCustCoText
	_PaymentBlockValueHelp		_PaymentBlockValueHelp
	_PaymentBlockingReasonText		_PaymentBlockingReasonText

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IBUPACUSTCOTP'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientDependent: true
@EndUserText.label: 'BO view for customer companycode'
@ObjectModel.writeEnabled: true
@ObjectModel.createEnabled 
@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION'
@ObjectModel.updateEnabled 
@ObjectModel.semanticKey: ['BusinessPartner','CompanyCode']
@ObjectModel.writeDraftPersistence: 'CUSCOMPANYCODE_D'
@ObjectModel.draftEnabled:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL

define view I_BusinessPartnerCustCoTP
  as select from I_BusinessPartnerCustCo as BusinessPartnerCustomerCo
                 left outer join t047 as CompanyCodeDunningControl on BusinessPartnerCustomerCo.CompanyCode = CompanyCodeDunningControl.bukrs

  association [0..1] to E_CUSCO_D                      as _DraftExtension             on  $projection.CompanyCode = _DraftExtension.CompanyCode
                                                                                      and $projection.Customer    = _DraftExtension.Customer

  association [0..1] to E_CUSCO_D                      as _ActiveExtension            on  $projection.CompanyCode = _ActiveExtension.CompanyCode
                                                                                      and $projection.Customer    = _ActiveExtension.Customer

  association [0..*] to I_BusinessPartnerCustWhdgTaxTP as _BusinessPartnerCustWhdgTax on  $projection.BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner
                                                                                      and $projection.CompanyCode     = _BusinessPartnerCustWhdgTax.CompanyCode

  association [1..1] to I_BusinessPartnerTP            as _BusinessPartner            on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  
  association [0..*] to I_BPCustomerDunningTP          as _BPCustomerDunning          on $projection.BusinessPartner = _BPCustomerDunning.BusinessPartner
                                                                                      and $projection.CompanyCode    = _BPCustomerDunning.CompanyCode
  association [0..*] to I_BusinessPartnerCustCoTextTP  as _BusinessPartnerCustCoText  on $projection.BusinessPartner = _BusinessPartnerCustCoText.BusinessPartner
                                                                                      and $projection.CompanyCode    = _BusinessPartnerCustCoText.CompanyCode                                                                                  
{
      @semanticKey: true
  key BusinessPartnerCustomerCo.BusinessPartner,
      @semanticKey: true
  key BusinessPartnerCustomerCo.CompanyCode,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CompanyCode     as CompanyCodeForEdit,
      BusinessPartnerCustomerCo.BusinessPartner as BusinessPartnerForEdit,
      BusinessPartnerCustomerCo.BusinessPartnerUUID,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.Customer,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AccountingClerk,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.ReconciliationAccount,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION' 
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AuthorizationGroup,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CustomerHeadOffice,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AlternativePayerAccount,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.PaymentBlockingReason,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.InterestCalculationCode,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.InterestCalculationDate,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.IntrstCalcFrequencyInMonths,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.LastInterestCalcRunDate,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CustomerAccountNote,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.APARToleranceGroup,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.HouseBank,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.ItemIsToBePaidSeparately,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.PaytAdviceIsSentbyEDI,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.PhysicalInventoryBlockInd,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.UserAtCustomer,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AccountingClerkPhoneNumber,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AccountingClerkFaxNumber,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AccountingClerkInternetAddress,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.AccountByCustomer,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.IsToBeLocallyProcessed,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CollectiveInvoiceVariant,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.LayoutSortingRule,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.PaymentTerms,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CreditMemoPaymentTerms,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CustomerSupplierClearingIsUsed,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.RecordPaymentHistoryIndicator,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.PaymentMethodsList,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CashPlanningGroup,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.ValueAdjustmentKey,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.KnownOrNegotiatedLeave,
      BusinessPartnerCustomerCo.Country, // country field to filter payment methods based on company code

      CompanyCodeDunningControl.xmabe as CompanyCodeDunningIsByDunArea,
      
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.SupplierReleaseGroup,
      BusinessPartnerCustomerCo.PersonnelNumber,
      BusinessPartnerCustomerCo.BuyingGroupAccountNumber,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.BillExchChargePaymentTerms,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CheckPaidDurationInDays,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerCustomerCo.CustomerPaymentBlockingReason,
      BusinessPartnerCustomerCo.PaymentMethodSupplement,
      BusinessPartnerCustomerCo.AcctsReceivablePledgingCode,
      BusinessPartnerCustomerCo.LockboxInternalID,
      BusinessPartnerCustomerCo.CustPreviousMasterRecordNumber,
      BusinessPartnerCustomerCo.PaymentClearingGroup,
      BusinessPartnerCustomerCo.ExtendedWhldgTaxIsActive,
      BusinessPartnerCustomerCo.CompanyCodeName,
      BusinessPartnerCustomerCo.PaymentReason,
      BusinessPartnerCustomerCo.DeletionIsBlocked,
      

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BusinessPartnerCustWhdgTax,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPCustomerDunning,
       @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BusinessPartnerCustCoText,

      _PaymentBlockValueHelp,
      _PaymentBlockingReasonText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERCUSTCO",
"T047"
],
"ASSOCIATED":
[
"E_CUSCO_D",
"I_BPCUSTOMERDUNNINGTP",
"I_BUSINESSPARTNERCUSTCOTEXTTP",
"I_BUSINESSPARTNERCUSTWHDGTAXTP",
"I_BUSINESSPARTNERTP",
"I_PAYMENTBLOCKINGREASON",
"I_PAYMENTBLOCKINGREASONTEXT"
],
"BASE":
[
"I_BUSINESSPARTNERCUSTCO"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BusinessPartnerCustCoTP view

I_BusinessPartnerCustCo view
t047

C_BusinessPartnerCustCo view