P_ARLineItem_7

Archived debtor line items (before HANA migration) | view: PARLINEITEM7 | Extraction: Not supported | Component: Information System
Tables used: BSAD_BCK
Column Name Description
CompanyCode FK Company Code
Debtor FK Customer Number
SpecialGLTransactionType Special G/L Transaction Type
SpecialGLCode Special G/L Indicator
ClearingDate Clearing Date
ClearingAccountingDocument Document Number of the Clearing Document
AssignmentReference Assignment number
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
AccountingDocumentItem Number of Line Item Within Accounting Document
Column Name Description
AmountInTransactionCurrency null
AmountInCompanyCodeCurrency null
AmountInAdditionalCurrency1 null
AmountInAdditionalCurrency2 null
ValuationDiffAmtInCoCodeCrcy null
ValuationDiffAmtInAddlCrcy1 null
ValuationDiffAmtInAddlCrcy2 null
AmountInBalanceTransacCrcy null
HedgedAmount null
CashDiscountBaseAmount null
CashDiscountAmtInCoCodeCrcy null
CashDiscountAmount null
AmountInPaymentCurrency null
Column Name Description
Column Name Description
ClearingDate Clearing Date
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
CreationDate Day On Which Accounting Document Was Entered
DueCalculationBaseDate Baseline Date for Due Date Calculation
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference date for settlement
Column Name Description
AccountingDocumentCategory Document Status Show values
IsNegativePosting Indicator: Negative Posting Show values
DocumentIsArchived Indicator: Document Already Archived? Show values
DebitCreditCode Debit/Credit Indicator Show values
TreasuryContractType Contract Type Show values
FixedCashDiscount Fixed Payment Terms Show values
IsUsedInPaymentTransaction Indicator: Is Posting Key Used in a Payment Transaction? Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
ClearingIsReversed Indicator: Clearing Was Reversed Show values
HasPaymentOrder Indicator: Items from Payment Program Blocked Show values
Column Name Description Domain name
ClearingDocFiscalYear Fiscal Year of Clearing Document GJAHR
AccountingDocumentType Document Type BLART
FiscalPeriod Fiscal Period POPER
PostingKey Posting Key BSCHL
BusinessArea Business Area GSBER
ProfitCenter Profit Center PRCTR
CostCenter Cost Center KOSTL
GLAccount General Ledger Account SAKNR
Branch Account Number of the Branch MAXKK
DocumentItemText Item Text TEXT50
DocumentReferenceID Reference Document Number XBLNR1
OrderID Order Number AUFNR
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceList Invoice List Number SAMNR
PartnerCompany Company ID of Trading Partner RCOMP
BillingDocument Billing Document VBELN
FollowOnDocumentType Follow-On Document Type REBZT
StateCentralBankPaymentReason State Central Bank Indicator LZBKZ
SupplyingCountry Supplying Country/Region LAND1
AssetContract Contract Number RANL
CashFlowType Flow Type SBEWART
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
Reference1IDByBusinessPartner Business Partner Reference Key CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key CHAR12
Reference3IDByBusinessPartner Reference key for line item CHAR20
RealEstateObject Internal Key for Real Estate Object IMKEY
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ScheduleLine Schedule Line Number ETENR
FundsCenter Funds Center FISTL
BusinessPlace Business Place J_1BBRANCH
TaxCode Tax on sales/purchases code MWSKZ
TaxCountry Tax Reporting Country/Region LAND1
TaxSection Section Code SECCO
PaymentTerms Terms of payment key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
PaymentMethod Payment Method ZLSCH
PaymentBlockingReason Payment Block Key ZAHLS
DunningBlockingReason Dunning Block MANSP
DunningKey Dunning Key MSCHL
DunningLevel Dunning Level MAHNS
DunningArea Dunning Area MABER
PaymentDifferenceReason Reason Code for Payments RSTGR
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment cards: Settlement run CCBTC
ReceivableAlternativePayer Payee/Payer MAXKK
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction key 3 DTWSX
DataExchangeInstruction4 Instruction key 4 DTWSX
PaymentReference Payment Reference CHAR30
BPBankAccountInternalID Partner bank type BVTYP
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
AccountingDocumentItemType Identification of the Line Item CHAR1
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
Master Data Relations Join Conditions
Accounts Receivable Pledging Indicator
  • Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • P_ARLINEITEM_7.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
  • P_ARLINEITEM_7.MANDT == TCESSION.CLIENT
  • P_ARLINEITEM_7.COMPANYCODE == TCESSION.COMPANY
Update Currency for General Ledger Transaction Figures
  • Client
  • Update Currency for General Ledger Transaction Figures
  • P_ARLINEITEM_7.MANDT == TCURC.MANDT
  • P_ARLINEITEM_7.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • Customer Number
  • P_ARLINEITEM_7.MANDT == KNB1.MANDT
  • P_ARLINEITEM_7.COMPANYCODE == KNB1.BUKRS
  • P_ARLINEITEM_7.DEBTOR == KNB1.KUNNR
Credit control area
  • Client
  • Credit control area
  • P_ARLINEITEM_7.MANDT == T014.MANDT
  • P_ARLINEITEM_7.CREDITCONTROLAREA == T014.KKBER
Customer Number
  • Client
  • Customer Number
  • P_ARLINEITEM_7.MANDT == KNA1.MANDT
  • P_ARLINEITEM_7.DEBTOR == KNA1.KUNNR
Payment method supplement
  • Client
  • Payment method supplement
  • P_ARLINEITEM_7.MANDT == T042F.MANDT
  • P_ARLINEITEM_7.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE