SAP ABAP Class CL_DMF_OFFER_DB (DB Access methods for promotions)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD (Application Component) Logistics Basic Data
     ⤷ DMF_DB_ACCESS (Package) Data Base accesses
Properties
Class CL_DMF_OFFER_DB  
Short Description DB Access methods for promotions    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package DMF_DB_ACCESS   Data Base accesses 
Created 20120419   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 RSDS Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_DMF_OFFER_DB has no interface implemented.
Friends
Class CL_DMF_OFFER_DB has no friend class.
Attributes
Class CL_DMF_OFFER_DB has no attribute.
Methods
# Method Level Visibility Method type Description Created on
1 CHECK_DISTR_CHN_FOR_SITE Instance method Public Method Check if distribution chain is valid for site (in TVKWZ) 20120823
2 DET_PRICE_LISTS_PER_ITEM Instance method Public Method Get price lists for items created from PPW (EA-RETAIL) 20121029
3 DET_SELOPT_FOR_RE_INIT Instance method Public Method Get select options for complete re-initial transfer 20121221
4 DET_SITES_PER_PPW_ITEM Instance method Public Method Get sites for items created from PPW (EA-RETAIL) 20121114
5 DET_TRANSFERRED_PROMOTIONS Instance method Public Method Determine which promotions have already been transferred 20130109
6 READ_TACTIC_CUSTOMIZING Instance method Public Method Read tactic mapping customizing 20121205
7 SELECT_ARTICLE_DATA Instance method Public Method Select article data (from MARA) 20130117
8 SELECT_PROMO_ART_SITE Instance method Public Method Get Promo Article/Site Data from WALE 20120420
9 SELECT_PROMO_HEADER Instance method Public Method Get Promotion Header Data from WAKH 20120420
10 SELECT_PROMO_ITEMS Instance method Public Method Get Promotion Item Data from WAKP 20120420
11 SELECT_PROMO_VIA_WAKP Instance method Public Method Find promotions where WAKP contains certain items (articles) 20130118
12 SELECT_PROMO_VIA_WALE Instance method Public Method Find promotions where WALE contains certain art./site comb. 20130117
13 SELECT_SITES_FOR_PRICE_LIST Instance method Public Method Select sites assigned to price list (from WRF6) 20120823
14 SELECT_SITE_DATA_FOR_CUSTOMER Instance method Public Method Get site data by customer number (from T001W) 20120425
15 SELECT_SITE_DATA_FOR_DISTR_CHN Instance method Public Method Select site data by distribution chain assignment (T001W) 20120725
16 SELECT_SITE_DATA_FOR_SITES Instance method Public Method Get site data by site number 20130117
17 STORE_SELOPT_FOR_RE_INIT Instance method Public Method Store select options used for initial transfer 20130108
Events
Class CL_DMF_OFFER_DB has no event.
Types
Class CL_DMF_OFFER_DB has no local type.
Method Signatures

Method CHECK_DISTR_CHN_FOR_SITE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_IS_VALID Call by reference Type reference (TYPE) XFLAG New Input Values 20120823
2 Importing I_VKORG Call by reference Type reference (TYPE) VKOIV Sales organization for intercompany billing 20120823
3 Importing I_VTWEG Call by reference Type reference (TYPE) VTWIV Distribution channel for intercompany billing 20120823
4 Importing I_WERKS Call by reference Type reference (TYPE) WERKS_D Plant 20120823

Method CHECK_DISTR_CHN_FOR_SITE on class CL_DMF_OFFER_DB has no exception.

Method DET_PRICE_LISTS_PER_ITEM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PRICE_LISTS Call by reference Type reference (TYPE) DMF_TS_ART_PL_DC_SITE price lists and prices per item (sorted) 20121029
2 Importing IS_PROMO_ITEM Call by reference Type reference (TYPE) DMF_S_PROMO_ITEM promo item data 20121029

Method DET_PRICE_LISTS_PER_ITEM on class CL_DMF_OFFER_DB has no exception.

Method DET_SELOPT_FOR_RE_INIT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_SELOPT Call by reference Type reference (TYPE) RSDS_SELOPT_T 20121221
2 Importing IV_APPLICATION Call by reference Type reference (TYPE) DRF_APPL Replication Model 20130108

Method DET_SELOPT_FOR_RE_INIT on class CL_DMF_OFFER_DB has no exception.

Method DET_SITES_PER_PPW_ITEM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PPW_SITES_PRICES Call by reference Type reference (TYPE) DMF_TS_PROMO_ART_SITE sites and prices assigned to the item in PPW (sorted) 20121114
2 Importing IS_PROMO_ITEM Call by reference Type reference (TYPE) DMF_S_PROMO_ITEM promo item data 20121114

Method DET_SITES_PER_PPW_ITEM on class CL_DMF_OFFER_DB has no exception.

Method DET_TRANSFERRED_PROMOTIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_TRANSFERRED_PROMOS Call by reference Type reference (TYPE) DMF_TS_PROMO transferred promos from import list (sorted) 20130109
2 Importing ITS_PROMO_OBJECTS Call by reference Type reference (TYPE) DMF_TS_PROMO_OBJECTS promotions to be checked for transfer (sorted) 20130109
3 Importing IV_APPLICATION Call by reference Type reference (TYPE) DRF_APPL Replication Model 20130109

Method DET_TRANSFERRED_PROMOTIONS on class CL_DMF_OFFER_DB has no exception.

