I_BusinessPartnerCustCo

DDL: I_BUSINESSPARTNERCUSTCO SQL: IBUPAPCUSTCO Type: view BASIC

core view for customer company code

I_BusinessPartnerCustCo is a Basic CDS View that provides data about "core view for customer company code" in SAP S/4HANA. It reads from 1 data source (I_CustomerCompany) and exposes 59 fields with key fields CompanyCode, BusinessPartner. It has 3 associations to related views.

1 data source(s) 59 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerCompany BusinessPartnerCustomerCo from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Customer_to_BusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer
[1..1] I_CompanyCode _Country $projection.CompanyCode = _Country.CompanyCode
[0..1] E_CUSCO_D _CustCoExt $projection.CompanyCode = _CustCoExt.CompanyCode and $projection.Customer = _CustCoExt.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBUPAPCUSTCO view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
EndUserText.label core view for customer company code view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CustomerCompany CompanyCode
KEY BusinessPartner
BusinessPartnerUUID _CustomerToBusinessPartner BusinessPartnerUUID
Customer I_CustomerCompany Customer
AccountingClerk I_CustomerCompany AccountingClerk
ReconciliationAccount I_CustomerCompany ReconciliationAccount
AuthorizationGroup I_CustomerCompany AuthorizationGroup
CustomerHeadOffice I_CustomerCompany CustomerHeadOffice
AlternativePayerAccount I_CustomerCompany AlternativePayerAccount
PaymentBlockingReason I_CustomerCompany PaymentBlockingReason
InterestCalculationCode I_CustomerCompany InterestCalculationCode
InterestCalculationDate I_CustomerCompany InterestCalculationDate
IntrstCalcFrequencyInMonths I_CustomerCompany IntrstCalcFrequencyInMonths
LastInterestCalcRunDate I_CustomerCompany LastInterestCalcRunDate
CustomerAccountNote I_CustomerCompany CustomerAccountNote
APARToleranceGroup I_CustomerCompany APARToleranceGroup
HouseBank I_CustomerCompany HouseBank
ItemIsToBePaidSeparately I_CustomerCompany ItemIsToBePaidSeparately
PaytAdviceIsSentbyEDI I_CustomerCompany PaytAdviceIsSentbyEDI
PhysicalInventoryBlockInd I_CustomerCompany PhysicalInventoryBlockInd
UserAtCustomer I_CustomerCompany UserAtCustomer
AccountingClerkPhoneNumber I_CustomerCompany AccountingClerkPhoneNumber
AccountingClerkFaxNumber I_CustomerCompany AccountingClerkFaxNumber
AccountingClerkInternetAddress I_CustomerCompany AccountingClerkInternetAddress
AccountByCustomer I_CustomerCompany AccountByCustomer
IsToBeLocallyProcessed I_CustomerCompany IsToBeLocallyProcessed
CollectiveInvoiceVariant I_CustomerCompany CollectiveInvoiceVariant
LayoutSortingRule I_CustomerCompany LayoutSortingRule
PaymentTerms I_CustomerCompany PaymentTerms
CreditMemoPaymentTerms I_CustomerCompany CreditMemoPaymentTerms
CustomerSupplierClearingIsUsed I_CustomerCompany CustomerSupplierClearingIsUsed
RecordPaymentHistoryIndicator I_CustomerCompany RecordPaymentHistoryIndicator
PaymentMethodsList I_CustomerCompany PaymentMethodsList
CashPlanningGroup I_CustomerCompany CashPlanningGroup
WithholdingTaxCountry I_CustomerCompany WithholdingTaxCountry
ValueAdjustmentKey I_CustomerCompany ValueAdjustmentKey
KnownOrNegotiatedLeave I_CustomerCompany KnownOrNegotiatedLeave
ExtendedWhldgTaxIsActive _Country ExtendedWhldgTaxIsActive
Country _Country Country
CompanyCodeName _Country CompanyCodeName
SupplierReleaseGroup I_CustomerCompany SupplierReleaseGroup
PersonnelNumber I_CustomerCompany PersonnelNumber
BuyingGroupAccountNumber I_CustomerCompany BuyingGroupAccountNumber
BillExchChargePaymentTerms I_CustomerCompany BillExchChargePaymentTerms
CheckPaidDurationInDays I_CustomerCompany CheckPaidDurationInDays
CustomerPaymentBlockingReason I_CustomerCompany CustomerPaymentBlockingReason
PaymentMethodSupplement I_CustomerCompany PaymentMethodSupplement
AcctsReceivablePledgingCode I_CustomerCompany AcctsReceivablePledgingCode
LockboxInternalID I_CustomerCompany LockboxInternalID
CustPreviousMasterRecordNumber I_CustomerCompany CustPreviousMasterRecordNumber
PaymentClearingGroup I_CustomerCompany PaymentClearingGroup
PaymentReason I_CustomerCompany PaymentReason
DeletionIsBlocked I_CustomerCompany DeletionIsBlocked
IsActiveEntity
_CompanyCode I_CustomerCompany _CompanyCode
_CustomerToBusinessPartner _CustomerToBusinessPartner
_Country _Country
_PaymentBlockValueHelp _PaymentBlockValueHelp
_PaymentBlockingReasonText _PaymentBlockingReasonText 
@AbapCatalog.sqlViewName: 'IBUPAPCUSTCO'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'core view for customer company code'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.personalData.blocking: #REQUIRED

