CDS Views for Financials Brazil (FI-LOC-FI-BR)

CDS View NameDescriptionSQL View Name
C_BR_FINSTMNTACCTBALCUBEFinancial Statement Account Balance CubeCBRFINSTMNTBALC
C_BR_FINSTMNTACCTBALQUERYFinancial Statement Account Bal QueryCBRFINSTMNTBALQ
C_BR_REPORTINGINVENTORYCUBEEFD - H010 - L012 - Inventory CubeCBRRPTGINVTRYCB
C_BR_REPORTINGINVENTORYQUERYEFD-H010-L012 - Inventory QueryCBRRPTGINVTRYQRY
C_BR_REPORTINGNFHEADERCUBEEFD-C100-L012 - NF Header CubeCBRNFHEADERCUBE
C_BR_REPORTINGNFHEADERQUERYEFD-C100-L012 - NF Header QueryCBRNFHEADERQRY
C_BR_REPORTINGNFITEMCUBEEFD-C170-L012 - NF Document Item CubeCBRNDOCITCUBE
C_BR_REPORTINGNFITEMQUERYEFD-C170-L012 - NF Document Item QueryCBRNDOCITQUERY
C_BR_REPORTINGNFITEMTAXCUBEEFD-C190-L012 - NF Item Taxes CubeCBRNFITMTXCB
C_BR_REPORTINGNFITEMTAXQUERYEFD-C190-L012 - NF Item Taxes QueryCBRNDOCITOBQUERY
C_BR_REPORTINGREFNFCUBEEFD-C113-L012 - Referenced NF CubeCBRREFNFCUBE
C_BR_REPORTINGREFNFQUERYEFD-C113-L012 - Referenced NF QueryCBRREFNFQRY
C_BR_RPTGAGGRGDCMPLMNTYINFOCEFD - 0450 - L012 - Table for Compl. Info of Fiscal Doc CubeCBRMATERIALIDNC
C_BR_RPTGAGGRGDCMPLMNTYINFOQEFD - 0450 - L012 - Table for Compl. Info of Fiscal Doc QuerCBRMATERIALIDNQ
C_BR_RPTGCOMPANYIDENTITYCUBEEFD-0000 - File Opening and Company IdCBROPENINGCUBE
C_BR_RPTGCOMPANYIDENTITYQUERYEFD-0000 - File Opening and Company IdCBROPENINGQUERY
C_BR_RPTGINTERSTATEOPCUBEEFD-C101-L012 - NF Interstate CubeCBRNFINTERSTCB
C_BR_RPTGINTERSTATEOPQUERYEFD-C101-L012 - NF Interstate QueryCBRNFINTERSTQRY
C_BR_RPTGINTRSTTTRANSPNFCUBEEFD-D101-Interstate Transp NF Hdr CubeCBRINTTRNSNFCB
C_BR_RPTGINTRSTTTRANSPNFQUERYEFD-D101-L012-Intrstt Transp NF Hdr QryCBRINTTRNSNFQRY
C_BR_RPTGINVTRYTOTAMOUNTCUBEEFD-H005-L012 - Invtry Total Amount CubeCBRRPTGINVTOTCB
C_BR_RPTGINVTRYTOTAMOUNTQUERYEFD-H005-L012 - Invtry Total Amount QryCBRRPTGINVTOTQY
C_BR_RPTGMATERIALANPCODECUBEEFD-0206 Material ANP Code CubeCBRPRODUCTANPC
C_BR_RPTGMATERIALANPCODEQUERYEFD-0206 Material ANP Code QueryCBRPRODUCTANPQ
C_BR_RPTGMATLIDENTIFICATIONCEFD-0200 Material Identification CubeCBRMATIDNC
C_BR_RPTGMATLIDENTIFICATIONQEFD-0200 Material Identification QueryCBRMATIDNQ
C_BR_RPTGNFCMPLMNTYINFOCUBEEFD-C110-L012 - NF Cmplmnty Info CubeCBRNFCMPLMNTY
C_BR_RPTGNFCMPLMNTYINFOQUERYEFD-C110-L012 - NF Cmplmnty Info QueryCBRNFCMPLMNTYQ
C_BR_RPTGNFPARTNERCUBEEFD - 0150 - Nota Fiscal Partner CubeCBRSPEDPTNRCUBE
C_BR_RPTGNFPARTNERQUERYEFD-0150 - Nota Fiscal Partner QueryCBRSPEDPTNRQRY
C_BR_RPTGOPERATIONNATURECUBEEFD-0400-L012 - Operation Nature CubeCBRRPTGOPNATCB
C_BR_RPTGOPERATIONNATUREQUERYEFD-0400-L012 - Operation Nature QueryCBRRPTGOPNATQRY
C_BR_RPTGSUBSTITTAXPAYERCUBEEFD - 0015 - Substitute TaxpayerCBRSUBSTAXPAYERC
C_BR_RPTGSUBSTITTAXPAYERQUERYEFD-0015-Substitute TaxpayerCBRSUBSTAXPAYERQ
C_BR_RPTGTRANSPNFHEADERCUBEEFD-D100-L012 - Transport NF Header CubeCBRNFTRANSPCUBE
C_BR_RPTGTRANSPNFHEADERQUERYEFD-D100-L012 - Transport NF Header QryCBRNFTRANSPQRY
C_BR_RPTGTRANSPNFTAXCUBEEFD-D190-L012 - Transport NF Taxes CubeCBRTRANSNFTXCUBE
C_BR_RPTGTRANSPNFTAXQUERYEFD-D190-L012 - Transp NF Hdr QryCBRNFTRNSTAXQRY
C_BR_RPTGUNITCNVRSNFACTORCUBEEFD-0220 - Unit Conversion Factor CubeCBRRPTGUNITCONVC
C_BR_RPTGUNITCNVRSNFACTORQUERYEFD-0220 - Unit Conversion Factor QueryCBRRPTGUNITCONVQ
C_BR_RPTGUNITOFMEASURECUBEEFD-0190 - Unit of Measure CubeCBRUNITIDENCUBE
C_BR_RPTGUNITOFMEASUREQUERYEFD-0190 - Unit of Measure QueryCBRUNITIDENQRY
C_BR_STATUTORYRPTGINVENTORYAll Inventory MaterialsCBRSTRYINV
C_BR_STATUTORYRPTGNFHEADERAll Nota Fiscal HeadersCBRNFHEADERLOG
I_BR_REPORTINGINVENTORYLOGAll Inventory MaterialsIBRRPTGINVLOG
I_BR_REPORTINGNFHEADERLOGAll Nota Fiscal HeadersIRPTGNFHLOG
P_BR_REPORTIGNFDOCUMENTITEMTAXEFD - NF Document Item Tax CubePBRNFDOCITEMTAX
P_BR_REPORTINGBUSINESSPLACEReporting Business Place DataPBRRPTGBP
P_BR_REPORTINGCALCCNPJDIGIT1Reporting - CNPJ First Digit CalculationPBRCNPJDIG1
P_BR_REPORTINGCALCCNPJDIGIT2Reporting - CNPJ 2nd Digit CalculationPBRCNPJDIG2
P_BR_REPORTINGITEMEFD - Product with Valuation and PlantPBRSPEDITEM
P_BR_REPORTINGMATERIALEFD - Material DataPBRMATERIALDATA
P_BR_REPORTINGNFDATAEFD - NF Header Data CubePBRNFDATACUBE
P_BR_REPORTINGNFEACTIVEEFD - NFe Actual Status and NFe KeyPBRSPEDNFEACTV
P_BR_REPORTINGNFEXPORTEFD - Nota Fiscal ReferencesPBRSPEDNFEXP
P_BR_REPORTINGNFEXPORTKEYNota Fiscal References by NFe KeyPBRSPEDNFEXKEY
P_BR_REPORTINGNFPARTNEREFD - Nota Fiscal PartnerPBRSPEDNFPTNR
P_BR_REPORTINGNFTAXCALCULATIONEFD - NF Calculated Tax Value CubePBRNFTAXCALC
P_BR_REPORTINGNFTAXRATEEFD - Nota Fiscal Tax RatePBRSPEDNFTXRATE
P_BR_REPORTINGPLANTEFD - PlantsPBRSPEDPLANT
P_BR_REPORTINGPLANTMATERIALEFD - Material per PlantPBRPLANTMATERIAL
P_BR_REPORTINGTRANSPORTNFDATAEFD - Transport Nota Fiscal DataPBRNFTRANSPDATA
P_BR_RPTGBUSINESSPLACEADDRESSEFD - Business Place AddressPBRSPEDBPADDR
P_BR_RPTGBUSINESSPLACECNPJEFD - Business Place Addl SpecificationsPBRBRPTGPCNPJ
P_BR_RPTGCESTDETERMINATIONEFD - CEST DeterminationPBRCESTDETN
P_BR_RPTGCUSTSUPLRPARTNEREFD - Customer and Supplier PartnerPBRSPEDCUSTSUPL
P_BR_RPTGFILLCESTBYMATERIALEFD - Material with CEST by CodePBRMATLCESTMATL
P_BR_RPTGFILLCESTBYNCMEFD - Material with CEST by NCMPBRMATLCESTNCM
P_BR_RPTGINVENTORYVALUATIONInventory ValuationPBRRPTGINVTRYVL
P_BR_RPTGINVTRYBUSINESSPLACEInventory - Business PlacePBRRPTGINVTRY
P_BR_RPTGNFACCOUNTCOUNTEREFD - Number of accounts in NF DocumentPBRSPEDNRCTEAC2
P_BR_RPTGNFDATAAGGREGATIONEFD - Nota Fiscal Data - AggregationPBRRPTGNFDATAAG
P_BR_RPTGNFSTATISTICALTAXEFD - Nota Fiscal Statistical TaxPBRSPEDNFSTCT
P_BR_RPTGNFTAXAGGREGATIONEFD - Nf Itens AggregationPBRNFTAXAGGR
P_BR_RPTGONETIMEPARTNEREFD - One Time PartnerPBRSPED1TMEPART
P_BR_RPTGPARTNERINFORMATIONEFD - Partner InformationPBRSPEDPTNRINFO
P_BR_RPTGREPORTEDMATERIALEFD - Reported MaterialPBRRPTDMATERIAL
P_BR_RPTGREPORTEDMATLDATAEFD - Reported Material DataPBRRPTDMATERIALD
P_BR_RPTGUOMAGGREGATIONUnit of Measure AggregationPBRUNITAGGREG
P_INVTRYACCOUNTDETERMINATIONAccount determination for InventoryPINVTRYACCDET
P_RPTGMATERIALDATAAGGREGATIONEFD - Material Data AggregationPBRMATERIALAGGR

Other CDS Views