FDATE in VGTBS

Table Field KEY FOTFDATE

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, TaxCodeValidFromDate.

Business Meaning

Description (EN)From Date
Beschreibung (DE)Ab-Datum
Data ElementFOTFDATE
Key FieldYes

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 (36 views)

ViewAccessVDMReleaseDescription
I_TaxBoxStructure direct BASIC Tax Box Structure definition
P_TaxBoxStructureValidTo1 direct BASIC ValidTo for Tax Box Structure
I_StRpCompatibleTxBoxStructure via 2 level COMPOSITE ACR: Tax Items groupping new customizing
P_TaxBoxStructureValidTo2 via 2 level BASIC ValidTo for Tax Box Structure
I_StRpTaxItemGrpg via 3 levels COMPOSITE Tax Item Grouping For Statutory Reporting
P_GB_ParkedTaxItems via 3 levels CONSUMPTION Parked customer/supplier items
I_StRpTaxItemBoxCube via 4 levels COMPOSITE VAT Tax Item box level reporting
P_KR_StRpNotRptdItem via 4 levels COMPOSITE Not Reported Tax Items for Korean VAT
P_StRpCalTaxReturnBox via 4 levels COMPOSITE Calculated Tax Return Box Information
P_StRpTaxItemBoxPA via 4 levels COMPOSITE VAT Tax Item box level reporting
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 Tax Item groups for ID Statutory Report
P_MY_StRpTxItmWithOriglDoc via 5 levels COMPOSITE Statutory Tax Item with Original Document
P_MY_TDTTAXRATE via 5 levels COMPOSITE Get Tax Percentage
P_MY_TxItmWithSlsDeductionAmt via 5 levels COMPOSITE Tax Item with Sales Deduction Amount
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_RS_StRpTaxReturnBoxQuery via 6 levels CONSUMPTION Analytical Query Tax Return info RS
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 Statutory Tax Item with Product
P_NZ_StRpTaxReturnBox via 6 levels COMPOSITE New Zealand specific base view for TaxBox Reporting
P_PH_SalesPurchasesSummaryItem via 6 levels COMPOSITE PH Sales Purchase Summary
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)

ViewAccessVDMReleaseDescription
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

TaxCodeValidFromDate (1 view)

ViewAccessVDMReleaseDescription
C_GB_StRpNotRptdTaxItem via 7 levels CONSUMPTION GB: Non Reported document for Statutory Reporting

Other Tables with Field FDATE (11)

TableData ElementKeyDescription
/ATL/GL1V GDATU_INV KEY Index Values
CUS_IMGACH HIER_FDATE IMG Activity
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