P_ARLineItemMixedAccount

Customer Accounts belonging to mixed accounts | view: PARITEMMIXEDACCT | Extraction: Not supported | Component: Information System
Tables used: ADCP, ADRC, KNA1, KNB1, KNB5
Column Name Description
Customer FK Customer Number
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
InterestCalculationDate Key Date of Last Interest Calculation
CreationDate Date on which the Record Was Created
Column Name Description
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
ItemIsToBePaidSeparately Indicator: Pay All Items Separately? Show values
PaytAdviceIsSentbyEDI Indicator: Send Payment Advices by EDI Show values
PostingIsBlocked Central posting block Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
AlternativePayerIsAllowed Indicator: Is an alternative payer allowed in document? Show values
Column Name Description Domain name
CustomerAccountNote Memo TEXT30
CustomerFinsAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
CustomerName Name of Customer TEXT80
CreatedByUser Name of Person who Created the Object USNAM
VATRegistration VAT Registration Number STCEG
CustomerCorporateGroup Group key KONZS
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
SortField Sort field CHAR10
CityName City TEXT40
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
PostalCode City postal code CHAR10
County County TEXT40
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Accounting Clerk Abbreviation
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.COMPANYCODE == T001S.BUKRS
  • P_ARLINEITEMMIXEDACCOUNT.ACCOUNTINGCLERK == T001S.BUSAB
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T001S.MANDT
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == KNA1.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Tolerance Group for Business Partner/G/L Account
  • Tolerance Group for Business Partner/G/L Account
  • Company Code
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.APARTOLERANCEGROUP == T043G.TOGRU
  • P_ARLINEITEMMIXEDACCOUNT.COMPANYCODE == T043G.BUKRS
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T043G.MANDT
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • P_ARLINEITEMMIXEDACCOUNT.CITYCODE == ADRCITY.CITY_CODE
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == ADRCITY.CLIENT
  • P_ARLINEITEMMIXEDACCOUNT.COUNTRY == ADRCITY.COUNTRY
Company Code
  • Company Code
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.COMPANYCODE == T001.BUKRS
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T005.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == KNA1.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.CUSTOMER == KNA1.KUNNR
Customer Account Group
  • Client
  • Customer Account Group
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T077D.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == KNA1.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.CUSTOMERHEADOFFICE == KNA1.KUNNR
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.DELIVERYISBLOCKED == TVLS.LIFSP
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == TVLS.MANDT
Industry key
  • Industry key
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.INDUSTRY == T016.BRSCH
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T016.MANDT
Interest Indicator
  • Interest Indicator
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.INTERESTCALCULATIONCODE == T056.VZSKZ
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T056.MANDT
Block Key for Payment
  • Block Key for Payment
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T008.MANDT
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Company Code
  • Client
  • P_ARLINEITEMMIXEDACCOUNT.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_ARLINEITEMMIXEDACCOUNT.COMPANYCODE == SKB1.BUKRS
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == SKB1.MANDT
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == T005S.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.COUNTRY == T005S.LAND1
  • P_ARLINEITEMMIXEDACCOUNT.REGION == T005S.BLAND
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == LFA1.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.SUPPLIER == LFA1.LIFNR
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • P_ARLINEITEMMIXEDACCOUNT.MANDT == TTXJ.MANDT
  • P_ARLINEITEMMIXEDACCOUNT.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_ARLINEITEMMIXEDACCOUNT.TAXJURISDICTION == TTXJ.TXJCD