SAP Table CRMD_MKTPL_AL01 stores Allocation Data: Product Assignmentsdata

  

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


SAP CRMD_MKTPL_AL01 dictionary attributes

Object Name: CRMD_MKTPL_AL01
Dictionary Type: Transparent table
Description: Allocation Data: Product Assignments


CRMD_MKTPL_AL01 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTESTCRM
ALLOCGUIDSYSUUID_XRAW16(0) CRMD_MKTPL_AL00UUID in X form (binary)SYSUUIDCRM
PRODUCT_GUIDCOMT_PRODUCT_GUIDRAW16(0) COMM_PRODUCTInternal Unique ID of ProductSYSUUIDCRM
GUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
ALRULECRM_MKTPL_ALRULECHAR10(0) CRMC_MKTPL_AL02Allocation RuleCRM_MKTPL_ALRULECRM
RLIMITCRM_MKTPL_RLIMITDEC2(1) Allocation: Rounding LimitCRM
MINQUANCRM_MKTPL_ALMINQUANQUAN17(3) Allocation: Minimum Quantity to be Allocated to a BPCRM
MAXQUANCRM_MKTPL_ALMAXQUANQUAN17(3) Allocation: Maximum Quantity to be AllocatedCRM
LIFTCRM_MKTPL_ALLIFTDEC5(2) Allocation: Lift PercentageCRM_MKTPL_ALLIFTCRM
REFERENCECRM_MKTPL_ALREFCHAR40(0) Allocation: Reference at Product LevelCRM_MKTPL_ALREFCRM
VALUATIONCRM_MKTPL_VALUATIONCURR17(2) Allocation: Value Used to Valuate QuantitiesCRM
ALQUANTITYCRM_MKTPL_ALQUANTITYQUAN17(3) Allocation QuantityCRM
ALUOMCRM_MKTPL_ALUOMUNIT3(0) *Allocation: Unit of MeasureMEINSCRM
ALBUDGETCRM_MKTPL_ALBUDGETCURR17(2) Allocation: BudgetCRM
VALIDITYCRM_MKTPL_ALVALIDCHAR1(0) Allocation: Validity of Allocation DataCRM_MKTPL_ALVALIDCRM


View list of all tables