SAP Table CRMD_MKTPL_AL03 - Stores Allocation Data

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

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

SAP Table CRMD_MKTPL_AL03 stores Allocation Datadata

SAP CRMD_MKTPL_AL03 dictionary attributes

CRMD_MKTPL_AL03 field list