FDATE in VGTBS
From Date (DE: Ab-Datum)
FDATE is a field in SAP table VGTBS (Tax Box Structure). It represents "From Date". Data element: FOTFDATE. Available in 40 CDS view(s) as ValidFrom, TaxBoxStrucValidityStartDate.
Business Meaning
| Description (EN) | From Date |
|---|---|
| Beschreibung (DE) | Ab-Datum |
| Data Element | FOTFDATE |
| Key Field | Yes |
CDS Views & Technical Names (40)
VGTBS.FDATE is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
ValidFrom
(37 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_TaxBoxStructure | direct | BASIC | Tax Box Structure definition | |
| P_TaxBoxStructureValidTo1 | direct | BASIC | ||
| I_StRpCompatibleTxBoxStructure | via 2 level | COMPOSITE | ACR: Tax Items groupping new customizing | |
| P_TaxBoxStructureValidTo2 | via 2 level | BASIC | ||
| I_StRpTaxItemGrpg | via 3 levels | COMPOSITE | Tax Item Grouping For Statutory Reporting | |
| P_GB_ParkedTaxItems | via 3 levels | CONSUMPTION | ||
| I_StRpTaxItemBoxCube | via 4 levels | COMPOSITE | VAT Tax Item box level reporting | |
| P_KR_StRpNotRptdItem | via 4 levels | COMPOSITE | ||
| P_StRpCalTaxReturnBox | via 4 levels | COMPOSITE | ||
| P_StRpTaxItemBoxPA | via 4 levels | COMPOSITE | ||
| C_CH_VATTaxItemCube | via 5 levels | CONSUMPTION | Tax Items log for Statutory Reporting for Switzerland | |
| I_FR_VATTaxItemCube | via 5 levels | COMPOSITE | VAT Tax Item Cube | |
| I_StRpTaxItemLog | via 5 levels | COMPOSITE | Tax Items log for Statutory Reporting | |
| I_StRpTaxReturnBoxCube | via 5 levels | COMPOSITE | Cube View to Return Tax Details with TaxBox configuration | |
| P_ID_STRPTAXITEMGROUP | via 5 levels | COMPOSITE | ||
| P_MY_StRpTxItmWithOriglDoc | via 5 levels | COMPOSITE | ||
| P_MY_TDTTAXRATE | via 5 levels | COMPOSITE | ||
| P_MY_TxItmWithSlsDeductionAmt | via 5 levels | COMPOSITE | ||
| P_RO_StRpSalesPurchaseBox | via 5 levels | CONSUMPTION | Data selection for the RO SPJ | |
| C_AT_StRpTaxItemQuery | via 6 levels | CONSUMPTION | VAT Tax Item Query for Austria | |
| C_CH_VATTaxItemQuery | via 6 levels | CONSUMPTION | VAT Tax Item Query for Switzerland | |
| C_DE_TaxReturnBoxQuery | via 6 levels | CONSUMPTION | Query Tax Items for Germany | |
| C_FR_VATTaxItemQuery | via 6 levels | CONSUMPTION | VAT Tax Item Query | |
| C_GB_StRpTaxItemBoxCube | via 6 levels | CONSUMPTION | VAT Tax Item box level reporting | |
| C_IT_TaxReturnBoxCube | via 6 levels | CONSUMPTION | Tax Items for Italy | |
| C_PT_StRpTaxItemQuery | via 6 levels | CONSUMPTION | VAT Tax Item Query for Portugal | |
| C_StRpTaxReturnBoxQuery | via 6 levels | CONSUMPTION | Analytical Query Tax Return info with TaxBox configuration | |
| I_ZA_StRpTaxReturnBoxCube | via 6 levels | COMPOSITE | South Africa VAT Report | |
| P_GB_StRpRCTaxItemBoxCube | via 6 levels | CONSUMPTION | VAT Tax Item box level reporting for Reverse Charge | |
| P_MY_StRpTaxItemWithProduct | via 6 levels | COMPOSITE | ||
| P_NZ_StRpTaxReturnBox | via 6 levels | COMPOSITE | New Zealand specific base view for TaxBox Reporting | |
| P_PH_SalesPurchasesSummaryItem | via 6 levels | COMPOSITE | ||
| P_SI_StRpTaxReturnBoxCube | via 6 levels | COMPOSITE | Slovenian TaxBox view | |
| P_StRpTaxReturnBoxCube | via 6 levels | COMPOSITE | Private View to Return Tax Details | |
| C_GB_StRpTaxItemQuery | via 7 levels | CONSUMPTION | Items from the current period | |
| C_IT_TaxReturnBoxQuery | via 7 levels | CONSUMPTION | Query Tax Items for Italy | |
| C_ZA_StRpTaxReturnBoxQuery | via 7 levels | CONSUMPTION | Analytical Query for South Africa VAT Reporting |
TaxBoxStrucValidityStartDate
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_SK_StRpCtrlStmntTaxGroup2 | direct | BASIC | SK VAT Control Statement Tax Group 2 | |
| I_TaxBoxStructure | direct | BASIC | Tax Box Structure definition | |
| I_ID_StRpTaxItemGrp | via 6 levels | COMPOSITE | Tax Item groups for ID Statutory Report | |
| C_ID_StRpVATOut | via 7 levels | CONSUMPTION | ID VAT OUT Statutory Report view |
Other Tables with Field FDATE (11)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /ATL/GL1V | GDATU_INV | KEY | Index Values |
| CUS_IMGACH | HIER_FDATE | IMG Aktivitäten | |
| DFKKBPLOCK | FDATE_KK | FI-CA: Geschäftspartnersperren | |
| DFKKBPLOCKH | FDATE_KK | FI-CA: Geschäftspartnersperren - Historie | |
| DFKKLOCKS | FDATE_KK | KEY | FI-CA: Betriebswirtschaftliche Sperren |
| DFKKLOCKSH | FDATE_KK | Historien zu BWL-Sperren | |
| DFKKOP_LOCKSNAP | FDATE_KK | Snapshot table for FI-CA business lock analysis | |
| T8JG | FDATE | KEY | Valid Investment Group |
| VGTAXBOX | FOTFDATE | KEY | Tax Boxes |
| VGTAXGR | FOTFDATE | KEY | Tax Groups Definition |
| VGTGTB | FOTFDATE | KEY | Assignment of Tax Groups to Tax Boxes |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA