C_BPAdditionalCustomer

C view for BP Additional Customers | view: CBPADDCUST | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, MDG_MLT_ASSGMNT, KNA1
Column Name Description
BusinessPartner Business Partner Number
Customer Customer 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
DeliveryDateTypeRule Delivery Date Rule Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
Column Name Description Domain name
BusinessPartnerForEdit Business Partner Number BU_PARTNER
CustomerForEdit Customer Number KUNNR
AuthorizationGroup Authorization Group BRGRU
AddressNumber Address Number AD_ADDRNUM
StreetName Street TEXT60
HouseNumber House Number TEXT10
PostalCode City postal code CHAR10
CityName City TEXT40
POBoxPostalCode PO Box Postal Code CHAR10
POBox PO Box CHAR10
Master Data Relations Join Conditions
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • C_BPADDITIONALCUSTOMER.MANDT == KNA1.MANDT
  • C_BPADDITIONALCUSTOMER.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Central billing block for customer
  • Client
  • Central billing block for customer
  • C_BPADDITIONALCUSTOMER.MANDT == TVFS.MANDT
  • C_BPADDITIONALCUSTOMER.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Assignment Reason
  • Assignment Reason
  • Client
Language key C_BPADDITIONALCUSTOMER.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region Key
  • Client
  • C_BPADDITIONALCUSTOMER.COUNTRY == T005.LAND1
  • C_BPADDITIONALCUSTOMER.MANDT == T005.MANDT
Customer Account Group
  • Client
  • Customer Account Group
  • C_BPADDITIONALCUSTOMER.MANDT == T077D.MANDT
  • C_BPADDITIONALCUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • C_BPADDITIONALCUSTOMER.MANDT == TKUKL.MANDT
  • C_BPADDITIONALCUSTOMER.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • C_BPADDITIONALCUSTOMER.DELIVERYISBLOCKED == TVLS.LIFSP
  • C_BPADDITIONALCUSTOMER.MANDT == TVLS.MANDT
Central order block for customer
  • Client
  • Language Key
  • Central order block for customer
  • C_BPADDITIONALCUSTOMER.MANDT == TVAST.MANDT
  • C_BPADDITIONALCUSTOMER.CORRESPONDENCELANGUAGE == TVAST.SPRAS
  • C_BPADDITIONALCUSTOMER.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Communication Method C_BPADDITIONALCUSTOMER.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • C_BPADDITIONALCUSTOMER.REGION == T005S.BLAND
  • C_BPADDITIONALCUSTOMER.COUNTRY == T005S.LAND1
  • C_BPADDITIONALCUSTOMER.MANDT == T005S.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • C_BPADDITIONALCUSTOMER.MANDT == LFA1.MANDT
  • C_BPADDITIONALCUSTOMER.SUPPLIER == LFA1.LIFNR