Skip to Content
0
Former Member
Dec 23, 2007 at 12:21 PM

plz help me to find out tables and fields........based on SD,PM,FICO Module

314 Views

Hi plz help me to find out the table name and field names as i am unable to find .....In the spec am given requirements in the following pattern.

Description SAP-Term Explaination

-


1.Salesman Equipment AC Mgr. VBPA2 – this is the salesman code - I need the

description for this.

2.Vendor MEPO_TOPLINE-SUPERFIELD Vendor field is pull from me23n where the

condition will be that COBL-KDAUF (this is a

structure from me23n in item data-account

assignment-sales order. The number here should

be the corresponding contract number. This field

should include a multiple selection function. User

can put more than one description to search for.

3. Val. Period Val. Period Category Val. Period Category from va41 header-contract

Category data. This field should include a multiple selection

function. User can put more than one description

to search for.

4. Service Order/ CAUFVD-GSTRP/ This should be the document date where by it is in

Purchase Order MEPO_TOPLINE-BEDAT between the range the user input

Document Date

5. B2B Vendor MEPO_TOPLINE-SUPERFIELD Vendor field is pull from me23n where the condition

will be that COBL-KDAUF (this is a structure from

me23n in item data-account assignment-sales

order. The number here should be the

corresponding contract number.

6. B2B Cost MEPO1211-NETPR This cost is pulled from PO (me23n) however take

note that the price will be pulled out base on line

item Net Price. Make sure that price is taken

corresponding only to the equipment tied to it.

Check on Number 7 to see how is the line item tied

to the equipment.

If this is in other currency please make it to SGD

with the exchange rate field Exchange rate

(MEPO1226-WKURS)

NOTE:: I need to know the table from which I can

determine the currency type as can be seen in the

ME23N transaction and also te exchange rate for

that particular currency.

7. No of faults The service order (CAUFVD-AUFNR) created base

on the equipment in Number 8. This should exclude

the service order of type RD08. Service order can be

access by IW33.

8. Faults Completed This would be the number of faults (Number 13)

which has a system status (CAUFVD-STTXT) of

TECO. System status can be viewed in IW33 Sys.

Status. Take note service order type RD08 will be

excluded

9. Time Spent on Fault AFVGD-ISMNW This field is in IW41 in confirmation base on the

order created. This field will be the actual time

spent. This will correspond to the Faults

Completed (Number 14). This means only orders

with system status TECO will be pull. Take not

service order type RD08 will be excluded

10. Fault Cost RIHAUFK_LIST- DGESKOSIST This will be the total cost for a service order which

have the status TECO. Those which are not TECO

will not be needed. This field can be obtain from

IW39 (standard report). Execute the report and

there will be a field for Total Actual Cost. You might

need to change the screen layout to be able to view

this. Take note service order type RD08 will be

excluded

11. PM Hours AFVGD-ISMNW This field is in IW41 in confirmation base on the

order created. This field will be the actual time

spent. This will correspond to the Faults Completed

This means only orders with system

status TECO will be pull. Take note service only

take order type RD08.

12. Spare Cost Spare part cost This field will be in IW33 under cost tab, and cost

PMCOEA-IKOSTENKGR tab in item level. This will be the actual cost of spare

part after TECO. This will include all order type.

13. Credit Note Credit Memo The programs need to pull out credit memo which is

reference from the contract. If there is a credit memo

reference from the contract then the value will be net

price per equipment.