In this post, I will try and describe everything you need to know about the SAP crmd_mkttggrp_us table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_MKTTGGRP_US what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_MKTTGGRP_US....Right lets get started!
Object Name: CRMD_MKTTGGRP_US
Dictionary Type: Transparent table
Description: CRM Marketing: Usage Category for Target Group
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| TARGETGRP_GUID | CRMT_TARGETGRP_GUID | RAW | 16(0) | CRMD_MKTTGGRP | CRM Marketing: GUID of Target Group | SYSUUID | CRM | |||||
| TARGETGRP_USAGE | CRMT_TARGETGRP_USAGE | CHAR | 2(0) | CRM Marketing: Usage Category for Target Group | CRM_MARKETING_USAGE | CRM | ||||||
| TARGETGRP_USID | CRMT_TARGETGRP_USID | CHAR | 32(0) | CRM Marketing: Target Group - Usage Object for Usage Cat. | CRM_MARKETING_ID | CRM | ||||||
| USAGE_VALID_TO | CRMT_USAGE_VALID_TO | DATS | 8(0) | CRM Marketing: Target Groups - Usage Category Valid To | DATUM | CRM | ||||||
| TOP_N_PARAM_ID | CRMT_BW_PARAM_ID | CHAR | 32(0) | CRM Marketing: BW Parameter ID | CRM_MARKETING_ID | CRM | ||||||
| TOP_N_PERMANENT | CRMT_TOP_N_PERMANENT | CHAR | 32(0) | CRM Marketing: Top n Permanent Product List ID | CRM_MARKETING_ID | CRM | ||||||
| ORIG_LG | CRMT_MKTTG_ORIG_LG | LANG | 1(0) | Original Language of Segment | LANG | CRM | ||||||
| CREATED_AT | CRMT_MKT_CREATED_AT | DEC | 15(0) | Marketing Object: Creation Date | BCOS_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_MKT_CREATED_BY | CHAR | 12(0) | Marketing Object: Created By User | UNAME | CRM | ||||||
| CHANGED_AT | CRMT_MKT_CHANGED_AT | DEC | 15(0) | Marketing Object: Date of Last Change | BCOS_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_MKT_CHANGED_BY | CHAR | 12(0) | Marketing Object: Last Changed By | UNAME | CRM | ||||||
| USAGE_VALID_FROM | CRMT_USAGE_VALID_FROM | DATS | 8(0) | CRM Marketing: Target Group Usage Category Valid From | DATUM | CRM | ||||||
| TGGRP_USAGE_GUID | CRMT_MKTTGGRP_US_GUID | RAW | 16(0) | CRM Marketing: GUID of a Usage Category | SYSUUID | CRM |