VIEXCFCNDNS SAP (Cash Flow Summarization) Table details
Dictionary Type: Table
Description: Cash Flow Summarization
Description: Cash Flow Summarization
Table field list including key, data, relationships and ABAP select examples
VIEXCFCNDNS is a standard SAP Table which is used to store Cash Flow Summarization data and is available within R/3 SAP systems depending on the version and release level.
The VIEXCFCNDNS table consists of various fields, each holding specific information or linking keys about Cash Flow Summarization data available in SAP. These include CFCNDNSRECGUID (Generic Key of Summarization Item), INTRENO (Internal Key of Real Estate Object), CFCNDNSNO (Sequence Number of Summarization), CFPERIODFROM (Period From).. 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 VIEXCFCNDNS 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 | Assigned to domain | MANDT | |||
CFCNDNSRECGUID | Generic Key of Summarization Item | REEXCFCNDNSRECGUID | RAW | 16 | RECAGUID | ||||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
CFCNDNSNO | Sequence Number of Summarization | REEXCFCNDNSNO | NUMC | 4 | RECANUMBER | ||||
CFPERIODFROM | Period From | REEXCFPERIODFROM | DATS | 8 | RECADATEBEG | ||||
CFPERIODTO | Period To | REEXCFPERIODTO | DATS | 8 | REDAT | RECADATEEND | |||
CFPERIODDUEDATE | Earliest Due Date of Period | REEXCFPERIODDUEDATE | DATS | 8 | RECADATE | ||||
CFCNDNSFROM | Summarization From | REEXCFCNDNSFROM | DATS | 8 | RECADATEBEG | ||||
CFCNDNSTO | Summarization To | REEXCFCNDNSTO | DATS | 8 | REDAT | RECADATEEND | |||
CFCNDNSDUEDATE | Earliest Due Date of Summarized Items | REEXCFCNDNSDUEDATE | DATS | 8 | RECADATE | ||||
DCINDICATOR | Debit/Credit Indicator | RERADCINDICATOR | CHAR | 1 | RERADCINDICATOR | ||||
LCNETAMOUNT | Net Amount of Cash Flow Item in Local Currency | RECDCFLCVALUENET | CURR | 15(2) | RECACURR | ||||
LCGROSSAMOUNT | Gross Amount of Cash Flow Item in Local Currency | RECDCFLCVALUEGROSS | CURR | 15(2) | RECACURR | ||||
LCNETAMOUNTNEW | Net Amount of Cash Flow Item in Local Currency | RECDCFLCVALUENET | CURR | 15(2) | RECACURR | ||||
LCGROSSAMOUNTNEW | Gross Amount of Cash Flow Item in Local Currency | RECDCFLCVALUEGROSS | CURR | 15(2) | RECACURR | ||||
LOCALCURR | Local Currency of Cash Flow Item | RECDCFLCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
CCNETAMOUNT | Net Amount of Cash Flow Item in Condition Currency | RECDCFVALUENET | CURR | 15(2) | RECACURR | ||||
CCGROSSAMOUNT | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15(2) | RECACURR | ||||
CCNETAMOUNTNEW | Net Amount of Cash Flow Item in Condition Currency | RECDCFVALUENET | CURR | 15(2) | RECACURR | ||||
CCGROSSAMOUNTNEW | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15(2) | RECACURR | ||||
CONDCURR | Condition Currency of Cash Flow Item | RECDCFCURR | CUKY | 5 | Assigned to domain | WAERS | |||
CFCNDNSAPPROVED | Summarization Approved | REEXCFCNDNSAPPROVED | CHAR | 1 | RECABOOL | ||||
CFCNDNSDECLINED | Summarization Rejected | REEXCFCNDNSDECLINED | CHAR | 1 | RECABOOL | ||||
BOOKLOCK | Locked to Posting | REEXBOOKLOCK | CHAR | 1 | RECABOOL | ||||
ADJMLOCK | Activation of Adjustment Is Locked | REEXADJMLOCK | CHAR | 1 | RECABOOL | ||||
FUND | Fund | RERAFUND | CHAR | 24 | CHAR24 | ||||
FUNDSCENTER | Funds Center | RERAFUNDSCENTER | CHAR | 24 | CHAR24 | ||||
COMMITMENTITEM | Commitment Item | RERACOMMITMENTITEM | CHAR | 24 | Assigned to domain | FMCIL | FM_FIPEX | ||
FUNCTIONALAREA | Functional Area | RERAFUNCTIONALAREA | CHAR | 24 | CHAR24 | ||||
GRANTNUMBER | Grant | RERAGRANTNUMBER | CHAR | 24 | CHAR24 | ||||
MEASURE | Program in Funds Management | RERAMEASURE | CHAR | 24 | CHAR24 | FM_MEASURE | |||
BUDGETPERIOD | FM: Budget Period | RERABUDGETPERIOD | CHAR | 24 | CHAR24 | BUDPER | |||
FMDOCNO | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
FMDOCITEMNO | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
FMDOCREVID | Indicator for Reversed Documents | RERAREVID | CHAR | 1 | RERAREVID | ||||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
COSTCENTER | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ORDERID | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR |
Key field | Non-key field |
How do I retrieve data from SAP table VIEXCFCNDNS using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIEXCFCNDNS to SELECT all data from the tableDATA: WA_VIEXCFCNDNS TYPE VIEXCFCNDNS.
SELECT SINGLE *
FROM VIEXCFCNDNS
INTO CORRESPONDING FIELDS OF WA_VIEXCFCNDNS
WHERE...
How to access SAP table VIEXCFCNDNS
Within an ECC or HANA version of SAP you can also view further information about VIEXCFCNDNS 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