/SAPPCE/TPNV SAP table for – Construction Progress Report

Here we would like to draw your attention to /SAPPCE/TPNV table in SAP. As we know it is being mainly used with the SAP PS-REV (Revenues and Earnings in PS) component which is coming under PS module (Project Systems). /SAPPCE/TPNV is a SAP standard transparent table used for storing Construction Progress Report related data in SAP. It comes under the package /SAPPCE/PNV.

SAP /SAPPCE/TPNV table

Table /SAPPCE/TPNV technical data

Table/SAPPCE/TPNV
Data storingConstruction Progress Report
ModulePS
ComponentPS-REV
SAP Package/SAPPCE/PNV
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /SAPPCE/TPNV Table Fields

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BLTXT
    Its data type is C (Character String) with field length 50
  • ERTIMESTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • AETIMESTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • AEDTM
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEZET
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_TPNV
  • PVNNO
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • PS_PSP_PHIUP
    Its data type is N (Character String with Digits Only) with field length 8
  • PSP_PROJ
    Its data type is N (Character String with Digits Only) with field length 8
  • PKOKR
    Its data type is C (Character String) with field length 4
  • GJAHR : Fiscal Year
    Its data type is N (Character String with Digits Only) with field length 4
  • PERIO
    Its data type is N (Character String with Digits Only) with field length 3
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8