P_PAYREQNSUPLRCUSTLINEITEM

Suplr and Cust invoice for requisition | view: PREQNSUPLRINVC | Extraction: Not supported | Component: Cash Management China
Tables used: BSEGT003TLFA1T001T014
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Transaction Currency (Currency):
AmountInTransactionCurrency Amount in Transaction Currency
PaidAmountInPaytCurrency null
Column Name Description
Column Name Description
NetDueDate Due Date for Net Payment
Column Name Description
DebitCreditCode Debit/Credit Code Show values
ClearingIsReversed Clearing Is Reversed Show values
Column Name Description Domain name
AccountingDocumentTypeName Document Type Name TEXT20
ClearingAccountingDocument Clearing Journal Entry BELNR
Supplier Supplier LIFNR
ItemType null
SupplierBankType Business Partner Bank Account Internal ID BVTYP
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == T003.MANDT
  • P_PAYREQNSUPLRCUSTLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == T001.MANDT
  • P_PAYREQNSUPLRCUSTLINEITEM.COMPANYCODE == T001.BUKRS
Transaction Currency
  • Transaction Currency
  • Client
  • P_PAYREQNSUPLRCUSTLINEITEM.CURRENCY == TCURC.WAERS
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == TCURC.MANDT
House Bank Key
  • House Bank Key
  • Client
  • ?
  • P_PAYREQNSUPLRCUSTLINEITEM.HOUSEBANK == T012.HBKID
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == T012.MANDT
  • P_PAYREQNSUPLRCUSTLINEITEM.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • Client
  • ?
  • House Bank Account
  • P_PAYREQNSUPLRCUSTLINEITEM.HOUSEBANK == T012K.HBKID
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == T012K.MANDT
  • P_PAYREQNSUPLRCUSTLINEITEM.[column in domain "BUKRS"] == T012K.BUKRS
  • P_PAYREQNSUPLRCUSTLINEITEM.HOUSEBANKACCOUNT == T012K.HKTID
Payment Method
  • Client
  • ?
  • Payment Method
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == T042Z.MANDT
  • P_PAYREQNSUPLRCUSTLINEITEM.[column in domain "LAND1"] == T042Z.LAND1
  • P_PAYREQNSUPLRCUSTLINEITEM.PAYMENTMETHOD == T042Z.ZLSCH
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • P_PAYREQNSUPLRCUSTLINEITEM.[column in domain "KOART"] == T074U.KOART
  • P_PAYREQNSUPLRCUSTLINEITEM.MANDT == T074U.MANDT
  • P_PAYREQNSUPLRCUSTLINEITEM.SPECIALGLCODE == T074U.UMSKZ