CRMD_MKTTG_TG_H SAP table for – TG Exchange: Target Group Header

Here we would like to draw your attention to CRMD_MKTTG_TG_H table in SAP. As we know it is being mainly used with the SAP SD-MD (Master Data in SD) component which is coming under SD module (Sales & Distribution). CRMD_MKTTG_TG_H is a SAP standard transparent table used for storing TG Exchange: Target Group Header related data in SAP. It comes under the package CRM_MKTTG_TG.

SAP CRMD_MKTTG_TG_H table

Table CRMD_MKTTG_TG_H technical data

TableCRMD_MKTTG_TG_H
Data storingTG Exchange: Target Group Header
ModuleSD
ComponentSD-MD
SAP PackageCRM_MKTTG_TG
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is CRMT_MKTTG_TG_KEY
  • PLAN_COUNT
    Its data type is X (Byte string) with field length 4
  • ACT_COUNT
    Its data type is X (Byte string) with field length 4
  • DEDUP_CODE
    Its data type is C (Character String) with field length 6
  • PRIO
    Its data type is X (Byte string) with field length 4
  • SEARCHFIELD
    Its data type is C (Character String) with field length 32
  • DELETE_FLAG
    Its data type is C (Character String) with field length 1
  • ITEM_TABLE
    Its data type is C (Character String) with field length 16
  • ORIG_LG
    Its data type is C (Character String) with field length 1
  • CREATED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • CREATED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 12
  • CHANGED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CHANGED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 12
  • TG_SEL
    Its data type is C (Character String) with field length 1
  • UU_COUNT
    Its data type is X (Byte string) with field length 4
  • BW_SYNC
    Its data type is C (Character String) with field length 1
  • OBJ_TYPE : Repository Object Type
    Its data type is C (Character String) with field length 2
  • COUNT_RELATION
    Its data type is X (Byte string) with field length 4
  • ID : Demo hierarchy: Node ID
    Its data type is C (Character String) with field length 10
  • MODELING_TYPE
    Its data type is C (Character String) with field length 1
  • GUID : 16 Byte UUID in 32 Characters (Hexadecimal Encoded)
    Its a key field. Its data type is X (Byte string) with field length 16
  • RESPONSIBLE : User Name
    Its data type is X (Byte string) with field length 16
  • TERR_PATH_GUID
    Its data type is X (Byte string) with field length 16
  • NODE_GUID
    Its data type is X (Byte string) with field length 16
  • VALID_FROM : Valid From (Time Stamp)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VALID_TO : Valid To (Time Stamp)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LAST_BUILD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SET_H_GUID
    Its data type is X (Byte string) with field length 16
  • SET_GUID
    Its data type is X (Byte string) with field length 16
  • PROF_GUID
    Its data type is X (Byte string) with field length 16
  • TG_ORG
    Its data type is C (Character String) with field length 2
  • TG_TYPE
    Its data type is C (Character String) with field length 6