RV13A097 SAP Report - Select Condition Records
RV13A097 is a standard ABAP report available within your SAP system (depending on your version and release level). Below is the standard documentation available for this report and a few details of other objects it interacts with such as tables, function modules, includes etc. If you would like to see the full code listing simply enter the object name( RV13A097 ) into the relevant SAP transaction such as SE38 or SE80
Within the comments section below there is also an opportunity for anyone to be able add useful hints and information specific to this SAP object. This means that you and other users will be able to find these details quickly by simply searching on the object name.
TRANSACTION CODE: N/A
Includes used within report:
* INCLUDE F�R VARIABLE SCHL�SSEL *
INCLUDE VAKEDATA.
Tables used within report and the associated select statement:
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = A097-KAPPL
AND KSCHL = A097-KSCHL
AND EKORG = A097-EKORG
AND LIFNR = A097-LIFNR
AND WERKS = A097-WERKS
AND SRVPOS = A097-SRVPOS
* +CALL DATUM_1 AND DATBI = A097-DATBI *
* +CALL DATUM_1 AND DATAB = A097-DATAB *
AND DATBI BETWEEN A097-DATBI AND *A097-DATBI
AND DATAB BETWEEN A097-DATAB AND *A097-DATAB
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL BETWEEN A097-KAPPL AND *A097-KAPPL
AND KSCHL BETWEEN A097-KSCHL AND *A097-KSCHL
AND EKORG BETWEEN A097-EKORG AND *A097-EKORG
AND LIFNR BETWEEN A097-LIFNR AND *A097-LIFNR
AND WERKS BETWEEN A097-WERKS AND *A097-WERKS
AND SRVPOS BETWEEN A097-SRVPOS AND *A097-SRVPOS
AND DATBI BETWEEN A097-DATBI AND *A097-DATBI
AND DATAB BETWEEN A097-DATAB AND *A097-DATAB
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = A097-KAPPL
AND KSCHL = A097-KSCHL
AND EKORG = A097-EKORG
AND LIFNR = A097-LIFNR
AND WERKS = A097-WERKS
AND SRVPOS = A097-SRVPOS
AND DATBI BETWEEN A097-DATBI AND *A097-DATBI
AND DATAB BETWEEN A097-DATAB AND *A097-DATAB
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = A097-KAPPL
AND KSCHL = A097-KSCHL
AND EKORG = A097-EKORG
AND LIFNR = A097-LIFNR
AND WERKS = A097-WERKS
AND SRVPOS = A097-SRVPOS
AND DATBI BETWEEN LOW_VAKE-DATBI AND HIGH_VAKE-DATBI
AND DATAB BETWEEN LOW_VAKE-DATAB AND HIGH_VAKE-DATAB
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = A097-KAPPL
AND KSCHL = A097-KSCHL
AND EKORG = A097-EKORG
AND LIFNR = A097-LIFNR
AND WERKS = A097-WERKS
AND SRVPOS = A097-SRVPOS
AND DATBI BETWEEN LOW_VAKE-DATBI AND HIGH_VAKE-DATBI
AND DATAB BETWEEN LOW_VAKE-DATAB AND HIGH_VAKE-DATAB
AND KNUMH = A097-KNUMH
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = A097-KAPPL
AND KSCHL = A097-KSCHL
AND EKORG = A097-EKORG
AND LIFNR = A097-LIFNR
AND WERKS = A097-WERKS
AND SRVPOS = A097-SRVPOS
* +CALL DATUM_1 AND DATBI = LOW_VAKE-DATBI *
* +CALL DATUM_1 AND DATAB = LOW_VAKE-DATAB *
AND DATBI BETWEEN LOW_VAKE-DATBI AND HIGH_VAKE-DATBI
AND DATAB BETWEEN LOW_VAKE-DATAB AND HIGH_VAKE-DATAB
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL BETWEEN A097-KAPPL AND *A097-KAPPL
AND KSCHL BETWEEN A097-KSCHL AND *A097-KSCHL
AND EKORG BETWEEN A097-EKORG AND *A097-EKORG
AND LIFNR BETWEEN A097-LIFNR AND *A097-LIFNR
AND WERKS BETWEEN A097-WERKS AND *A097-WERKS
AND SRVPOS BETWEEN A097-SRVPOS AND *A097-SRVPOS
AND DATBI BETWEEN LOW_VAKE-DATBI AND HIGH_VAKE-DATBI
AND DATAB BETWEEN LOW_VAKE-DATAB AND HIGH_VAKE-DATAB
ORDER BY PRIMARY KEY.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = S_KAPPL
AND KSCHL = S_KSCHL
AND EKORG = F001
AND LIFNR = F002
AND WERKS = F003
AND SRVPOS IN F004
AND DATBI >= SEL_DATE
AND DATAB <= SEL_DATE.
A097
SELECT * FROM A097 BYPASSING BUFFER
WHERE KAPPL = A097-KAPPL
AND KSCHL = A097-KSCHL
AND EKORG = A097-EKORG
AND LIFNR = A097-LIFNR
AND WERKS = A097-WERKS
AND SRVPOS = A097-SRVPOS
AND KNUMH = A097-KNUMH
ORDER BY PRIMARY KEY.
Function Modules used within report and the associated call statement:
RS_SUBMIT_INFO
CALL FUNCTION 'RS_SUBMIT_INFO'
IMPORTING
P_SUBMIT_INFO = RSSUBINFO.
RV_CONDITION_GET_CUA_REPO
CALL FUNCTION 'RV_CONDITION_GET_CUA_REPO'
EXPORTING
PFKEY_I = 'ASELE'
TITLE_I = TITEL
PAR1_I = T185V-PARA1
PAR2_I = T185V-PARA2
PAR3_I = T185V-PARA3
PAR4_I = T185V-PARA4
TABLES
EXCL_I = AUSSCHLUSS.
RS_EXTERNAL_SELSCREEN_STATUS
CALL FUNCTION 'RS_EXTERNAL_SELSCREEN_STATUS'
EXPORTING
P_FB = 'RV_CONDITION_SET_CUA_REPO'.
DEQUEUE_E_TABLE
CALL FUNCTION 'DEQUEUE_E_TABLE'
EXPORTING
TABNAME = RSTABLE-TABNAME
VARKEY = RSTABLE-VARKEY.
ENQUEUE_E_TABLE
CALL FUNCTION 'ENQUEUE_E_TABLE'
EXPORTING
TABNAME = RSTABLE-TABNAME
VARKEY = RSTABLE-VARKEY
EXCEPTIONS
FOREIGN_LOCK = 4
SYSTEM_FAILURE = 8.
Text pool values
Selection Text: DATE_AS = Keep end of validity period
Selection Text: SEL_DATE = Valid on
Selection Text: F004 = D Service number
Title: Select Condition Records
Text Symbol: 011 = Purch. organization
Text Symbol: 012 = Vendor
Text Symbol: 013 = Plant
|
