I_BPAdditionalCustomerTP

BO view for Additional Customers of BP | view: IBPADDCUSTTP | 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
IsStandardAssignment General Flag Show values
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
BPAssignmentID Multiple Assignment ID (Number) MDG_BP_ASSIGNMENT_ID
AddressNumber Address Number AD_ADDRNUM
AuthorizationGroup Authorization Group BRGRU
CustomerName Name of Customer TEXT80
PostalCode City postal code CHAR10
StreetName Street TEXT60
HouseNumber House Number TEXT10
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
  • I_BPADDITIONALCUSTOMERTP.MANDT == KNA1.MANDT
  • I_BPADDITIONALCUSTOMERTP.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Central billing block for customer
  • Client
  • Central billing block for customer
  • I_BPADDITIONALCUSTOMERTP.MANDT == TVFS.MANDT
  • I_BPADDITIONALCUSTOMERTP.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Assignment Category I_BPADDITIONALCUSTOMERTP.BPASSIGNMENTCATEGORY == MDG_MLT_AS_CAT.ASSIGNMENT_CAT
Assignment Reason
  • Client
  • Assignment Reason
Language key I_BPADDITIONALCUSTOMERTP.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_BPADDITIONALCUSTOMERTP.MANDT == T005.MANDT
  • I_BPADDITIONALCUSTOMERTP.COUNTRY == T005.LAND1
Customer Account Group
  • Client
  • Customer Account Group
  • I_BPADDITIONALCUSTOMERTP.MANDT == T077D.MANDT
  • I_BPADDITIONALCUSTOMERTP.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • I_BPADDITIONALCUSTOMERTP.MANDT == TKUKL.MANDT
  • I_BPADDITIONALCUSTOMERTP.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • I_BPADDITIONALCUSTOMERTP.MANDT == TVLS.MANDT
  • I_BPADDITIONALCUSTOMERTP.DELIVERYISBLOCKED == TVLS.LIFSP
Central order block for customer
  • Language Key
  • Client
  • Central order block for customer
  • I_BPADDITIONALCUSTOMERTP.CORRESPONDENCELANGUAGE == TVAST.SPRAS
  • I_BPADDITIONALCUSTOMERTP.MANDT == TVAST.MANDT
  • I_BPADDITIONALCUSTOMERTP.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Communication Method I_BPADDITIONALCUSTOMERTP.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_BPADDITIONALCUSTOMERTP.MANDT == T005S.MANDT
  • I_BPADDITIONALCUSTOMERTP.COUNTRY == T005S.LAND1
  • I_BPADDITIONALCUSTOMERTP.REGION == T005S.BLAND
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_BPADDITIONALCUSTOMERTP.SUPPLIER == LFA1.LIFNR
  • I_BPADDITIONALCUSTOMERTP.MANDT == LFA1.MANDT