TPZ20 SAP table for – Business Partner Acquisition Data: Information Categories

Here we would like to draw your attention to TPZ20 table in SAP. As we know it is being mainly used with the SAP FS-BP (Business Partner in FS) component which is coming under FS module (Financial Services). TPZ20 is a SAP standard transp table used for storing Business Partner Acquisition Data: Information Categories related data in SAP. It comes under the package FS_BP_AL_ADDITIONS.

SAP TPZ20 table

Table TPZ20 technical data

TableTPZ20
Data storingBusiness Partner Acquisition Data: Information Categories
ModuleFS
Sub ModuleFS-BP
SAP PackageFS_BP_AL_ADDITIONS
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_ABA
Table CategoryTRANSP

SAP TPZ20 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 TPZ20 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ADDTYPE : Information Category
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • C_CRITER : Differentiation of Additional Information
    Its data type is CHAR (Character String) with field length 1
  • C_DEFAULT : Automatic Default Value for Information Category
    Its data type is CHAR (Character String) with field length 1
  • C_DATA_TYPE_1 : Permit Several Information Types Per Information Category
    Its data type is CHAR (Character String) with field length 1
  • C_DATA_TYPE_2 : Use Counters for Date Fields
    Its data type is CHAR (Character String) with field length 1
  • C_CT_FIELD_1 : Suppress Check Against Values Defined in Customizing
    Its data type is CHAR (Character String) with field length 1
  • C_CT_FIELD_FMOD : Field Status for Field with F4 Input Help
    Its data type is CHAR (Character String) with field length 1
  • C_XFELD_FMOD : Field Status of Checkbox
    Its data type is CHAR (Character String) with field length 1
  • C_TEXT_FMOD : Field Status of Text Field
    Its data type is CHAR (Character String) with field length 1
  • C_AMNT_FMOD : Field Status of Amount Field
    Its data type is CHAR (Character String) with field length 1
  • C_DATEFR_FMOD : Field Status of Valid-From Date for Additional Information
    Its data type is CHAR (Character String) with field length 1
  • C_DATETO_FMOD : Field Status of Valid-To Date for Additional Information
    Its data type is CHAR (Character String) with field length 1
  • C_ADDATE_FMOD : Field Status of the Additional Date for Additional Info
    Its data type is CHAR (Character String) with field length 1
  • C_DETAIL : Show / Hide Detail View
    Its data type is CHAR (Character String) with field length 1
  • C_ORGA : Partner Category ‘Organization’ Is Relevant
    Its data type is CHAR (Character String) with field length 1
  • C_PERS : Partner Category ‘Natural Person’ Is Relevant
    Its data type is CHAR (Character String) with field length 1
  • C_GROU : Partner Category ‘Group’ Is Relevant
    Its data type is CHAR (Character String) with field length 1