List of standard reports

[former_member187437]

HI all

I would like to have the list of all standard sap reports in scm. Is there any site that gives these details or is there any way to get this list.

Message was edited by:

aarthi

[Former Member · Accepted solution]

Dear Aarthi,

Important Tables in APO

Table Remarks

/SAPAPO/TBQTVB ATP: Parameter Buffer, Product Allocation Assignment

/SAPAPO/PAGZE001 PAG-Z001 Product Allocations: Characteristic Value* This table is generated when a Product Allocation Group is defined. Use it to convert the GUID into a CVC.

/SAPAPO/MATKEY Product Master* Use it to convert Material GUID into a material number.

/SAPAPO/MATLOC Location product Master* Use it to see valid material plant combinations (GUID’s) in APO.

/SAPAPO/MATMAP Mapping Table for Products* Use it to see mapping of material numbers in R/3, APO and GUID

/SAPAPO/LOC Locations* Use it to convert Location GUID into a Location number.

/SAPAPO/QTTAB Product Allocations: Schedule Line

/SAPAPO/SDQTVB SD Order: Product Allocation Assignment* Use it to see detailed allocation assignment by Sales Order

/SAPAPO/POSMAPN Order Items Mapping Table*Use to get GUID for Sales Orders

/sapapo/treqires- All the confirmed qty and confirmed timestamp for order transaction GUID

CDHDR, CDPOS- Broader- All changes

/sapapo/DMCP

R-Delete

N-Create

C-Change

Tables:

Tables where SALES ORDER Data is stored in APO

In addition to the requirements in SAP liveCache, the SD order tables are also included in the comparison with SAP R/3. Data is stored in these tables that is required for SAP APO functions from the area of Global ATP, such as the check against product allocations and backorder processing.

Both the existence and the consistency of the stored data is checked, based on the most important fields, as well as on the connection between main item(s) and subitem(s) in the following tables:

· /sapapo/posmapn (mapping the item)

· /sapapo/ordadm_h (order header)

· /sapapo/ordadm_i (order item)

· /sapapo/schedlin (order schedule line)

· /sapapo/obref (object reference)

· /sapapo/sdfield (SD order/delivery: Item additional data, also called 'field catalog')

· /sapapo/ciflooku (CIF lookup table)

The following inconsistencies can arise:

· r3obj : R/3 object of item in table /sapapo/posmapn

· atpcat: ATP category of item in table /sapapo/ordadm_i

· chmod: Check mode of item in table /sapapo/ordadm_i

· pstyv: Item category of item in table /sapapo/ordadm_i

· from_time: Schedule line date in table /sapapo/schedlin

· to_time: Schedule line date in table /sapapo/schedlin

· uepos: Assignment of higher-level (main) item

(Mapping in table /sapapo/posmapn and entry table in /sapapo/sdfield)

· wmeng: Requested quantity in table /sapapo/schedlin

· edatu: Requested delivery date in table /sapapo/schedlin

· obref: Object reference between order and delivery item in table /sapapo/obref

· matnr (MainItem)/matnrMItem: Product of main item in table /sapapo/ordadm_i

· werks (MainItem)/werksMItem: Plant of main item in table /sapapo/ordadm_i

· lgort (MainItem)/lgortMItem: Storage location of main item in table /sapapo/ordadm_i

· Account assignment (MainItem)/accMItem: The account assignment of the main item, that is, the pegging area from table /sapapo/ordadm_i does not correspond to the account assignment in SAP R/3 (vbap-sobkz, vbap-vbeln and vbap-posnr)

Important Tables in R/3

Table Remarks

QTVB Product Allocation: Allocation used by Customer Order* Use this table to find allocation assignment by Sales Order

Regards,

Naveen.

[former_member187437 · Accepted solution]

HI Naveen

thanks for your valuable information.

actually i want to have standard reports in scm

[Former Member · Accepted solution]

Dear Aarthi,

Useful TCodes:

[Long list of transaction codes deleted as its not relevant to the query]

Regards,

Naveen.

Message was edited by:

Somnath Manna

[somnath_manna · Accepted solution]

Hi Aarthi,

What kind of reports are you looking for in SAP SCM. Is it standard Evaluation Reports for particular module or ABAP reports for different functionalities.

For example PPDS module provides good reporting capabilities for Order and Resource <a href="http://help.sap.com/saphelp_scm50/helpdata/en/f8/774a395138fd68e10000000a114084/content.htm">Evaluations</a>. This would be available under APO >> PPDS >> Evaluations.

If you are looking for technical ABAP related reports you may like to take a look at the <a href="https://wiki.sdn.sap.com/wiki/display/SCM/APO-Technical">APO-Technical Wiki</a>.

Hope this helps.

Thanks,

Somnath

[Former Member]

Hi Aarthi,

Go through the below link.

Regards,

Siva.