Data Model
Data Model
Value Chain: revenue and costs categorized in certain ways that allows analysis accross the valu
Allowing flexibility 1) support the "cost to serve model" while allowing flexibility to support other future reportin
to support other 2)developments
facilitate integration, harmonization standardization and simplication throughout the value
future reporting We should not "close doors" for possible future while designing the solutions.
Common data objects are requires across these 5 pillars marked below
requirements.
Siemens Energy Value Chain
phase 2: Sales/Marketing
phase 1: R&D phase 3: Supply chain
portfolio management Lead generation S&OP
requirement Technology development Opportunities Purchasing
example sales forecasting
product development production
contract negotiations delivery
contract management
FiCo
FiCo
FiCo
FiCo
FiCo
FiCo
FiCo
11 service, projects, sales to be FiCo
informed.
6 CoPa FiCo
7 FiCo
10 CoPa FiCo
13 FiCo
14 FiCo
23 FiCo
production example
- please complete support CTS model Fico with production FiCo
list (Eric B)
project datamode
example - please
complete list: support CTS model FiCo with projects FiCo
Matthias
nue and costs categorized in certain ways that allows analysis accross the value chain in order to
cost to serve model" while allowing flexibility to support other future reporting requirements.
gration, harmonization
hile designing standardization and simplication throughout the value chain processes.
the solutions.
Common data objects are requires across these 5 pillars marked below
phase5: Service
phase 4: Commercial projects training
Project planning and execution operate
design and engineering monitoring
construction maintenance
installation & Commissioning repair
upps & mods
Material number C
Business Relationship
Reflecting the business relationship with the customer
- New Installed Base Business: New Unit will come from the equipment and this will be at line item open
- Existing Installed Base Business: after market level. User status
Precondition: need to check how installed based is represented in the
new S4 system.
will come from the equipment and this will be at line item
level. User status =NEW of top level Equipment (installed
New Installed Base based). Equipment Status is under discussion. Check with open
Mathias.
When do they create a New equipment
will come from the equipment and this will be at line item
level. User status = Delivered or PAC of top level Equipment
Addition To Existing Installed Base (installed based). Equipment Status is under discussion. open
Check with Mathias.
will come from the equipment and this will be at line item
level. User status = "handed over to service” of top level
Servicing Existing Installed Base Equipment (installed based). Equipment Status is under open
discussion. Check with Mathias.
Type of service
Using the division in the line item might work as long as we clearly
separate the service types from the GPU's
The GPU in the master record of the equipment is being used to
derive the GPU for the work done. This is not the same as the type of
work.
Type of service
SV - Consulting
SV - Design open
SV - Build
SV - Operate
SV - Maintenance
SV - Digital Services
SV - Rentals
SV - Recycling
SV - Training
SV - Finance
Document Type
Identifies The Sales Process
Inquiry
Quotation Sales Header – Order Type
Contract done
Delivery Ok, Order type; decided.
Billing
Return
Credit Memo
Customer Type
Private Company
Derived from Customer master
Public Company
Should be a certain field, but field not decided. Need to follow
Semi-Public Company done
up with Daniel Reisberger. Sales will follow up.
Government Owned Entity
Semi-Government Entity Needs to be on general data
Government Entity
Product Grouping
Reflecting Major Product Groups Sales item (Product Hierarchy)
Based on Energy Value Chain Clear KDD for product hierarchy approved. done
Organizational Agnostic
Assumption: The sales document driven sourcing will only be
controlled by item category (partially true).
Type of Sourcing Reflecting the type of sourcing Procurement key, strategy group and MRP group will not
Purchased From Stock – not available impact the sales document behavior.
Purchased To Order (yes – ITC)
Sell From Stock – not available Purchased From Stock – not available
Make To Order (yes, ITC) Purchased To Order (yes – ITC)
Configured To Order – not discussed yet. Sell From Stock – not available done
Engineered To Order – Not in sales order (WBS) Make To Order (yes, ITC)
Systems Project To Order – Not in sales order (WBS) Configured To Order – not discussed yet.
Solutions Project To Order – Not in sales order (WBS) Engineered To Order – Not in sales order (WBS)
Systems Project To Order – Not in sales order (WBS)
Solutions Project To Order – Not in sales order (WBS)
2022-12-13 Sales:
What kind of plant is meant? Delivering plant is available.
Sourcing plant from Stock Transfer Order is not available.
Supplier comes from purchase order or production order but
Supplier
not from sales document.
Vendor 4711
Work item explaining the limitations of current set-up in Sales:
Vendor 4712
Plant 4711 - Only delivering plant
Plant 4713 - Only Vendor in case of Purchase order directly linked to done
sales order item
what & why?
- NO link available to find OEM (e.g. plant in different
company code).
- No link in case the part is purchased to stock. Not needed.
- How far back in the supply chain do you want to go?
action: FiCo to determine the requirements: what is needed
and why?
extract from system. all tables that have accounting impact need to Different tables, Not a datamodel requirement.suggest to pick
be tagged. need to have dataviews on all audit critical data. define all open
up as a FiCo requirement
tables that are not SAP standard.
EU-Taxonomie more specification needed open
External Sales needs to be reported with EU-Tax-Codes
Pending Contracts/ Rejecter
Customer has not agreed to the transfer of the contract from Siemens Only small quantity of contract left, so possible that is not
AG to Siemens Energy; Legacy from Carve Out needed anymore after migration to S4. parked
No datamodel topic, part of datamigration for each roll-out.
Within the supply chain the Cost to Serve model reflects the
main activities performed and executed in an E2E manner:
0) Materials
1) Mfg Support
2) Customer Order Engineering
3) Procurement
4) Logistics
5) Order Planning & Execution
6) Mfg Support
7) Manufacturing
8) QM Testing
Production datamodel 9) Delivery
done
related to point 4 type of work ype of service
The costs of bringing purchased materials to its storage
location are reflected as MM Condition Types in the regular
PO. These values get posted at the time of GR and thereby
updating inventory values correctly with all the relevant costs
of bringing it to its location.
On production orders the activities are represented by activity
types and used for hour sconfirmation, overhead charges and
business process charges.
Project datamodel:
WUPID ID, used in CoPa WUPID is derieved from the sales order...etc etc and then visibl done
SEEM relevant Other teams
SAP Technical field Prio Action Action owner
Go live october involved
Controling,
Sales -Parag, Need to involve
H yes Folow up needed Peter, Boris. Project, service
once sales comes
with a proposal
VBAP-PRODH (Product
Hierarchy) H yes define SAP field Parag
L no controling to check FICo sales & projects
M no investigate Controling
no
no
WI Work package
1000005531
1000005527
WI - implement DART
phase 1: R&D phase 2: Sales/Marketing phase 3: Supply chain
Lead generation
portfolio management S&OP
requirement example Technology development Opportunities Purchasing
sales forecasting
product development production
contract negotiations delivery
contract management
same material used accross the value chain Material number A Material number B
contract number visible accross the value chain customer contract number ? customer contract number
Internal/external sales
Busines type x x
phase5: Service
phase 4: Commercial projects training
Project planning and execution operate
design and engineering monitoring
construction maintenance
installation & Commissioning repair
upps & mods
Material number C
x x