Below the complete report S.50.R.11 is shown except the last page for the branch table.
Smart Reference Data is highly configurable. Because a predefined report can never be developed exactly matching these configurations, this report allows you to easily customize the content for most fields.
In order to allow this report to show specific specification header table details or commodity code details, procedures (CIP) in the custom package M_PCK_S50R11_custom are available.
This document cannot function as a development guide for CIPs. Attached is an example how the customization for this report works.
The above screen shot from the specification report shows the "RATING" (the area highlighted green is the fixed programmed part that comes from the report definition itself) and the "CL300, ASME …" (the area highlighted in yellow that comes from the database definition for the specification BP_10S01).
The custom package receives the spec header id from the report as an input parameter. The spec header id is the internal unique key for specifications.
Based on the spec_header_id, the function now can be programmed to find the valid value for "RATING" in the database.
The function has to search for the table "RATING_CLASS" in the database table "M_SPEC_HEADER_DETAILS." The function has to transfer to the report the short description of the detected table detail as the return value.
FUNCTION GET_RATING (P_SPEC_HEADER_ID IN m_spec_header_details.spec_header_id%TYPE)
--daclaration of variables, using this the variable takes over the data type from the field, where it tetrieves later on the value from, This ensures the correct data type!
-- PL/SQL Block
-- This select statement selects the short desc into the return variable
select tdn.short_desc into p_get_rating
from m_table_detail_nls tdn,
and td.td_id= shd.td_id
and dt.table_name='RATING CLASS'
/* return selection */
then return 'no data found in GET_rating';