C_StRpOverdueInvoicesCube

Overdue Invoices Cube for Stat.Reporting | view: CSROVRDUEINVC | TRAN | Extraction: Not supported | Component: Financials Poland
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
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
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
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_STRPOVERDUEINVOICESCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_STRPOVERDUEINVOICESCUBE.MANDT == T003.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_STRPOVERDUEINVOICESCUBE.MANDT == T004.MANDT
  • C_STRPOVERDUEINVOICESCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_STRPOVERDUEINVOICESCUBE.COMPANYCODE == T001.BUKRS
  • C_STRPOVERDUEINVOICESCUBE.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • C_STRPOVERDUEINVOICESCUBE.CUSTOMER == KNA1.KUNNR
  • C_STRPOVERDUEINVOICESCUBE.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_STRPOVERDUEINVOICESCUBE.COMPANYCODE == SKB1.BUKRS
  • C_STRPOVERDUEINVOICESCUBE.MANDT == SKB1.MANDT
  • C_STRPOVERDUEINVOICESCUBE.GLACCOUNT == SKB1.SAKNR
Reporting Entity
  • Client
  • Reporting Entity
  • C_STRPOVERDUEINVOICESCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_STRPOVERDUEINVOICESCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_STRPOVERDUEINVOICESCUBE.MANDT == LFA1.MANDT
  • C_STRPOVERDUEINVOICESCUBE.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • C_STRPOVERDUEINVOICESCUBE.TAXCODE == T007A.MWSKZ
  • C_STRPOVERDUEINVOICESCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • C_STRPOVERDUEINVOICESCUBE.MANDT == T007A.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_STRPOVERDUEINVOICESCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_STRPOVERDUEINVOICESCUBE.MANDT == TCURC.MANDT