P_ARLineItemForCorrespondence

AR line items for correspondence | view: PARLIITFORCOR | Extraction: Not supported | Component: Financial Accounting
Tables used: VBKPFVBKPFVBSEGKVBKPFVBSEGDBKPFBSEGKNA1T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
Column Name Description
Column Name Description
KeyDate Open on Key Date
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
ClearingDate Clearing Date
NetDueDate Due Date for Net Payment
DueCalculationBaseDate Due Calculation Base Date
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
DocumentReferenceID Document Reference ID XBLNR1
DueItemType null
BranchAccount Branch Account MAXKK
FiscalPeriod Fiscal Period POPER
ClearingAccountingDocument Clearing Journal Entry BELNR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
ItemTypeBranch 30 Characters CHAR30
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
BillingDocument Billing Document VBELN
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
PaymentReference Payment Reference CHAR30
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Original Reference Document AWKEY
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == T003.MANDT
  • P_ARLINEITEMFORCORRESPONDENCE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_ARLINEITEMFORCORRESPONDENCE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == TCURC.MANDT
Company Code
  • Client
  • Company Code
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == T001.MANDT
  • P_ARLINEITEMFORCORRESPONDENCE.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • P_ARLINEITEMFORCORRESPONDENCE.CUSTOMER == KNA1.KUNNR
  • P_ARLINEITEMFORCORRESPONDENCE.CUSTOMERSUPPLIERACCOUNT == KNA1.KUNNR
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == KNA1.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • P_ARLINEITEMFORCORRESPONDENCE.CUSTOMER == KNA1.KUNNR
  • P_ARLINEITEMFORCORRESPONDENCE.CUSTOMERSUPPLIERACCOUNT == KNA1.KUNNR
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == KNA1.MANDT
Posting Key
  • Client
  • Posting Key
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == TBSL.MANDT
  • P_ARLINEITEMFORCORRESPONDENCE.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • P_ARLINEITEMFORCORRESPONDENCE.[column in domain "KOART"] == T074U.KOART
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == T074U.MANDT
  • P_ARLINEITEMFORCORRESPONDENCE.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Client
  • Supplier
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == LFA1.MANDT
  • P_ARLINEITEMFORCORRESPONDENCE.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • P_ARLINEITEMFORCORRESPONDENCE.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARLINEITEMFORCORRESPONDENCE.MANDT == TCURC.MANDT