CDS Views for Localization Financials (generic parts) (FI-LOC-GEN)

CDS View NameDescriptionSQL View Name
C_AU_STRPBASGENERALLEDGERBALCAU Bas G/L Balance CubeCAUSTRPBASGLBALC
C_AU_STRPBASGENERALLEDGERBALQAU BAS Analytical Query ViewCAUSTRPBASGLBLQ
C_AU_STRPTPARACCOUNTINGDOCSQRYAustralia TPAR Accounting Docs QueryCAUTPARACCTGDOCQ
C_AU_STRPTPARCRRTNPHSEDETQRYAustralia TPAR Crrtn Phase Details QueryCAUSRTPARCRTNPDQ
C_AU_STRPTPARSUPLRDETAILSQRYAustralia TPAR Supplier Details QueryCAUSRTPARSPLRDQ
C_IN_SUBCONTRGCHALLANQUERYSubcontracting Challan CockpitCSUBCHALLANQUERY
C_STRPCASHFLOWFINSTMNTQUERYCash Flow By Financial StatementCSRCASHFTMNTQ
C_STRPCOMPANYCODEQConsumption View for CompanyCode DetailsCSRCOMPCODEQ
C_STRPNOTRPTDJOURNALENTRYNot Reported Journal EntriesCNOTRPTDDOCS
C_STRPNOTRPTDTAXITEMNon Reported document for Statutory ReportingCSRNOTRPTDTAXITM
C_STRPRPTDJOURNALENTRYReported document for Statutory ReportingCSRRPTDJRNLENTRY
C_STRPTAXITEMAll Tax Items for Statutory ReportingCSRTAXITEM
C_STRPTAXITEMBOXLOGQUERYAnalytical Query for Box Reporting With Rptd Item Log DataCSRTXITMBOXLGQ
C_STRPTAXITEMQTax Items for Statutory ReportingCSRQTAXITEM
I_AU_STRPBASGENERALLEDGERBALAU BAS payg balanceIAUSTRPBASGLBALC
I_AU_STRPBASTAXTYPEAU BAS payg balanceIAUSTRPBASTYP
I_AU_STRPTPARACCOUNTINGDOCCUBEAustralia TPAR Acctg Documents CubeIAUTPARACCTGDOCC
I_AU_STRPTPARCRRTNPHSEDETCUBEAustralia TPAR Crrtn Phase Detail CubeIAUSRTPARCPDC
I_AU_STRPTPARGRANTSCONFIGNOBJAustralia TPAR Grants Confign ObjectIAUSRTPARGRCO
I_AU_STRPTPARINVOICELINEITEMSAustralia TPAR Invoice Line ItemsIAUTPARINVCLI
I_AU_STRPTPARSERVICETYPEAustralia TPAR Service TypeIAUSRTPARSTYP
I_AU_STRPTPARSUPLRDETAILSCUBEAustralia TPAR Supplier Details CubeIAUSRTPARSUPLRDC
I_AU_STRPTPARSUPPLIERAMOUNTLOGAustralia TPAR Supplier Amount LogIAUSRTPARSUPLRAL
I_BREXITPROTOCOLVALIDITYNorthern Ireland Protocol ValidityINIPROT
I_BSET_GLORead VAT AmountIBSETGLO
I_CASTREPLOGInformation for documents selected per report runICASTREPLOG
I_DOCTYPEOFCLDOCCLASSASSGMTDocument Type Official Doc Class AssgmtIDOCCLASSASSGMT
I_FINSTMNTWITHJRNLENTRYRPTGCFin Stmnt Info for Rptg. with JE entriesIFINSTATRPTGJE
I_IN_CHALLANSTATUSSTDVHValue Help for Challan StatusIINCHLLNSTSSTDVH
I_IN_CHALLANSTDVHValue Help for Challan NumberIINCHLNSTDVH
I_IN_CHALLANVISLFLTRVisual Filter For Challan StatusIINCHLNVISLFLTR
I_IN_GOODSISSUEDOCLISTGoods Issue Documents For INDIAIGOODSISUDOCLST
I_IN_GOODSRECEIPTDOCLISTList of Goods Receipt DocumentsIGOODSRCPTDOCLST
I_IN_MATLDOCLISTMaterial Document for Subcon ChallanINMATLDOCLIST
I_IN_MATLDOCNOTREVERSEDDocuments which are not canceledIMATDOCNOTREV
I_IN_MATLDOCSTDVHVH for Uncancelled Material DocumentIMATLDOCSTDVH
I_IN_PLANTSTDVHValue Help for PlantINPLANTSTDVH
I_IN_SUBCONTRACTORSTDVHValue Help for SubcontractorISUBCONTRACTORVH
I_STRPCASHFLOWFINSTMNTHIERCUBECash Flow Financial Statement HierarchyISRCASHFINSTMNTC
I_STRPCASHFLOWLQDYITEMCUBECash flow By Liquidity ItemISRCASHLQDYITMC
I_STRPCUSTOMERSUPPLIERLINEITEMCustomer Supplier Line ItemISRCUSTSUPITM
I_STRPFINANCIALSTATEMENTLGAll documents to be reported for a Fin. Statement versionIFINSTATRPTGL
I_STRPJOURNALENTRYLOGJournal entries selected by a report runISRJRNLENTRLOG
I_STRPRUNDETAILSReporting Periods of Reporting DocumentsISTRPTRUNDET
I_STRPTAXITEMTax Item view for Statutory ReportingISRTAXITEM
I_STRPTAXITEMBOXCUBEVAT Tax Item box level reportingISRTAXITEMBOX
I_STRPTAXITEMGRPGTax Item Grouping For Statutory ReportingISRTAXITEMGRPG
I_STRPTAXITEMLOGTax Items log for Statutory ReportingISRTAXITEMLOG
I_STRPTAXITMWITHEUTAXCLASSEU Sales Tax Item view for Statutory ReportingISRTIEUTAXCLS
I_TAXBOXSTRUCTURETax Box Structure definitionITAXBOXSTRUC
I_TAXBOXSTRUCTURE2Tax Box Structure definitionITAXBOXSTRUC2
I_TAXDECLNAMOUNTTYPETax Amount TypesITAXDECLNAMTTYP
I_TAXDECLNAMOUNTTYPETEXTTax Amount Types TextITAXDECLNAMTTYPT
P_AU_STRPAGGRGTXITMPERACCTGDOCAU TPAR aggregate tax itemsPAUSRATXIPERADOC
P_AU_STRPBASCALCULATIONAU BAS Summary CalculationPAUSTRPBASCAL
P_AU_STRPBASCALCULATION1AU BAS Summary CalculationPAUSTRPBASCAL1
P_AU_STRPBASCALCULATION2AU BAS Summary CalculationPAUSTRPBASCAL2
P_AU_STRPBASGLBALAU BAS GL BalancePAUSTRPGLBAL
P_AU_STRPBASGLBALSUMAU BAS GL Balance SumPAUSTRPBASGLSUM
P_AU_STRPBASGLBALSUM1GL Balance SumPAUSTRPBASGLSUM1
P_AU_STRPBASGLBALSUMMARYAMNTAU BAS GL Balance SumPAUSTRPBASGLAMNT
P_AU_STRPBASITEMAU BAS Document SelectionPAUSTRPBASITEM
P_AU_STRPBASSMMRYAMNTAU BAS Summary CalculationPAUSTRPSUMMRYAMT
P_AU_STRPTPARACCOUNTINGDOCSTPAR Docs with Gross and Tax Amount Per Doc.PAUTPARACCTGDOCS
P_AU_STRPTPARAGGRGSUPPLIERAMTAU TPAR Supplier Amount Log AggregatePAUSRTPARASUPLRA
P_AU_STRPTPARAGGRGTAXLINEITEMSAggregrated Tax Items Per Accounting DocPAUSRTPARATXLITM
P_AU_STRPTPARCOMPANYCODEDETSPayer RecordsPAUSRTPARCCD
P_AU_STRPTPARCRRTNPHSESUPLRDETAU TPAR Correction Phase Supplier DetailPAUSRTPARCRTNPSD
P_AU_STRPTPARCRRTNPHSESUPLRLOGAU TPAR Correction Phase Supplier LogPAUSRTPARCRTNPSL
P_AU_STRPTPARFULLYPAIDINVCDOCFully Cleared DocumentsPAUSRTPARFPINVCD
P_AU_STRPTPARMINIMUMTAXLINEITMAU TPAR Minimun Tax Line ItemPAUSRTPARMTXLITM
P_AU_STRPTPARPRTLYPAIDINVCDOCPartially Cleared DocumentsPAUSRTPARPPINVCD
P_AU_STRPTPARSERVICETYPEAustralia TPAR Service TypePAUSRTPARSTYP
P_AU_STRPTPARSOFTWARECOMPSoftware ComponentPAUSRTPARSOFTCMP
P_AU_STRPTPARSUPLRACCTGDOCITMUnion of Fully and Partially Cleared DocumentsPAUSRSPLRACCDITM
P_AU_STRPTPARSUPPLIERAMOUNTLOGSupplier Amount LogPAUSRTPARSUPLRAL
P_AU_STRPTPARSUPPLIERDETAILSAU TPAR Supplier DetailsPAUSRTPARSUPLRD
P_AU_STRPTPARTAXLINEITEMSTax Items of TPAR Accounting DocsPAUSRTPARTXLITMS
P_AU_TPARSUPPLIERBANKDETAILSAU TPAR Bank DetailsPAUTPARSPLRBNKD
P_BOEDPEXCLUDE_GLODown payment with BoE Withholding Tax ViewPBOEDPEXCLGLO
P_BSEC_GLOOne Time partner DataPBSECGLO
P_COMPANYCODEDETAILSPAPlant Aborad DetailsPCOCODETAILSPA
P_CUSTOMERVENDORLINEITEMCustomer Vendor Line ItemPCSTVENLINITM
P_CUSTOMERVENDORLINEITEM1Customer Vendor Line ItemPCSTVENLINITM1
P_CUSTVENDLINEITEMFINALCustomer Vendor line with min itemPCUSTVENDF
P_DEBTORCREDITORRBLSPYBLSITEMDebtor Creditor Receivables Payables ItemPDRCRRBPAYITM
P_DPWITHBOE_GLODown payment with BoE Withholding Tax ViewPDPWITHBOEGLO
P_FIRSTDBTRCRDTRRBLSPYBLMINITMCustomer Vendor Minimum Line itemPDKMINITEM
P_FIRSTDBTRCRDTRRBLSPYBLSITEMFirst Vendor or Customer Accounting Document ItemPFSTDRCRRBITM
P_GETNONDEDUCTIBLEDOCITEMPrivate view to obtain Non Deductible Doc ItemsPGETNONDEDDOCITM
P_GLACCOUNTWITHJOURNALENTRYDistinct on I_JournalEntryItem by GL AccountPGLWITHJE
P_IDUK_BREXITView of parameter table for BrexitPIDUKBREXIT
P_KNAS_GLOCustomer Master (VAT registration numbers general selection)PKNASGLO
P_LFAS_GLOVendor master (VAT registration numbers general section)PLFASGLO
P_OPLACCTGDOCITEMCREDITSUMSum of S-AmountsPFIOPACCTGDITCS
P_OPLACCTGDOCITEMDEBITSUMSum of S-AmountsPFIOPACCTGDITDS
P_STRPCASHFLOWLQDYITEMBASEHelp view for cash flowPSRCASHLQDYITMBS
P_STRPCASHFLOWLQDYITEMCALAmount CalculationPSRCASHLQDYITMC
P_STRPNOTRPTDTAXITEMNon Reported document for Statutory ReportingPSRNOTRPTDTAXITM
P_STRPRPTDTAXITEMReported document for Statutory ReportingPSRRPTDTAXITM
P_STRPTAXITEMTax Item for Statutory Reporting (Auxiliary View)PSRTAXITEM
P_STRPTAXITEMGRPGTax Item Grouping For Statutory ReportingPSRTAXITEMGRPG
P_STRPTAXITEMVERSIONGRPGPrivtate view for old Box configurationPSRTXITMVERGRPG
P_STRPTAXITMWITHEUTAXCLASS1EU Sales Tax Item View for Statutory ReportingPSRTIEUTAXCLS1
P_STRPTAXITMWITHEUTAXCLASS2EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS2
P_STRPTAXITMWITHEUTAXCLASS3EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS3
P_STRPTAXITMWITHEUTAXCLASS4EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS4
P_STRPTAXITMWITHEUTAXCLASS5EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS5
P_STRPTAXITMWITHEUTAXCLASS6EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS6
P_STRPTAXITMWITHEUTAXCLASS7EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS7
P_STRPTAXITMWITHEUTAXCLASS8EU Sales tax Item View for Statutory ReportingPSRTIEUTAXCLS8
P_T007B_GLOGet taxtypePT007BGLO
P_T007K_GLOTemporary View for T007K AccessPT007KGLO
P_T007L_GLOTemporary View for T007L AccessPT007LGLO
P_TAXBOXSTRUCTUREVALIDTO1ValidTo for Tax Box StructurePTBSVALTO1
P_TAXBOXSTRUCTUREVALIDTO2ValidTo for Tax Box StructurePTBSVALTO2
SRFHELPERUPPERCASETranslated to UppercaseSRF_HELPER_UPPER

Other CDS Views