SAP WTADP Cumulative values for accounts receivable (payment proposal) Table

Overview

WTADP is a standard SAP S/4HANA table that stores Cumulative values for accounts receivable (payment proposal) data. There are total 56 fields in the WTADP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WTADP belongs to Withholding Tax (Calculation) (FI-AP-AP-Q) module and is located in the package Infrastructure for withholding tax (FQST).

In addition, following links provide an overview of foreign key relationships, if any, that link WTADP to other SAP tables and standard CDS views available based on WTADP table in S/4HANA 2020.

Techincal Settings of WTADP

Below are technical details of the table WTADP

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WTADP Fields

The following table gives you an overview of the fields available in WTADP

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
BUKRSCompany CodeBUKRST001CHAR4
KUNNRCustomer NumberKUNNRKNA1CHAR10
WT_CALYCalendar Year: AccumulationWT_CALYNUMC4
WITHTIndicator for Withholding Tax TypeWITHTCHAR2
WT_WITHCDWithholding Tax CodeWT_WITHCDCHAR2
LAUFDDate on Which the Program Is to Be RunLAUFDDATS8
LAUFIAdditional IdentificationLAUFICHAR6
WT_BS01Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT01Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP01Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA01Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS02Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT02Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP02Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA02Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS03Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT03Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP03Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA03Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS04Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT04Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP04Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA04Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS05Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT05Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP05Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA05Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS06Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT06Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP06Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA06Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS07Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT07Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP07Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA07Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS08Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT08Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP08Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA08Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS09Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT09Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP09Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA09Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS10Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT10Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP10Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA10Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS11Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT11Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP11Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA11Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_BS12Withholding Tax Base Amount (Local Currency)WT_BSCURR23
WT_WT12Withholding Tax Amount in Local CurrencyWT_WTCURR23
WT_HLP12Auxiliary Amount in Local CurrencyWT_HLPCURR23
WT_HLPA12Auxiliary Amount in Local CurrencyWT_HLPCURR23

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WTADP

Table NameFieldCardinalityCheck Table
WTADPBUKRS:T001
WTADPKUNNR1: CNKNA1
WTADPMANDT1: CNT000

Other References