Table with F&R Order Proposals

[former_member1050692]

I am looking for a table that shows order proposal data for F&R. The only table that I have found so far containing order proposal data is FRE_OP_PO_KEY. However, when validating my data, I noticed there are order proposal numbers showing in transaction ZD2F_MASSMAINT_ODPSL that are not on the FRE_OP_PO_KEY table. Is their a table that shows all order proposal numbers? Ideally the table would include material number and order proposal quantity as well.

[moshenaveh]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[SylviaLudwig]

Hi Grant

thanks to my consulting colleagues I can provide some details here 🙂

Table FRE_OP_PO_KEY is a table in ECC/S/4 to capture the relation OP ó PO for interface processing

You can see in this table order proposals that were created in SAP F&R first and became PO's in ERP after a successful processing

If a PO was manually created on ERP side, FRE_OP_PO_KEY contains only the PO Nummer – the corresponding OP is only visible in F&R Status 40.

All F&R OP's can be seen in SAP F&R itself (SCM)

There are two clusters of ODM tables available (last three digits = client number):

Current Status:

/1OM/FDA11HDR100 ODM: Order Document Header

/1OM/FDA12IT2100 ODM: Order Item (Double-Level Document Typ

/1OM/FDA17MP2100 ODM: Mapping, Template Structure

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

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

/1OM/FDA1OPH1100 Extended Order Proposal Header

/1OM/FDA1OPI1100 ODM-Specific Order Item Extension

OP History:

/1OT/FDA11HDR100 ODM: Order Document Header

/1OT/FDA12IT2100 ODM: Order Item (Double-Level Document Typ

/1OT/FDA17MP2100 ODM: Mapping, Template Structure

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

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

/1OT/FDA1OPH1100 Extended Order Proposal Header

/1OT/FDA1OPI1100 ODM-Specific Order Item Extension

OP Status:

05 MANUALLY CREATED

10 CUSTOMER SPECIFIC RELEASE WITH HIGH PRIO

11 EXCEPTION BASED RELEASE WITH HIGH PRIO.

12 OBJECT BASED RELEASE WITH HIGH PRIORITY

13 EXCEP. AND OBJ. BASED RELEASE HIGH PRIO

20 CUSTOMER SPECIFIC RELEASE WITH LOW PRIO

21 EXCEPTION BASED RELEASE WITH LOW PRIO.

22 OBJECT BASED RELEASE WITH LOW PRIO.

23 EXC. AND OBJ. BASED REL. WITH LOW PRIO

30 RELEASED

31 TRANSFERRED

40 EXTERNALLY CREATED

45 EXTERNALLY CHANGED

50 PARTIAL DELIVERED

60 RETURNS

90 COMPLETED

95 REJECTED

99 DELETED

After transfer OP’s to ECC/S/4… - OP’s are also kept (in and out) in staging tables – but just for the sake of interfacing…

/FRE/BIF_OPH

/FRE/BIF_OPI

Hope this helps!

Best regards

Sylvia