You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

Identified data points needed for SAP push (originally in GSheet)


Sample Data as provided by Anita: Sample records to upload to SAP


SAP needed fields to push into One Quote Report and Export



Field LabelAPI NameData TypeFormulaSolution/CommentsDescription/Help
1Condition TypeSAP_Condition_Type

Formula (Text)

Solvay_Sales_Organization__r.Condition_Type__c

Condition Type will be a required picklist field on Solvay Sales Organization object - each Sales Org will have its own Condition Type - data defined by Business

OQLI retrieves its Condition Type from the linked Sales Org:

  • Sales Org EMEA: PR00
  • Sales Org APAC: PR00
  • Sales Org NAM: ZPRI
  • Sales Org LAM: PR00
  • Sales Org BR: ZPB0
  • Sales Org IN: PRIN
SAP needed field - used to retrieve Condition Type from Solvay Sales Organization record.
2TableSAP_Table__cFormula (Text)"847"
SAP needed field - always with value 847
3Sales Org.SAP_Sales_Org__cLookup (Solvay Sales Organization)

Not applicable

Using 2 new objects that will allow to create a Master List of Sales Organizations (Solvay Sales Organization) - and using a junction object called Sales Org Key) to allow each OQLI to find it's own Sales Organization Code.

see Solvay Sales Organization & Condition Type 

SAP needed field - Identifies the specific Sales Organization associated with this QLI (defined via a combination of Shipping Plant, Ship-To Country and Incoterm).
4Distr. ChannelSAP_Distr_Channel__cFormula (Text)

CASE( SLV44_ONE_Quote__r.SLV44_BU__c ,
"Agro", "9",
"Amines", "8A",
"Coatings", "10",
"Industrial Solutions", "7",
"Non Allocated", "6X",
"Home & Personal Care",

CASE( HPC_Selection__c,
"Home Care", "17",
"Personal Care", "16",
"Undefined"), "Undefined")

Based on One Quote BU - Number mapping as per below

For HPC, create 2 lines for upload: (1) Personal Care & (2) Home Care

If Quote's BU is Home & Personal Care, Pricing Admin Users will have to define each OQLI as being either Home Care or Personal Care - see Home & Personal Care - HPC Selection

SAP needed field - derived from One Quote's BU value (plus HPC Selection when BU is Home & Personal Care)
5IncotermsSLV44_Incoterms__cPicklist
Existing field in OQLI - Using Incoterms Global Value Set
6Customer group
Text(255)""
SAP needed field - default value is null
7Customer

Formula (Text)

SLV44_Ship_to__r.RCS_ID__c

Pedro Infante to check if Ship-To codes of this Sheet exist in Core Prod as RCS Ids of SAP RT Accounts

6 records from data sent by NOE, Juliendo not exist in SF Prod (RCS ID not found)

SAP needed field - retrieves the RCS ID of the Ship-To Account of the QLI
8Name
Formula (Text)SLV44_Ship_to__r.Name
SAP needed field - retrieves the Name of the Ship-To Account of the QLI
9Sold-To Party
Text(255)

SAP needed field - default value is null
10Sold-to Name
Text(255)

SAP needed field - default value is null
11Ship-To Party
Text(255)

SAP needed field - default value is null
12Ship-to Name
Text(255)

SAP needed field - default value is null
13Price List
Text(255)

SAP needed field - default value is null
14Doc. Currency
Text(255)

SAP needed field - default value is null
15Price group
Text(255)

SAP needed field - default value is null
16Mat.pricing grp
Text(255)

SAP needed field - default value is null
17Material
Formula (Text)SLV44_Product_Level_5__r.ProductCode
SAP needed field - retrieves SAP Product Code from OQLI's Product
18Description
Formula (Text)SLV44_Product_Level_5__r.Name
SAP needed field - retrieves Product Name from OQLI's Product
19Division
Text(255)

SAP needed field - default value is null
20Plant
Formula (Text)SLV44_Shipping_Plant__r.Name
SAP needed field - retrieves Shipping Plant Name from OQLI's Shipping Plant
21Sales Office
Text(255)

SAP needed field - default value is null
22Country
Text(255)

SAP needed field - default value is null
23Sales Unit
Text(255)

SAP needed field - default value is null
24Basic material
Text(255)

SAP needed field - default value is null
25Valid From

Valid From Date (internal) in dd.mm.yyyy

Solution TBD

26Valid To

