CORE - SAP Interface Process Flow

Diagram: https://app.diagrams.net/#G1y-kvF_vTRCxg1pJKVO6L07nzspPC7FpM





Questions to address in SAP interface

  1. Data mapping  -Fields needed to send to SAP (preferably automatically - not requiring User input) - see table below.
  2. What is the mandatory information to send a quote to SAP?
    1. if the information is missing, who will provide it?
    2. should we put the fields as mandatory?
  3. What other data points are CSR's checking before pushing data to SAP? what data is needed to display at Task object to be able to send the needed data in SAP
  4. Allocation of tasks for SAP data upload - Queue or specific individual
  5. What responses can we expect from SAP (error messages/etc)? (Nicolas Balbiani & HISLER, Olivier)
    1. how to handle the error messages - via a log record under the Opportunity?
  6. Loopback between CSR and Account Managers in case there are errors/discrepancies in data at OLI level - Chatter?
    1. error happening after sending the data to SAP - CSR to delete manually the entry in SAP - then correct in SF and re-send the data.
      1. how do CSR's identify an entry wrongfully sent to SAP in SAP (to be able to delete it?)


Data mapping  - Fields needed to send to SAP

Field Name

Salesforce field

Field Type

Salesforce Object

Price Valid From

SLV44_Quote_valid_from_internal_only__cdate

SLV44_ONE_Quote__c

Price Valid To

SLV44_Quote_valid_to_External__cdateSLV44_ONE_Quote__c
Sales OrganizationPP_SAP_Sales_Org__crestricted picklistSLV44_ONE_Quote__c
DivisionSLV44_SAP_Division__ctextSLV44_ONE_Quote_Line_Item__c
Distribution ChannelPP_SAP_Distr_Channel__crestricted picklistSLV44_ONE_Quote_Line_Item__c

Bracket From

PP_Bracket_From__c

double (18, 2)

SLV44_ONE_Quote_Line_Item__c

Bracket To

PP_Bracket_To__c

double (18, 2)

SLV44_ONE_Quote_Line_Item__c
IncotermsSLV44_Incoterms__crestricted picklistSLV44_ONE_Quote_Line_Item__c
Manufacturing PlantSLV44_Manufacturing_Plant__cIdSLV44_ONE_Quote_Line_Item__c
Shipping PlantSLV47_Shipping_Plants__cidSLV44_ONE_Quote_Line_Item__c
Manufacturing Plant NamePP_Manufacturing_Plant_Name__ctextSLV44_ONE_Quote_Line_Item__c
Shipping Plant NamePP_Shipping_Plant_Name__ctextSLV44_ONE_Quote_Line_Item__c
Quote Line Item IDIdIdSLV44_ONE_Quote_Line_Item__c

Bracket (From-To)

SLV44_Bracket_From_To__ctextSLV44_ONE_Quote_Line_Item__c
Annual VolumeSLV44_Estimated_Annual_Volume__cdouble (18, 2)SLV44_ONE_Quote_Line_Item__c
Quote IdSLV44_ONE_Quote__cIdSLV44_ONE_Quote__c

Product Level 4 (Product)

SLV44_Product_Level_4__cProduct2SLV44_ONE_Quote_Line_Item__c

Product Level 5 (Material)

SLV44_Product_Level_5__c

Product2SLV44_ONE_Quote_Line_Item__c

Quoted Price

SLV44_Quoted_Price__ccurrency (18, 2)SLV44_ONE_Quote_Line_Item__c
Currency Iso COdeSLV44_SAP_Cond_currency__ctextSLV44_ONE_Quote_Line_Item__c

Condition Type

SLV44_SAP_Condition_Type__ctextSLV44_ONE_Quote_Line_Item__c
Customer NumberSLV44_SAP_Customer__ctextSLV44_ONE_Quote_Line_Item__c
Customer NameSLV44_SAP_Name__ctextSLV44_ONE_Quote_Line_Item__c
Material NameSLV44_SAP_Material__ctextSLV44_ONE_Quote_Line_Item__c

Unit of measure

SLV44_SAP_Unit_of_measure__ctextSLV44_ONE_Quote_Line_Item__c

Valid From

SLV44_SAP_Valid_From__ctextSLV44_ONE_Quote_Line_Item__c

Valid To

SLV44_SAP_Valid__ctextSLV44_ONE_Quote_Line_Item__c

Ship-to

SLV44_Ship_to__cIdSLV44_ONE_Quote_Line_Item__c

Unit of Measurement

SLV44_Unit_of_Measurement__crestricted picklistSLV44_ONE_Quote_Line_Item__c
Lead TimeSLV49_Lead_Time__c

double (16, 0)

SLV44_ONE_Quote_Line_Item__c




Fields to save the response from SAP  -  to be created in Salesforce CORE

Field NameSalesforce fieldField TypeDescription

SAP Response

oli_SAP_Respon

text

Updated by CORE System, based on the integration status

SAP Integration In Progress, SAP Integration Completed, SAP Integration Failed,  Manually Created in SAP,  Closed - No action needed

SAP Response(Detail)

SAP_Response_Detail__ctextSave the answer coming from SAP