CDS Views for Financials Mexico (FI-LOC-FI-MX)

CDS View NameDescriptionSQL View Name
C_DUEDEFERREDTAXITEMLOGQUERYAnalytical Qry to display DueDefered Tax with Rptd Item LogCDUEDEFTXITMLGQ
C_DUEDEFERREDTAXITEMQUERYAnalytical Query to display Due Deferred Tax ItemsCDUEDEFTXITMQ
C_MX_AUXILIARYRPTACCTBALANCEQMX Auxiliary Report for Accounts QueryCMXAUXACCTBALQ
C_MX_AUXILIARYRPTACCTDETAILCMX Auxiliary Rpt for Acct Details CubeCMXAUXACCTDETC
C_MX_AUXILIARYRPTACCTDETAILQMX Auxiliary Report for Accounts Details QueryCMXAUXACCTDETQ
C_MX_DUETAXANDWHLDGTXITEMCUBEMexico specific Due Tax and Withholding Tax ItemCMXDUTXNWGTXITMC
C_MX_DUETAXANDWHLDGTXITEMLOGCMexico specific Due Tax and Whldg Tax with Rptd Item Log DtaCMXDTXNWGTXITLGC
C_MX_DUETAXANDWHLDGTXITEMLOGQAnalytical Query for Due and Whldg Tax with Rptd Log InfoCMXDTXNWGTXITLGQ
C_MX_DUETAXANDWHLDGTXITEMQUERYMexico specific Analytical Query Due Tax and Whldg Tax ItemCMXDUTXNWGTXITMQ
C_MX_FINANCIALSTATEMENTRPTGQAnalytical query for Mexico Financial Statement ReportingCMXFINSTATRPTGQ
C_MX_FINANCIALSTMNTRPTGLOGQAnalytical qry for MX Financial Stmnt Rpg with Rptd Log infoCMXFINSTRPTGLGQ
C_MX_FINANCIALSTMNTSTRUCTUREFinancial Statement Structure for MXCMXFINSTMNTSTRUC
C_MX_GLACCTWITHJOURNALENTRYGL Account with Journal EntryCMXGLACCTJRNL
C_MX_JOURNALENTRYDETAILSCUBEMexico Journal Entry Details CubeCMXJRNLENTRYC
C_MX_JRNLENTRAGGREGATEDDETAILSMexico Journal Entry Aggregated DetailsCMXJRNLENTAGGR
C_MX_JRNLENTRITMINVCDETAILSCJournal Entries Items with Invoices CubeCMXJEINVDETC
C_MX_JRNLENTRITMINVCDETAILSQJournal Entries Items with Invoice QueryCMXJEINVDETQ
C_MX_JRNLENTRITMPAYTDETAILSCJournal Entries Items with Payments CubeCMXJEPAYMDETC
C_MX_JRNLENTRITMPAYTDETAILSQJournal Entries Items with Payment QueryCMXJEPAYMDETQ
C_MX_JRNLENTRWITHRELATEDDOCSLGAudit Trail in Journal Entries ReportCMXJEDETAILSRDLG
C_MX_JRNLENTRYOPERATIONALVIEWCJournal Entries Items CubeCMXJEDETAILSC
C_MX_JRNLENTRYOPERATIONALVIEWQJournal Entries Items QueryCMXJEDETAILSQ
I_DUEDEFERREDTAXITEMCUBEView to display Due Deferred Tax ItemsIDUEDEFTXITM
I_DUEDEFERREDTAXITEMLOGCUBEDue Deferred Tax with Rptd Item Log InfoIDUEDEFTXITMLGC
I_DUETAXANDWITHHOLDINGTAXITEMCView to display Due Tax and Withholding Tax ItemsIDUETXNWTHITM
I_FINANCIALSTATEMENTRPTGCUBEFinancial Statement Reporting InformationIFINSTATRPTG
I_FINANCIALSTATEMENTRPTGLOGCFinancial Statement Reporting with Rptd Log InformationIFINSTATRPTGLGC
I_MX_EXTPAYMENTMETHODMAPPINGExternal Payment Method Mapping for MXIMXPAYTMETHMAP
I_MX_SUPPLIERTRANSACTIONTYPEView to select transaction type and version for SuppliersIMXSUPTTYPE
I_MX_TRANSACTIONTYPEMexico Transaction TypeIMXTRANSTYPE
I_MX_TRANSACTIONTYPETEXTMexico Transaction Type TextIMXTRANSTYPET
I_STRPGLACCOUNTLOGView for logging GL Accounts for Statutory ReportingISRGLACCTLOG
P_COUNTOFSAMETAXINVDOCPrivate View for counting Same Inv DocPCNTINVDOC
P_COUNTOFSAMETAXINVDOC2Private View for counting Same Inv DocPCNTINVDOC2
P_DEFTAX_ITEMDeferred Tax Item DetailsPDEFTXITM
P_DUEDEFERREDTAXITEMLOGCUBEDue Deferred Tax with Rptd Item Log InfoPDUEDEFTXITMLGC
P_DUETAXANDWITHHOLDINGTAXITEMCDue Tax and Withholding Tax ItemsPDUETXNWTHITM
P_DUETAXITEMCOUNTANDWHDGTAXITMTest for withholding MXPDUETITMCTWHTITM
P_JRNLENTRADDLCLRGINFORMATIONClearing Information for MXPMXJRENCLRINFO
P_MX_EDOCINVCDETAILSData from eDocument and eInvoice MXPMXEDOCINV
P_MX_EDOCUMENTPAYMENTDETAILSeDoc Payt Details for MX eAccountingPMXEDOCPAYTDTLS
P_MX_EDOCUMENTSData from eDocument tablePMXEDOC
P_MX_EINVOICEDETAILSData from eInvoice for mexico tablePMXEINVDET
P_MX_ELECTRONICINVCRSPDETAILSElectronic Invoice Details for MXPMXELINVDT
P_MX_EPAYMENTDETAILSePayment Details for Mexico Electronic AccountingPEDOMXPYIT
P_MX_FINANCIALSTMNTSTRUCTUREMX Financial Statement StructurePMXFINSTMNTSTRUC
P_MX_FINANCIALSTMNTSTRUCTURE2Mexico Financial Statement StructurePMXFINSTMNTSTRU2
P_MX_FINSTMNTWTHTRIALBALANCEFinancial Statement with Trial BalancesPMXFINSTMTTRLBAL
P_MX_INVCDESCAMTAmount and descriptionPMXINVCDESCAM
P_MX_INVOICERECEIPTREFERENCEBusiness Partner Tax Item (Journal Entry Item Branch 1)PMXINVCRCPTREF
P_MX_JOURNALENTRYGRHISTORYJournal Entry Goods Receipt HistoryPMXJEGRHIST
P_MX_JOURNALENTRYPAYMENTITEMJournal Entry Payment ItemPMXJRNLENTPAYIT
P_MX_JRNLENTRAGGREGATEDDETAILSMexico Journal Entry Aggregated DetailsPMXJRNLENTAGGR
P_MX_JRNLENTRAGGREGATEDDETS2Mexico Journal Entry Aggregated DetailsPMXJRNLENTAGGR2
P_MX_JRNLENTRITMINVCCOMPTYPESelect Compesantion type for the documentPMXINVCOMP
P_MX_JRNLENTRITMINVCDETAILSOperationalAcct with mexico invoice dataPMXJEINVDET
P_MX_JRNLENTRITMPAYTDETAILSCJournal Entries Items with PaymentsPMXJEPAYMDETC
P_MX_JRNLENTRYDISTINCTGLACCTJournal Entry Distinct GL AccountPMXJEDISTGLACCT
P_MX_OPERATIONALACCTDOCITEMJournal Entries Items with PaymentsPMXOPERADOCIT
P_MX_PAYTDESCAMTAmount and descriptionPMXPAYTDESCAM
P_MX_TAXBOXSTRUCTURETYPEMexico Tax Box Structure TypePMXTAXBOXSTRTYPE
P_TAXITEMANDWHLDGITMPrivate View for Tax and Withholding ItemsPIDUETXNWTHITM

Other CDS Views