SAP FMS1081_DET FMS1081 Detail Records Table data and field list

FMS1081_DET 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 "FMS1081 Detail Records" 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_FMS1081_DET TYPE FMS1081_DET.

The FMS1081_DET table consists of various fields, each holding specific information or linking keys about FMS1081 Detail Records data available in SAP. These include INV_BUKRS (Company Code), INV_GJAHR (Fiscal Year), INV_BUZEI (Number of Line Item Within Accounting Document), DET_TEXT (Character 100)... 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. .

FMS1081_DET 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 FMS1081_DET 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 FMS1081_DET 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
INV_DOC	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
INV_BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
INV_GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
INV_BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
DET_TEXT	Character 100	CHAR100	CHAR	100			CHAR100
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
WAERS	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
DMBTR	Amount Before Deductions in Local Currency with +/- Signs	DMBTV_FPM	CURR	23(2)			WERTV12
ABZUG	Total Deductions (+/-) in Local Currency	ABZGV_FPM	CURR	23(2)			WERTV12
NETTO	Net Amount in Local Currency with +/- Signs	NETTV_FPM	CURR	23(2)			WERTV12

Key field

Non-key field

< FMS1081DET_S - FMSF1081 SF1081 interface details FMS1081_DET_FUNDS - FMS1081 Funds Customer Agency >

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

As FMS1081_DET 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 FMS1081_DET as there is no data to select.

How to access SAP table FMS1081_DET

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

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