SAP Table CRMD_MKTPL_AL00 stores Allocation Headerdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_al00 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_AL00 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_AL00....Right lets get started!


SAP CRMD_MKTPL_AL00 dictionary attributes

Object Name: CRMD_MKTPL_AL00
Dictionary Type: Transparent table
Description: Allocation Header


CRMD_MKTPL_AL00 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
ALLOCGUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
ALAPPLCRM_MKTPL_ALAPPLCHAR5(0) CRMC_MKTPL_AL00Allocation ApplicationCRM_MKTPL_ALAPPLCRM
OBJGUIDCRM_MKTPL_ALOBJGUIDRAW16(0) Allocation: GUID of an application context objectSYSUUIDCRM
ORIG_SYSTCRM_MKTPL_AL_ORIG_SYSTCHAR1(0) Allocation: Original SystemCRM_MKTPL_AL_ORIG_SYSTCRM
START_DATECGPL_PLANSTARTDATEDATS8(0) Planned Start DateDATUMCRM
END_DATECGPL_PLANFINISHDATEDATS8(0) Planned Finish DateDATUMCRM
ALBUDGETCRM_MKTPL_ALBUDGETCURR17(2) Allocation: BudgetCRM
ALQUANTITYCRM_MKTPL_ALQUANTITYQUAN17(3) Allocation QuantityCRM
ALUOMCRM_MKTPL_ALUOMUNIT3(0) T006Allocation: Unit of MeasureMEINSCRM
ALCUKYCRM_MKTPL_ALCUKYCUKY5(0) TCURCAllocation: CurrencyWAERSCRM
ALSTATUSCRM_MKTPL_ALSTATUSCHAR1(0) Allocation: StatusCRM_MKTPL_ALSTATUSCRM
UNAMEUNAMECHAR12(0) User NameUNAMESAPCRM
AEDTMAEDTMDATS8(0) Changed onDATUMPPCRM
ATIMEAS4TIMETIMS6(0) Last changed atAS4TIMESDICCRM
EXT_OBJECT_IDCRMT_MKTPL_EXTIDCHAR24(0) Marketing ProjectCGPL_EXTIDCRM


View list of all tables