Valid To Date (internal) in dd.mm.yyyy

Solution TBD

27Cond. currency

Formula (Text)

TEXT(SLV44_ONE_Quote__r.CurrencyIsoCode)Quote Currency (Triletter code - USD, EUR, CNY - Salesforce uses the ISO Standard and so does SAP - no need to translate)SAP needed field - retrieves Quote's Currency ISO Code
28Pricing unit
Formula (Number)1
SAP needed field - always with value 1
29Unit of measure

Quote UoM
- Lb (SAP = LB)
- Kg (SAP = KG)
- T (SAP =  TO)
- G (SAP = ???)

NOE, Julien - what is the denomination that SAP gives to grams?

Solution TBD

30Scale UoM

Quote UoM
- Lb (SAP = LB)
- Kg (SAP = KG)
- T (SAP =  TO)
- G (SAP = ???)

NOE, Julien - what is the denomination that SAP gives to grams?

Solution TBD

31Scale quantity
Formula (Number)1
SAP needed field - always with value 1
32Amount
QLI PriceSolution TBD

33Scale quantity
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
34Amount
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
35Scale quantity
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
36Amount
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
37Scale quantity
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
38Amount
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
39Scale quantity
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
40Amount
Text(255)
Default value null - field will be re-used once Order Release Pricing (post-MVP) is builtSAP needed field - default value is null
41Scale quantity
Text(255)

SAP needed field - default value is null
42Amount
Text(255)

SAP needed field - default value is null
43Scale quantity
Text(255)

SAP needed field - default value is null
44Amount
Text(255)

SAP needed field - default value is null
45Scale quantity
Text(255)

SAP needed field - default value is null
46Amount
Text(255)

SAP needed field - default value is null
47Scale quantity
Text(255)

SAP needed field - default value is null
48Amount
Text(255)

SAP needed field - default value is null
49Scale quantity
Text(255)

SAP needed field - default value is null
50Amount
Text(255)

SAP needed field - default value is null
51

Name


Formula (Text)""

52Account group
Text(255)

SAP needed field - default value is null
53City
Text(255)

SAP needed field - default value is null
54Region
Text(255)

SAP needed field - default value is null
55Country
Formula (Text)""

56Deletion flag
Text(255)

SAP needed field - default value is null
57Sales block
Text(255)

SAP needed field - default value is null
58Order block
Text(255)

SAP needed field - default value is null
59Del.ID SlsArea
Text(255)

SAP needed field - default value is null
60Sales block
Formula (Text)""

61Ord.blk:sls ar.
Formula (Text)""

62Price List
Formula (Text)""

63Incoterms
Text(255)

SAP needed field - default value is null
64Customer group
Formula (Text)""

65Price group
Formula (Text)""

66Sales Group
Text(255)

SAP needed field - default value is null
67

Description


Formula (Text)""

68Letter ?
Formula (Text)""

69Cust/Sales Area
Text(255)

SAP needed field - default value is null
70X-DChain status
Text(255)

SAP needed field - default value is null
71DF client level
Text(255)

SAP needed field - default value is null
72DChain-spec.
Text(255)

SAP needed field - default value is null
73Deletion Ind.
Text(255)

SAP needed field - default value is null
74DF plant level
Text(255)

SAP needed field - default value is null
75Mat/Plant
Text(255)

SAP needed field - default value is null
76Search term
Text(255)

SAP needed field - default value is null
77Scale type
Formula (Text)"A"

78Scale basis
Formula (Text)"C"

79Proc. status
Text(255)

SAP needed field - default value is null
80SMART Reference#
Text(255)

SAP needed field - default value is null
81Price justification
Formula (Text)SLV44_ONE_Quote_Line_Item__c.Name + Quote owner

82Exp. Ann. Volume
Formula (Text)Quote Created Date + Quote Auto-Number Name

83Cond.record no.
Formula (Text)""

84Created By
Formula (Text)""

85Created On
Formula (Text)""

86Prop.ship.point
Formula (Text)""

Extra Fields for One Quote Line Item


Field LabelAPI NameData TypeFormulaSolution/CommentsDescription/Help
1HPC SelectionHPC_Selection__c

Picklist

Not applicable

Restrict picklist to the values defined in the value set = TRUE

Not Required

No default value

  • Home Care
  • Personal Care
For Pricing Admins to determine which Distribution Channel needs to be defined for Quotes where BU is HPC
  • No labels