/SAPPCE/TDPC01 SAP table for – Down Payment Chains

Here we would like to draw your attention to /SAPPCE/TDPC01 table in SAP. As we know it is being mainly used with the SAP FI-AF (Additional Functions in FI) component which is coming under FI module (Financial Accounting). /SAPPCE/TDPC01 is a SAP standard transp table used for storing Down Payment Chains related data in SAP. It comes under the package /SAPPCE/DPC.

SAP /SAPPCE/TDPC01 table

Table /SAPPCE/TDPC01 technical data

Table/SAPPCE/TDPC01
Data storingDown Payment Chains
ModuleFI
Sub ModuleFI-AF-DPC
SAP Package/SAPPCE/DPC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP /SAPPCE/TDPC01 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in /SAPPCE/TDPC01 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DPCNR : Down Payment Chain Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OBJNR : Object number
    Its data type is CHAR (Character String) with field length 22
  • DPCTP : Down Payment Chain Type
    Its data type is CHAR (Character String) with field length 4
  • KOART : Down Payment Chain Account Type
    Its data type is CHAR (Character String) with field length 1
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • VBELN : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • POSNR : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • DPCKT : Down Payment Chain Name
    Its data type is CHAR (Character String) with field length 40
  • DPENR : External Reference for Down Payment Chain
    Its data type is CHAR (Character String) with field length 35
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • DDATC : Contract Issue Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DDATF : Completion Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • TBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • TBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • STERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • SBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • SBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • SBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • SBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • NETPR : Contract Value
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TMWKZ : Sales Tax Code for Partial Invoice
    Its data type is CHAR (Character String) with field length 2
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • CRDAT : Date on which the object was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : User name of administrator who entered object
    Its data type is CHAR (Character String) with field length 12
  • CHDAT : Date of last change to object
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHNAM : User name of processer who made change to object
    Its data type is CHAR (Character String) with field length 12
  • CSTAT : Down Payment Chain Status
    Its data type is CHAR (Character String) with field length 1
  • CLKMD : Contract Lock
    Its data type is CHAR (Character String) with field length 1
  • CLKPO : Posting Lock
    Its data type is CHAR (Character String) with field length 1
  • ACCTASSCAT : Down Payment Chain: Account Assignment Type
    Its data type is CHAR (Character String) with field length 1
  • TAXJURCODE : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • INFO_CLRNG_DP : Down Payment Chain: Information of Advance Payment Clearing
    Its data type is CHAR (Character String) with field length 40
  • IND_LOGISTICS : DPC: Indicator – Down Payment Chain created from Logistics
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes