P_ARCustomer

Customer Company Aggregated | view: PARCUSTOMER | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: ADCP, ADRC, ADR6, ADR2, BUT000, KNA1, T077X, KNB1, KNB5, KNVV, CVI_CUST_LINK, TVKO, FITHA_PBUPL_D, FITHA_PBUPL_D_T
Column Name Description
Customer Customer Number
CompanyCode FK Company Code
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
CustomerIsWithCompanyCode null
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
Column Name Description
PostingIsBlocked Central posting block Show values
VATLiability Liable for VAT Show values
IsMarkedForArchiving Central Archiving Flag Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
ContactPermission Business Partner: Contact Permission Show values
PhysicalInventoryBlockInd Posting block for company code Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
Column Name Description Domain name
AccountGroupName Account Group Name TEXT30
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
CustomerPaymentTerms Terms of payment key ZTERM
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
BusinessPartnerName null
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
AddressID Address Number AD_ADDRNUM
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
District District TEXT40
HouseNumber House Number TEXT10
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
PaymentTerms Terms of payment key ZTERM
DunningLevel Dunning Level MAHNS
CreditMemoPaymentTerms Payment Terms Key for Credit Memos ZTERM
PaymentMethodsList List of Respected Payment Methods ZWELS
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
CustPreviousMasterRecordNumber Previous Master Record Number CHAR10
BranchCode Branch Code BCODE
TH_BranchCodeDescription Branch Descriptopn TEXT40
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • Dunning Clerk
  • P_ARCUSTOMER.MANDT == T001S.MANDT
  • P_ARCUSTOMER.COMPANYCODE == T001S.BUKRS
  • P_ARCUSTOMER.ACCOUNTINGCLERK == T001S.BUSAB
  • P_ARCUSTOMER.DUNNINGCLERK == T001S.BUSAB
Address time zone
  • Client
  • Address time zone
  • P_ARCUSTOMER.MANDT == TTZZ.CLIENT
  • P_ARCUSTOMER.ADDRESSTIMEZONE == TTZZ.TZONE
Business Partner Type
  • Business Partner Type
  • Client
  • P_ARCUSTOMER.BUSINESSPARTNERTYPE == TB004.BPKIND
  • P_ARCUSTOMER.MANDT == TB004.CLIENT
Company Code
  • Client
  • Company Code
  • P_ARCUSTOMER.MANDT == T001.MANDT
  • P_ARCUSTOMER.COMPANYCODE == T001.BUKRS
Language key P_ARCUSTOMER.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • P_ARCUSTOMER.MANDT == T005.MANDT
  • P_ARCUSTOMER.COUNTRY == T005.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • P_ARCUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_ARCUSTOMER.MANDT == T077D.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_ARCUSTOMER.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_ARCUSTOMER.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • P_ARCUSTOMER.MANDT == TSPA.MANDT
  • P_ARCUSTOMER.DIVISION == TSPA.SPART
Dunning Block
  • Client
  • Dunning Block
  • P_ARCUSTOMER.MANDT == T040S.MANDT
  • P_ARCUSTOMER.DUNNINGBLOCK == T040S.MANSP
Dunning Clerk
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • Dunning Clerk
  • P_ARCUSTOMER.MANDT == T001S.MANDT
  • P_ARCUSTOMER.COMPANYCODE == T001S.BUKRS
  • P_ARCUSTOMER.ACCOUNTINGCLERK == T001S.BUSAB
  • P_ARCUSTOMER.DUNNINGCLERK == T001S.BUSAB
Key for Dunning Notice Grouping
  • Client
  • Key for Dunning Notice Grouping
  • P_ARCUSTOMER.MANDT == T047R.MANDT
  • P_ARCUSTOMER.DUNNINGNOTICEGROUP == T047R.MGRUP
Dunning Procedure
  • Client
  • Dunning Procedure
  • P_ARCUSTOMER.MANDT == T047A.MANDT
  • P_ARCUSTOMER.DUNNINGPROCEDURE == T047A.MAHNA
Account Number of the Dunning Recipient
  • Client
  • Account Number of the Dunning Recipient
  • P_ARCUSTOMER.MANDT == KNA1.MANDT
  • P_ARCUSTOMER.DUNNINGRECIPIENT == KNA1.KUNNR
Short Key for a House Bank
  • ?
  • Client
  • Short Key for a House Bank
  • P_ARCUSTOMER.[column in domain "BUKRS"] == T012.BUKRS
  • P_ARCUSTOMER.MANDT == T012.MANDT
  • P_ARCUSTOMER.HOUSEBANK == T012.HBKID
Interest Indicator
  • Interest Indicator
  • Client
  • P_ARCUSTOMER.INTERESTCALCULATIONCODE == T056.VZSKZ
  • P_ARCUSTOMER.MANDT == T056.MANDT
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • P_ARCUSTOMER.MANDT == TB032.CLIENT
  • P_ARCUSTOMER.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • P_ARCUSTOMER.LEGALFORM == TB019.LEGAL_ENTY
  • P_ARCUSTOMER.MANDT == TB019.CLIENT
Block Key for Payment
  • Block Key for Payment
  • Client
  • P_ARCUSTOMER.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • P_ARCUSTOMER.MANDT == T008.MANDT
Communication Method P_ARCUSTOMER.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Client
  • Company Code
  • P_ARCUSTOMER.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_ARCUSTOMER.MANDT == SKB1.MANDT
  • P_ARCUSTOMER.COMPANYCODE == SKB1.BUKRS
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • P_ARCUSTOMER.MANDT == T005S.MANDT
  • P_ARCUSTOMER.COUNTRY == T005S.LAND1
  • P_ARCUSTOMER.REGION == T005S.BLAND
Tax Type
  • Client
  • ?
  • Tax Type
  • P_ARCUSTOMER.MANDT == J_1AFITP.MANDT
  • P_ARCUSTOMER.[column in domain "KOART"] == J_1AFITP.KOART
  • P_ARCUSTOMER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
Sales group
  • Sales office
  • Client
  • Sales group
  • P_ARCUSTOMER.SALESOFFICE == TVBVK.VKBUR
  • P_ARCUSTOMER.MANDT == TVBVK.MANDT
  • P_ARCUSTOMER.SALESGROUP == TVBVK.VKGRP
Sales office
  • Sales office
  • Client
  • P_ARCUSTOMER.SALESOFFICE == TVBUR.VKBUR
  • P_ARCUSTOMER.MANDT == TVBUR.MANDT
Sales Organization
  • Client
  • Sales Organization
  • P_ARCUSTOMER.MANDT == TVKO.MANDT
  • P_ARCUSTOMER.SALESORGANIZATION == TVKO.VKORG
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_ARCUSTOMER.SUPPLIER == LFA1.LIFNR
  • P_ARCUSTOMER.MANDT == LFA1.MANDT
J_1ATODC
  • Tax Number Type
  • Client
  • P_ARCUSTOMER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
  • P_ARCUSTOMER.MANDT == J_1ATODC.MANDT