In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_al03 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_MKTPL_AL03 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_MKTPL_AL03....Right lets get started!
Object Name: CRMD_MKTPL_AL03
Dictionary Type: Transparent table
Description: Allocation Data
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| ALLOCDATAGUID | SYSUUID_X | RAW | 16(0) | UUID in X form (binary) | SYSUUID | CRM | ||||||
| ALLOCGUID | SYSUUID_X | RAW | 16(0) | CRMD_MKTPL_AL00 | UUID in X form (binary) | SYSUUID | CRM | |||||
| TARGETGRP_GUID | CRMT_TARGETGRP_GUID | RAW | 16(0) | CRMD_MKTTG_TG_H | CRM Marketing: GUID of Target Group | SYSUUID | CRM | |||||
| PRODUCT_GUID | COMT_PRODUCT_GUID | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | CRM | ||||||
| BP_GUID | CRMT_TG_BP_GUID | RAW | 16(0) | CRM Marketing: Target Group Business Partner GUID | SYSUUID | CRM | ||||||
| PLAN_QUAN | CRM_MKTPL_PLAN_QUAN | QUAN | 17(3) | Allocation: Planned Quantity | CRM | |||||||
| ACT_QUAN | CRM_MKTPL_ACT_QUAN | QUAN | 17(3) | Allocation: Actual Quantity | CRM | |||||||
| STATUS | CRM_MKTPL_ALACTSTAT | CHAR | 1(0) | CRMC_MKTPL_AL04 | Allocation: Status of Actual Quantities | CRM | ||||||
| ALPRIO | CRM_MKTPL_ALPRIO | CHAR | 1(0) | CRMC_MKTPL_AL03 | Allocation: Priority | CRM_MKTPL_ALPRIO | CRM | |||||
| DATE_FROM | CRM_MKTPL_ALFROM | DATS | 8(0) | Allocation: 'Valid From' Date | CRM | |||||||
| DATE_TO | CRM_MKTPL_ALTO | DATS | 8(0) | Allocation: 'Valid To' Date | CRM |