P_ARCustomerUnion

AR Customer Union | view: PARCUSTOMERUN | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: KNA1KNB1KNB5KNVVTVKO
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
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
PhysicalInventoryBlockInd Posting block for company code Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
Column Name Description Domain name
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
AddressID Address ADRNR
CustomerPaymentTerms Terms of payment key ZTERM
PaymentTerms Terms of payment key ZTERM
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
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • P_ARCUSTOMERUNION.MANDT == T001S.MANDT
  • P_ARCUSTOMERUNION.COMPANYCODE == T001S.BUKRS
  • P_ARCUSTOMERUNION.ACCOUNTINGCLERK == T001S.BUSAB
Company Code
  • Client
  • Company Code
  • P_ARCUSTOMERUNION.MANDT == T001.MANDT
  • P_ARCUSTOMERUNION.COMPANYCODE == T001.BUKRS
Customer Account Group
  • Client
  • Customer Account Group
  • P_ARCUSTOMERUNION.MANDT == T077D.MANDT
  • P_ARCUSTOMERUNION.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Distribution Channel
  • Client
  • Distribution Channel
  • P_ARCUSTOMERUNION.MANDT == TVTW.MANDT
  • P_ARCUSTOMERUNION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_ARCUSTOMERUNION.MANDT == TSPA.MANDT
  • P_ARCUSTOMERUNION.DIVISION == TSPA.SPART
Key for Dunning Notice Grouping
  • Client
  • Key for Dunning Notice Grouping
  • P_ARCUSTOMERUNION.MANDT == T047R.MANDT
  • P_ARCUSTOMERUNION.DUNNINGNOTICEGROUP == T047R.MGRUP
Short Key for a House Bank
  • Client
  • ?
  • Short Key for a House Bank
  • P_ARCUSTOMERUNION.MANDT == T012.MANDT
  • P_ARCUSTOMERUNION.[column in domain "BUKRS"] == T012.BUKRS
  • P_ARCUSTOMERUNION.HOUSEBANK == T012.HBKID
Interest Indicator
  • Client
  • Interest Indicator
  • P_ARCUSTOMERUNION.MANDT == T056.MANDT
  • P_ARCUSTOMERUNION.INTERESTCALCULATIONCODE == T056.VZSKZ
Block Key for Payment
  • Client
  • Block Key for Payment
  • P_ARCUSTOMERUNION.MANDT == T008.MANDT
  • P_ARCUSTOMERUNION.PAYMENTBLOCKINGREASON == T008.ZAHLS
Reconciliation Account in General Ledger
  • Client
  • Company Code
  • Reconciliation Account in General Ledger
  • P_ARCUSTOMERUNION.MANDT == SKB1.MANDT
  • P_ARCUSTOMERUNION.COMPANYCODE == SKB1.BUKRS
  • P_ARCUSTOMERUNION.RECONCILIATIONACCOUNT == SKB1.SAKNR
Tax Type
  • Tax type
  • Client
  • ?
  • P_ARCUSTOMERUNION.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • P_ARCUSTOMERUNION.MANDT == J_1AFITP.MANDT
  • P_ARCUSTOMERUNION.[column in domain "KOART"] == J_1AFITP.KOART
Sales group
  • Client
  • Sales office
  • Sales group
  • P_ARCUSTOMERUNION.MANDT == TVBVK.MANDT
  • P_ARCUSTOMERUNION.SALESOFFICE == TVBVK.VKBUR
  • P_ARCUSTOMERUNION.SALESGROUP == TVBVK.VKGRP
Sales office
  • Client
  • Sales office
  • P_ARCUSTOMERUNION.MANDT == TVBUR.MANDT
  • P_ARCUSTOMERUNION.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • P_ARCUSTOMERUNION.MANDT == TVKO.MANDT
  • P_ARCUSTOMERUNION.SALESORGANIZATION == TVKO.VKORG
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_ARCUSTOMERUNION.MANDT == LFA1.MANDT
  • P_ARCUSTOMERUNION.SUPPLIER == LFA1.LIFNR
J_1ATODC
  • Client
  • Tax Number Type
  • P_ARCUSTOMERUNION.MANDT == J_1ATODC.MANDT
  • P_ARCUSTOMERUNION.TAXNUMBERTYPE == J_1ATODC.J_1ATODC