sap bi

[former_member604260]

Hi Gurus,

I have 2 tables 1) is returnable gate pass(RGP) and non returnable gate pass(NRGP)  header details table

RGP/NRGP HEADER DETAILS
Field name	Data type	Description
MANDT	CLNT	Client ID of Current User
GP_TYPE	CHAR	Gatepass Type
GP_NUMBER	CHAR	For RGP and NRGP number
.INCLUDE	STRU	Structure For RGP/NRGP
INITIATOR_NAME	CHAR	User Name
SOURCE_PLANT	CHAR	Receiving/Issuing Plant
RECEIVER_CODE	CHAR	Receiver Plant/Vendor Code
APPROVAL_STATUS	CHAR	For approval status of RGP and NRGP address
FORM_STATUS	CHAR	RGP/NRGP Form Status
VENDOR_NAME	CHAR	Name
COMP_NAME	CHAR	Name
GP_CREATION_DATE	DATS	Date on Which Record Was Created
LEAVING_DATE	DATS	Date on which Material is Leaving
DELIVERY_DATE	DATS	Delivery Date
LEAVING_TIME	TIMS	Time of Goods Issue (Local, Relating to a Plant)
VEHICLE_NO	CHAR	Vehicle No
TRANSFER_MODE	CHAR	Mode of transport
ATTACHMENT	CHAR	Attachemnt Document Name
EXCISABLE	CHAR	Is Excisable
EXCISE_DETAIL	CHAR	Excise Detail
EXCISE_GP_NO	CHAR	Excise Registration Number
EMAIL_WH	CHAR	Warehouse Head Email ID
EMAIL_FI	CHAR	Finance Head Email ID
REF_DOC_TYPE	CHAR	Reference Document Type
REF_DOC_NO	CHAR	Reference Document
PERSON_NAME	CHAR	For person name in RGP/NRGP
DOC_NUM	CHAR	Document number
APPROVER_NAME	CHAR	Communication ID/Number
APPROVAL_DATE	DATS	Final Approval Date
MJAHR	NUMC	Material Document Year

                      2) Table For RGP/ NRGP/Inward/Outward Material (item details table).

                                   Table For RGP/NRGP/Inward/Outward Material(Item details)

FIELD	DATA TYPE	DESCRIPTION
MANDT	CLNT	Client ID of Current User
SL_NO	CHAR	Serial Number
GP_NUMBER	CHAR	For RGP and NRGP number
REF_OBJECT_TYPE	CHAR	Scenario Type
.INCLUDE	STRU	Structure For RGP/NRGP/Inward/Outward Material
MTART	CHAR	Material Type
MATNR	CHAR	Material Number
MEKTS	CHAR	Material Description (Short Text)
APPROVED_QUAN	QUAN	Scheduled Quantity
PENDING_QUAN	QUAN	Pending Quantity
DC_QUANTITY	QUAN	Issued Quantity
MIENS	UNIT	Base Unit of Measure
UNIT_PRICE	CURR	Net price
VALUE	CURR	Net price
EXPTD_R_DATE	DATS	Goods Receipt End Date
REASON	CHAR	Reason
REMARKS	CHAR	Remarks
CONTAINER	CHAR	No of container
BATCH_PO	CHAR	Batch number/Ref PO

My requirement is

I)Summary of Gatepass

Input Data:-

Plant: 2001

Type : NRGP/ GP

Period:

From:   01.6.2013      To        10.06.2013

Out Put

Total no of RGP’s generated during the given period

Statistics as per Status wise i.e  InProcess , Approved, Completed, Discarded, Closed.

II) Average time taken for clearing the Gatepass:

Logic: Total time taken for approving gate passes / Total no of gate passes approved

Green colour for < 2Hr

III ) Pending RGP’s Plant wise with Delay details

Logic: RGP’s with  status ‘Approved’  and Outward is made

could you please give me urgent reply for above the logics and what is the procedure to get the that type of repots above table are the customized tables

[former_member604260]

Hi Gurus,

please give me replie my thinking is i want to  create the one generic data source on 1)header data returnable gatapass and non returnable gate pass details,

2) second table i am creating view on  and bringing the date field(created on date ),

is it correct way are not please give me urgent reply