May 2010

sap abap list of sales order programming report

This sap abap programming report lists sales orders, grouped by sold-to party or material number.The following entries are required to run this report:

1. Valid sold-to party or material master number
2. Valid sales organization

You can branch to the SD document, document status, document flow, customer address, sold-to party and the material master.

The selection screen of this report includes:

Input sold-to party, material number, or a PO number
Input SD organizational data
Further selection criteria
Distribution
Division
Sales office
Sales group
Sales document type
Created by
SD document
Date range
Display variants (0SAP, 1SAP, and 3SAP)

Output screen

Filter functions
Sort functions
Sum up (add values) function
Change the width of the column, and freeze or unfreeze columns.
Alternate between display variants (Settings → Display variants → Choose)
Branch to the SD document, document status, document flow, and master data (customer address, partner (sold-to), and material)

This report contains data from sales documents, which include materials and partners. It allows you to branch to the SD document for editing, but does not allow any other manipulation of the output.

To access the first screen for this abap report, choose Logistics → Sales and distribution → Sales → Order → List.

1. Enter a Sold-to party or Material number (for example, 1321).
2. Enter the document date range (for example, 01.01.1998 to 12.31.1998). This is based on the date the sales order was created.
3. Under Selection criteria, select All sales orders.
4. Choose Enter.

This screen shows the basic list of all sales orders without display variants.

5. Click on the Doc. date column.
6. Choose Filter.
7. Enter the filter date range (for example, 10.16.1998 to 11.11.1998) in Document date. Sales documents will be filtered only for this date range.
8. Choose Copy. This screen shows the filtered output for sales orders that occurred in the above range.
9. Click on the Net value column.
10. Choose Summation.

SAP ABAP HR Entries and withdrawals Programming Report

This sap abap programming report lists employees who have entered or left the company within a certain period. You can choose any period as a reference point for this report.The output is presented in tabular view. The screen may be changed to a formatted page layout view. Columns and rows may be hidden from the display with mouse or function key controls. The data may also be transferred to Microsoft Excel, Word, or HTML through push buttons or menu selections available on the output display. Furthermore, connection to SAP Office lets you send the report to another R/3 user as a mail attachment.

This report includes:

Variants
Execution (and print) in background
Standard selection fields available
Additional selection fields (use Further Selections or Matchcodes buttons)
Selection of entries and/or withdrawals
Sorting of data according to the user’s preferences
Data output to table or report, with links to Excel, Word, and HTML
Ability to show/hide lines or columns of data

This report contains employee master data. As such, it cannot be changed or manipulated from the report, but it but does let you hide specific columns or rows of data.

To access the first screen for this ABAP report, choose Human resources → Personnel management → Administration → Reporting → Report selection → Employee → Entries/withdrawals → Employees who have Entered and/or Left the company.

1. Under Period, enter 01/01/1996 to 12/31/1996 in Other period.

2. Under Selection, enter 0 in Employment status. Select not equal to (≠) in order to exclude terminated employees.

3. Enter 300 in Personnel area.

4. Select EEs entered/left in order to include employees who have entered or left the company.

5. Choose Execute.

This screen shows Employees who have entered/left. Entering employees have an Entry date, while departing employees have a Leaving date.

Employees who have left and returned list in both columns (for example, Jonathan Benson left the company on June 1, but was rehired on June 2).

A Total number of employees selected (for example, 26)
B Function used to transfer data to report layout, SAP Office, Excel, and Word .

SAP ABAP HR programming report sample for EEOC

SAP ABAP HR programming report about EEO 1 report deals with compiling the EEO-1 data that US employers need to file every year with the Equal Employment Opportunity Commission (EEOC). The resulting statistic is formatted in accordance with the standards for computerized output prescribed by the EEOC. Section G (Certification) is omitted, since multi establishment employers are required to file the certified consolidated report on the original EEO-1 form.

This report only runs for employees who have a valid organizational assignment infotype 0001, including assignment to a personnel area/subarea and job. Employees must also have a valid additional personal data infotype 0077, including assignment of ethnic origin, and veteran status.
In addition, you must maintain the following system tables:

T5U0P: Every personnel area subarea has to be maintained. The following country-specific fields—with country modifier 10 (US)—must be completed:

REPUN: Reporting organizational unit
COIND: Company ID
EEOHQ: Headquarters indicator (checkbox). Must be checked ONLY for headquarters unit.
SICNO: Standard industry code (T5USC)
EINUM: INS employer ID
DANDB: Dun & Bradstreet ID

