C_PT_DocItemWhldgTxCshDiscC

Cube for Portugal annual list | view: CPTWTCDCUBE | TRAN | Extraction: Not supported | Component: Financials Portugal
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
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):
WithholdingTaxAmount Signed Withholding Tax Amount (in Document Currency)
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
AmountInReportingCurrency Amount in Reporting 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 null
VATRegistrationCountry null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_PT_DOCITEMWHLDGTXCSHDISCC.MANDT == T003.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • C_PT_DOCITEMWHLDGTXCSHDISCC.MANDT == T001.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCC.COMPANYCODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • C_PT_DOCITEMWHLDGTXCSHDISCC.MANDT == KNA1.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCC.CUSTOMER == KNA1.KUNNR
Reporting Entity
  • Client
  • Reporting Entity
  • C_PT_DOCITEMWHLDGTXCSHDISCC.MANDT == SRF_RPG_ENT.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_PT_DOCITEMWHLDGTXCSHDISCC.MANDT == LFA1.MANDT
  • C_PT_DOCITEMWHLDGTXCSHDISCC.SUPPLIER == LFA1.LIFNR