C_PT_DocItemWhldgTxCshDiscQ

Query for Portugal Annual List | view: CPTWTCDQUERY | Extraction: Not supported | Component: Financials Portugal
Column Name Description
AccountingDocument Journal Entry
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInReportingCurrency Amount in Reporting Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
WithholdingTaxAmount Signed Withholding Tax Amount (in Document Currency)
CashDiscountAmount Signed Cash Discount Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
IsSalesRelated Is Sales Related Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
ReportingVATRegistration VAT Registration Number STCEG
VATRegistrationCountry null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.MANDT == T001.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Client
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.CUSTOMER == KNA1.KUNNR
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.MANDT == KNA1.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.MANDT == SRF_RPG_ENT.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.SUPPLIER == LFA1.LIFNR
  • C_PT_DOCITEMWHLDGTXCSHDISCQ.MANDT == LFA1.MANDT