C_BusinessPartnerCust

Business Partner Customer | view: CBUPACUST | Extraction: Not supported | Component: Business Partners
Tables used: BP001, BUT000, BUT000, CVI_CUST_LINK, KNA1, TB003, BUT100
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DataMediumExchangeIndicator Report key for data medium exchange Show values
VATLiability Liable for VAT Show values
PostingIsBlocked Central posting block Show values
IsNaturalPerson Natural Person Show values
DeliveryDateTypeRule Delivery Date Rule Show values
IsCompetitor Indicator: Competitor Show values
IsSalesPartner Indicator: Sales partner Show values
IsDefaultSoldToParty ID for default sold-to party Show values
IsConsumer Indicator: Consumer Show values
BPIsEqualizationTaxSubject Checkbox Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
SalesIsBlockedForCustomer Checkbox Show values
Column Name Description Domain name
Customer Customer Number KUNNR
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
AuthorizationGroup Authorization Group BRGRU
ExpressTrainStationName Express train station BAHNH
TrainStationName Train station BAHNH
CityLocationCoordinatesCode City Coordinates LOCCO
CustomerCorporateGroup Group key KONZS
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
Country Country/Region Key LAND1
Region Region (State, Province, County) REGIO
PaymentReason Payment Reason FARP_PAYT_RSN
Master Data Relations Join Conditions
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • C_BUSINESSPARTNERCUST.MANDT == KNA1.MANDT
  • C_BUSINESSPARTNERCUST.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Central billing block for customer
  • Central billing block for customer
  • Client
  • C_BUSINESSPARTNERCUST.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
  • C_BUSINESSPARTNERCUST.MANDT == TVFS.MANDT
City Code
  • City Code
  • ?
  • Client
  • ?
  • C_BUSINESSPARTNERCUST.CITYCODE == T005G.CITYC
  • C_BUSINESSPARTNERCUST.[column in domain "LAND1"] == T005G.LAND1
  • C_BUSINESSPARTNERCUST.MANDT == T005G.MANDT
  • C_BUSINESSPARTNERCUST.[column in domain "REGIO"] == T005G.REGIO
County Code
  • County Code
  • ?
  • Client
  • ?
  • C_BUSINESSPARTNERCUST.COUNTY == T005E.COUNC
  • C_BUSINESSPARTNERCUST.[column in domain "LAND1"] == T005E.LAND1
  • C_BUSINESSPARTNERCUST.MANDT == T005E.MANDT
  • C_BUSINESSPARTNERCUST.[column in domain "REGIO"] == T005E.REGIO
Customer Account Group
  • Customer Account Group
  • Client
  • C_BUSINESSPARTNERCUST.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_BUSINESSPARTNERCUST.MANDT == T077D.MANDT
Customer Classification
  • Client
  • Customer Classification
  • C_BUSINESSPARTNERCUST.MANDT == TKUKL.MANDT
  • C_BUSINESSPARTNERCUST.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Customer Condition Group
  • Client
  • Customer condition group 1
  • C_BUSINESSPARTNERCUST.MANDT == TVKGG.MANDT
  • C_BUSINESSPARTNERCUST.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer Condition Group
  • Customer condition group 2
  • Client
  • C_BUSINESSPARTNERCUST.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_BUSINESSPARTNERCUST.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 3
  • Client
  • C_BUSINESSPARTNERCUST.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • C_BUSINESSPARTNERCUST.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 4
  • Client
  • C_BUSINESSPARTNERCUST.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • C_BUSINESSPARTNERCUST.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 5
  • C_BUSINESSPARTNERCUST.MANDT == TVKGG.MANDT
  • C_BUSINESSPARTNERCUST.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • C_BUSINESSPARTNERCUST.DELIVERYISBLOCKED == TVLS.LIFSP
  • C_BUSINESSPARTNERCUST.MANDT == TVLS.MANDT
Account number of the master record with the fiscal address
  • Client
  • Account number of the master record with the fiscal address
  • C_BUSINESSPARTNERCUST.MANDT == KNA1.MANDT
  • C_BUSINESSPARTNERCUST.FISCALADDRESS == KNA1.KUNNR
Attribute 3
  • Client
  • Attribute 3
  • C_BUSINESSPARTNERCUST.MANDT == TVK3.MANDT
  • C_BUSINESSPARTNERCUST.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3
Industry code 1
  • Industry code 1
  • Client
  • C_BUSINESSPARTNERCUST.INDUSTRYCODE1 == TBRC.BRACO
  • C_BUSINESSPARTNERCUST.MANDT == TBRC.MANDT
Industry code 2
  • Client
  • Industry code 2
  • C_BUSINESSPARTNERCUST.MANDT == TBRC.MANDT
  • C_BUSINESSPARTNERCUST.INDUSTRYCODE2 == TBRC.BRACO
Industry code 3
  • Industry code 3
  • Client
  • C_BUSINESSPARTNERCUST.INDUSTRYCODE3 == TBRC.BRACO
  • C_BUSINESSPARTNERCUST.MANDT == TBRC.MANDT
Language Key C_BUSINESSPARTNERCUST.LANGUAGE == T002.SPRAS
Central order block for customer
  • Client
  • Central order block for customer
  • ?
  • C_BUSINESSPARTNERCUST.MANDT == TVAST.MANDT
  • C_BUSINESSPARTNERCUST.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • C_BUSINESSPARTNERCUST.[column in domain "SPRAS"] == TVAST.SPRAS
Plant
  • Client
  • Plant
  • C_BUSINESSPARTNERCUST.MANDT == T001W.MANDT
  • C_BUSINESSPARTNERCUST.PLANT == T001W.WERKS
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_BUSINESSPARTNERCUST.SUPPLIER == LFA1.LIFNR
  • C_BUSINESSPARTNERCUST.MANDT == LFA1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_BUSINESSPARTNERCUST.TRADINGPARTNER == T880.RCOMP
  • C_BUSINESSPARTNERCUST.MANDT == T880.MANDT