T5U13—Jobs: Country-specific field for country modifier 10 (US). For each job, the field EEOCT - EEO job category must be maintained. Standard EEO job categories are delivered.
All EEO categories must be entered into feature EEOCT, which converts job categories to the row numbers (01 to 09) in the EEO-1 report. Features may be accessed using transaction PE03.

T5UAD: For every reporting unit, an address should be created.
T5URU - EEO unit number for each reporting unit should be then created. For each EEO unit number, an address has to be assigned.

T5U0E - EEO Record: This report uses this table in several ways. The table provides:

Previously reported totals per reporting unit
Settings (that is, section C and E) for the current report
Totals for the current period (if needed)
T505R - Ethnic origin: If table T505R is modified or extended to allow additional ethnic categories, feature EEOCL (transaction PE03) must be modified to reflect those changes. Feature EEOCL yields the EEO employee category based on ethnic origin and gender.

Depending on when you run the report, you will need to consider special requirements concerning totals previously reported to the government.

. Running the report for the first time: For the period that provides the previous reported total, a record needs to be created for EACH reporting unit in T5U0E. This record should contain the totals per employee category and, preferably, the indicators for the questions in sections B and C reported for that period.

2. Running the report in subsequent periods: If the indicators for section B and C have not changed, it is not necessary to create the records for the current periods, since the report will read the indicators from the previous period. If the indicators have changed, a new record for the current period, containing the correct settings must be manually created. If desired, the report will update table T5U0E with the totals for the current period when the report is run.

Choose PA_UPDAT to create or modify the entry per reporting unit in table T5U0E .

EEOCT (Feature): Depending on the value used in table T5U13 (field EEOCT), this feature must be modified to yield the correct row number for each EEO category.

This report includes:

Variants
Execution (and print) in background
Standard selection fields available
Additional selection fields via the Further Selections or Matchcodes buttons
Data output formatted in accordance with the standards for computerized output prescribed by the EEOC.

To run this abap report

choose System → Services → Reporting and enter RPSEEOU1 in the Program field. Then,
choose Execute to run the report.

1. Under Period, enter 06/01/1998 to 06/30/1998 in Other period and Person selection period.
2. Under Selection, enter 300 in Personnel area and 0001 in personnel subarea to limit the selection of employees.
3. Enter +3+ in Status 1/status 2/status 3 (employment status) to include only active employees.
4. Under Additional data, enter 00 1996 in Previous period. This determines the period from which the previously reported totals are read.
5. Enter 06 1996 in Current period.

This determines the period from which the indicators for sections C and E are read.

6. Choose Execute.

SAP ABAP human resource New Hire Programming Report

The purpose of this sap abap hr new hire programming report is to provide regulatory reporting information on new hires within each state and tax company. For each state, the tax company to which the employees are assigned lists by the employer’s address and Federal ID number. The employees hired during the reporting period list by their full name, social security number, and home address. This information may be used for federal reporting purposes.

This abap report only runs for employees assigned to a valid personnel subarea. The personnel subarea must be assigned to a valid tax company. The tax company definition includes the official company address, as well as the assignment of the federal tax identification number. Employees must also have a valid residence address in infotype 0006 addresses, and be assigned to a valid unemployment state (infotype 0209).

This report includes:

Variants
Execution (and print) in background
Standard selection fields available
Additional selection fields via the Further Selections or Matchcodes buttons
Detailed data output for further reporting

This report contains employee master data. As such, it cannot be changed or manipulated from the report.

Choose System → Services → Reporting and enter RPLNHRU0 in the Program field. Then, choose Execute to run the report.

1. Under Period, select Current year.
2. Under Selection, enter 3 in Employment status to include only active employees.
3. Under Report-specific selections, enter US01 in Tax company and CA in State.
4. Select the Multiple selection button for Hire/rehire event type to include multiple event types that represent hiring.

5. On the Multiple Selection screen, enter 01 and 12 to ensure inclusion of all hiring actions.
6. Choose Copy. The event type selection now shows that multiple actions are being used.
7. Choose Execute.

A The selected state with tax company information
B Employee information (for each employee within the tax company)
C Summary of selection criteria (at end of employee information list)
D Total number of new hires.

E List of employees included or excluded due to lack of information (located at the bottom of the screen)

Correct these records and rerun the report to ensure all relevant information is reported.

SAP FICO cross company code reconciliation report

Subscribe to: Posts ( Atom )