P_PT_DocItemWhldgTxCshDisc

Cash Discount and WithHolding Tax items union | view: PTDOCITEMWTCD | Extraction: Not supported | Component: Financials Portugal
Tables used: BKPFBSEGKNA1LFA1T001T014
Column Name Description
AccountingDocument Journal Entry
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
WithholdingTaxAmount Signed Withholding Tax Amount (in Document Currency)
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
CashDiscountAmount Signed Cash Discount Amount in Document Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
AmountInReportingCurrency Amount in Reporting 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 STCEG
VATRegistrationCountry null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_PT_DOCITEMWHLDGTXCSHDISC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == T003.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == TCURC.MANDT
  • P_PT_DOCITEMWHLDGTXCSHDISC.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == T001.MANDT
  • P_PT_DOCITEMWHLDGTXCSHDISC.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Client
  • P_PT_DOCITEMWHLDGTXCSHDISC.CUSTOMER == KNA1.KUNNR
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == KNA1.MANDT
Supplier
  • Client
  • Supplier
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == LFA1.MANDT
  • P_PT_DOCITEMWHLDGTXCSHDISC.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • P_PT_DOCITEMWHLDGTXCSHDISC.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == TCURC.MANDT
Withholding Tax Code
  • ?
  • Client
  • Withholding Tax Code
  • P_PT_DOCITEMWHLDGTXCSHDISC.[column in domain "LAND1"] == T059Q.LAND1
  • P_PT_DOCITEMWHLDGTXCSHDISC.MANDT == T059Q.MANDT
  • P_PT_DOCITEMWHLDGTXCSHDISC.WITHHOLDINGTAXCODE == T059Q.QSSKZ