I_PaytRequisitionLineItem

Query Invoice/Down payment request | view: IPAYTREQNLINEITM | Extraction: Not supported | Component: Cash Management China
Tables used: PAYREQN_REQNPAYREQN_REQNITMBKPFBSEGT001TKA02LFA1PRPST001T014
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
PaidAmountInPaytCurrency null
PaymentRequestAmountInPaytCrcy null
RemainingOpenAmtInDspCrcy null
Column Name Description
Column Name Description
NetDueDate Due Date for Net Payment
DocumentDate Journal Entry Date
PostingDate Posting Date
CashDiscount1DueDate Due Date for Cash Discount 1
DueCalculationBaseDate Due Calculation Base Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
SupplierIsOneTimeAccount Indicator: Is the Account a One-Time Account Show values
PaymentIsBlockedForSupplier Payment Block Show values
Column Name Description Domain name
NetDueStatus null
ItemType null
SupplierBankType Business Partner Bank Account Internal ID BVTYP
NetDueArrearsDays null
ClearingStatus null
CostCenter Cost Center KOSTL
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
CashDiscount2Days Cash Discount Days 2 ZBDXT
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
ProfitCenter Profit Center PRCTR
BranchCode Branch Code BCODE
DocumentItemText Item Text TEXT50
AssignmentReference Assignment Reference ZUONR
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
SupplierName Name of Supplier TEXT80
AccountingDocCreatedByUser User that created the journal entry
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_PAYTREQUISITIONLINEITEM.MANDT == T001.MANDT
  • I_PAYTREQUISITIONLINEITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_PAYTREQUISITIONLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_PAYTREQUISITIONLINEITEM.MANDT == TKA01.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_PAYTREQUISITIONLINEITEM.MANDT == T005.MANDT
  • I_PAYTREQUISITIONLINEITEM.COUNTRY == T005.LAND1
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • I_PAYTREQUISITIONLINEITEM.MANDT == T008.MANDT
  • I_PAYTREQUISITIONLINEITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Method
  • Client
  • Payment Method
  • Country/Region Key
  • I_PAYTREQUISITIONLINEITEM.MANDT == T042Z.MANDT
  • I_PAYTREQUISITIONLINEITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • I_PAYTREQUISITIONLINEITEM.COUNTRY == T042Z.LAND1
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • I_PAYTREQUISITIONLINEITEM.[column in domain "KOART"] == T074U.KOART
  • I_PAYTREQUISITIONLINEITEM.MANDT == T074U.MANDT
  • I_PAYTREQUISITIONLINEITEM.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Client
  • Supplier
  • I_PAYTREQUISITIONLINEITEM.MANDT == LFA1.MANDT
  • I_PAYTREQUISITIONLINEITEM.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • I_PAYTREQUISITIONLINEITEM.MANDT == TCURC.MANDT
  • I_PAYTREQUISITIONLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS