converstion

Former Member — Fri, 05 Oct 2007 05:04:33 GMT

The scope of this document is to provide the mapping of the legacy fields for the CORE Team to produce an extract from PROM98 (legacy promotional system) in order for the Technical Team to upload this extract into DISCO SAP Project Systems.

When the CORE Team has created the extract, the file will have to be given to the Business Teams (Trade Communications, Sales Planning & Trade Fund Management) & DISCO IT in order for some of the fields to be manually updated prior to being loaded into SAP.

Note – This spec does not include any ASAP promotions, as they will be a manual conversion.

1.2 General Description of Functionality

Legacy (CORE) will create an extract file that will contain data elements that will be used to map directly into SAP, the layout of the extract file may be in a FTP file.

Key:- TBM = To Be Mapped by Business & IT after CORE extract

Excel – SP = Excel spreadsheet to be provided by Sales Planning

Excel – TFM = Excel spreadsheet to be provided by Trade Fund Management

Source Field Field Name Data Type / Length Field Name Table Field Data Type / Length

TBM Project Definition PROJ

PSPID CHAR 24

PROMO98 Promotion Description SPROMO – PMPRDS A 50 Description PROJ POST1 CHAR 40

Source Field Field Name Data Type / Length Field Name Table Field Data Type / Length

TBM Person Responsible PROJ VERNR NUMC 8

PROMO98 Promotion Start Date SPROMO - PMPRSD Date Start date PROJ PLFAZ DATS 8

PROMO98 Published Order End Date SPROMO-PMORED Date Finish date PROJ PLSEZ DATS 8

PROMO98 Promotion Description SPROMO – PMPRDS A 50 Project Profile PROJ PROFL CHAR 7

TBM Std WBS Template PRPS SPSNR NUMC 8

TBM Project Type PROJ

ZZPROJTYP

Numc 2

TBM Project Identity PROJ ZZPROIDT

Numc 2

PROMO98 Will Call date SPROMO- PMWCDT P 8 Promo Street Date PROJ ZZPROMSTDT

Dats 8

Excel - SP Internal Announce Date PROJ ZZINTANDT

Dats 8

Excel - SP OCAD PROJ ZZOCAD

Dats 8

PROMO98 Announce date SPROMO-PMANDT P 8 External Announce Date PROJ ZZEXTANDT

Dats 8

TBM Moratorium PROJ ZZMORAT Dats 8

TBM Cancelled for Siebel PROJ ZZCANSEIB

checkbox

TBM Force to Siebel PROJ ZZFORSEIB

checkbox

Source Field Field Name Data Type / Length Field Name Table Field Data Type / Length

PROM98 See rules attached Country PROJ ZZCTRY Numc 2

Excel - SP Product Category PROJ ZZPRODCAT

Numc 2

Excel - SP Product Sub -Category PROJ ZZPRODSCAT

Numc 3

Excel - SP Brand PROJ ZZBRAND Numc 2

Excel - SP US Rating PROJ ZZUSRATE Numc 2

Excel - SP Theatrical Release date PROJ ZZTHRELDT

Dats 8

Excel – SP

NA Projected GBO PROJ ZZNAPRGBO

Numc 11

Excel - SP NA Final GBO PROJ ZZNAFNLGBO

Numc 11

Excel - SP CAN Projected GBO PROJ ZZCANPRGBO

Numc 11

Excel - SP CAN Final GBO PROJ ZZCANFNLGBO

Numc 11

Excel - SP SP Coding PROJ ZZSPCODE Numc 2

Excel - SP Published Goal PROJ ZZPUBGL Char 1

Excel – SP Sales Goal PROJ ZZSALESGL Numc 11

Excel – SP Goal Length PROJ ZZGLLTH Alpha/numc 2

Excel – SP Indirect Goal PROJ ZZINDGL Char 1

Excel - SP Goal Publish Date PROJ ZZGLPUBDT

Dats 8

Excel - SP Promo Code Comp 2 PROJ ZZPROCOM2 Char 24

Source Field Field Name Data Type / Length Field Name Table Field Data Type / Length

Excel - SP Promo Code Comp 3 PROJ ZZPROCOM3

Char 24

Excel - SP Promo Code Comp 4 PROJ ZZPROCOM4

Char 24

Excel - SP Name Of Buddy Title PROJ ZZBUDTITL Char 40

Excel - TFM SPF – Distributor Rebates (%) PROJ ZZSPFDISTREB

Numc 5

Excel - TFM SPF – National Programs (%) PROJ ZZSPFNATPG

Numc 5

Excel - TFM Customer Specific Trade Fund (CSTF) (%) PROJ ZZCSTF

Numc 5

Excel - TFM Customer Specific Marketing Fund (CSMF) * (%) PROJ ZZCSMF

Numc 5

Excel - TFM Total Trade Spend (%) PROJ ZZTSTOTAL Numc 5

Excel - TFM Co-op advertising (%) PROJ ZZCOOPAD

Numc 5

Excel - TFM COGS – Trade Premiums (%) PROJ ZZCOGSTP

Numc 5

Excel - TFM COGS – Trade Premiums PROJ ZZCOGSTPAMT

Numc 11

Source Field Field Name Data Type / Length Field Name Table Field Data Type / Length

Excel - TFM Customer Rebates & Coupons PROJ ZZCUREBCPN

Numc 5

Excel - TFM Total CSMF (%) PROJ ZZCSMFTOTAL

Numc 5

Excel - TFM Announce Trade Spend (%) PROJ ZZANNTS

Numc 5

Excel - TFM TS Customizable Coupon US (Amount) PROJ ZZTSUSCPN

Numc 11

Excel - TFM TS Customizable Coupon CAN (Amount) PROJ ZZTSCANCPN

Numc 11

Excel - TFM Brand Customizable Coupon US (Amount) PROJ ZZBRUSCPN

Numc 11

Excel - TFM Brand Customizable Coupon CAN (Amount) PROJ ZZBRCANCPN

Numc 11

PROMO98 Product Number SPRMPR-PPPROD A 18 Material Number PRPS ZZMATNR Char 18

PROMO98 Min Adver Price SPRMPR-PPMAP P 7 MAP PRPS ZZMAP Numc 9

Dec 2

PROMO98 Promotion Number SPROMO-PMPROM A 10 PROMO98# PRPS ZZOLDID Alpha/num 30

Rules

• DIS Promotion derivation

To determine if the Project Profile is BVHE (Z000001) or DIS (Z000002) the following logic has to be applied:-

DIS promotions are identified by the Promotion description of:-

DIS – Promo title e.g. DI - DISNEY'S ZOOG GENIUS II (8/01), DI - CHRONICLES OF NARNIA: LWW GC (11/05), DI - LIZZIE MCGUIRE 2 GBA (10/04)

As opposed to BVHE Promotion Description of e.g. SWEET HOME ALABAMA - FRENCH (2/03),

DEJA VU (4/07), ABOUT ADAM (10/01)

• Country determination on the Project Definition level

In PROMO98 the country is identified at the Product (material level) which is the lowest level on the promotion. We need the logic to determine the country info at the Project Definition level, highest level on the project. The following logic will apply in order to derive this info:-

File: SPRMPC Promoted Product Country

Field T Len Fd Dd E Pr From To Text

P2PROM A 10 10 1 10 PROMOTION NUMBER

P2CTRY A 11 11 11 21 COUNTRY

P2PROD A 18 18 22 39 PRODUCT NUMBER

Steps for completion of extract file and subsequent upload file

1) Extract data from PROMO98 in the format identified above.

2) Identify DIS Promotions using the above rule logic

3) Identify Country using the above rule logic

4) The following tasks will be performed by the Business and IT Disco team:-

a. Incorporate data from the Excel spreadsheet to be prepared from both Sales Planning and Trade Fund Management for BVHE only

b. Perform the mapping of the old field values to SAP field values e.g. material# , new Z custom table fields etc.

c. Extract all the material #’s and create a separate upload files, for BVHE and DIS in order to upload the 2 Non-Promoted Projects with all materials. There will be separate Project Templates for ‘Non-Promoted BVHE’ and ‘Non-Promoted DIS’.

4.2.5 Relevant SAP Fields

Fields to be populated through Inbound Interface or Conversion (into SAP) / Fields to be sent out through Outbound interface (from SAP)

SAP Transaction code CJ20N – Project Builder

Screen

Sample document(s) <document numbers>

SAP system/Client for sample docs <system details>

VIEW FIELD NAME TABLE FIELD DESCRIPTION REQUIRED/Optional USE/EXPLANATION

Initial Screen Project Definition PROJ PSPID Project # REQUIRED Enter the number of the project for which you want to create

Initial Screen Description PROJ POST1 Description of Project REQUIRED Enter the project description

Initial Screen Start PROJ PLFAZ Start date of Project REQUIRED Enter the Start date of Project

Initial Screen Finish Date PROJ PLSEZ End date of Project REQUIRED Enter the End date of Project

Initial Screen Project Profile PROJ PROFL Project Profile REQUIRED Enter the Project Profile (Z000001 = BVHE and Z000002 = DIS)

Initial Screen St Proj Def. PRPS SPSNR Standard template REQUIRED Enter the template for the project

SAP Transaction code CJ20N – Project Builder

Screen 2 – Project definition

Screen

Sample document(s) <document numbers>

VIEW FIELD NAME TABLE FIELD DESCRIPTION REQUIRED/Optional USE/EXPLANATION

Screen 2 Person Respons. PROJ VERNR Responsible Person REQUIRED Enter the contact for Brand from the drop down e.g Tom Stockemer

Screen 3 -5 Project Definition

There will be 4 additional new tabs that will need to be populated (see EFIC1004 - Add'l fields in PROJ & PRPS) ASAP Promotions are not included in this conversion therefore the tab will not be converted.

Screen 3 - Trade Communications Tab

VIEW Field Name Table Field DESCRIPTION REQUIRED/Optional USE/EXPLANATION

Screen 3 Project Type PROJ ZZPROJTYP

Project Type REQUIRED Enter the Project Type for the project, e.g. New Release, Repromote, Reprice, catalog etc.

Screen 3 Project Identity PROJ ZZPROIDT

Project Identity REQUIRED Enter the Project Identity for the project, e.g. Promoted or Non-Promoted.

Screen 3 Promo Street Date PROJ ZZPROMSTDT

Promo Street Date REQUIRED Enter the Promotion Street Date

Screen 3 Internal Announce Date PROJ ZZINTANDT

Internal Announce Date Optional Enter Internal Announce Date

Screen 3 OCAD PROJ ZZOCAD

OCAD Optional Enter OCAD date

Screen 3 External Announce Date PROJ ZZEXTANDT

External Announce Date Optional Enter External Announce Date

Screen 3 Moratorium PROJ ZZMORAT Moratorium Optional Enter Moratorium date, if applicable.

Screen 3 Cancelled for Siebel PROJ ZZCANSEIB

Cancelled for Siebel Optional Check this box if the promotion is cancelled (this is for Siebel purposes and will be sent in the interface to Siebel)

Screen 3 Force to Siebel PROJ ZZFORSEIB

Force to Siebel Optional Check this box if the promotion should be sent to Siebel before it has been ‘released’ (this is for Siebel purposes and will be sent in the interface to Siebel)

Screen 3 Country PROJ ZZCTRY Country Optional Enter Country for promotion

Screen 4 - Sales Planning tab

VIEW Field Name Table Field DESCRIPTION REQUIRED/Optional USE/EXPLANATION

Screen 4 Product Category PROJ ZZPRODCAT

Product Category Optional Enter Product Category of promotion e.g. Theatrical, Direct To Video, TV etc.

Screen 4 Product Sub -Category PROJ ZZPRODSCAT

Product Sub -Category Optional Enter Product Sub-category e.g. Live action, animation etc.

Screen 4 Brand PROJ ZZBRAND Brand Optional Enter Brand e.g. Miramax, Touchstone, Disney, etc.

Screen 4 US Rating PROJ ZZUSRATE US Rating Optional Enter US rating for promotion e.g. PG, PG-13, NR, R, etc.

Screen 4 Theatrical Release date PROJ ZZTHRELDT

Theatrical Release date Optional Enter the Theatrical Release date

Screen 4 NA Projected GBO PROJ ZZNAPRGBO

NA Projected GBO Optional Enter NA Projected GBO (Gross Box Office)

Screen 4 NA Final GBO PROJ ZZNAFNLGBO

NA Final GBO Optional Enter NA Final GBO (Gross Box Office)

Screen 4 CAN Projected GBO PROJ ZZCANPRGBO

CAN Projected GBO Optional Enter CAN Projected GBO (Gross Box Office)

Screen 4 CAN Final GBO PROJ ZZCANFNLGBO

CAN Final GBO Optional Enter CAN Final GBO (Gross Box Office)

Screen 4 SP Coding PROJ ZZSPCODE SP Coding Optional Enter SP Coding e.g. Goaled Promotion - non-catalog, Catalog - no goal, Goaled Promotion - catalog, Special etc.

Screen 4 Published Goal PROJ ZZPUBGL Published Goal Optional Enter Published Goal, Y or N

Screen 4 Goal Length PROJ ZZGLLTH Goal Length Optional Enter Goal Length, 1, 12, y, n etc.

Screen 4 Indirect Goal PROJ ZZINDGL Indirect Goal Optional Enter y or n for Indirect Goal

Screen 4 Goal Publish Date PROJ ZZGLPUBDT

Goal Publish Date Optional Enter Goal Publish Date if applicable

Screen 4 Promo Code Comp 1 PROJ ZZPROCOM1

Promo Code Comp 1 Optional Enter applicable Promo Code Comp 1

Screen 4 Promo Code Comp 2 PROJ ZZPROCOM2 Promo Code Comp 2 Optional Enter applicable Promo Code Comp 2

Screen 4 Promo Code Comp 3 PROJ ZZPROCOM3

Promo Code Comp 3 Optional Enter applicable Promo Code Comp 3

Screen 4 Promo Code Comp 4 PROJ ZZPROCOM4

Promo Code Comp 4 Optional Enter applicable Promo Code Comp 4

Screen 4 Name Of Buddy Title PROJ ZZBUDTITL Name Of Buddy Title Optional Enter applicable Name Of Buddy Title

Screen 5 - Trade Fund Management Tab

VIEW Field Name Table Field DESCRIPTION REQUIRED/Optional USE/EXPLANATION

Screen 5 SPF – Distributor Rebates (%) PROJ ZZSPFDISTREB

SPF – Distributor Rebates (%) Optional Enter SPF – Distributor Rebates (%)

Screen 5 SPF – National Programs % PROJ ZZSPFNATPG

SPF – National Programs % Optional Enter SPF – National Programs %

Screen 5 Customer Specific Trade Fund (CSTF) (%) PROJ ZZCSTF

Customer Specific Trade Fund (CSTF) (%) Optional Enter Customer Specific Trade Fund (CSTF) (%)

Screen 5 Customer Specific Marketing Fund (CSMF) (%) * PROJ ZZCSMF

Customer Specific Marketing Fund (CSMF) (%) * Optional Enter Customer Specific Marketing Fund (CSMF) (%) *

Screen 5 Co-op advertising (%) PROJ ZZCOOPAD

Co-op advertising (%) Optional Enter Co-op advertising (%)

Screen 5 COGS – Trade Premiums (%) PROJ ZZCOGSTP

COGS – Trade Premiums (%) Optional Enter COGS – Trade Premiums (%)

Screen 5 COGS – Trade Premiums PROJ ZZCOGSTPAMT

COGS – Trade Premiums Optional Enter COGS – Trade Premiums

Screen 5 Customer Rebates & Coupons (%) PROJ ZZCUREBCPN

Customer Rebates & Coupons (%) Optional Enter Customer Rebates & Coupons (%)

Screen 5 Announce Trade Spend (%) PROJ ZZANNTS

Announce Trade Spend (%) Optional Enter Announce Trade Spend (%)

Screen 5 TS Customizable Coupon US (Amount) PROJ ZZTSUSCPN

TS Customizable Coupon US (Amount) Optional Enter the amount for TS Customizable Coupon US

Screen 5 TS Customizable Coupon CAN (Amount) PROJ ZZTSCANCPN

TS Customizable Coupon CAN (Amount) Optional Enter the amount for TS Customizable Coupon CAN

Screen 5 Brand Customizable Coupon US (Amount) PROJ ZZBRUSCPN

Brand Customizable Coupon US (Amount) Optional Enter the amount for Brand Customizable Coupon US

Screen 5 Brand Customizable Coupon CAN (Amount) PROJ ZZBRCANCPN

Brand Customizable Coupon CAN (Amount) Optional Enter the amount for Brand Customizable Coupon CAN

SAP Transaction code CJ20N – Project Builder

Screen 6 WBS Elements

Screen

Sample document(s) <document numbers>

Screen 6 – Trade Communications

VIEW Field Name Table Field DESCRIPTION REQUIRED/Optional USE/EXPLANATION

Screen 6 Material Number PRPS ZZMATNR Material Number Optional Enter the material # for the product

Screen 6 MAP PRPS ZZMAP MAP Optional Enter the MAP (minimum advertised price) for the product (material)

Screen 6 PROMO98# PRPS ZZOLDID PROMO98# Optional Enter the PROMO98 old code for the promotion

CURRENT PROMOTIONS SYSTEM (PROMO98) INFO

Full System DB Relationships

Relevant Files

SPROMO

SPROMO is the promotions header master record.

K Field T Len Fd Dd E Pr From To Text

1 PMPROM A 10 1 10 PROMOTION NUMBER

PMPRGR P 5 0 0 L 11 13 PROMO GROUP

PMPRDS A 50 14 63 PROMOTION DESCRIPTION

PMPRSD P 8 0 0 L 64 68 PROMOTION START DATE

PMWCDT P 8 0 0 L 69 73 WILL CALL DATE

PMAVDT P 8 0 0 L 74 78 AVAILABILITY DATE

PMANDT P 8 0 0 L 79 83 ANNOUNCE DATE

PMORDT P 8 0 0 L 84 88 ORDER DATE

PMPRDT P 8 0 0 L 89 93 PREBOOK DATE

PMORED P 8 0 0 L 94 98 PUBLISHED ORDER END DATE

PMRTSD P 8 0 0 L 99 103 RETURN START DATE

PMRTED P 8 0 0 L 104 108 RETURN END DATE

PMARSD P 8 0 0 L 109 113 AD RUN START DATE

PMARED P 8 0 0 L 114 118 AD RUN END DATE

PMPOSD P 8 0 0 L 119 123 POS START DATE

PMPOED P 8 0 0 L 124 128 POS END DATE

PMFACD P 8 0 0 L 129 133 FINAL AD CLAIMS DATE

PMYRRN A 1 134 134 YEAR-ROUND - Y/N

PMRTST A 1 135 135 RENTAL/SELL-THRU

PMHTNH A 1 136 136 HIT/NON-HIT

PMCOEM P 5 0 0 L 137 139 CO-OP EXPIRE MONTHS

PMRTEM P 5 0 0 L 140 142 RETURN EXPIRE MONTHS

PMANLT P 7 0 0 L 143 146 ANNOUNCED LETTER #

PMSTS A 1 147 147 STATUS

PMGRAC* P 2 0 0 L 148 149 GRACE PERIOD #

PMVIOL** A 1 150 150 COOP VIOLATION FLAG

PMLSUP A 12 151 162 LAST UPDATED YYMMDDhhmmss

Notes:

PMGRAC is now used to identify cancelled promotions that should not be published by BIZ and should not be used to stamp orders (value ‘9’). It is ignored by the feed to Siebel as cancelled promotions may have had customer activity for which we are liable.

PMVIOL is now used to force unannounced promotions to Siebel (value ‘S’).

SPRMPR

SPRMPR is the promotions promoted products detail record.

K Field T Len Fd Dd E Pr From To Text

1 PPPROM A 10 1 10 PROMOTION NUMBER

2 PPPROD A 18 11 28 PRODUCT NUMBER

PPPRSD P 8 0 0 L 29 33 PROMOTION START DATE

PPARSD P 8 0 0 L 34 38 AD RUN START DATE

PPARED P 8 0 0 L 39 43 AD RUN END DATE

PPRTSD P 8 0 0 L 44 48 RETURN START DATE

PPNAAD P 8 0 0 L 49 53 NAAD

PPMAP P 7 2 2 L 54 57 MIN ADVER PRICE

PPMAPD P 8 0 0 L 58 62 MAP EXP DATE

PPNEW A 1 63 63 NEW PRODUCT? - Y/N

SCPRMG

SCPRMG is currently used to store Goals by Promotion and Customer. Additionally it is used to store Shipments for Indirect Accounts.

K Field T Len Fd Dd E Pr From To Text

1 CGPROM A 10 1 10 PROMOTION NUMBER

2 CGCUST A 12 11 22 CUSTOMER NUMBER

3 CGGLRG P 5 0 0 L 23 25 GOAL RANGE NUMBER

CGGQTY P 9 0 0 L 26 30 GOAL QUANTITY

CGAQTY P 9 0 0 L 31 35 ACTUAL QUANTITY

CGGAMT P 11 2 2 L 36 41 GOAL AMOUNT

CGAAMT P 11 2 2 L 42 47 ACTUAL AMOUNT

CGQAIN A 1 48 48 QTY/AMT INDICATOR

CGEFGL A 1 49 49 EFFECTIVE GOAL INDICATOR

CGPROD A 18 50 67 PRODUCT ID

CGG1QT P 9 0 0 L 68 72 DAY 1 GOAL QTY

CGIACT A 30 73 102 Indirect Account

CGSQTY P 9 0 0 L 103 107 Indirect shipment Qty

CGTYPE A 1 108 108 Record Type G/S

topic converstion in Application Development and Automation Discussions

converstion

Re: converstion

Re: converstion