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

Compare with Current View Page History

« Previous Version 14 Next »

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


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


Field LabelData TypeFormulaSolution/CommentsDescription/Help
1Condition 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


Based on Sales Org Region
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.
2TableFormula (Text)"847"
SAP needed field - always with value 847
3Sales Org.Lookup(Solvay Sales Organization)

Not applicable

Data for determination of Sales Area (from where a Sales Organisation field could be infered) sits currently on Utility object, specifically RecType = Sales Area. Report in Prod.

New idea: to use 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. ChannelBased on Quote market + Number mapping
- HPC
- IPS
- Agro
- Amines
- Coatings

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


5IncotermsPicklistUsing Incoterms Global Value SetAlready exists - SLV44_Incoterms__c
6Customer groupText(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
8NameFormula (Text)SLV44_Ship_to__r.Name
SAP needed field - retrieves the Name of the Ship-To Account of the QLI
9Sold-To PartyText(255)

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

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

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

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

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

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

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

SAP needed field - default value is null
17MaterialFormula (Text)SLV44_Product_Level_5__r.ProductCode
SAP needed field - retrieves SAP Product Code from OQLI's Product
18DescriptionFormula (Text)SLV44_Product_Level_5__r.Name
SAP needed field - retrieves Product Name from OQLI's Product
19DivisionText(255)

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

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

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

SAP needed field - default value is null
24Basic materialText(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)SAP needed field - retrieves Quote's Currency ISO Code
28Pricing unitFormula (Number)1
SAP needed field - always with value 1
29Unit of measureQuote UoM
- LB
- KG
- To
- G		Solution TBD

30Scale UoMQuote UoM
- LB
- KG
- To
- G		Solution TBD

31Scale quantityFormula (Number)1
SAP needed field - always with value 1
32AmountQLI PriceSolution TBD

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

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

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

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

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

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

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

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

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

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

SAP needed field - default value is null
51

Name

Formula (Text)""

52Account groupFormula (Text)""

53CityFormula (Text)""

54RegionFormula (Text)""

55CountryFormula (Text)""

56Deletion flagFormula (Text)""

57Sales blockFormula (Text)""

58Order blockFormula (Text)""

59Del.ID SlsAreaFormula (Text)""

60Sales blockFormula (Text)""

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

62Price ListFormula (Text)""

63IncotermsFormula (Text)""

64Customer groupFormula (Text)""

65Price groupFormula (Text)""

66Sales GroupFormula (Text)""

67

Description

Formula (Text)""

68Letter ?Formula (Text)""

69Cust/Sales AreaFormula (Text)""

70X-DChain statusFormula (Text)""

71DF client levelFormula (Text)""

72DChain-spec.Formula (Text)""

73Deletion Ind.Formula (Text)""

74DF plant levelFormula (Text)""

75Mat/PlantFormula (Text)""

76Search termFormula (Text)""

77Scale typeFormula (Text)"A"

78Scale basisFormula (Text)"C"

79Proc. statusFormula (Text)""

80SMART Reference#Formula (Text)""

81Price justificationFormula (Text)SLV44_ONE_Quote_Line_Item__c.Name + Quote owner

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

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

84Created ByFormula (Text)""

85Created OnFormula (Text)""

86Prop.ship.pointFormula (Text)""

  • No labels