CDS Views

CDS Views (Finance - Master Data)

Show extracted text

SAP S4HANA
FINANCE
CDS VIEWS – MASTER DATA
January 2021
Table of Contents
CDS Views for Master Data ................................ ................................ ................................ .... 5
Country ................................ ................................ ................................ ................................ . 5
Country text ................................ ................................ ................................ .......................... 5
Fixed Asset ................................ ................................ ................................ ............................ 6
Fixed Asset Group ................................ ................................ ................................ .................. 7
Fixed Asset (Country-Dependent Data) ................................ ................................ ................... 7
Fixed Asset (Time-Dependent Data) ................................ ................................ ....................... 9
Fixed Asset Valuation (Ledger-Dependent Data)................................ ................................ ... 10
Asset Class ................................ ................................ ................................ ........................... 10
Depreciation Key ................................ ................................ ................................ ................. 10
Depreciation Area ................................ ................................ ................................ ................ 10
Depreciation Area Text ................................ ................................ ................................ ........ 11
Chart of Depreciation................................ ................................ ................................ ........... 11
Chart of Depreciation Text ................................ ................................ ................................ ... 11
Asset Transaction Type ................................ ................................ ................................ ........ 12
Asset Transaction Type Text ................................ ................................ ................................ . 12
Asset Account Determination ................................ ................................ ...............................  12
Asset Accounting Key Figure ................................ ................................ ................................  13
Asset Accounting Key Figure Text ................................ ................................ ......................... 13
Asset Accounting Key Figure Group ................................ ................................ ...................... 13
Asset Accounting Key Figure Group Text ................................ ................................ .............. 14
Asset Accounting Key Figure Group Specification (With Sorting Sequence) ............................ 14
Evaluation Group 1 ................................ ................................ ................................ .............. 14
Evaluation Group 2 ................................ ................................ ................................ .............. 15
Evaluation Group 3 ................................ ................................ ................................ .............. 15
Evaluation Group 4 ................................ ................................ ................................ .............. 15
Evaluation Group 5 ................................ ................................ ................................ .............. 18
Financial Statement Item ................................ ................................ ................................ ..... 18
Consolidation  Dimension ................................ ................................ ................................ .... 20
Consolidation Ledger ................................ ................................ ................................ ........... 20
Consolidation Version ................................ ................................ ................................ .......... 21
Consolidation Chart of Accounts................................ ................................ ........................... 21
Consolidation Group ................................ ................................ ................................ ............ 22
Consolidation Unit ................................ ................................ ................................ ............... 22
Subitem Category ................................ ................................ ................................ ................ 23
Subitem ................................ ................................ ................................ ...............................  23
Document Type ................................ ................................ ................................ ................... 23
Posting Level ................................ ................................ ................................ ....................... 24
Accounting Document Type ................................ ................................ ................................ . 24
Accounting Document Type Text ................................ ................................ .......................... 25
Chart of Accounts ................................ ................................ ................................ ................ 25
Chart of Accounts Text ................................ ................................ ................................ ......... 27
Currency Role ................................ ................................ ................................ ...................... 27
Currency Role Text ................................ ................................ ................................ ............... 28
Debit Credit Code ................................ ................................ ................................ ................. 28
Debit Credit Code Text ................................ ................................ ................................ ......... 29
Functional Area ................................ ................................ ................................ ................... 29
Functional Area Text ................................ ................................ ................................ ............ 30
G/L Account Group ................................ ................................ ................................ .............. 30
G/L Account Group Text ................................ ................................ ................................ ....... 31
G/L Account Type ................................ ................................ ................................ ................ 32
G/L Account Type Text ................................ ................................ ................................ ......... 32
Global Company ................................ ................................ ................................ .................. 32
Joint Venture Recovery ................................ ................................ ................................ ........ 33
Joint Venture Recovery Text ................................ ................................ ................................ . 33
Ledger ................................ ................................ ................................ ................................ . 34
Ledger Group ................................ ................................ ................................ ....................... 35
Ledger Group Text ................................ ................................ ................................ ............... 36
Ledger Text................................ ................................ ................................ .......................... 36
Source Ledger .

CDS Views (Finance - Transactional Data)

View original PDF ↗

Show extracted text

SAP S4HANA
FINANCE
CDS VIEWS – TRANSACTION DATA
January 2021
Table of Contents
CDS Views for Transaction Data  ................................ ................................ ..............................  4
Accounting Document Item: Operational View  ................................ ................................ ....... 4
Accounting Document Item: Operational View (Additional Ledger) ................................ ........ 5
Related Information ................................ ................................ ................................ ................. 6
Accounting Document Journal  ................................ ................................ ................................ . 6
Actual Plan Line Item Semantic Tag  ................................ ................................ ......................... 6
Asset Balances  ................................ ................................ ................................ ........................ 7
Asset Balances (Deprecated)  ................................ ................................ ................................ . 9
Asset Balances Cube  ................................ ................................ ................................ ............. 10
Asset Balances Cube (Deprecated)  ................................ ................................ ...................... 11
Asset History Sheet ................................ ................................ ................................ ................ 12
Asset History Sheet (Deprecated)  ................................ ................................ ........................ 14
Asset History Sheet Cube ................................ ................................ ................................ ....... 16
Asset History Sheet Cube (Deprecated)  ................................ ................................ ............... 17
Financial Statement-based KPIs ................................ ................................ .............................  19
G/L Account Balance  ................................ ................................ ................................ ............ 20
G/L Account Balance Cube ................................ ................................ ................................ ..... 21
G/L Account Balance Comparison Cube  ................................ ................................ .............. 22
G/L Account Balance with Flow Measure  ................................ ................................ .............. 23
Retrieve Balances for G/L Accounts in Fiscal Period  ................................ ..............................  25
G/L Account Line Item ................................ ................................ ................................ ............ 27
G/L Account Line Item Cube  ................................ ................................ ................................ ... 28
G/L Account Line Item Semantic Tag ................................ ................................ ................... 29
Journal Entry Analyzer ................................ ................................ ................................ ........... 31
Journal Entry: Operational View  ................................ ................................ ............................ 32
Journal Entry Item ................................ ................................ ................................ .................. 34
Journal Entry Item Cube ................................ ................................ ................................ ......... 35
Journal Entry Item Browser  ................................ ................................ ................................ .... 37
Journal Entry Item Cube - Plan/Actual ................................ ................................ ................... 39
Plan Line Item Semantic Tag  ................................ ................................ ................................ .. 40
Trial Balance ................................ ................................ ................................ .......................... 42
Trial Balance Comparison ................................ ................................ ................................ ...... 42
Trial Balance for API................................ ................................ ................................ ............... 43
Group Journal Entries Cube  ................................ ................................ ................................ .... 44
Group Report Data Cube ................................ ................................ ................................ ........ 45
Enhanced Group Report Data Cube  ................................ ................................ ....................... 46
Group Data Analysis Cube ................................ ................................ ................................ ...... 47
Rule-Based Group Data Analysis Cube  ................................ ................................ ................... 49
Company Code User Default Value  ................................ ................................ ........................ 50
Inbox View of GL JE to Be Verified  ................................ ................................ ......................... 51
CDS Views for Configuration Data  ................................ ................................ ......................... 52
CDS Views for Fiscal Calendar  ................................ ................................ ................................  52
Fiscal Year ................................ ................................ ................................ ..............................  52
Fiscal Year Variant ................................ ................................ ................................ ................. 52
Fiscal Year for Company Code ................................ ................................ ................................  53
Fiscal Year Period ................................ ................................ ................................ ................... 54
Fiscal Year Period for Company Code ................................ ................................ ..................... 55
Fiscal Year Period for Ledger  ................................ ................................ ................................ .. 55
Fiscal Calendar Date ................................ ................................ ................................ .............. 56
Fiscal Calendar Date for Company Code  ................................ ................................ ................ 57
Fiscal Calendar Date for Ledger  ................................ ................................ .............................  58
Previous Fiscal Period to each Fiscal Calendar Date  ................................ ..............................  59
Previous Fiscal: Year, Period, Quarter to Fiscal Cal. Date  ................................ ...................... 60
Next Fiscal Period for each Fiscal Calendar Date  ................................ ................................ ... 61
Next Fiscal: Year, Period, Quarter for Fiscal Calendar Date  ................................ ................... 61
Fiscal Year Week with Next Fiscal Year Week  ................................ ................................ ........ 62
Inventory Valuation Type  ................................ ................................ ................................ ....... 63
Tax Jurisdiction ................................ ................................ ................................ ...................... 64
Tax Jurisdiction (Text) ................................ ................................ ................................ ........... 64
CDS Views for Transaction Data
Accounting Document Item: Operational View
Technical name I_OperationalAcctgDocItem
View type  Dimension
Purpose
This CDS view provides ac

Custom CDS Views (Document)