SAP F&R (APO)--Master data Tables

[Former Member]

Dear All,

I reuire the list of tables in detail (technical details)which are used in SAP F&R 5.1 system related to master data.If any document related to order proposal,FRP processer & etc.

Please provide the link or any file which will help me.

Regards,

DD

[Former Member · Accepted solution]

Hi DD,

there are a lot of tables existing for master data. 1. Tables of which object do you need exactly e. g. location or product or supply network? 2. Only the DB tables or interface tables as well (creation of master data is mostly performed by interfaces since F&R expects the leading system for master data to deliver it)?

Kind regards,

Rainer

[Former Member · Accepted solution]

Hi Rainer,

Actually i want all the Database tables related to F&R (especially for Order proposals) and table for all master data coming from R/3. If possible please send me all the important tables which is relevant for F&R.

Thanks in advance & your inputs will be rewarded.

Regards,

Dharmendra

[Former Member · Accepted solution]

Hi Dharmendra,

I have never seen a list of all F&R DB tables or at least the most important ones. I would say it is not existing.

Anyway, these are the tables for order proposals. The last 3 digits represent the client number.

Table Description

/1OM/FDA11HDR110 ODM: Order Document Header

/1OM/FDA12IT2110 ODM: Order Item (Double-Level Document Type)

/1OM/FDA17MP2110 ODM: Mapping (Double-Level Document Type)

/1OM/FDA1HREF110 DL: Reference to Document (Not an ODM Document) (Extension)

/1OM/FDA1IREF110 DL: Reference to Document (Not an ODM Document) (Extension)

/1OM/FDA1OPH1110 Extended Order Proposal Header

/1OM/FDA1OPI1110 ODM-Specific Order Item Extension

/1OT/FDA11HDR110 ODM: Order Document Header

/1OT/FDA12IT2110 ODM: Order Item (Double-Level Document Type)

/1OT/FDA17MP2110 ODM: Mapping (Double-Level Document Type)

/1OT/FDA1HREF110 DL: Reference to Document (Not an ODM Document) (Extension)

/1OT/FDA1IREF110 DL: Reference to Document (Not an ODM Document) (Extension)

/1OT/FDA1OPH1110 Extended Order Proposal Header

/1OT/FDA1OPI1110 ODM-Specific Order Item Extension

For tables that are adressed by interface functionality when SAP ERP Retail sends data to F&R, I can provide a document by e-mail. The document is published by SAP.

Kind regards,

Rainer

[Former Member · Accepted solution]

Hi Rainer ,

Thanks a lot for your valid input.Can you please mail me in dharmendra.das#tcs.com

Sorry to bother you,if any relevant document on F&R with you,please mail me.

That will be well appriciated.

Thanks in advance..

DD

[Former Member · Accepted solution]

Hi DD,

I just sent you an e-mail. It will be some work to create a list of the F&R DB tables out of the attachments but I think it's an excellent starting point.

Kind regards,

Rainer

[Former Member · Accepted solution]

Thanks a lot.If any futher requirement i will be in touch with you.