CDS Views for Localization Financials (FI-LOC-FI)

CDS View NameDescriptionSQL View Name
C_AU_STRPTAXITEMCUBEConsumtion View for Australia VAT Tax Line ItemCAUSTRPTAXITEMC
C_AU_STRPTAXITEMQUERYAnalytical Query View for AU VAT ReportingCAUTAXITEMQ
C_CA_STRPGSTITEMCUBECanada GST Tax Item DetailsCCASRGSTITMC
C_CA_STRPGSTITEMQUERYAnalytical Query for Canada GST ItemsCCASRGSTITMQ
C_CA_STRPINPUTTAXCRDTITEMCCanada RITC Cube viewCCASRRITCITMC
C_CA_STRPINPUTTAXCRDTITEMQAnalytical Query for Canada RITC itemsCCASRRITCITMQ
C_CA_STRPPROVINCIALTAXITEMCCanada PST Tax Item DetailsCCASRPSTITMC
C_CA_STRPPROVINCIALTAXITEMQAnalytical Query for Canada PST ItemsCCASRPSTITMQ
C_CA_STRPTAXITEMCUBEConsumption view for Canada GST ReturnCCASRTAXITEMC
C_CA_STRPTAXITEMQUERYAnalytical Query for CA GST ReturnCCASRQTAXITEMQ
C_HU_BALANCEVALUATIONHISTORYValuation History of BalancesCHUBALVALNHISTOR
C_HU_DOCUMENTVALUATIONFIELDDocument Valuation FieldCHUDOCVALNFLD
C_HU_EXCHANGERATECALCULATIONLGExchange rate calculation log (Hungary)CHUEXCHRATECLCLG
C_HU_FINANCIALDEPRECATIONAREAFI Depreciation AreaCHUFIDEPRAREA
C_HU_FOREIGNCURRENCYVALNMETHForeign Currency Valuation MethodsCHUFRGCRCYVLNMTH
C_HU_VALUATIONHISTORYFORDOCSValuation History for DocumentsCHUVALNHISTFDOCS
C_INVENTORYGLACCTBALCUBETurkey Inventory CDS cube viewCINVTRGLACBALC
C_INVENTORYGLACCTBALQUERYTurkey Inventory CDS queryCINVTRGLACBALQ
C_SA_STRPBILLINGWITHREFSDDOCBilling Reference Documents for Saudi ArabiaCSASRBILLREFDOC
C_SA_STRPBILLINGWTHREFACCTGDOCBilling Reference Documents for Saudi ArabiaCSASRBILLRACCDOC
C_SA_STRPTAXITEMCUBETax Item view for ACR Saudi ArabiaCSASRTAXITEMC
C_SA_STRPTAXITEMGROUPINGTax Item Grouping For Statutory Reporting for Saudi ArabiaCSASRTAXITEMGRPG
C_SA_STRPTAXITEMQUERYTax Items for ACR Saudi ArabiaCSASRTXITMQ
C_SA_STRPTAXITEMWITHREFDOCTax Items for ACR Saudi Arabia with Reference DocumentsCSASRTXITMREFDOC
C_SA_STRPTAXITEMWTHREFACCTGDOCTax Items for ACR Saudi Arabia with Accounting Ref DocumentsCSASRTXITMRACDOC
C_STRPADVNCRETFORSLSANDPURTXQAnalytical Query which returns Sales and Purchases Tax ItemsCSRADVRTSLSPRTXQ
C_STRPSALESINVOICECUBEConsumption view for TR Sales listCSALEINVLCUBE
C_STRPSALESINVOICEQUERYSales Invoice List QueryCSALEINVLQUERY
C_STRPTAXITEMBOXQUERYAnalytical Query for Box ReportingCSRTXITMBOXQ
C_STRPTAXRETURNBOXQUERYAnalytical Query Tax Return info with TaxBox configurationCSRTAXRETURNBOXQ
C_STRPTAXRETURNQUERYAnalytical Query to Fetch all types of Tax Return detailsCSRTAXRETURNQ
C_STRPTRIALBALANCEITEMQUERYTrial Balance QueryCSTRPTRIBALITEMQ
C_TR_PURSLSBUSPARTABVTHLDLIMITData above threshold limitCTRBABSBPTHL
C_TR_PURSLSBUSPARTABVTHLDLMTQFinal query to fetch TR Sls & Pur DataCTRBABSBPTHQ
C_TR_PURSLSTAXITEMLOGCUBETurkey consumption view for Purchase and Sales Tax ItemsCTRPRSLSTXITMLGC
C_TR_PURSLSTAXITEMLOGQUERYAnalytical Query displaying Turkey Purchase Sales Tax ItemsCTRPRSLSTXITMLGQ
C_TR_STRPELECTRONICLEDGERCUBECube View For Electronice LedgerCELDGRCUBE
C_TR_STRPELECTRONICLEDGERQQuery View ForElectronic LedgerCELDGRQ
C_TR_STRPINPUTTAXITEMLOGCUBETurkey specific view displays all the input taxitemsCTRINPTXITMLGC
C_TR_STRPINPUTTAXITEMLOGQUERYAnalytical Query to display turkey Input Tax ItemsCTRINPTXITMLGQ
C_ZA_STRPREVENUEEXPENSELINEQRYAnalytical Query for Revenue Expense LinesCSRZARVEXLINEQ
C_ZA_STRPTAXITEMLOGQUERYAnalytical Qry for South Africa Tax Item with Rptd Log DataCSRZATAXITEMLGQ
C_ZA_STRPTAXITEMQUERYAnalytical Query for South Africa Tax Item DataCSRZATAXITEMQ
C_ZA_STRPTAXRETURNBOXQUERYAnalytical Query for South Africa VAT ReportingCZASRTAXRETBOXQ
C_ZA_SUPLRCHARCSANDTAXITEMCUBESouth Africa Supplier Characteristics and Tax Item detailsCZASUPCHARTXITMC
C_ZA_SUPLRCHARCSANDTAXITEMQRYAnalytical query South Africa BBBEE Supplier ClassificationCZASUPCHARTXITMQ
I_ADVANCEDTAXREPORTINGCOUNTRYAdvanced Tax Reporting CountryIATRCOUNTRY
I_CA_FEDGVMNTTAXJXRELEVANTCustomizing view to classify Tax Jur Codes as GST RelICAFEDGVTXREL
I_HU_EXCHANGERATECALCULATIONLGExchange rate calculation log (Hungary)IHUEXCHRATECLCLG
I_STRPADVNCRETFORSLSANDPURTXCCube View which returns Sales and Purchases tax itemsISRADVRTSLSPRTXC
I_STRPBPTAXITEMBusiness Partner Tax ItemISTRPBPTAXITEM
I_STRPCOMPATIBLETXBOXSTRUC2ACR: Tax Items groupping new customizingISCTRPTBXST2
I_STRPCOMPATIBLETXBOXSTRUCTUREACR: Tax Items groupping new customizingISCTRPTBXST
I_STRPTAXITEMBOXCONFIGURATIONTaxBox configuration informationISRTAXITMBOXCONF
I_STRPTAXRETURNBOXCUBECube View to Return Tax Details with TaxBox configurationISRTAXRETURNBOXC
I_STRPTAXRETURNCUBECube view to Return all types of Tax DetailsISRTAXRETURNC
I_STRPTRIALBALANCEITEMCUBETrail Balance Item CubeISRTRLBALITEMC
I_TIMEDEPENDENTTAXSTATUSView to determine is Time dependent Tax is activeITDTSTATUS
I_TR_CONFIGNTRANSKEYTurkey Transaction Key ConfigurationTRCONFGNTRNSKEY
I_TR_PURSLSAGGREGATEDACCTDOCTurkey view to fetch PurSls dataIITRBABSFINAL
I_TR_PURSLSAMOUNTLIMITFetch Thrshold Limit for BaBsITRPURSLSAMTLMT
I_TR_PURSLSTAXITEMView for Purchase and Sales Tax ItemsITRPRSLSTXITM
I_TR_STRPELECTRONICLEDGERITEMElectronic Ledger Documents ReportingITRELDGRITM
I_ZA_STRPREVENUEEXPENSELINECSouth Africa Revenue Expense LinesISRZARVEXLINENC
I_ZA_STRPTAXITEMCUBESouth Africa Tax Items for VAT ReportingISRZATAXITEMC
I_ZA_STRPTAXITEMLOGCUBESouth Africa Tax Items for VAT Rpg with Rptd Log infoISRZATAXITEMLGC
I_ZA_STRPTAXRETURNBOXCUBESouth Africa VAT ReportIZASRTAXRETBOXC
P_BALANCEVALUATIONHISTORYValuation History of BalancesPBALVALNHISTORY
P_BASEAMTFORNEGATIVECHARGEPrivate view to return Base Amount for Neg ChargePBASEAMTNEGCHARE
P_BUSINESSFUNCTIONSTATUSView to determine if a system is cloud or on-premise.PBUSFUNCSTATUS
P_CLOUDPACKAGEView to determine if a package is Cloud Package or notPCLOUDPACKAGE
P_CNDNTYPETAXCLASSIFICATIONCondition Type ClassificationPCNDNTYPTXCLS
P_COMPANYTAXDETAILSPrivate view to retrieve Company Tax DetailsPCOCODETXDET
P_CONDITIONSITEMPrivate view to retrieve Conditions ItemPCNDTNITM
P_COUNTCOUNTRYPrivate view to count no of countriesPCOUNTCNTRY
P_COUNTOFSAMETAXCODELINESCount number of Lines with same TaxCodePCNTSAMTXCDLNS
P_COUNTOFTAXLINESNumber of Tax Line Items Per DocumentPCOUNTOFTXLINE
P_DEFTAXINVOICEDeferred Tax Invoice DataPDEFTAXINVOICE
P_DEFTAXTRANSFERPreselection for Deferred Tax Transfer DataPDEFTAXTRANSFER
P_DEFTAXTRANSFER1Preselection for Deferred Tax Transfer DataPDEFTAXTRANSFER1
P_DISTINCTDATETOFISCALYEARDistinct Date to Fiscal YearPDISTDATTOFY
P_FOREIGNCURRENCYVALNMETHForeign Currency Valuation MethodsPFRGNCRCYVALNMTH
P_PLANTSANDBRANCHESITEMPrivate View to fetch data from PlantsPPLANTSITEM
P_REFUNDRELATEDTAXCODEPrivate view for fetching Refund Tax CodesPRFDTXCODES
P_RETRIEVEMRNVALUESRetrieve MRN ValuesPRTRVMRNVAL
P_RNDRULESFORCOCODEANDCRCYPrivate view for fetching Rounding RulesPRNDRULEFRCCNCCY
P_SA_COMPANYCODE_ADDRESSKSA VAT Company Code AddressPSACOMPCODEADDRS
P_SLSPURLISTBPTAXITEMSales Purchase List BP Tax ItemPSPLSTBPTAXITM
P_SLSPURLISTBPTAXITEM00Sales Purchase List BP Tax Item (Helper)PSPLSTBPTAXITM00
P_SLSPURLISTBPTAXITEM10Sales Purchase List BP Tax Item (Helper)PSPLSTBPTAXITM10
P_SLSPURLISTBPTAXITEM20Sales Purchase List BP Tax Item (Helper)PSPLSTBPTAXITM20
P_STRPADVNCRETFORSLSANDPURTXPrivate view for Advance VAT ReturnPSRADVRTSLSPURTX
P_STRPALLTAXITEMPrivate view to select all the tax itemsPSRALLTXITM
P_STRPBPTAXITEMBusiness Partner Tax Item (Journal Entry Item Branch 1)PSTRPBPTAXITEM
P_STRPBPTAXITEM1Business Partner Tax Item (Tax Item Branch 2)PSTRPBPTAXITEM1
P_STRPBPTAXITEM2Business Partner Tax Item (Tax Item Branch 1)PSTRPBPTAXITEM2
P_STRPBPTAXITEM3Business Partner Tax Item (Journal Entry Item Branch 2)PSTRPBPTAXITEM3
P_STRPBPTAXITEM4Business Partner Tax Item (Journal Entry Item Branch 2)PSTRPBPTAXITEM4
P_STRPCALTAXRETURNCalculated Tax Return InformationPSRCALTAXRET
P_STRPCALTAXRETURNBOXCalculated Tax Return Box InformationPSRCALTAXRETBOX
P_STRPNOTREPORTEDITEMFinal private view to fetch Not reported items in ACRPSRNTRPTDTITMFIN
P_STRPNOTRPTDITEMPrivate view to fetch Not reported items in ACRPSRNTRPTDTAXITM
P_STRPRPTDANDNOTRPTDITEMPrivate view to select both reported and not reported docsPSRRDNNTRPTXITM
P_STRPSALESINVOICEITEMPrivate View for Sales Invoice ListPSALEINVLITEM
P_STRPTAXITEMCOUNTDocument Count With Same Tax CodePCNTAXLINE
P_STRPTAXRETURNPrivtate view for Tax ReturnsPSRTAXRETURN
P_STRPTAXRETURNBOXPrivate view to return Tax Details with TaxBox configPSRTAXRETBOX
P_STRPTAXRETURNCUBECDS view for P_StRpTaxReturnCubePSRTAXRETURNC
P_STRPTRIALBALANCEITEMTrial Balance ItemPSRTRLBALITM
P_STRPTRIALBALANCEITEM1Trial Balance Line ItemPTRIALBALITEM1
P_STRPTRIALBALANCEITEM2Trial Balance Line Item 2PTRIALBALITEM2
P_TAXCODEPrivate view to retrieve Tax Code DetailsPFITAXCODE
P_TIMEDEPDNTVERSASSGMTPrivate view for Time dependent version assignmentPTIMDEPVERASSN
P_TIMEDEPDNTVERSASSGMTNEXTSecond Private view for Time dependent version assignmentPTIMDEPVERASSNXT
P_TR_CONFIGNTRANSKEYPrivtate view for Turkey Configuration Transaction KeysPTRCONFGNTRNSKEY
P_TR_PURSLSACCDOCDATATurkey view to fetch Acc Doc DataPTRBABSACDOC
P_TR_PURSLSAGGACCDOCAggrTaxbase amt on BP levelPTRBABSAGGACDOC
P_TR_PURSLSAMOUNTLIMITFetch data from the table fitrc_limitPTRBABSAMTLIMIT
P_TR_STRPELDGRREPORTEDITEMLOGReported item logPTRRPTLOG
P_TR_STRPELECTRONICLEDGERHDRElectronic Ledger Documents ReportingPTRELDGRHDR
P_TR_STRPINPUTTAXITEMLOGInput Item details to fetch OriginalReference DocumentNumPTRSRINPTXITM
P_ZA_CHARACTERISTICSVALUEGet the Characteristics Values for ZA BBBEEPCHARCSVAL
P_ZA_STRPTAXRETURNBOXPrivate CDS view for South Africa PDF reportPZASTRPTXBOX1
P_ZA_STRPTAXRETURNBOX2Private CDS view for ZA PDF report 2PZASTRPTXBOX2
P_ZA_STRPTAXRETURNBOX3Private CDS view for ZA PDF report 3PZASTRPTXBOX3
P_ZA_STRPTAXRETURNBOX4Private CDS view for ZA PDF report 4PZASTRPTXBOX4
P_ZA_STRPTAXRETURNITEMPrivate view for Item level data for ZA ReportPZASRTAXRETITEM
SRF_HELPER_VATsfadSRF_HELPER_VAT
SRF_HELPER_VATREGNCOUNTRYSPLITSplit country and VAT registrationSRFVATCNTRYSPLIT
SRF_HELPER_VATREGNSTRTWTHCNTRYCheck if VAT regn starts with countrySRFHVATSTRTCNTRY
SRF_ZA_HELPER_SUMAMTSHelper View for obtaining the Sum of all Monetary FieldsSRFZAHLPRSMAMTS

Other CDS Views