Accessing Cluster Tables in SAP
Accessing Cluster Tables in SAP
Accessing Cluster Tables in SAP
SRTFD (PSKEY) = pernr (8) info type (4) subtype (4) obj id (2) lock (1) endda (8) begda (8) seqnr (3)
SRTFD (PC400) = trans class always A for master data (1) pernr (8) info type (4) modified date (8) modified time (8) seqnr (4)
Cluster Definition
Naming convention for INCLUDES when defining clusters. These INCLUDES will define the work area key above and the cluster data that is returned from an IMPORT:
RPCnxxy0 n = 1, 2, 3 or 4 (for PCL1, PCL2, PCL3, PCL4) xx = cluster ID y = country grouping (0 for international otherwise country indicator T500L) Description of Cluster Data using Cluster RX as an Example The data description is stored in the include RPC2RX00 in accordance with the above naming conventions.
RPC1TX00 - Long text cluster ID in table PCL1 RPC2RUU0 - Payroll results for the US cluster ID in table PCL2 RPC4LA00 - Change log cluster ID in table PCL4
converted by Web2PDFConvert.com
Cluster Authorization
Simple EXPORT/IMPORT statement does not check for cluster authorization. Use EXPORT/IMPORT via buffer, the buffer management routines check for cluster authorization.
rpcbdt00 - include needed for importing from database PCL4(la) (Change log cluster ID)
When we upgraded to ERP2005, we encountered a problem because a couple of our programs tested the version (VERNR) number to determine which structure the detail used. The SAP include program, RPCBDT00, indicates that VERNR 01 & 02 use the same structure which is PC404. Therefore, we made our programs match SAP.
DATA: BEGIN OF RX-KEY . INCLUDE STRUCTURE PC200. DATA: END OF RX-KEY . *Payroll directory DATA: BEGIN OF RGDIR OCCURS 100. INCLUDE STRUCTURE PC261. DATA: END OF RGDIR. Payroll Cluster Directory REPORT ZHRIMPRT. TABLES: PERNR, PCL1, PCL2. INLCUDE: RPC2CD09. "definition cluster CD PARAMETERS: PERSON LIKE PERNR-PERNR. ... RP-INIT-BUFFER. " macro to get one person at a time based on single parameter for pernr *Import cluster Directory CD-KEY-PERNR = PERNR-PERNR. RP-IMP-C2-CU. " defined in include file CHECK SY-SUBRC = 0. LOOP AT RGDIR. RX-KEY-PERNR = PERSON. UNPACK RGDIR-SEQNR TO RX-KEY-SEQNO. " converts rgdir-seqnr (numc 5) to packed and moves to char 5 *Import data from PCL2 RP-IMP-C2-RU. INLCUDE: RPPPXM00. "PCL1/PCL2 BUFFER HANDLING
features of the employees selected with GET PERNR. Employees for which the user has no authorization are skipped and appear in a list at the end of the report. Authorization object: 'HR: Master data'
converted by Web2PDFConvert.com