CRMD_MKTTG_TG_I SAP (TG Exchange: Target Group Item (BP Info)) Table details

Dictionary Type: Table
Description: TG Exchange: Target Group Item (BP Info)




ABAP Code to SELECT data from CRMD_MKTTG_TG_I
Related tables to CRMD_MKTTG_TG_I
Access table CRMD_MKTTG_TG_I




Table field list including key, data, relationships and ABAP select examples

CRMD_MKTTG_TG_I is a standard SAP Table which is used to store TG Exchange: Target Group Item (BP Info) data and is available within R/3 SAP systems depending on the version and release level.

The CRMD_MKTTG_TG_I table consists of various fields, each holding specific information or linking keys about TG Exchange: Target Group Item (BP Info) data available in SAP. These include TG_ID (CRM Marketing: Target Group ID), CLIENT (Client), GUID (Item List Business Partner GUID), KUNNR (Customer Numbers).. 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 CRMD_MKTTG_TG_I 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
TG_IDCRM Marketing: Target Group ID CRMT_MKTTG_TG_IDCHAR10CRM_MKTTG_TG_ID
CLIENTClient MANDTCLNT3T000MANDT
GUIDItem List Business Partner GUID CRMT_BPITEMS_GUIDRAW16SYSUUID
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
TG_GUIDCRM Marketing: GUID of Target Group CRMT_TARGETGRP_GUIDRAW16SYSUUID
BP_GUIDCRM Marketing: Target Group Business Partner GUID CRMT_TG_BP_GUIDRAW16SYSUUID
BP_ORGCRM Marketing: Origin Indicator for a Business Partner CRMT_MKTTG_BP_ORGCHAR2CRM_MKTTG_BP_ORG
BP_DELCRM Marketing: Delete Indicator for a Business Partner CRMT_MKTBP_ITEMS_DELCHAR1CRM_BOOLEAN
REL_GUIDGUID for Relationship Object CRMT_MKTTG_RELATED_GUIDRAW16SYSUUID
RELATIONSHIPBusiness Partner Relationship Category BU_RELTYPCHAR6Assigned to domainBU_RELTYP
TYPE_BP_GUIDBusiness partner category BU_TYPECHAR1BU_TYPEBPY
TYPE_REL_GUIDBusiness partner category BU_TYPECHAR1BU_TYPEBPY

Key field Non-key field



How do I retrieve data from SAP table CRMD_MKTTG_TG_I using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRMD_MKTTG_TG_I to SELECT all data from the table
DATA: WA_CRMD_MKTTG_TG_I TYPE CRMD_MKTTG_TG_I.

SELECT SINGLE *
FROM CRMD_MKTTG_TG_I
INTO CORRESPONDING FIELDS OF WA_CRMD_MKTTG_TG_I
WHERE...

How to access SAP table CRMD_MKTTG_TG_I

Within an ECC or HANA version of SAP you can also view further information about CRMD_MKTTG_TG_I and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!