Method READ_TACTIC_CUSTOMIZING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TAC_MAP Call by reference Type reference (TYPE) DMF_TS_TACTIC_MAP Tactic Mapping 20121205

Method READ_TACTIC_CUSTOMIZING on class CL_DMF_OFFER_DB has no exception.

Method SELECT_ARTICLE_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_ARTICLE_DATA Call by reference Type reference (TYPE) DMF_TS_MARA Article data from MARA 20130117
2 Importing IT_ARTICLES Call by reference Type reference (TYPE) DMF_T_ART_SITE Articles 20130117

Method SELECT_ARTICLE_DATA on class CL_DMF_OFFER_DB has no exception.

Method SELECT_PROMO_ART_SITE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PROMO_ART_SITE Call by reference Type reference (TYPE) DMF_TS_PROMO_ART_SITE promo article/site data from WALE (sorted) 20120420
2 Importing ITS_PROMO_ITEMS Call by reference Type reference (TYPE) DMF_TS_PROMO_ITEM promo item data from WAKP (sorted) 20120420

Method SELECT_PROMO_ART_SITE on class CL_DMF_OFFER_DB has no exception.

Method SELECT_PROMO_HEADER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PROMO_HEAD Call by reference Type reference (TYPE) DMF_TS_PROMO_HEAD keys of relevant promotion items (sorted) 20120420
2 Importing ITS_PROMO_NUMBER Call by reference Type reference (TYPE) DMF_TS_PROMO_OBJECTS Table ype of WAKH 20120420
3 Importing IT_SELOPT Call by reference Type reference (TYPE) RSDS_SELOPT_T 20120521
4 Importing IV_START_OF_SELECTION Call by reference Type reference (TYPE) SY-DATUM Current Date of Application Server 20120420

Method SELECT_PROMO_HEADER on class CL_DMF_OFFER_DB has no exception.

Method SELECT_PROMO_ITEMS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PROMO_ITEMS Call by reference Type reference (TYPE) DMF_TS_PROMO_ITEM promo item data from WAKP (sorted) 20120420
2 Importing ITS_PROMO_HEAD Call by reference Type reference (TYPE) DMF_TS_PROMO_HEAD promo header data from WAKH (sorted) 20120420

Method SELECT_PROMO_ITEMS on class CL_DMF_OFFER_DB has no exception.

Method SELECT_PROMO_VIA_WAKP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PROMO_OBJ Call by reference Type reference (TYPE) DMF_TS_PROMO_OBJECTS keys of relevant promotions (sorted) 20130118
2 Importing ITS_ARTICLES Call by reference Type reference (TYPE) DMF_TS_PROMO_ITEM article (item) data for WAKP access (sorted) 20130118

Method SELECT_PROMO_VIA_WAKP on class CL_DMF_OFFER_DB has no exception.

Method SELECT_PROMO_VIA_WALE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_PROMO_OBJ Call by reference Type reference (TYPE) DMF_TS_PROMO_OBJECTS keys of relevant promotions (sorted) 20130117
2 Importing ITS_ART_SITES Call by reference Type reference (TYPE) DMF_TS_PROMO_ART_SITE article/site data for WALE access (sorted) 20130117

Method SELECT_PROMO_VIA_WALE on class CL_DMF_OFFER_DB has no exception.

Method SELECT_SITES_FOR_PRICE_LIST Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CTS_PRICE_LIST_SITES Call by reference Type reference (TYPE) DMF_TS_ART_PL_DC_SITE sites for price list / article / distribution chain (sorted) 20121029
2 Importing IS_PROMO_ITEM Call by reference Type reference (TYPE) DMF_S_PROMO_ITEM promo item data from WAKP 20120823

Method SELECT_SITES_FOR_PRICE_LIST on class CL_DMF_OFFER_DB has no exception.

Method SELECT_SITE_DATA_FOR_CUSTOMER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_SITE_DATA Call by reference Type reference (TYPE) DMF_T_STORE_DATA table with site data 20120425
2 Importing IT_CUSTOMERS Call by reference Type reference (TYPE) DMF_T_PROMO_ART_SITE table with customer numbers 20120425

Method SELECT_SITE_DATA_FOR_CUSTOMER on class CL_DMF_OFFER_DB has no exception.

Method SELECT_SITE_DATA_FOR_DISTR_CHN Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ETS_DISTR_CHN_SITE_DATA Call by reference Type reference (TYPE) DMF_TS_DISTR_CHAIN_SITE main distribution chain assignment for sites (sorted) 20120725
2 Importing ITS_DISTRIBUTION_CHAINS Call by reference Type reference (TYPE) DMF_TS_DISTR_CHAIN_SITE main distribution chain assignment for sites (sorted) 20120725

Method SELECT_SITE_DATA_FOR_DISTR_CHN on class CL_DMF_OFFER_DB has no exception.

Method SELECT_SITE_DATA_FOR_SITES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_SITE_DATA Call by reference Type reference (TYPE) DMF_T_STORE_DATA table with site data 20130117
2 Importing IT_SITES Call by reference Type reference (TYPE) DMF_T_ART_SITE Sites 20130117

Method SELECT_SITE_DATA_FOR_SITES on class CL_DMF_OFFER_DB has no exception.

Method STORE_SELOPT_FOR_RE_INIT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_SELOPT Call by reference Type reference (TYPE) RSDS_SELOPT_T 20130108
2 Importing IV_APPLICATION Call by reference Type reference (TYPE) DRF_APPL Replication Model 20130108

Method STORE_SELOPT_FOR_RE_INIT on class CL_DMF_OFFER_DB has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 607