SAP Table CRMD_MKTPL_AL03 stores Allocation Datadata

  

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!


SAP CRMD_MKTPL_AL03 dictionary attributes

Object Name: CRMD_MKTPL_AL03
Dictionary Type: Transparent table
Description: Allocation Data


CRMD_MKTPL_AL03 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTESTCRM
ALLOCDATAGUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
ALLOCGUIDSYSUUID_XRAW16(0) CRMD_MKTPL_AL00UUID in X form (binary)SYSUUIDCRM
TARGETGRP_GUIDCRMT_TARGETGRP_GUIDRAW16(0) CRMD_MKTTG_TG_HCRM Marketing: GUID of Target GroupSYSUUIDCRM
PRODUCT_GUIDCOMT_PRODUCT_GUIDRAW16(0) Internal Unique ID of ProductSYSUUIDCRM
BP_GUIDCRMT_TG_BP_GUIDRAW16(0) CRM Marketing: Target Group Business Partner GUIDSYSUUIDCRM
PLAN_QUANCRM_MKTPL_PLAN_QUANQUAN17(3) Allocation: Planned QuantityCRM
ACT_QUANCRM_MKTPL_ACT_QUANQUAN17(3) Allocation: Actual QuantityCRM
STATUSCRM_MKTPL_ALACTSTATCHAR1(0) CRMC_MKTPL_AL04Allocation: Status of Actual QuantitiesCRM
ALPRIOCRM_MKTPL_ALPRIOCHAR1(0) CRMC_MKTPL_AL03Allocation: PriorityCRM_MKTPL_ALPRIOCRM
DATE_FROMCRM_MKTPL_ALFROMDATS8(0) Allocation: 'Valid From' DateCRM
DATE_TOCRM_MKTPL_ALTODATS8(0) Allocation: 'Valid To' DateCRM


View list of all tables