C_ARCustomer

Customer List | view: CARCUSTOMER | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: CRM_JEST, CRM_JSTO, T001S, ADCP, ADRC, ADR6, ADR2, BNKA, BUT000, BUT0BK, KNA1, T077X, KNB1, KNB5, KNVV, CVI_CUST_LINK, KNVP, TPAR, /SHCM/HRP5092, TIBAN, BUT0CC, TVKO, TJ02, TJ02T, FITHA_PBUPL_D, FITHA_PBUPL_D_T, USR21, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, TJ30, TJ30T, ADRCT, BP001
Column Name Description
Customer Customer Number
CompanyCode Company Code
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
PartnerCounter Partner counter
CardNumber Payment Cards: Card Number
PaymentCardType Payment Card Type
PartnerFunction FK In-House Contact
CustomerIsWithCompanyCode null
BankIdentification Bank Details ID
Column Name Description
Column Name Description
Column Name Description
LastDunnedOn Date of Last Dunning Notice
LegDunningProcedureOn Date of the Legal Dunning Proceedings
InterestCalculationDate Key Date of Last Interest Calculation
LastInterestCalcRunDate Date of Last Interest Calculation Run
LastCustomerContactDate Date of Last Customer Contact
Column Name Description
IsMarkedForArchiving Central Archiving Flag Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
ContactPermission Business Partner: Contact Permission Show values
PostingIsBlocked Central posting block Show values
VATLiability Liable for VAT Show values
CustomerIsUnwanted Undesirable Customer Show values
Column Name Description Domain name
IBAN IBAN (International Bank Account Number) CHAR34
PartnerFunctionName In-House Contact TEXT100
PersonnelNumber Personnel Number PERNR
AccountingClerk Accounting Clerk Abbreviation BUSAB
AccountingClerkName Name of Accounting Clerk TEXT30
PaymentTerms Terms of Payment Key Sales Data ZTERM
BusinessPartnerName Name of Customer TEXT80
CityName City TEXT40
PhoneNumber Landline telephone number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
DunningProcedure Dunning Procedure MAHNA
DunningBlock Dunning Block MANSP
AccountGroupName Account Group Name TEXT30
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
GroupBusinessPartnerName1 Name 1 (group) BU_NAME
GroupBusinessPartnerName2 Name 2 (group) BU_NAME
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
StreetName Street TEXT60
PostalCode City postal code CHAR10
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
MobilePhoneNumber Mobile phone number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
SearchTerm1 Search Term 1 CHAR20
SearchTerm2 Search Term 2 CHAR20
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
BusinessPartnerDistrict District TEXT40
HouseNumber House Number TEXT10
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
VATRegistration VAT Registration Number STCEG
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
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
CustomerPaymentTerms Terms of Payment Key Sales Data ZTERM
DunningLevel Dunning Level MAHNS
PhysicalInventoryBlockInd Posting block for company code
CreditMemoPaymentTerms Payment Terms Key for Credit Memos ZTERM
PaymentMethodsList List of Respected Payment Methods ZWELS
HouseBank Short Key for a House Bank HBKID
PaymentBlockingReason Block Key for Payment ZAHLS
DunningNoticeGroup Key for Dunning Notice Grouping MGRUP
AccountByCustomer Our account number at customer CHAR12
UserAtCustomer User at Customer TEXT15
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner CHAR30
AccountingClerkInternetAddress Internet address of partner company clerk TXT130
ReconciliationAccount Reconciliation Account in General Ledger SAKNR
InterestCalculationCode Interest Calculation Indicator
DunningRecipient Account Number of the Dunning Recipient KUNNR
DunningClerk Dunning Clerk BUSAB
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months
BPCustomerNumber Previous Master Record Number CHAR10
UndesirabilityComment Comment on Undesirability TEXT35
Status Object Status CRM_J_STATUS
SystemStatusShortName Status Short Name TEXT4
AddressText Address notes TEXT50
CustomerListKeyField1 Character field, 8 characters long CHAR8
CustomerListKeyField2 Character field, 8 characters long CHAR8
CustomerListKeyField3 Character field, 8 characters long CHAR8
CustomerListKeyField4 Character field, 8 characters long CHAR8
BranchCode Branch Code BCODE
TH_BranchCodeDescription Branch Descriptopn TEXT40
FullName Full Name of Person TEXT80
Master Data Relations Join Conditions
Address Time Zone
  • Client
  • Address Time Zone
  • C_ARCUSTOMER.MANDT == TTZZ.CLIENT
  • C_ARCUSTOMER.ADDRESSTIMEZONE == TTZZ.TZONE
Business Partner Type
  • Business Partner Type
  • Client
  • C_ARCUSTOMER.BUSINESSPARTNERTYPE == TB004.BPKIND
  • C_ARCUSTOMER.MANDT == TB004.CLIENT
Language key C_ARCUSTOMER.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • C_ARCUSTOMER.MANDT == T005.MANDT
  • C_ARCUSTOMER.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • C_ARCUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_ARCUSTOMER.MANDT == T077D.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_ARCUSTOMER.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_ARCUSTOMER.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • C_ARCUSTOMER.DIVISION == TSPA.SPART
  • C_ARCUSTOMER.MANDT == TSPA.MANDT
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • C_ARCUSTOMER.MANDT == TB032.CLIENT
  • C_ARCUSTOMER.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
Legal Form of Organization
  • Legal Form of Organization
  • Client
  • C_ARCUSTOMER.LEGALFORM == TB019.LEGAL_ENTY
  • C_ARCUSTOMER.MANDT == TB019.CLIENT
In-House Contact
  • In-House Contact
  • Client
  • C_ARCUSTOMER.PARTNERFUNCTION == TPAR.PARVW
  • C_ARCUSTOMER.MANDT == TPAR.MANDT
Communication Method C_ARCUSTOMER.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_ARCUSTOMER.MANDT == T005S.MANDT
  • C_ARCUSTOMER.COUNTRY == T005S.LAND1
  • C_ARCUSTOMER.REGION == T005S.BLAND
Tax Type
  • ?
  • Tax Type
  • Client
  • C_ARCUSTOMER.[column in domain "KOART"] == J_1AFITP.KOART
  • C_ARCUSTOMER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • C_ARCUSTOMER.MANDT == J_1AFITP.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_ARCUSTOMER.SALESORGANIZATION == TVKO.VKORG
  • C_ARCUSTOMER.MANDT == TVKO.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_ARCUSTOMER.SUPPLIER == LFA1.LIFNR
  • C_ARCUSTOMER.MANDT == LFA1.MANDT
J_1ATODC
  • Client
  • Tax Number Type
  • C_ARCUSTOMER.MANDT == J_1ATODC.MANDT
  • C_ARCUSTOMER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_ARCUSTOMER.TRADINGPARTNER == T880.RCOMP
  • C_ARCUSTOMER.MANDT == T880.MANDT
Reason for Undesirability
  • Reason for Undesirability
  • Client
  • C_ARCUSTOMER.UNDESIRABILITYREASON == TP18.UNW_REASON
  • C_ARCUSTOMER.MANDT == TP18.MANDT