C_StRpOverdueInvoicesQuery

Overdue Invoices Qry for Stat. Reporting | view: CSROVRDUEINVQ | Extraction: Not supported | Component: Financials Poland
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DueCalculationBaseDate Due Calculation Base Date
NetDueDate Due Date for Net Payment
ClearingDate Clearing Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
DocumentReferenceID Document Reference ID XBLNR1
CustomerName Name of Customer TEXT80
SupplierName Name of Supplier TEXT80
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
DocumentItemText Item Text TEXT50
IsCleared null
NetDueArrearsDays null
NetDueDays null
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_STRPOVERDUEINVOICESQUERY.MANDT == T003.MANDT
  • C_STRPOVERDUEINVOICESQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • C_STRPOVERDUEINVOICESQUERY.MANDT == T001.MANDT
  • C_STRPOVERDUEINVOICESQUERY.COMPANYCODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • C_STRPOVERDUEINVOICESQUERY.MANDT == KNA1.MANDT
  • C_STRPOVERDUEINVOICESQUERY.CUSTOMER == KNA1.KUNNR
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_STRPOVERDUEINVOICESQUERY.MANDT == SKB1.MANDT
  • C_STRPOVERDUEINVOICESQUERY.GLACCOUNT == SKB1.SAKNR
  • C_STRPOVERDUEINVOICESQUERY.COMPANYCODE == SKB1.BUKRS
Reporting Entity
  • Client
  • Reporting Entity
  • C_STRPOVERDUEINVOICESQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_STRPOVERDUEINVOICESQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_STRPOVERDUEINVOICESQUERY.MANDT == LFA1.MANDT
  • C_STRPOVERDUEINVOICESQUERY.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • C_STRPOVERDUEINVOICESQUERY.MANDT == T007A.MANDT
  • C_STRPOVERDUEINVOICESQUERY.[column in domain "KALSM_D"] == T007A.KALSM
  • C_STRPOVERDUEINVOICESQUERY.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Transaction Currency
  • Client
  • C_STRPOVERDUEINVOICESQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_STRPOVERDUEINVOICESQUERY.MANDT == TCURC.MANDT