/SAPPCE/TDPC01 SAP (Down Payment Chains) Table details
Dictionary Type: Table
Description: Down Payment Chains
Description: Down Payment Chains
ABAP Code to SELECT data from /SAPPCE/TDPC01
Related tables to /SAPPCE/TDPC01
Access table /SAPPCE/TDPC01
Related tables to /SAPPCE/TDPC01
Access table /SAPPCE/TDPC01
Table field list including key, data, relationships and ABAP select examples
/SAPPCE/TDPC01 is a standard SAP Table which is used to store Down Payment Chains data and is available within R/3 SAP systems depending on the version and release level.
The /SAPPCE/TDPC01 table consists of various fields, each holding specific information or linking keys about Down Payment Chains data available in SAP. These include BUKRS (Company Code), DPCNR (Down Payment Chain Number), OBJNR (Object number), DPCTP (Down Payment Chain Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /SAPPCE/TDPC01 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
DPCNR | Down Payment Chain Number | /SAPPCE/DPCNR | CHAR | 10 | ALPHA | /SAPPCE/DPCNR | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
DPCTP | Down Payment Chain Type | /SAPPCE/DPCTP | CHAR | 4 | /SAPPCE/TDPC02 | /SAPPCE/DPCTP | |||
KOART | Down Payment Chain Account Type | /SAPPCE/DPCKOART | CHAR | 1 | /SAPPCE/DPCKOART | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBAK | ALPHA | VBELN | AUN | |
POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
DPCKT | Down Payment Chain Name | /SAPPCE/DPCKT | CHAR | 40 | TEXT40 | ||||
DPENR | External Reference for Down Payment Chain | /SAPPCE/DPCENR | CHAR | 35 | CHAR35 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFB1 | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNB1 | ALPHA | KUNNR | KUN | C_KUNNR |
DDATC | Contract Issue Date | /SAPPCE/DPCDATC | DATS | 8 | DATUM | ||||
DDATF | Completion Date | /SAPPCE/DPCDATF | DATS | 8 | DATUM | ||||
TTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
TBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
TBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
TBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
TBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
TBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
STERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
SBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
SBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
SBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
SBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
SBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
NETPR | Contract Value | /SAPPCE/DPCBPREI | CURR | 15(2) | WERT15 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
TMWKZ | Sales Tax Code for Partial Invoice | /SAPPCE/DPCTMWKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
CRDAT | Date on which the object was created | /SAPPCE/DPCCRDAT | DATS | 8 | DATUM | ||||
CRNAM | User name of administrator who entered object | /SAPPCE/DPCCRNAM | CHAR | 12 | SYCHAR12 | ||||
CHDAT | Date of last change to object | /SAPPCE/DPCCHDAT | DATS | 8 | DATUM | ||||
CHNAM | User name of processer who made change to object | /SAPPCE/DPCCHNAM | CHAR | 12 | SYCHAR12 | ||||
CSTAT | Down Payment Chain Status | /SAPPCE/DPC_STATUS | CHAR | 1 | /SAPPCE/DPC_STATUS | ||||
CLKMD | Contract Lock | /SAPPCE/DPC_LOCKMD | CHAR | 1 | XFELD | ||||
CLKPO | Posting Lock | /SAPPCE/DPC_LOCKPO | CHAR | 1 | XFELD | ||||
ACCTASSCAT | Down Payment Chain: Account Assignment Type | /SAPPCE/AATYP | CHAR | 1 | /SAPPCE/AATYP | ||||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
INFO_CLRNG_DP | Down Payment Chain: Information of Advance Payment Clearing | /SAPPCE/DPC_INFO_CLRNG_DP | CHAR | 40 | /SAPPCE/DPC_INFO_CLRNG_DP | ||||
IND_LOGISTICS | DPC: Indicator - Down Payment Chain created from Logistics | /SAPPCE/DPC_LOGISTICS | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table /SAPPCE/TDPC01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPPCE/TDPC01 to SELECT all data from the tableDATA: WA_/SAPPCE/TDPC01 TYPE /SAPPCE/TDPC01.
SELECT SINGLE *
FROM /SAPPCE/TDPC01
INTO CORRESPONDING FIELDS OF WA_/SAPPCE/TDPC01
WHERE...
How to access SAP table /SAPPCE/TDPC01
Within an ECC or HANA version of SAP you can also view further information about /SAPPCE/TDPC01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects