SAP PSGL_EXTSTRUCT_LEAD Extraction Structure for the Leading Ledger Table data and field list

PSGL_EXTSTRUCT_LEAD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extraction Structure for the Leading Ledger" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PSGL_EXTSTRUCT_LEAD TYPE PSGL_EXTSTRUCT_LEAD.

The PSGL_EXTSTRUCT_LEAD table consists of various fields, each holding specific information or linking keys about Extraction Structure for the Leading Ledger data available in SAP. These include ACTIV (FI-SL Business Transaction), RMVCT (Transaction Type), RTCUR (Currency Key), RUNIT (Base Unit of Measure)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PSGL_EXTSTRUCT_LEAD structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP PSGL_EXTSTRUCT_LEAD structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PSGL_EXTSTRUCT_LEAD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
RYEAR	Fiscal year	RYEAR	NUMC	4		GJAHR	GJAHR	GFY
ACTIV	FI-SL Business Transaction	ACTI1	CHAR	4	T022		ACTIVITY
RMVCT	Transaction Type	RMVCT	CHAR	3	T856		RMVCT
RTCUR	Currency Key	RTCUR	CUKY	5	Assigned to domain		WAERS	FWS
RUNIT	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
AWTYP	Reference Transaction	AWTYP	CHAR	5	TTYP		AWTYP
RLDNR	Ledger in General Ledger Accounting	FAGL_RLDNR	CHAR	2	V_FAGL_T881_DBAL	ALPHA	RLDNR	GLN_FLEX	FAGL_RLDNR
RRCTY	Record Type	RRCTY	CHAR	1			RRCTY
RVERS	Version	RVERS	CHAR	3	Assigned to domain	ALPHA	RVERS	GVS
LOGSYS	Logical system	LOGSYS	CHAR	10	TBDLS	ALPHA	LOGSYS
RACCT	Account Number	RACCT	CHAR	10	SKB1	ALPHA	SAKNR	ACC
COST_ELEM	Cost Element	KSTAR	CHAR	10	CSKB	ALPHA	KSTAR	KAT
RE_BUKRS	Cash Ledger: Company Code for Expense/Revenue	FAGL_RE_BUKRS	CHAR	4	Assigned to domain		BUKRS
RE_ACCOUNT	Cash Ledger: Expense or Revenue Account	FAGL_RE_ACCOUNT	CHAR	10	Assigned to domain	ALPHA	SAKNR
RBUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
RBUSA	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
FIKRS	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
SFAREA	Partner Functional Area	SFKBER	CHAR	16	TFKB		FKBER
SBUSA	Trading partner's business area	PARGB	CHAR	4	TGSB		GSBER	GSB
RASSC	Company ID of trading partner	RASSC	CHAR	6	T880	ALPHA	RCOMP	PGS
SFUND	Partner Fund	BP_P_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
SGRANT_NBR	Partner Grant	GM_GRANT_PARTNER	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR		GRANTS_GENERIC
SBUDGET_PD	FM: Partner Budget Period	FM_PBUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
RFUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
RGRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
RFAREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
RBUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
QUANUNIT	Unit of Measure	ROUNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
VALUETYPE	Value type for Reporting	RSVTYPE	NUMC	3	Assigned to domain		RSVTYPE
CURTYPE	Currency type	RSCURTYPE	CHAR	2			RSCURTYPE
FISCPER	Fiscal year / period	RSFISCPER	NUMC	7		PERI7	RSFISCPER
FISCVAR	Fiscal year variant	RSFISCVAR	CHAR	2			RSFISCVAR
CHARTACCTS	Chart of Accounts	KTOPL	CHAR	4	Assigned to domain		KTOPL	KPL	C_KTOPL
UPMOD	BW Delta Process: Record Mode	RODMUPDMOD	CHAR	1			RODMUPDMOD
VALUTYP	Valuation View	VALUTYP	NUMC	1			VALUTYP	VTP
CURRUNIT	Currency Key	RSCURRENCY	CUKY	5	Assigned to domain		WAERS
BALANCE	Accumulated balance	RR_KUMSL	CURR	17(2)			WERTV9
DEBIT	Total debit postings	RR_UMSOL	CURR	17(2)			WERTV9
CREDIT	Total credit postings	RR_UMHAB	CURR	17(2)			WERTV9
TURNOVER	Sales of the period	RR_SALES	CURR	17(2)			WERTV9
QUANTITY	Consumption Quantity	SMEGR9	QUAN	17(3)			MENGV9
ADQUANUNIT	Unit of Measure	ROUNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
ADQUANTITY	Consumption Quantity	SMEGR9	QUAN	17(3)			MENGV9

Key field

Non-key field

< PSGLMIG_PROTOCOL - rotocol for the Migration to the new Public Sector Template PSGOTO - Project System: Go to PS Objects >

How do I retrieve data from SAP structure PSGL_EXTSTRUCT_LEAD using ABAP code?

As PSGL_EXTSTRUCT_LEAD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PSGL_EXTSTRUCT_LEAD as there is no data to select.

How to access SAP table PSGL_EXTSTRUCT_LEAD

Within an ECC or HANA version of SAP you can also view further information about PSGL_EXTSTRUCT_LEAD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).