FDS2 SAP (CM&F Line Items in SD Documents (fromr Release 4.0)) Table details
Dictionary Type: Table
Description: CM&F Line Items in SD Documents (fromr Release 4.0)
Description: CM&F Line Items in SD Documents (fromr Release 4.0)
Table field list including key, data, relationships and ABAP select examples
FDS2 is a standard SAP Table which is used to store CM&F Line Items in SD Documents (fromr Release 4.0) data and is available within R/3 SAP systems depending on the version and release level.
The FDS2 table consists of various fields, each holding specific information or linking keys about CM&F Line Items in SD Documents (fromr Release 4.0) data available in SAP. These include AWTYP (Reference Transaction), AWREF (Reference Document Number), AWORG (Reference Organizational Units), AWSYS (Logical System).. 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. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FDS2 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
| AWREF | Reference Document Number | AWREF | CHAR | 10 | ALPHA | AWREF | |||
| AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
| AWSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| AWPOS | Reference line item | AWPOS | CHAR | 10 | AWPOS | ||||
| VRGNG | Business Transaction | J_VORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
| ORVTP | Value type of purchase order/sales order values | ORVTP | CHAR | 1 | ORVTP | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| FDGRP | Planning Group | FDGRP | CHAR | 10 | T035 | ALPHA | FDGRP | FFG | |
| FDTAG | Planning date | FDTAG | DATS | 8 | DATUM | FDT | |||
| TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
| FDLEV | Planning level | FDLEV | CHAR | 2 | T036 | FDLEV | FFE | ||
| OAUME | Open orders quantity in base unit of measure | MC_OAUME | QUAN | 15(3) | MENGV15_3 | ||||
| BASME | Base unit of measure for BOM | BASME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| WRSHB | Amount in planned currency | WRSHW | CURR | 15(2) | WERTV8 | ||||
| DMSHB | Amount in local currency | DMSHW | CURR | 15(2) | WERTV8 | ||||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC |
| Key field | Non-key field |
How do I retrieve data from SAP table FDS2 using ABAP code
The following ABAP code Example will allow you to do a basic selection on FDS2 to SELECT all data from the tableDATA: WA_FDS2 TYPE FDS2.
SELECT SINGLE *
FROM FDS2
INTO CORRESPONDING FIELDS OF WA_FDS2
WHERE...
How to access SAP table FDS2
Within an ECC or HANA version of SAP you can also view further information about FDS2 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects