P_APLineItemMixedAccount

Supplier Accounts belonging to mixed accounts | view: PAPITEMMIXEDACCT | Extraction: Not supported | Component: Information System
Tables used: ADCP, ADRC, T001, TKA02, LFA1, LFB1, LFA1
Column Name Description
Creditor FK Account Number of Supplier
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
InterestCalculationDate Key Date of Last Interest Calculation
Column Name Description
AccountIsBlockedForPosting Central posting block Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
ItemIsToBePaidSeparately Indicator: Pay All Items Separately? Show values
PaymentIsToBeSentByEDI Indicator: Send Payment Advices by EDI Show values
AlternativePayeeIsAllowed Indicator: Alternative Payee in Document Allowed? Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
CreatedByUser Name of Person who Created the Object USNAM
SupplierCorporateGroup 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
VATRegistration VAT Registration Number STCEG
CityName City TEXT40
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
PostalCode City postal code CHAR10
SupplierAccountNote Memo TEXT30
SupplierFinsAuthorizationGrp Authorization Group BRGRU
SupplierBasicAuthorizationGrp Authorization Group BRGRU
SortField Sort field CHAR10
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Accounting Clerk Abbreviation
  • Client
  • P_APLINEITEMMIXEDACCOUNT.COMPANYCODE == T001S.BUKRS
  • P_APLINEITEMMIXEDACCOUNT.ACCOUNTINGCLERK == T001S.BUSAB
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T001S.MANDT
Account number of the alternative payee
  • Account number of the alternative payee
  • Client
  • P_APLINEITEMMIXEDACCOUNT.ALTERNATIVEPAYEE == LFA1.LIFNR
  • P_APLINEITEMMIXEDACCOUNT.MANDT == LFA1.MANDT
Tolerance Group for Business Partner/G/L Account
  • Company Code
  • Tolerance Group for Business Partner/G/L Account
  • Client
  • P_APLINEITEMMIXEDACCOUNT.COMPANYCODE == T043G.BUKRS
  • P_APLINEITEMMIXEDACCOUNT.APARTOLERANCEGROUP == T043G.TOGRU
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T043G.MANDT
Company Code
  • Company Code
  • Client
  • P_APLINEITEMMIXEDACCOUNT.COMPANYCODE == T001.BUKRS
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T005.MANDT
  • P_APLINEITEMMIXEDACCOUNT.COUNTRY == T005.LAND1
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_APLINEITEMMIXEDACCOUNT.MANDT == LFA1.MANDT
  • P_APLINEITEMMIXEDACCOUNT.CREDITOR == LFA1.LIFNR
Customer Number
  • Customer Number
  • Client
  • P_APLINEITEMMIXEDACCOUNT.DEBTOR == KNA1.KUNNR
  • P_APLINEITEMMIXEDACCOUNT.MANDT == KNA1.MANDT
Industry key
  • Industry key
  • Client
  • P_APLINEITEMMIXEDACCOUNT.INDUSTRY == T016.BRSCH
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T016.MANDT
Interest Indicator
  • Client
  • Interest Indicator
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T056.MANDT
  • P_APLINEITEMMIXEDACCOUNT.INTERESTCALCULATIONCODE == T056.VZSKZ
Block Key for Payment
  • Client
  • Block Key for Payment
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T008.MANDT
  • P_APLINEITEMMIXEDACCOUNT.PAYMENTBLOCKINGREASON == T008.ZAHLS
Reconciliation Account in General Ledger
  • Company Code
  • Reconciliation Account in General Ledger
  • Client
  • P_APLINEITEMMIXEDACCOUNT.COMPANYCODE == SKB1.BUKRS
  • P_APLINEITEMMIXEDACCOUNT.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_APLINEITEMMIXEDACCOUNT.MANDT == SKB1.MANDT
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T005S.MANDT
  • P_APLINEITEMMIXEDACCOUNT.REGION == T005S.BLAND
  • P_APLINEITEMMIXEDACCOUNT.COUNTRY == T005S.LAND1
Vendor account group
  • Vendor account group
  • Client
  • P_APLINEITEMMIXEDACCOUNT.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • P_APLINEITEMMIXEDACCOUNT.MANDT == T077K.MANDT
Head office account number
  • Head office account number
  • Client
  • P_APLINEITEMMIXEDACCOUNT.SUPPLIERHEADOFFICE == LFA1.LIFNR
  • P_APLINEITEMMIXEDACCOUNT.MANDT == LFA1.MANDT
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • P_APLINEITEMMIXEDACCOUNT.TAXJURISDICTION == TTXJ.TXJCD
  • P_APLINEITEMMIXEDACCOUNT.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_APLINEITEMMIXEDACCOUNT.MANDT == TTXJ.MANDT