I_BUSINESSPARTNERCUSTCOTP

CDS View

BO view for customer companycode

I_BUSINESSPARTNERCUSTCOTP is a CDS View in S/4HANA. BO view for customer companycode. It contains 53 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 53 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BusinessPartnerCustCo view from CONSUMPTION BP Cust CompanyCode Consumption

Fields (53)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CompanyCode CompanyCode 1
AccountByCustomer AccountByCustomer 1
AccountingClerk AccountingClerk 1
AccountingClerkFaxNumber AccountingClerkFaxNumber 1
AccountingClerkInternetAddress AccountingClerkInternetAddress 1
AccountingClerkPhoneNumber AccountingClerkPhoneNumber 1
AcctsReceivablePledgingCode AcctsReceivablePledgingCode 1
AlternativePayerAccount AlternativePayerAccount 1
APARToleranceGroup APARToleranceGroup 1
AuthorizationGroup AuthorizationGroup 1
BillExchChargePaymentTerms BillExchChargePaymentTerms 1
BusinessPartnerForEdit BusinessPartnerForEdit 1
BuyingGroupAccountNumber BuyingGroupAccountNumber 1
CashPlanningGroup CashPlanningGroup 1
CheckPaidDurationInDays CheckPaidDurationInDays 1
CollectiveInvoiceVariant CollectiveInvoiceVariant 1
CompanyCodeDunningIsByDunArea CompanyCodeDunningIsByDunArea 1
CompanyCodeForEdit CompanyCodeForEdit 1
CompanyCodeName CompanyCodeName 1
Country Country 1
CreditMemoPaymentTerms CreditMemoPaymentTerms 1
Customer Customer 1
CustomerAccountNote CustomerAccountNote 1
CustomerHeadOffice CustomerHeadOffice 1
CustomerSupplierClearingIsUsed CustomerSupplierClearingIsUsed 1
CustPreviousMasterRecordNumber CustPreviousMasterRecordNumber 1
DeletionIsBlocked DeletionIsBlocked 1
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive 1
HouseBank HouseBank 1
InterestCalculationCode InterestCalculationCode 1
InterestCalculationDate InterestCalculationDate 1
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 1
IsToBeLocallyProcessed IsToBeLocallyProcessed 1
ItemIsToBePaidSeparately ItemIsToBePaidSeparately 1
KnownOrNegotiatedLeave KnownOrNegotiatedLeave 1
LastInterestCalcRunDate LastInterestCalcRunDate 1
LayoutSortingRule LayoutSortingRule 1
LockboxInternalID LockboxInternalID 1
PaymentBlockingReason PaymentBlockingReason 1
PaymentClearingGroup PaymentClearingGroup 1
PaymentMethodsList PaymentMethodsList 1
PaymentMethodSupplement PaymentMethodSupplement 1
PaymentReason PaymentReason 1
PaymentTerms PaymentTerms 1
PaytAdviceIsSentbyEDI PaytAdviceIsSentbyEDI 1
PersonnelNumber PersonnelNumber 1
PhysicalInventoryBlockInd PhysicalInventoryBlockInd 1
ReconciliationAccount ReconciliationAccount 1
RecordPaymentHistoryIndicator RecordPaymentHistoryIndicator 1
SupplierReleaseGroup SupplierReleaseGroup 1
UserAtCustomer UserAtCustomer 1
ValueAdjustmentKey ValueAdjustmentKey 1 
@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":""
}
}*/

Learn More