MDM_TESTDATA_1 SAP table for – Test Data Directory

Here we would like to draw your attention to MDM_TESTDATA_1 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). MDM_TESTDATA_1 is a SAP standard transp table used for storing Test Data Directory related data in SAP. It comes under the package FSBP_TEST_EXTERNAL.

SAP MDM_TESTDATA_1 table

Table MDM_TESTDATA_1 technical data

TableMDM_TESTDATA_1
Data storingTest Data Directory
ModuleFS
Sub ModuleFS-BP
SAP PackageFSBP_TEST_EXTERNAL
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_ABA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GUID : Key for Test Data
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • BUSINESS_OBJECT : Business Object
    Its data type is CHAR (Character String) with field length 2
  • SOFTWARE_LAYER : Level
    Its data type is CHAR (Character String) with field length 1
  • CRDATE : Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRTIME : Creation Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CR_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • NUMBER_OBJECTS : Number of Business Objects
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NUMBER_CALLS : Number of Read Calls
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • LAST_CALL_DATE : Date of Last Read Call
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CALL_TIME : Time of Last Read Call
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PRECALC_RESULT : Precalculated Results
    Its data type is CHAR (Character String) with field length 1
  • LOGNUMBER : Application log: log number
    Its data type is CHAR (Character String) with field length 20