define view I_BusinessPartnerCustCo
  as select from I_CustomerCompany as BusinessPartnerCustomerCo
  association [1..1] to I_Customer_to_BusinessPartner as _CustomerToBusinessPartner on  $projection.Customer = _CustomerToBusinessPartner.Customer

  association [1..1] to I_CompanyCode                 as _Country                   on  $projection.CompanyCode = _Country.CompanyCode

  association [0..1] to E_CUSCO_D                     as _CustCoExt                 on  $projection.CompanyCode = _CustCoExt.CompanyCode
                                                                                    and $projection.Customer    = _CustCoExt.Customer
{
  key BusinessPartnerCustomerCo.CompanyCode,
  key _CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
      _CustomerToBusinessPartner.BusinessPartnerUUID,
      BusinessPartnerCustomerCo.Customer,
      BusinessPartnerCustomerCo.AccountingClerk,
      BusinessPartnerCustomerCo.ReconciliationAccount,
      BusinessPartnerCustomerCo.AuthorizationGroup,
      BusinessPartnerCustomerCo.CustomerHeadOffice,
      BusinessPartnerCustomerCo.AlternativePayerAccount,
      BusinessPartnerCustomerCo.PaymentBlockingReason,
      BusinessPartnerCustomerCo.InterestCalculationCode,
      BusinessPartnerCustomerCo.InterestCalculationDate,
      BusinessPartnerCustomerCo.IntrstCalcFrequencyInMonths,      
      BusinessPartnerCustomerCo.LastInterestCalcRunDate,
      BusinessPartnerCustomerCo.CustomerAccountNote,
      BusinessPartnerCustomerCo.APARToleranceGroup,
      BusinessPartnerCustomerCo.HouseBank,
      BusinessPartnerCustomerCo.ItemIsToBePaidSeparately,
      BusinessPartnerCustomerCo.PaytAdviceIsSentbyEDI,

      BusinessPartnerCustomerCo.PhysicalInventoryBlockInd,
      BusinessPartnerCustomerCo.UserAtCustomer, //GFN not available

      BusinessPartnerCustomerCo.AccountingClerkPhoneNumber,
      BusinessPartnerCustomerCo.AccountingClerkFaxNumber,
      BusinessPartnerCustomerCo.AccountingClerkInternetAddress,
      BusinessPartnerCustomerCo.AccountByCustomer,
      BusinessPartnerCustomerCo.IsToBeLocallyProcessed,
      BusinessPartnerCustomerCo.CollectiveInvoiceVariant, //GFN not available

      BusinessPartnerCustomerCo.LayoutSortingRule,
      BusinessPartnerCustomerCo.PaymentTerms,
      BusinessPartnerCustomerCo.CreditMemoPaymentTerms,
      BusinessPartnerCustomerCo.CustomerSupplierClearingIsUsed,
      BusinessPartnerCustomerCo.RecordPaymentHistoryIndicator, //GFN not available

      BusinessPartnerCustomerCo.PaymentMethodsList,
      BusinessPartnerCustomerCo.CashPlanningGroup,
      BusinessPartnerCustomerCo.WithholdingTaxCountry,
      BusinessPartnerCustomerCo.ValueAdjustmentKey,
      BusinessPartnerCustomerCo.KnownOrNegotiatedLeave,
      _Country.ExtendedWhldgTaxIsActive,
      _Country.Country                                as Country,
      _Country.CompanyCodeName,
      
      BusinessPartnerCustomerCo.SupplierReleaseGroup,
      BusinessPartnerCustomerCo.PersonnelNumber,
      BusinessPartnerCustomerCo.BuyingGroupAccountNumber,
      BusinessPartnerCustomerCo.BillExchChargePaymentTerms,
      BusinessPartnerCustomerCo.CheckPaidDurationInDays,
      BusinessPartnerCustomerCo.CustomerPaymentBlockingReason,
      BusinessPartnerCustomerCo.PaymentMethodSupplement,
      BusinessPartnerCustomerCo.AcctsReceivablePledgingCode,
      BusinessPartnerCustomerCo.LockboxInternalID,
      BusinessPartnerCustomerCo.CustPreviousMasterRecordNumber,
      BusinessPartnerCustomerCo.PaymentClearingGroup,
      BusinessPartnerCustomerCo.PaymentReason,
      BusinessPartnerCustomerCo.DeletionIsBlocked,

      //For extensibility

      cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,

      BusinessPartnerCustomerCo._CompanyCode,
      //BusinessPartnerCustomerCo._Customer,

      _CustomerToBusinessPartner,
      _Country,      
      _PaymentBlockValueHelp,
      _PaymentBlockingReasonText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_CUSTOMERCOMPANY",
"I_CUSTOMER_TO_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"E_CUSCO_D",
"I_COMPANYCODE",
"I_CUSTOMER_TO_BUSINESSPARTNER",
"I_PAYMENTBLOCKINGREASON",
"I_PAYMENTBLOCKINGREASONTEXT"
],
"BASE":
[
"I_CUSTOMERCOMPANY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More