WRITTEN BY: supportmymoto.com STAFF
Choice tables are essential ideas in SAP HANA native modelling. Ideally once we are working with IBP and APO even ECC or S/4 HANA supply programs in SAP HANA Native modelling then undoubtedly one would possibly had created and used resolution tables.
Choice tables are form of ETL guidelines utilized on a Column. So it a desk with ETL guidelines wrapped in ti with Circumstances and Actions.
There are few details about Choice Desk however we should know once we want it and if in any respect we want Easy methods to do it. Beneath weblog submit Cleary illustrates the creation and utilization of DT in SAP HANA 2.0 SPS 04
Suppose Enterprise wish to plan reductions primarily based on some merchandise.
Earlier than giving or declaring the low cost the enterprise wish to analyze if we give the reductions will it give us revenue or loss and many others. Choice desk helps in instantly updating the worth or it returns sure motion on which enterprise can resolve on additional selections.
in such circumstances it ultimate to create a call desk.
Choice tables are of two sorts
1) Choice Desk Replace Worth.( When the consumer wish to change and replace the values in DB itself)
2) Choice desk Return Worth (If consumer wish to add new discipline and alter the values).
I had defined them in a Pictorial representations. Take into account we’re giving 10 % reductions to all of our buyer then what precisely each the choice tables do to the info in a desk in Database.
Now allow us to create a call desk. For Each resolution desk we have to have a situation and a motion to the measure or the Key Determine KF.
I created two tables out of Gross sales Oder header and Merchandise desk as Beneath. HANA offers glorious characteristic like Teradata to create a desk on the fly similar as a base desk. see Beneath : –
Now I’ll create a call desk as Beneath : –
The primary time if you create a call desk it seems like as under : –
I’m going to now add the ZVBAP_TEST desk and I created that with the intention to not have an effect on the unique VBAP desk. 🙂
I added the MATNR which is the fabric because the situation and NETWR to the motion as in above snapshot.
Now I’m making use of the logic of the reductions as in under snapshot. We will additionally import the calculations from an excel file as properly. Import from excel file I Will cowl letter.
Save Validate and Activate the info. By Default Choices tables are created below “_SYS_BIC” schema however we will create a call desk below any schema if we have now proper previlage enabled for the Choice Desk Object or artifact.
we can not see the info in a call desk instantly in Knowledge Preview simply as we do with a desk or a CV. Each time we create a call desk a Saved process can be getting created below the “_SYS_BIC_” SCHEMA.
allow us to discover the saved process and to the info within the DT we have to name the process. A saved process is rather like a operate module or a executable assertion which can be utilized n variety of occasions. we will name the process in scripted CVS. Level to notice right here is that we can not name the SP inside a TF as Desk features are not allowed to change database state, and saved procedures are allowed to change database state. Subsequently, it’s not allowed to execute a saved process from inside a operate.
Now allow us to name the SP created for the Choice Desk.
When you name the SP you will notice that knowledge is getting up to date to the bottom NETWR worth is DB.
Right here as I had created the choice desk on ZVBAP_TEST the NETWR worth is being up to date to 10% or 15% or 20% for the fabric I select for the desk ZVBAP_TEST.
You possibly can select a base desk too once we are creating a call desk. However ideally higher not to decide on the precise base desk as the bottom desk could also be used for different modelling functions. Create a replica of the bottom desk and create resolution desk on prime that. Is dependent upon your online business state of affairs.
Now knowledge in S/4 HANA Supply OLTP system.
ZDEC_TEST resolution desk is created below the “_SYS_BIC” as a Column View which ultimately is updating the ZVBAP_TEST through a saved process name.
We have to schedule the saved process primarily based on the enterprise necessities in order that knowledge is getting up to date for the chosen supplies. Say each 1 hour or 2 hour and many others.
We will additionally feed the choice desk to a calculation view and in addition we will use inside a desk operate Node (HANA 2.0 SPS 04)
additionally we will return calculated attributes as under
These calculated attributes can solely be added to a situation to a measure. Suppose we wish to once more apply some form of filters say Materials Like “M-100%” and many others then we derive calculated attribute and apply the motion on this situation on a special Measure.
We will additionally parameterize the choice desk with an IP parameters which may additional be handed to a CV or a TF.
This weblog submit will assist you to create sturdy resolution tables on Native HANA environments.