A_Customer

Customer | view: ACUSTOMER | Extraction: Not supported | Component: Business Partners
Tables used: KNA1
Column Name Description
Customer Customer Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
NFPartnerIsNaturalPerson Natural Person Show values
PostingIsBlocked Central posting block Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
CustomerFullName Customer Full Name TEXT220
CustomerName Name of Customer TEXT80
CustomerCorporateGroup Group key KONZS
InternationalLocationNumber1 International location number (part 1) NUM07
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
VATRegistration VAT Registration Number STCEG
ExpressTrainStationName Express train station BAHNH
TrainStationName Train station BAHNH
Master Data Relations Join Conditions
Central billing block for customer
  • Client
  • Central billing block for customer
  • A_CUSTOMER.MANDT == TVFS.MANDT
  • A_CUSTOMER.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
City Code
  • Client
  • ?
  • City Code
  • ?
  • A_CUSTOMER.MANDT == T005G.MANDT
  • A_CUSTOMER.[column in domain "REGIO"] == T005G.REGIO
  • A_CUSTOMER.CITYCODE == T005G.CITYC
  • A_CUSTOMER.[column in domain "LAND1"] == T005G.LAND1
County Code
  • Client
  • ?
  • County Code
  • ?
  • A_CUSTOMER.MANDT == T005E.MANDT
  • A_CUSTOMER.[column in domain "REGIO"] == T005E.REGIO
  • A_CUSTOMER.COUNTY == T005E.COUNC
  • A_CUSTOMER.[column in domain "LAND1"] == T005E.LAND1
Customer Account Group
  • Client
  • Customer Account Group
  • A_CUSTOMER.MANDT == T077D.MANDT
  • A_CUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • A_CUSTOMER.MANDT == TKUKL.MANDT
  • A_CUSTOMER.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • A_CUSTOMER.MANDT == TVLS.MANDT
  • A_CUSTOMER.DELIVERYISBLOCKED == TVLS.LIFSP
Account number of the master record with the fiscal address
  • Account number of the master record with the fiscal address
  • Client
  • A_CUSTOMER.FISCALADDRESS == KNA1.KUNNR
  • A_CUSTOMER.MANDT == KNA1.MANDT
Industry key
  • Client
  • Industry key
  • A_CUSTOMER.MANDT == T016.MANDT
  • A_CUSTOMER.INDUSTRY == T016.BRSCH
Industry code 1
  • Client
  • Industry code 1
  • A_CUSTOMER.MANDT == TBRC.MANDT
  • A_CUSTOMER.INDUSTRYCODE1 == TBRC.BRACO
Industry code 2
  • Industry code 2
  • Client
  • A_CUSTOMER.INDUSTRYCODE2 == TBRC.BRACO
  • A_CUSTOMER.MANDT == TBRC.MANDT
Industry code 3
  • Industry code 3
  • Client
  • A_CUSTOMER.INDUSTRYCODE3 == TBRC.BRACO
  • A_CUSTOMER.MANDT == TBRC.MANDT
Industry code 4
  • Client
  • Industry code 4
  • A_CUSTOMER.MANDT == TBRC.MANDT
  • A_CUSTOMER.INDUSTRYCODE4 == TBRC.BRACO
Industry code 5
  • Client
  • Industry code 5
  • A_CUSTOMER.MANDT == TBRC.MANDT
  • A_CUSTOMER.INDUSTRYCODE5 == TBRC.BRACO
Nielsen ID
  • Client
  • Nielsen ID
  • A_CUSTOMER.MANDT == TNLS.MANDT
  • A_CUSTOMER.NIELSENREGION == TNLS.NIELS
Central order block for customer
  • Client
  • ?
  • Central order block for customer
  • A_CUSTOMER.MANDT == TVAST.MANDT
  • A_CUSTOMER.[column in domain "SPRAS"] == TVAST.SPRAS
  • A_CUSTOMER.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Tax Type
  • Client
  • ?
  • Tax type
  • A_CUSTOMER.MANDT == J_1AFITP.MANDT
  • A_CUSTOMER.[column in domain "KOART"] == J_1AFITP.KOART
  • A_CUSTOMER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • A_CUSTOMER.MANDT == LFA1.MANDT
  • A_CUSTOMER.SUPPLIER == LFA1.LIFNR
J_1ATODC
  • Client
  • Tax Number Type
  • A_CUSTOMER.MANDT == J_1ATODC.MANDT
  • A_CUSTOMER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC