0RT_MAT_PRM_ATTR

Material Number Compounded to Retail Promotion | #ATTR | Extraction method: F1 | No Delta | Component: Master Data Retail

Tables used: WAKP, WALE, WAKH → show details

🔑 Keys (3)
💰 Amounts (7)
∑ Quantities (4)
📅 Dates (10)
☰ Categorical (12)
Other (11)
🔗 Relations (23)

Column Name	Description
AKTNR FK	Promotion
ARTNR FK	Material Number
MEBME FK	Sales unit

Column Name	Description
💲 Currency Current Promotion - Planning (WAELA):
PUMVP	Promotion Plan Mat. Sales Vol. at Promo. Sales Price
PUMEP	Promotion plan: mat. sales at PP in sales currency
PLVKP	Sales price for promotion item
NVKP	Standard sales price
💲 Purchase price currency (WAEEK):
PUMEN	Promotion plan: sales volume at purchase price (net/net)
PLEKP	Purchase price for promotion item
PLEKN	Basic purchase price: net/net - promotion item

Column Name	Description
📏 Sales unit (MEBME):
PABBM	Planned Sales Qty. of Promotion Material in Sales Units
MIAMG	Minimum order qty for promotional material
📏 Logistics unit (MELOG):
PABLM	Planned Sales Qty of Promotion Material in Logistics Units
📏 Allocation table unit (MEAUF):
AUFME	Promotion plan: Material allocation table quantity

Column Name	Description
SPDAT	Date on which promotion material is blocked for promotion
FBDAT	Earliest Order Date
SBDAT	Latest Order Date
FLDAT	Earliest delivery date
SLDAT	Latest delivery date
BEDAT	Order Date with Supplier
ERDAT	Date on which the record was created
AEDAT	Last Changed On
VK_AKTIV_AB	Sales prices active from
VK_AKTIV_BI	Sales price active to

Column Name	Description
BZQFI	Supply Source Determination Status	Show values
AKBSP	Item status, listing	Show values
RESKZ	Check Against Listing Rules/Listing Conditions	Show values
SPGRU	Reason for promotion block	Show values
RGART	Return type for promotional material	Show values
EKKPS	Maintenance status of purchase price conditions	Show values
VKKPS	Maintenance status of sales price conditions	Show values
EKKON	Create purchase price condition records	Show values
VKKON	Create sales price condition records	Show values
ECKPKZ	Indicates whether price point tables should override price	Show values
VZKON	Create DC condition records	Show values
VZKPS	Maintenance status of DC conditions	Show values

Column Name	Description	Domain name
AKPOS	Promotion Item Number	NUMC6
NBPOS	No. of modules with this material as an item	INT2
AKLIZ	Planned delivery time for promotional goods	DEC3
VPEIN	Sales price unit	DEC5
EPEIN	Price unit	DEC5
NDISP	Replenishment indicator	CHAR2
VREGE	No. of allocation rule	SBELN
ACTIV	No. of successful price activations	INT1
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
EPRGR	Price point group	EPRGR

Master Data Relations	Join Conditions
Promotion theme Client Promotion theme	`0RT_MAT_PRM_ATTR.MANDT == TWAT.MANDT` `0RT_MAT_PRM_ATTR.AKTHE == TWAT.AKTHE`
Promotion Client Promotion	`0RT_MAT_PRM_ATTR.MANDT == WAKH.MANDT` `0RT_MAT_PRM_ATTR.AKTNR == WAKH.AKTNR`
Item category of allocation table Client Item category of allocation table	`0RT_MAT_PRM_ATTR.MANDT == T621.MANDT` `0RT_MAT_PRM_ATTR.APSTP == T621.APSTP`
xx Client Material Number	`0RT_MAT_PRM_ATTR.MANDT == MARA.MANDT` `0RT_MAT_PRM_ATTR.ARTNR == MARA.MATNR`
Allocation material number Client Allocation material number	`0RT_MAT_PRM_ATTR.MANDT == MARA.MANDT` `0RT_MAT_PRM_ATTR.BATNR == MARA.MATNR`
Promotion announcement category Client Promotion announcement category	`0RT_MAT_PRM_ATTR.MANDT == T626.MANDT` `0RT_MAT_PRM_ATTR.BEKTY == T626.AAVIT`
Promotion: Purchase price determination sequence ? Client Promotion: Purchase price determination sequence	`0RT_MAT_PRM_ATTR.[column in domain "KAPPL"] == TWEV.KAPPL` `0RT_MAT_PRM_ATTR.MANDT == TWEV.MANDT` `0RT_MAT_PRM_ATTR.EKERV == TWEV.EKERV`
Purchasing Group Client Purchasing Group	`0RT_MAT_PRM_ATTR.MANDT == T024.MANDT` `0RT_MAT_PRM_ATTR.EKGRP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`0RT_MAT_PRM_ATTR.MANDT == T024E.MANDT` `0RT_MAT_PRM_ATTR.EKORG == T024E.EKORG`
IS-R Labeling: material grouping (deactivated in 4.0) Client IS-R Labeling: material grouping (deactivated in 4.0)	`0RT_MAT_PRM_ATTR.MANDT == TWEA.MANDT` `0RT_MAT_PRM_ATTR.ETIAG == TWEA.ARTGR`
Material Group Client Material Group	`0RT_MAT_PRM_ATTR.MANDT == T023.MANDT` `0RT_MAT_PRM_ATTR.MATKL == T023.MATKL`
Allocation table unit Client Allocation table unit	`0RT_MAT_PRM_ATTR.MANDT == T006.MANDT` `0RT_MAT_PRM_ATTR.MEAUF == T006.MSEHI`
Sales unit Client Sales unit	`0RT_MAT_PRM_ATTR.MANDT == T006.MANDT` `0RT_MAT_PRM_ATTR.MEBME == T006.MSEHI`
Order Price Unit (Purchasing) Client Order Price Unit (Purchasing)	`0RT_MAT_PRM_ATTR.MANDT == T006.MANDT` `0RT_MAT_PRM_ATTR.MEBPR == T006.MSEHI`
Base unit of measure Client Base unit of measure	`0RT_MAT_PRM_ATTR.MANDT == T006.MANDT` `0RT_MAT_PRM_ATTR.MEINS == T006.MSEHI`
Logistics unit Client Logistics unit	`0RT_MAT_PRM_ATTR.MANDT == T006.MANDT` `0RT_MAT_PRM_ATTR.MELOG == T006.MSEHI`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`0RT_MAT_PRM_ATTR.MANDT == MARA.MANDT` `0RT_MAT_PRM_ATTR.SATNR == MARA.MATNR`
Sales Organization Client Sales Organization	`0RT_MAT_PRM_ATTR.MANDT == TVKO.MANDT` `0RT_MAT_PRM_ATTR.VKORG == TVKO.VKORG`
Distribution Channel Client Sales Organization Distribution Channel	`0RT_MAT_PRM_ATTR.MANDT == TVKOV.MANDT` `0RT_MAT_PRM_ATTR.VKORG == TVKOV.VKORG` `0RT_MAT_PRM_ATTR.VTWEG == TVKOV.VTWEG`
Purchase price currency Client Purchase price currency	`0RT_MAT_PRM_ATTR.MANDT == TCURC.MANDT` `0RT_MAT_PRM_ATTR.WAEEK == TCURC.WAERS`
Currency Current Promotion - Planning Client Currency Current Promotion - Planning	`0RT_MAT_PRM_ATTR.MANDT == TCURC.MANDT` `0RT_MAT_PRM_ATTR.WAELA == TCURC.WAERS`