C_CN_PaytRequisitionLineItem

Query Invoice/Down payment request | view: CCNPAYTREQNLINEI | Extraction: Not supported | Component: Cash Management China
Tables used: PAYREQN_REQNPAYREQN_REQNITMBKPFBSEGT001TKA02LFBKLFA1ADCPADR2ADR3ADR6ADRPUSR21PRPST014
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
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
NetDueStatus null
ClearingStatus null
ItemType null
SupplierName Name of Supplier TEXT80
SupplierIsOneTimeAccount Indicator: Is the Account a One-Time Account
SupplierBankType Business Partner Bank Account Internal ID
HouseBank Bank Keys
HouseBankAccount Bank account number
NetDueArrearsDays null
PaymentIsBlockedForSupplier Payment Block
CostCenter Cost Center KOSTL
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
CashDiscount1Percent Cash Discount Percentage 1
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2
CashDiscount2Days Cash Discount Days 2 ZBDXT
WBSElementInternalID WBS Element Internal ID
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited
ProfitCenter Profit Center PRCTR
BranchCode Branch Code BCODE
DocumentItemText Item Text TEXT50
AssignmentReference Assignment Reference
AccountingDocCreatedByUser User that created the journal entry
CreatedByUserFullName Full Name of Person TEXT80
OriginalReferenceDocument Object key AWKEY
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_CN_PAYTREQUISITIONLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_CN_PAYTREQUISITIONLINEITEM.COMPANYCODE == T001.BUKRS
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == TKA01.MANDT
  • C_CN_PAYTREQUISITIONLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
Payment Blocking Reason
  • Payment Blocking Reason
  • Client
  • C_CN_PAYTREQUISITIONLINEITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == T008.MANDT
Payment Method
  • Payment Method
  • Client
  • ?
  • C_CN_PAYTREQUISITIONLINEITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == T042Z.MANDT
  • C_CN_PAYTREQUISITIONLINEITEM.[column in domain "LAND1"] == T042Z.LAND1
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • ?
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == T074U.MANDT
  • C_CN_PAYTREQUISITIONLINEITEM.SPECIALGLCODE == T074U.UMSKZ
  • C_CN_PAYTREQUISITIONLINEITEM.[column in domain "KOART"] == T074U.KOART
Supplier
  • Supplier
  • Client
  • C_CN_PAYTREQUISITIONLINEITEM.SUPPLIER == LFA1.LIFNR
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_CN_PAYTREQUISITIONLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_CN_PAYTREQUISITIONLINEITEM.MANDT == TCURC.MANDT