C_ARUniqueCustomer

Customer List | view: CARUNQCUSTOMER | 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
AccountingClerk Accounting Clerk
PaymentTerms Terms of Payment Key Sales Data
DunningProcedure Dunning Procedure
DunningBlock Dunning Block
DunningLevel Dunning Level
PhysicalInventoryBlockInd Posting block for company code Show values
CreditMemoPaymentTerms Payment Terms Key for Credit Memos
PaymentMethodsList List of Respected Payment Methods
HouseBank House Bank Key
PaymentBlockingReason Payment Block on Item
DunningNoticeGroup Key for Dunning Notice Grouping
AccountByCustomer Our account number at customer
UserAtCustomer User at customer
AccountingClerkPhoneNumber Accounting clerk's telephone number at business partner
AccountingClerkInternetAddress Internet address of partner company clerk
ReconciliationAccount Reconciliation Account in General Ledger
InterestCalculationCode Interest Calculation Indicator
DunningRecipient Account Number of the Dunning Recipient
DunningClerk Dunning Clerk
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
SalesOrganization Sales Organization
DistributionChannel Distribution Channel
Division Division
SalesOffice Sales office
SalesGroup Sales group
CustomerPaymentTerms Terms of Payment Key Sales Data
PartnerCounter null
IBAN IBAN (International Bank Account Number)
CardNumber Payment Cards: Card Number
PaymentCardType Payment Card Type
CustomerListKeyField1 Character field, 8 characters long
CustomerListKeyField2 Character field, 8 characters long
CustomerListKeyField3 Character field, 8 characters long
CustomerListKeyField4 Character field, 8 characters long
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
PhysicalInventoryBlockInd Posting block for company code Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
IsMarkedForArchiving Central Archiving Flag Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
ContactPermission Business Partner: Contact Permission Show values
CustomerIsUnwanted Undesirable Customer Show values
PostingIsBlocked Central posting block Show values
VATLiability Liable for VAT Show values
Column Name Description Domain name
PartnerFunction In-House Contact TEXT100
PersonnelNumber Personnel Number PERNR
PartnerFunctionName Partner Function PARVW
AccountingClerkName Name of Accounting Clerk TEXT30
BPCustomerNumber Previous Master Record Number CHAR10
BusinessPartnerName Name of Customer TEXT80
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
AccountGroupName Account Group Name TEXT30
GroupBusinessPartnerName2 Name 2 (group) BU_NAME
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
UndesirabilityComment Comment on Undesirability TEXT35
CityName City TEXT40
PhoneNumber First telephone no.: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
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 Complete Number: Dialling Code+Number+Extension 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
Status Object Status CRM_J_STATUS
SystemStatusShortName Individual status of an object (short form) TEXT4
AddressText Address notes TEXT50
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_ARUNIQUECUSTOMER.MANDT == TTZZ.CLIENT
  • C_ARUNIQUECUSTOMER.ADDRESSTIMEZONE == TTZZ.TZONE
Business Partner Type
  • Client
  • Business Partner Type
  • C_ARUNIQUECUSTOMER.MANDT == TB004.CLIENT
  • C_ARUNIQUECUSTOMER.BUSINESSPARTNERTYPE == TB004.BPKIND
Language key C_ARUNIQUECUSTOMER.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • C_ARUNIQUECUSTOMER.MANDT == T005.MANDT
  • C_ARUNIQUECUSTOMER.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • C_ARUNIQUECUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_ARUNIQUECUSTOMER.MANDT == T077D.MANDT
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • C_ARUNIQUECUSTOMER.MANDT == TB032.CLIENT
  • C_ARUNIQUECUSTOMER.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
BP: Legal form of organization
  • Client
  • BP: Legal form of organization
  • C_ARUNIQUECUSTOMER.MANDT == TB019.CLIENT
  • C_ARUNIQUECUSTOMER.LEGALFORM == TB019.LEGAL_ENTY
Communication Method C_ARUNIQUECUSTOMER.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • C_ARUNIQUECUSTOMER.MANDT == T005S.MANDT
  • C_ARUNIQUECUSTOMER.REGION == T005S.BLAND
  • C_ARUNIQUECUSTOMER.COUNTRY == T005S.LAND1
Tax Type
  • ?
  • Tax Type
  • Client
  • C_ARUNIQUECUSTOMER.[column in domain "KOART"] == J_1AFITP.KOART
  • C_ARUNIQUECUSTOMER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • C_ARUNIQUECUSTOMER.MANDT == J_1AFITP.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_ARUNIQUECUSTOMER.SUPPLIER == LFA1.LIFNR
  • C_ARUNIQUECUSTOMER.MANDT == LFA1.MANDT
J_1ATODC
  • Tax Number Type
  • Client
  • C_ARUNIQUECUSTOMER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
  • C_ARUNIQUECUSTOMER.MANDT == J_1ATODC.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_ARUNIQUECUSTOMER.MANDT == T880.MANDT
  • C_ARUNIQUECUSTOMER.TRADINGPARTNER == T880.RCOMP
Reason for Undesirability
  • Client
  • Reason for Undesirability
  • C_ARUNIQUECUSTOMER.MANDT == TP18.MANDT
  • C_ARUNIQUECUSTOMER.UNDESIRABILITYREASON == TP18.UNW_REASON