Sunday, May 19, 2024

SAP Table ACCT_SRF_REP_ITM – Information for documents selected per report run

ACCT_SRF_REP_ITM is a standard SAP table in SAP ECC (or) S/4HANA which stores Information for documents selected per report run data. There are total 8 fields in ACCT_SRF_REP_ITM table.This blog post provides key technical details of SAP table ACCT_SRF_REP_ITM, including its availability across SAP S/4HANA versions and the list of CDS views for ACCT_SRF_REP_ITM table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Globalization Financials Information System Cross-Country (GLO_FIN_IS_GEN)
Technical Component Localization Financials (generic parts) (FI-LOC-GEN)

SAP ACCT_SRF_REP_ITM Table Fields

The following is the list of fields that are available in SAP ACCT_SRF_REP_ITM table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT T000 CLNT (3)
STATRYRPTGENTITY Reporting Entity SRF_REPORTING_ENTITY SRF_REPORTING_ENTITY SRF_RPG_ENT CHAR (10)
STATRYRPTCATEGORY Report Category ID SRF_REP_CAT_ID SRF_REP_CAT_ID SRF_REP_CAT CHAR (30)
STATRYRPTRUNID Report Run ID SRF_REPORT_RUN_ID SRF_REPORT_RUN_ID NUMC (8)
COMPANYCODE Company Code BUKRS BUKRS T001 CHAR (4)
ACCOUNTINGDOCUMENT Accounting Document Number BELNR_D BELNR CHAR (10)
FISCALYEAR Fiscal Year GJAHR GJAHR NUMC (4)
_DATAAGING Data Filter Value for Data Aging DATA_TEMPERATURE DATA_TEMPERATURE DATS (8)

Availability

The SAP table ACCT_SRF_REP_ITM is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACCT_SRF_REP_ITM table

The following is the list of ACCT_SRF_REP_ITM CDS views, which can also be used instead of ACCT_SRF_REP_ITM table based on your business requirements.

CDS View CDS View Type Description
I_STRPJOURNALENTRYLOG BASIC Journal entries selected by a report run
I_AR_LATESTOFFICIALDOCNMBR COMPOSITE View Containing the latest Reference Document Number
I_AR_STRPBPTAXITEM COMPOSITE Tax Line Items with Official Document Number
I_AR_STRPWITHHOLDINGTAXITEM COMPOSITE Interface View – AR SIRE VAT WHT Report
I_AU_STRPTPARACCOUNTINGDOCCUBE COMPOSITE Australia TPAR Acctg Documents Cube
I_AU_STRPWITHHOLDINGTAXITEM COMPOSITE Withholding Tax Data for BAS Report
I_BE_STRPWHLDGTAXITEM COMPOSITE Withholding Tax Item For Statutory Reporting Belgium
I_CN_CHANGESINOWNERSEQUITYCUBE COMPOSITE ChangesInOwnersEquityStmnt Cube
I_CZ_STRPTAXITEM COMPOSITE VAT Tax Line Item CZ
I_CZ_STRPTAXITEMCUBE COMPOSITE VAT Tax Item Cube CZ
I_CZ_STRPTAXITEMRETURNCUBE COMPOSITE EVAT Tax Item Cube CZ
I_EG_STRPTAXITEMCUBE COMPOSITE Tax Item view for Statutory Reporting for Egypt
I_ES_STRPVATRETTAXITEMCUBE COMPOSITE Tax Items for Statutory Reporting Modelo 303 Spain Cube
I_ES_STRPWHLDGTAXITEM COMPOSITE Spain Withholding Tax Reporting
I_FIXEDASSETTAXITEM COMPOSITE Tax Items for Fixed Asset
I_FR_DUEDEFERREDTAXITEMCUBE COMPOSITE Deferred Tax Item Cube
I_FR_STRPWHLDGTAXITEM COMPOSITE Withholding Tax Item For Statutory Reporting France
I_FR_VATTAXITEMCUBE COMPOSITE VAT Tax Item Cube
I_ID_STRPTAXITEMCUBE COMPOSITE Tax Item Statutory Reporting for ID
I_IN_STRPGSTANNEXCUBE COMPOSITE Tax Item Details for GST Returns
I_JP_STRPWHITERETSWHLDGTXITM COMPOSITE Japan White Returns Withholding Tax Details
I_JRNLENTRITMTOBOPFORMITMCUBE COMPOSITE Journal Entry Item To BOP Form Item Cube
I_KR_STRPWITHHOLDINGTAXITEMC COMPOSITE Business and Other income withholding tax Items for Korea
I_KR_VATINVOICEITEMCUBE COMPOSITE VAT Reporting Tax Items
I_MY_STRPSLSSRVCTXITMCUBE COMPOSITE Tax Items Cube for Malaysia SST
I_MY_STRPTAXITEM COMPOSITE Tax Items for Malaysia Statutory Reporting
I_MY_STRPWHLDGTAXITEM COMPOSITE Withholding Tax Item View For Malaysia Reporting
I_MY_TXITMWITHSLSDEDUCTIONCUBE COMPOSITE Cube for Tax Item with Sales Deduction
I_PH_AMORTIZEDTAXITEMCUBE COMPOSITE Cube View of Tax Item Exceeding 1PM for PH VAT
I_PH_NOTAMORTIZEDTAXITEMCUBE COMPOSITE Cube View of Not Amortized Tax Item for PH VAT
I_PH_PURCHASESSUMMARYITEMCUBE COMPOSITE Philippines Purchases Summary
I_PH_SALESSUMMARYITEMCUBE COMPOSITE Philippines Sales Summary Cube
I_PH_STRPTAXITEMCUBE COMPOSITE Tax Item Statutory Reporting for PH
I_PH_STRPTXITMGRPBYINDSTRYCUBE COMPOSITE Tax Item for Philippline
I_PH_STRPWHLDGTAXITEM COMPOSITE Withholding Tax View For Philippines
I_SG_STRPTAXITEMCUBE COMPOSITE Tax Items for Singapore Statutory Reporting
I_SK_STRPWITHHOLDINGTAXITEM COMPOSITE Interface view for Slovakia Withholding Tax
I_STRPACCOUNTINGDOCUMENTITMC COMPOSITE Accounting Document Item Cube for Statutory Reporting
I_STRPADVNCRETFORSLSANDPURTXC COMPOSITE Cube View which returns Sales and Purchases tax items
I_STRPDOCUMENTSTATUS COMPOSITE Tax Document Activity status
I_STRPRUNDETAILS COMPOSITE Reporting Periods of Reporting Documents
I_STRPTAXITEMLOG COMPOSITE Tax Items log for Statutory Reporting
I_STRPTAXITMWITHEUTAXCLASS COMPOSITE EU Sales Tax Item view for Statutory Reporting
I_STRPTRIALBALANCEITEMCUBE COMPOSITE Trail Balance Item Cube
I_STRPWHLDGTAXITEM COMPOSITE Withholding Tax Item View For Statutory Reporting
I_TH_ASSETDEPRECIATIONCUBE COMPOSITE Cube View for Thailand Depreciation List
I_TH_ASSETDEPRECIATIONLOG COMPOSITE Thailand Asset Depreciation Report Log
I_TH_ASSETDISPOSALCUBE COMPOSITE Thailand: Disposal List Cube
I_TH_STRPEXCEEDEDTAXITEMCUBE COMPOSITE Tax Items log for TH Statutory Reporting
I_TH_STRPREMITTANCETAXITEMCUBE COMPOSITE Remittance Tax Item Statutory Reporting for Thailand(P.P.36)
I_TH_STRPTAXITEMCUBE COMPOSITE Tax Items log for TH Statutory Reporting
I_TR_PURSLSAGGREGATEDACCTDOC COMPOSITE Turkey view to fetch PurSls data
I_TR_PURSLSTAXITEM COMPOSITE View for Purchase and Sales Tax Items
I_TR_STRPELECTRONICLEDGERITEM COMPOSITE Electronic Ledger Documents Reporting
I_TW_CHANGESINEQUITYCUBE COMPOSITE Statement of Changes in Equity Cube
I_TW_FIXEDASSETTAXCUBE COMPOSITE Analytical Cube for Asset Tax Items
I_TW_TAXITEMCUBE COMPOSITE Tax Item Cube
I_TW_ZEROTAXCUBE COMPOSITE Taiwan Zero Tax Item Cube
I_UK_STRPTAXITMWITHEUTAXCLASS COMPOSITE EU Sales Tax Item view for UK
I_UK_STRPWHLDGTAXITEM COMPOSITE Withholding Tax View For UK
I_US_RGNLSTRPWHLDGTAXITEM COMPOSITE Withholding Tax View for US for State Level Reporting
I_US_STRP1099FEDWHLDGTXITM COMPOSITE US 1099 G Reporting
I_US_STRP1099INTRSTWHLDGTXITM COMPOSITE US 1099 Statutory Reporting for Interest Income
I_US_STRP1099MISCWHLDGTXITM COMPOSITE US 1099 MISC Reporting
I_US_STRP1099PAYTWHLDGTXITM COMPOSITE Interface View for 1099K
I_US_STRPFRGNVNDRWHLDGTXITM COMPOSITE Cube View For 1042s Reporting
I_US_STRPWHLDGTAXITEM COMPOSITE Withholding Tax View for US
I_VE_STRPBPANDWHLDGTAXITEM COMPOSITE Venezuela Business Partner VAT and Withholding Tax Items
I_ZA_STRPTAXITEMLOGCUBE COMPOSITE South Africa Tax Items for VAT Rpg with Rptd Log info
P_AR_INVOICEACCTGDOCUMENTS COMPOSITE Relevant Documents Of Official Document Numbering
P_AU_STRPAGGRGTXITMPERACCTGDOC COMPOSITE AU TPAR aggregate tax items
P_AU_STRPBASITEM COMPOSITE AU BAS Document Selection
P_AU_STRPTPARACCOUNTINGDOCS COMPOSITE TPAR Docs with Gross and Tax Amount Per Doc.
P_AU_STRPTPARAGGRGTAXLINEITEMS COMPOSITE Aggregrated Tax Items Per Accounting Doc
P_AU_STRPTPARMINIMUMTAXLINEITM COMPOSITE AU TPAR Minimun Tax Line Item
P_AU_STRPTPARTAXLINEITEMS COMPOSITE Tax Items of TPAR Accounting Docs
P_BE_STRPNOTRPTDWHLDGTAXITEM COMPOSITE Non Reported document for Statutory Reporting of Belgium
P_BE_STRPRPTDWHLDGTAXITEM COMPOSITE Reported document for Statutory Reporting for Belgium
P_BOEDPEXCLUDE_GLO COMPOSITE Down payment with BoE Withholding Tax View
P_COUNTCOUNTRY COMPOSITE Private view to count no of countries
P_CZ_STRPTAXITEMY COMPOSITE VAT Tax Line Item CZ
P_DPWITHBOE_GLO COMPOSITE Down payment with BoE Withholding Tax View
P_ES_STRPVATRETTAXITEM COMPOSITE Tax Items for Statutory Reporting Modelo 303 Spain Cube
P_ES_STRPVATRETTAXITEM10 COMPOSITE Tax Items for Statutory Reporting Modelo 303 Spain Cube
P_FR_STRPNOTRPTDWHLDGTAXITEM COMPOSITE Non Reported document for Statutory Rep of WHLD for France
P_FR_STRPRPTDWHLDGTAXITEM COMPOSITE Reported document for Statutory Reporting of WHLD for France
P_GETNONDEDUCTIBLEDOCITEM COMPOSITE Private view to obtain Non Deductible Doc Items
P_JP_LASTVNDRINVCPAYTINFO COMPOSITE Private View, Last Vendor Inv, Payment Japan White Returns
P_JP_LASTVNDRPAYTINFO COMPOSITE Private View, Last Vendor Payment for Japan White Returns
P_KR_STRPNOTRPTDITEM COMPOSITE Not Reported Tax Items for Korean VAT
P_KR_STRPRPTDITEM COMPOSITE South Korea Reported Item
P_KR_VATINVOICEITEM COMPOSITE KR VAT Item Information
P_KR_WHLDGINHABITANTTXITM COMPOSITE Inhaitant tax line details for Korea
P_MY_STRPTAXITEMWITHPRODUCT COMPOSITE Statutory Tax Item with Product
P_MY_STRPTAXITEMWOPRODUCT COMPOSITE Statutory Tax Item w/o Product Line
P_MY_STRPTXITMWITHORIGLDOC COMPOSITE Statutory Tax Item with Original Document
P_PH_ATCITEM COMPOSITE For PH 2550M ATC Items
P_PH_ATCSUMITEM COMPOSITE for getting atc summary item
P_PH_SALESPURCHASESSUMMARYITEM COMPOSITE PH Sales Purchase Summary
P_PH_STRPNOTRPTDWHLDGTAXITEM COMPOSITE Non Reported document for Statutory Reporting of Philippines
P_PH_STRPRPTDWHLDGTAXITEM COMPOSITE Reported document for Statutory Reporting for Philippines
P_PH_STRPTAXITEMQ COMPOSITE Tax Item Statutory Reporting for PH
P_PH_STRPTAXITEMS COMPOSITE tax Items with discounts
P_SG_STRPRUNDOC COMPOSITE SG Run result Document
P_SG_STRPRUNLOG COMPOSITE Get Report Run Log
P_STRPADVNCRETFORSLSANDPURTX COMPOSITE Private view for Advance VAT Return
P_STRPCALTAXRETURN COMPOSITE Calculated Tax Return Information
P_STRPRPTDTAXITEM COMPOSITE Reported document for Statutory Reporting
P_STRPTAXITMWITHEUTAXCLASS7 COMPOSITE EU Sales tax Item View for Statutory Reporting
P_STRPTAXITMWITHEUTAXCLASS8 COMPOSITE EU Sales tax Item View for Statutory Reporting
P_STRPTAXRETURN COMPOSITE Privtate view for Tax Returns
P_STRPTAXRETURNBOX COMPOSITE Private view to return Tax Details with TaxBox config
P_TH_SPLITFILE COMPOSITE SPLIT FIle
P_TH_STRPAVERAGETAXITEM COMPOSITE Calculate average tax values for TH
P_TH_STRPTAXITEMS COMPOSITE Private view of Tax Item Statutory Reporting for Thailand
P_TH_STRPTAXPAYMENTITEM COMPOSITE For Thailand PP36 Tax Return Report
P_TR_PURSLSACCDOCDATA COMPOSITE Turkey view to fetch Acc Doc Data
P_TR_PURSLSAGGACCDOC COMPOSITE AggrTaxbase amt on BP level
P_TR_STRPELECTRONICLEDGERHDR COMPOSITE Electronic Ledger Documents Reporting
P_TW_STRPNOTRPTDITEM COMPOSITE Not Reported Tax Items for Taiwan VAT
P_TW_STRPRPTDITEM COMPOSITE Reported Item for Taiwan VAT
P_TW_TAXITEM COMPOSITE Tax Item Information for TaiWan
P_TW_TAXITEMDELETIONOPTION COMPOSITE Tax Item with Deletion Option
P_TW_ZEROTAXITEM COMPOSITE Zero Tax Item Information for Taiwan
P_UK_STRPNOTRPTDEUTAXCLASS COMPOSITE Not Reported document for Statutory Reporting of ECSL for UK
P_UK_STRPNOTRPTDWHLDGTAXITEM COMPOSITE Non Reported document for Statutory Rep of WHLD for UK
P_UK_STRPRPTDEUTAXCLASS COMPOSITE Reported documents for Statutory Reporting of ECSL for UK
P_UK_STRPRPTDWHLDGTAXITEM COMPOSITE Reported document for Statutory Reporting of WHLD for UK
P_US_STRP1099WHLDGTXITM COMPOSITE US 1099 With Item
P_US_STRPWHLDGTAXITEM COMPOSITE WIthholding Tax View for US
P_US_WHLDGTXBUSPARTAGGRGDTXITM COMPOSITE sgrg
P_US_WHLDGTXCODEAGGRGDFEDERAL COMPOSITE ssrg
P_US_WHLDGTXCODEAGGRGDROYALTY COMPOSITE sdvsegsr
P_US_WHLDGTXCODEAGGRGDTXITM COMPOSITE csdc
P_US_WHLDGTXCODEFEDERALTHLDCHK COMPOSITE esgweg
P_US_WHLDGTXCODEROYALTYTHLDCHK COMPOSITE vsdf
P_US_WHLDGTXCODETHLDCHECK COMPOSITE hgvy
P_US_WHLDGTXREGIONAGGRGDTXITM COMPOSITE fef
P_US_WHLDGTXRGNLTHLDCHECK COMPOSITE fsefe
P_WHLDGBOE_GLO COMPOSITE Bills of Exchange Withholding Tax View
P_ZA_STRPTAXRETURNBOX COMPOSITE Private CDS view for South Africa PDF report
P_ZA_STRPTAXRETURNBOX2 COMPOSITE Private CDS view for ZA PDF report 2
P_ZA_STRPTAXRETURNBOX3 COMPOSITE Private CDS view for ZA PDF report 3
P_ZA_STRPTAXRETURNBOX4 COMPOSITE Private CDS view for ZA PDF report 4
C_AR_STRPBPTAXITEMLOGQUERY CONSUMPTION Consumption View for Tax Item with Rptd Item Data
C_AR_STRPDAILYVATCUBE CONSUMPTION Cube view for Argentina Daily VAT StRp
C_AR_STRPDAILYVATQUERY CONSUMPTION Query View for Argentina Daily VAT StRp
C_AR_STRPDAILYVATRPTDJRNLENTRC CONSUMPTION Reported Journal Entries in Daily VAT
C_AR_STRPLATESTREFDOCLOGCUBE CONSUMPTION Argentina Latest Official Document Details
C_AR_STRPLATESTREFDOCLOGQUERY CONSUMPTION Consumption View for Argentina Printing Official Document
C_AR_STRPPURFOREIGNSRVCQUERY CONSUMPTION Query View For Argentina Foreign Service
C_AR_STRPPURFRGNSRVCCUBE CONSUMPTION Cube View For Argentina Foreign Service
C_AR_STRPPURTAXITEMLOGCUBE CONSUMPTION Argentina Purchase VAT Tax Line Item Calculation
C_AR_STRPPURTAXITEMLOGQUERY CONSUMPTION Analytical Qry for AR Pur VAT Tax with Reptd Item Log Data
C_AR_STRPSALESTAXITEMLOGCUBE CONSUMPTION Cube View for AR Sls Scenario with Reptd Item Log Data
C_AR_STRPSALESTAXITEMLOGQUERY CONSUMPTION Query View for Argentina Sales w/LogData
C_AR_STRPTAXITEMQ CONSUMPTION Consumption View for Tax Item Data
C_AR_STRPVATFORM731ITEMC CONSUMPTION Argentina VAT Form 731
C_AR_STRPVATFORM731ITEMLOGC CONSUMPTION Argentina VAT Form 731 with Rptd item log data
C_AR_STRPVATFORM731ITEMLOGQ CONSUMPTION AR Tax Items for VAT Rpg with Rptd Item Log data
C_AR_STRPVATFORM731ITEMQ CONSUMPTION Argentina Tax Items for VAT Reporting
C_AR_STRPWITHHOLDINGTAXITEMQ CONSUMPTION Consumption View: AR SIRE VAT WHT Report
C_AT_BALANCEOFPAYMENTSITEMQ CONSUMPTION Journal Entry Item To BOP Form Item Query
C_AT_STRPAUDITBALANCEITEMQUERY CONSUMPTION Austrian Audit Balance Item Query
C_AT_STRPTAXITEMQUERY CONSUMPTION VAT Tax Item Query for Austria
C_AT_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Austria
C_AT_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Austria
C_AU_STRPBASGENERALLEDGERBALC CONSUMPTION AU Bas G/L Balance Cube
C_AU_STRPBASGENERALLEDGERBALQ CONSUMPTION AU BAS Analytical Query View
C_AU_STRPTAXITEMCUBE CONSUMPTION Consumtion View for Australia VAT Tax Line Item
C_AU_STRPTAXITEMQUERY CONSUMPTION Analytical Query View for AU VAT Reporting
C_AU_STRPTPARACCOUNTINGDOCSQRY CONSUMPTION Australia TPAR Accounting Docs Query
C_AU_STRPWITHHOLDINGTAXITEMQ CONSUMPTION Withholding Tax lines for BAS Report
C_BE_BOPF01MERCUBE CONSUMPTION BOP Reporting Belgium – F01MER Format
C_BE_BOPF01MERQRY CONSUMPTION BOP Reporting Belgium – F01MER Format
C_BE_BOPS03CCRCUBE CONSUMPTION BOP Reporting Belgium – S03CCR Format
C_BE_BOPS03CCRQRY CONSUMPTION BOP Reporting Belgium – S03CCR Format
C_BE_DOMESTICSALESLISTCUBE CONSUMPTION Domestic Sales List for Belgium
C_BE_DOMESTICSALESLISTQUERY CONSUMPTION Domestic Sales List for Belgium
C_BE_STRPTAXITMWITHEUTAXCLASS CONSUMPTION EU Sales Tax Item view for BE
C_BE_STRPTAXITMWITHEUTAXCLASSQ CONSUMPTION EU Sales Tax Item view for BE
C_BE_STRPWHLDGTAXITEMQ CONSUMPTION Withholding Tax Item For Statutory Reporting Belgium
C_CA_STRPGSTITEMCUBE CONSUMPTION Canada GST Tax Item Details
C_CA_STRPGSTITEMQUERY CONSUMPTION Analytical Query for Canada GST Items
C_CA_STRPINPUTTAXCRDTITEMC CONSUMPTION Canada RITC Cube view
C_CA_STRPINPUTTAXCRDTITEMQ CONSUMPTION Analytical Query for Canada RITC items
C_CA_STRPPROVINCIALTAXITEMC CONSUMPTION Canada PST Tax Item Details
C_CA_STRPPROVINCIALTAXITEMQ CONSUMPTION Analytical Query for Canada PST Items
C_CA_STRPTAXITEMCUBE CONSUMPTION Consumption view for Canada GST Return
C_CA_STRPTAXITEMQUERY CONSUMPTION Analytical Query for CA GST Return
C_CH_VATTAXITEMCUBE CONSUMPTION Tax Items log for Statutory Reporting for Switzerland
C_CH_VATTAXITEMQUERY CONSUMPTION VAT Tax Item Query for Switzerland
C_CL_NMBROFJRNLENTRBYPOSTGDTEC CONSUMPTION Number of Journal Entries by Posting Date for Chile Rptg
C_CL_STRPJOURNALENTRYITEMCUBE CONSUMPTION Jrnl Entr Items for Chile Reporting Cube
C_CL_STRPJOURNALENTRYITEMQUERY CONSUMPTION Jrnl Entr Items for Chile Reporting Qry
C_CL_STRPJRNLENTRYDOCAMOUNTC CONSUMPTION Jrnl Entry Doc Amt for Chile Rptg – Cube
C_CL_STRPTRIALBALANCEITEMCUBE CONSUMPTION Trial Balance Items for Chile Rptg Cube
C_CL_STRPTRIALBALANCEITEMQUERY CONSUMPTION Trial Balance Item for Chile Rptg Query
C_CN_CHANGESINOWNERSEQUITYQRY CONSUMPTION ChangesInOwnersEquityStmnt Query
C_CO_DIANSTRPBPTAXITEMCUBE CONSUMPTION Format 1005 & 1006 – Tax Item Cube
C_CO_DIANSTRPCREDITOROPENITEMC CONSUMPTION Creditor Balances Cube for Colombia DIAN
C_CO_DIANSTRPCREDITOROPENITEMQ CONSUMPTION Crdtr Balances Query for Colombia DIAN
C_CO_DIANSTRPCUSTOMEROPENITEMC CONSUMPTION Cust. Balances Cube for Colombia DIAN
C_CO_DIANSTRPCUSTOMEROPENITEMQ CONSUMPTION Cust. Balances Query for Colombia DIAN
C_CO_DIANSTRPCUSTOPENITEMLG CONSUMPTION All Customer Open Item for Colombia DIAN
C_CO_DIANSTRPDEBTOROPENITEMC CONSUMPTION Debtor Balances Cube for Colombia DIAN
C_CO_DIANSTRPDEBTOROPENITEMQ CONSUMPTION Debtor Balances Query for Colombia DIAN
C_CO_DIANSTRPFORMAT1001CUBE CONSUMPTION Format 1001 – Journal Entry Item Cube
C_CO_DIANSTRPFORMAT1001QUERY CONSUMPTION Format 1001 – Journal Entry Item Query
C_CO_DIANSTRPFRMT1001VERS10Q CONSUMPTION Format 1001 – Journal Entry Item Query
C_CO_DIANSTRPJOURNALENTRYITEMC CONSUMPTION G/L Formats – Journal Entry Item Cube
C_CO_DIANSTRPREVENUECUBE CONSUMPTION Format 1007 – Revenue Cube
C_CO_DIANSTRPREVENUEQUERY CONSUMPTION Format 1007 – Revenue Query V8
C_CO_DIANSTRPREVENUEVERSION9Q CONSUMPTION Format 1007 – Revenue Query V9
C_CO_DIANSTRPSUPLRCUSTOPNITEMC CONSUMPTION Supplier & Customer Open Item for DIAN
C_CO_DIANSTRPSUPLRCUSTOPNITMLG CONSUMPTION All Suplr. & Cust.Bal. for Colombia DIAN
C_CO_DIANSTRPSUPLROPENITEMLG CONSUMPTION All Supp. Balances for Colombia DIAN
C_CO_DIANSTRPSUPPLIEROPENITEMC CONSUMPTION Supplier Balances Cube for Colombia DIAN
C_CO_DIANSTRPTAXITEMQUERY CONSUMPTION Format 1005 & 1006 – Tax Item Query
C_CO_DIANSTRPWHLDGTAXITEMCUBE CONSUMPTION Withholding Tax Item for Colombia DIAN
C_CO_DIANSTRPWHLDGTAXITEMLG CONSUMPTION All Whldg. Tax Items For Colombia DIAN
C_CO_DIANSTRPWHLDGTAXITEMQUERY CONSUMPTION Whldg Tax Items Query for Colombia DIAN
C_CZ_STRPTAXITEMQUERY CONSUMPTION VAT Tax Item Query CZ
C_CZ_STRPTAXITEMRETURN CONSUMPTION EVAT Tax Line Item CZ
C_CZ_STRPTAXITEMRETURNQUERY CONSUMPTION EVAT Tax Line Item CZ
C_CZ_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Czech Rep.
C_CZ_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Czech Rep.
C_CZ_STRPTXITMWITHEUTXCLCRRTNC CONSUMPTION EU Sales Tax Item View – Correction Run
C_CZ_STRPTXITMWITHEUTXCLCRRTNQ CONSUMPTION EU Sales Tax Item View – Correction Run
C_DE_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales List Tax Item View for Germany
C_DE_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales List Tax Item View for Germany-Query
C_DK_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Denmark
C_DK_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Denmark
C_EG_STRPTAXITEMCUBE CONSUMPTION Egypt specific tax item cube view for Statutory Reporting
C_EG_STRPTAXITEMFORM100CUBE CONSUMPTION Billing Tax Items for ACR Egypt VAT form 100
C_EG_STRPTAXITEMFORM100QUERY CONSUMPTION Tax Items for Statutory Reporting Egypt form 100
C_EG_STRPTAXITEMFORM10100QUERY CONSUMPTION Tax Items for Statutory Reporting Egypt form 10
C_EG_STRPTAXITEMFORM10QUERY CONSUMPTION Tax Items for Statutory Reporting Egypt form 10
C_EG_STRPTAXITEMQUERY CONSUMPTION Tax Items for Statutory Reporting Egypt
C_ES_STRP190WHLDGTAXITEMCUBE CONSUMPTION Spain Modelo-190 Wth Tax Itm View – Cube
C_ES_STRP190WHLDGTAXITEMQUERY CONSUMPTION Spain Modelo-190 Wth Tax Itm View-Query
C_ES_STRP296WHLDGTAXITEMCUBE CONSUMPTION Cube View for Spain Modelo 296 report
C_ES_STRP296WHLDGTAXITEMQUERY CONSUMPTION Withholding Tax Item Query View for Spain
C_ES_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for ES
C_ES_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item view for ES
C_ES_STRPVATRETTAXITEM CONSUMPTION Reported and Non Reported Items for Modelo 303 Spain
C_ES_STRPVATRETTAXITEMQ CONSUMPTION Tax Items for Statutory Reporting Modelo 303 Spain Query
C_ES_STRPWHLDGTAXITEMQUERY CONSUMPTION Withholding Tax Item For Statutory Reporting Spain
C_ES_TAXRETURNBOXCUBE CONSUMPTION ATR enabled Tax Items for Modelo 303 Spain Cube
C_ES_TAXRETURNBOXQUERY CONSUMPTION ATR enabled Tax Items for Modelo 303 Spain Query
C_FI_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Finland
C_FI_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Finland-Query
C_FR_BOPECOCUBE CONSUMPTION BOP Reporting France – ECO Format
C_FR_BOPECOQRY CONSUMPTION BOP Reporting France – ECO Format
C_FR_DUEDEFERREDTAXITEMQUERY CONSUMPTION Deferred Tax Item Query
C_FR_STRPAUDITFECITEMCUBE CONSUMPTION France Audit File (FEC) ΓÇô Cube
C_FR_STRPAUDITFECITEMQUERY CONSUMPTION France Audit File (FEC) ΓÇô Query
C_FR_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item view for France
C_FR_STRPTAXITMWITHEUTAXCLASS CONSUMPTION EU Sales Tax Item view for France
C_FR_STRPWHLDGTAXITEMQ CONSUMPTION Withholding Tax Item For Statutory Reporting France
C_FR_VATTAXITEMQUERY CONSUMPTION VAT Tax Item Query
C_GB_STRPNOTRPTDPARKEDDOCTXITM CONSUMPTION Not reported parked documents
C_GB_STRPNOTRPTDTAXITEM CONSUMPTION GB: Non Reported document for Statutory Reporting
C_GB_STRPOLDOPENTAXITEMQRY CONSUMPTION Open items to be repaid
C_GB_STRPOLDPARKEDDOCTXITMBOXQ CONSUMPTION Parked Items with opposite sign
C_GB_STRPOLDTAXITEMBOXCUBE CONSUMPTION VAT Tax Item box level reporting
C_GB_STRPOLDTAXITEMQUERY CONSUMPTION Items from the current period
C_GB_STRPPARKEDDOCTXITMBOXCUBE CONSUMPTION Parked Items for Statutory Reporting
C_GB_STRPPARKEDDOCTXITMBOXQRY CONSUMPTION Parked documents for SRF
C_GB_STRPTAXITEMBOXCUBE CONSUMPTION VAT Tax Item box level reporting
C_GB_STRPTAXITEMQUERY CONSUMPTION Items from the current period
C_GB_STRPTAXITMREVERSECHRGCUBE CONSUMPTION VAT Tax Item box level reporting
C_GB_STRPTAXITMREVERSECHRGQRY CONSUMPTION Items from the current period
C_HU_STRPBUSINESSPARTNERQUERY CONSUMPTION Hungary VAT: M-page header
C_HU_STRPINVOICECHAINQUERY CONSUMPTION Hungary VAT: M-page Tax items
C_HU_STRPTAXITEMBOXCUBE CONSUMPTION Hungary VAT: Tax Items
C_HU_STRPTAXITEMQUERY CONSUMPTION Hungary VAT: A-page header
C_ID_STRPTAXITEMQUERY CONSUMPTION Tax Items Query for ID Statutory Reporting
C_IE_STRPNOTRPTDTAXITEM CONSUMPTION IE: Non Reported document for SRF
C_IE_STRPTAXITEMBOXCUBE CONSUMPTION IE VAT Return items
C_IE_STRPTAXITEMBOXQUERY CONSUMPTION IE VAT Return items
C_IE_STRPTAXITEMCUBE CONSUMPTION IE VAT Return items
C_IE_STRPTAXITEMQUERY CONSUMPTION IE VAT Return items
C_IE_STRPTAXITMWITHEUTAXCLASSC CONSUMPTION EU Sales Tax Item View for Ireland
C_IE_STRPTAXITMWITHEUTAXCLASSQ CONSUMPTION EU Sales Tax Item View for Ireland
C_INVENTORYGLACCTBALCUBE CONSUMPTION Turkey Inventory CDS cube view
C_INVENTORYGLACCTBALQUERY CONSUMPTION Turkey Inventory CDS query
C_IN_STRPGSTITEMQ CONSUMPTION Query view for GST Simplification
C_JP_CENTRALBKPAYTWITHCHT1CUBE CONSUMPTION Cube view for Japan Central Bank Chart1
C_JP_CENTRALBKPAYTWITHCHT1QRY CONSUMPTION Query view for Japan Central Bank Chart1
C_JP_CENTRALBKPAYTWITHCHT2CUBE CONSUMPTION Cube for Japan Central Bank Payment Chart2
C_JP_CENTRALBKPAYTWITHCHT2QRY CONSUMPTION Query for Japan Central Bank Payment Chart2
C_JP_STRPWHITERETSWHLDGTXITMQ CONSUMPTION Consumption View Japan White Returns Withholding Tax Details
C_JP_VATRETURNDETAILCUBE CONSUMPTION Japan VAT Return Detail Cube
C_JP_VATRETURNDETAILQUERY CONSUMPTION Japan VAT Return Detail Query
C_JRNLENTRITMTOBOPFORMITMQRY CONSUMPTION Journal Entry Item To BOP Form Item Query
C_KR_STRPTRIALBALANCEITEMQUERY CONSUMPTION South Korea Trial Balance Query
C_KR_STRPWITHHOLDINGTAXITEMQ CONSUMPTION Business and Other income tax Items for Korea Query
C_KR_VATINVOICEITEMQUERY CONSUMPTION VAT Reporting Tax Items
C_LU_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item view for LU
C_LU_STRPTAXITMWITHEUTAXCLASS CONSUMPTION EU Sales Tax Item view for LU
C_MX_AUXILIARYRPTACCTDETAILC CONSUMPTION MX Auxiliary Rpt for Acct Details Cube
C_MX_AUXILIARYRPTACCTDETAILQ CONSUMPTION MX Auxiliary Report for Accounts Details Query
C_MX_JOURNALENTRYDETAILSCUBE CONSUMPTION Mexico Journal Entry Details Cube
C_MX_JRNLENTRAGGREGATEDDETAILS CONSUMPTION Mexico Journal Entry Aggregated Details
C_MX_JRNLENTRITMINVCDETAILSC CONSUMPTION Journal Entries Items with Invoices Cube
C_MX_JRNLENTRITMINVCDETAILSQ CONSUMPTION Journal Entries Items with Invoice Query
C_MX_JRNLENTRITMPAYTDETAILSC CONSUMPTION Journal Entries Items with Payments Cube
C_MX_JRNLENTRITMPAYTDETAILSQ CONSUMPTION Journal Entries Items with Payment Query
C_MX_JRNLENTRYOPERATIONALVIEWC CONSUMPTION Journal Entries Items Cube
C_MX_JRNLENTRYOPERATIONALVIEWQ CONSUMPTION Journal Entries Items Query
C_MY_STRPSLSSRVCTXITMQUERY CONSUMPTION Tax Items Query for Malaysia SST
C_MY_STRPTAXITEMQ CONSUMPTION Tax Items Query for Malaysia Statutory Reporting
C_MY_STRPWHLDGTAXITEMQUERY CONSUMPTION Withholding Tax Item View For Statutory Reporting
C_MY_TXITMWTHSLSDEDUCTIONQUERY CONSUMPTION Query for Tax Item with Sales Deduction
C_NL_STRPACCEPTEDTAXITEMCUBE CONSUMPTION [Obsolete] NL VAT – Reported Tax Items
C_NL_STRPACCEPTEDTAXITEMQUERY CONSUMPTION [Obsolete] NL VAT – Query for Reported Tax Items
C_NL_STRPTAXITEMCUBE CONSUMPTION Consumption View for NL VAT Tax Line Items
C_NL_STRPTAXITEMQUERY CONSUMPTION Analytical Query View for NL VAT Reporting
C_NL_STRPTAXITMWITHEUTAXCLASS CONSUMPTION EU Sales Tax Item View for NL
C_NL_STRPTAXITMWITHEUTAXCLASSQ CONSUMPTION EU Sales Tax Item view for NL
C_NO_STRPTRIALBALANCEITEMQUERY CONSUMPTION Norway Trial Balance Query
C_PE_STRPJOURNALENTRYITEMCUBE CONSUMPTION Journal Entry Item Cube View for Peru
C_PE_STRPJOURNALENTRYITEMQUERY CONSUMPTION Peru Journal Entry Query View
C_PH_AMORTIZEDTAXITEMQUERY CONSUMPTION Consumption view for Exceeding 1PM Tax Item for PH VAT
C_PH_NOTAMORTIZEDTAXITEMQUERY CONSUMPTION Consumption View of Tax Item Not Exceding 1PM for PH VAT
C_PH_PURCHASESSUMMARYITEMQUERY CONSUMPTION Philippines Purchases Summary Query
C_PH_SALESSUMMARYITEMQUERY CONSUMPTION Philippines Sales Summary Query
C_PH_STRPTAXITEMQ CONSUMPTION Tax Item Statutory Reporting for PH
C_PH_STRPTXITMGRPBYINDSTRYQRY CONSUMPTION Tax Item Statutory Reporting for Philippline
C_PH_STRPWHLDGTAXITEMQ CONSUMPTION Withholding Tax View For Philippines
C_PL_STRPCUSTOPLACCTGDOCITEMQ CONSUMPTION Customer Opl Acc.Doc.Item Query – Poland
C_PL_STRPCUSTTRIALBALITMQUERY CONSUMPTION Customer Trial Balance Query ΓÇô Poland
C_PL_STRPGLACCTJRNLENTRYITMQRY CONSUMPTION GL Account Jrnl Entry Item Qry ΓÇô Poland
C_PL_STRPGLACCTOPLACCTGDOCITMQ CONSUMPTION GL Acct Opl Acc.Doc.Item Query ΓÇô Poland
C_PL_STRPGLACCTTRIALBALITMQRY CONSUMPTION GL Account Trial Balance Query ΓÇô Poland
C_PL_STRPSUPLROPLACCTGDOCITEMQ CONSUMPTION Supplier Opl Acc.Doc.Item Query – Poland
C_PL_STRPSUPLRTRIALBALITMQUERY CONSUMPTION Supplier Trial Balance Query ΓÇô Poland
C_PL_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Poland
C_PL_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Poland
C_PL_STRPTXITMWITHEUTXCLCRRTNC CONSUMPTION EU Sales Tax Item View – Correction Run
C_PL_STRPTXITMWITHEUTXCLCRRTNQ CONSUMPTION EU Sales Tax Item View – Correction Run
C_PT_DOCITEMWHLDGTXCSHDISCC CONSUMPTION Cube for Portugal annual list
C_PT_DOCITEMWHLDGTXCSHDISCQ CONSUMPTION Query for Portugal Annual List
C_PT_STRPTAXITEMQUERY CONSUMPTION VAT Tax Item Query for Portugal
C_PT_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Portugal
C_PT_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Portugal
C_RO_STRPDEFERREDITEMCUBE CONSUMPTION RO: VAT 300 Deferred Items – Cube
C_RO_STRPDEFERREDITEMQUERY CONSUMPTION RO: VAT 300 Deferred Items – Query
C_RO_STRPDOMESTICSLSPURLISTC CONSUMPTION RO: Domestic Sales/Purchase List
C_RO_STRPDOMESTICSLSPURLISTQ CONSUMPTION RO: Domestic Sales/Purchase List Query
C_RO_STRPGLACCTJRNLENTRYITMQRY CONSUMPTION GL Account Trial Balance Query ΓÇô Romania
C_RO_STRPNOTRPTDDFRRDTAXITEM CONSUMPTION RO: Non Reported Deffered tax documents
C_RO_STRPNOTRPTDTAXITEM CONSUMPTION RO: Non Reported document for SRF
C_RO_STRPSALESPURCHASEITEM1Q CONSUMPTION RO: Sales/Purchase Journal Items Query
C_RO_STRPSALESPURCHASEITEM2Q CONSUMPTION RO: Sales/Purchase Journal Items Query
C_RO_STRPSALESPURCHASEITEM3Q CONSUMPTION RO: Sales/Purchase Journal Items Query
C_RO_STRPSALESPURCHASEITEMC CONSUMPTION RO: Sales/Purchase Journal Items
C_RO_STRPTAXITEMBOXCUBE CONSUMPTION RO VAT 300 Declaration Items – Cube
C_RO_STRPTAXITEMBOXQUERY CONSUMPTION RO VAT 300 Declaration Items – Query
C_RO_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for RO
C_RO_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for RO
C_SA_STRPTAXITEMCUBE CONSUMPTION Tax Item view for ACR Saudi Arabia
C_SA_STRPTAXITEMQUERY CONSUMPTION Tax Items for ACR Saudi Arabia
C_SE_STRPTAXITMWITHEUTAXCLASSC CONSUMPTION EU Sales Tax Item View for Sweden
C_SE_STRPTAXITMWITHEUTAXCLASSQ CONSUMPTION EU Sales Tax Item View for Sweden
C_SG_STRPTAXITEMQUERY CONSUMPTION Tax Items Query for Singapore Statutory Reporting
C_SK_STRPTAXITEMWITHEUTAXCLFNC CONSUMPTION EU Sales Tax Item View for Slovakia
C_SK_STRPTAXITEMWITHEUTAXCLFNQ CONSUMPTION EU Sales Tax Item View for Slovakia
C_SK_STRPWHLDGTAXITEMCUBE CONSUMPTION Cube view for Slovakia Withholding Tax
C_SK_STRPWHLDGTAXITEMQUERY CONSUMPTION Query View for Slovakia Withholding Tax
C_STRPACCOUNTINGDOCUMENTITMQRY CONSUMPTION Accounting Document Item Query for Statutory Reporting
C_STRPADVNCRETFORSLSANDPURTXQ CONSUMPTION Analytical Query which returns Sales and Purchases Tax Items
C_STRPEUTAXCLASSFCTNWTHDOCDATE CONSUMPTION ECSL Items with Document Date selection
C_STRPEUTAXCLASSIFICATION CONSUMPTION Reported and Non Reported items for ECSL
C_STRPJOURNALENTRYITEMCUBE CONSUMPTION Jrnl Entry Item Cube for Stat.Reporting
C_STRPNOTRPTDEUTAXCLASS CONSUMPTION Non Reported document for ECSL
C_STRPNOTRPTDJOURNALENTRY CONSUMPTION Not Reported Journal Entries
C_STRPNOTRPTDTAXITEM CONSUMPTION Non Reported document for Statutory Reporting
C_STRPOPLACCTGDOCUMENTITEMCUBE CONSUMPTION Opl Acc.Doc.Item Cube for Stat.Reporting
C_STRPOVERDUEINVOICESCUBE CONSUMPTION Overdue Invoices Cube for Stat.Reporting
C_STRPOVERDUEINVOICESQUERY CONSUMPTION Overdue Invoices Qry for Stat. Reporting
C_STRPRPTDJOURNALENTRY CONSUMPTION Reported document for Statutory Reporting
C_STRPSALESINVOICECUBE CONSUMPTION Consumption view for TR Sales list
C_STRPSALESINVOICEQUERY CONSUMPTION Sales Invoice List Query
C_STRPTAXITEMBOXLOGQUERY CONSUMPTION Analytical Query for Box Reporting With Rptd Item Log Data
C_STRPTAXITEMQ CONSUMPTION Tax Items for Statutory Reporting
C_STRPTRIALBALANCEITEMQUERY CONSUMPTION Trial Balance Query
C_STRPWHLDGTAXITEM CONSUMPTION All Withholding Tax Items For Statutory Reporting
C_STRPWHLDGTXITMWTHRPTDSTS CONSUMPTION Withholding Tax Items With Reporting Status
C_STRPWITHHOLDINGTAXITEMQUERY CONSUMPTION Withholding Tax Item Query
C_TAXDOCUMENTSTRPACTIVITY CONSUMPTION Tax Document Reporting Activity
C_TH_ASSETDEPRECIATIONQUERY CONSUMPTION Asset Depreciation List for Thailand
C_TH_ASSETDISPOSALQUERY CONSUMPTION Thailand: Disposal List Query
C_TH_STRPEXCEEDEDTAXITEMQUERY CONSUMPTION Exceeding 6 months Tax Item Statutory Reporting for TH
C_TH_STRPREMITTANCETAXITMQUERY CONSUMPTION Remittance Tax Item Statutory Reporting for Thailand(P.P.36)
C_TH_STRPTAXITEMQUERY CONSUMPTION Tax Item Statutory Reporting for TH
C_TH_STRPWHLDGTAXITEMCUBE CONSUMPTION Withholding Tax Item View for Thailand
C_TH_WHLDGTAXITEMQ CONSUMPTION Withholding Tax Items Query for all PND
C_TR_PURSLSBUSPARTABVTHLDLIMIT CONSUMPTION Data above threshold limit
C_TR_PURSLSBUSPARTABVTHLDLMTQ CONSUMPTION Final query to fetch TR Sls & Pur Data
C_TR_PURSLSTAXITEMLOGCUBE CONSUMPTION Turkey consumption view for Purchase and Sales Tax Items
C_TR_PURSLSTAXITEMLOGQUERY CONSUMPTION Analytical Query displaying Turkey Purchase Sales Tax Items
C_TR_STRPELECTRONICLEDGERCUBE CONSUMPTION Cube View For Electronice Ledger
C_TR_STRPELECTRONICLEDGERQ CONSUMPTION Query View ForElectronic Ledger
C_TR_STRPINPUTTAXITEMLOGCUBE CONSUMPTION Turkey specific view displays all the input taxitems
C_TR_STRPINPUTTAXITEMLOGQUERY CONSUMPTION Analytical Query to display turkey Input Tax Items
C_TW_CHANGESINEQUITYQUERY CONSUMPTION Statement of Changes in Equity Query
C_TW_FIXEDASSETTAXQUERY CONSUMPTION Analytical Query of Fixed Asset Tax Item
C_TW_TAXITEMQUERY CONSUMPTION Tax Item Query
C_TW_VATDECLARATIONITEM CONSUMPTION Taiwan VAT Declaration Item
C_TW_ZEROTAXQUERY CONSUMPTION Taiwan Zero Tax Item Query
C_UK_STRPTAXITMWITHEUTAXCLASSQ CONSUMPTION EU Sales Tax Item view for UK
C_UK_STRPWHLDGTAXITEMQ CONSUMPTION Withholding Tax View For UK
C_US_STRP1099FEDWHLDGTXITMQ CONSUMPTION US 1099 G Query
C_US_STRP1099INTRSTWHLDGTXITMQ CONSUMPTION US 1099 INT Query
C_US_STRP1099MISCWHLDGTXITMQ CONSUMPTION US 1099 Misc Reoprting Query
C_US_STRP1099PAYTWHLDGTXITMQ CONSUMPTION Consumption View 1099K
C_US_STRPFRGNVNDRWHLDGTXITMQ CONSUMPTION Consumption View For 1042s
C_US_STRPWHLDGTAXITEM1042S CONSUMPTION CDS view for US 1042S
C_US_STRPWHLDGTAXITEM1042SQRY CONSUMPTION Query CDS view for US 1042S
C_US_STRPWHLDGTAXITEMCUBE CONSUMPTION Withholding Tax Item Cube View for US Statutory Reporting
C_VE_STRPPURANDWHLDGTXITMC CONSUMPTION Venezuela Purchase VAT and Withholding Tax Items Cube
C_VE_STRPPURANDWHLDGTXITMLOGC CONSUMPTION Venezuela Pur and Whldg Tax Items with Rptd Item log Cube
C_VE_STRPPURANDWHLDGTXITMLOGQ CONSUMPTION Analytical Query for VE Pur Tax with Reptd Item Log Data
C_VE_STRPPURANDWHLDGTXITMQ CONSUMPTION Analytical Query for VE Purchase Tax Item
C_VE_STRPSLSANDWHLDGTXITMC CONSUMPTION Venezuela Sales VAT and Withholding Tax Items Cube
C_VE_STRPSLSANDWHLDGTXITMLOGC CONSUMPTION Venezuela Sales VAT and Whldg Tax with Rptd Item Log Cube
C_VE_STRPSLSANDWHLDGTXITMLOGQ CONSUMPTION Analytical Query for VE Sales Tax with Rptd Item Log Data
C_VE_STRPSLSANDWHLDGTXITMQ CONSUMPTION Analytical Query for VE Sales Tax Item
C_ZA_STRPTAXITEMLOGQUERY CONSUMPTION Analytical Qry for South Africa Tax Item with Rptd Log Data
C_ZA_SUPLRCHARCSANDTAXITEMCUBE CONSUMPTION South Africa Supplier Characteristics and Tax Item details
C_ZA_SUPLRCHARCSANDTAXITEMQRY CONSUMPTION Analytical query South Africa BBBEE Supplier Classification
P_AU_STRPBASGLBALSUM CONSUMPTION AU BAS GL Balance Sum
P_AU_STRPBASGLBALSUM1 CONSUMPTION GL Balance Sum
P_AU_STRPBASGLBALSUMMARYAMNT CONSUMPTION AU BAS GL Balance Sum
P_BE_STRPNOTRPTDEUTAXCLASS CONSUMPTION Non reported documents for SRF – BE ECSL
P_CL_JOURNALENTRYITEMDOCAMOUNT CONSUMPTION Journal Entry Items with Doc Amt
P_CL_TRIALBALANCERPTGCRCYAMT CONSUMPTION Trial Balance Amounts in Reporting Currency
P_CODIANSTRPTAXCODESANDITEMS CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIAN1001JRNLENTRLISTLOG CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIANFRMT1001GDSRCPTITEM CONSUMPTION Format 1001 – Goods Receipt Item
P_CO_DIANFRMT1001JRNLENTRITEM2 CONSUMPTION Format 1001 – JE Item with BP Details
P_CO_DIANFRMT1001JRNLENTRITEM3 CONSUMPTION Format 1001 – JE Item with BP Details
P_CO_DIANFRMT1001JRNLENTRITEM4 CONSUMPTION Format 1001 – JE Item with BP Details
P_CO_DIANFRMT1001JRNLENTRITMLG CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIANFRMT1001JRNLENTROPLV2 CONSUMPTION Format 1001 – JE Operational View
P_CO_DIANFRMT1001JRNLENTROPLV3 CONSUMPTION Format 1001 – JE Operational View
P_CO_DIANFRMT1001JRNLENTROPLV4 CONSUMPTION Format 1001 – JE Operational View
P_CO_DIANFRMT1001JRNLENTROPLVW CONSUMPTION Format 1001 – JE Operational View
P_CO_DIANFRMT1001JRNLENTRYITEM CONSUMPTION Format 1001 – JE Item with BP Details
P_CO_DIANFRMT1001TAXITEM CONSUMPTION Format 1001 – VAT Tax Item
P_CO_DIANFRMT1001WHLDGTAXITEM CONSUMPTION Format 1001 – Whitholding Tax Item
P_CO_DIANINVOICEFINDOCUMENT CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIANJRNLENTRINVCFINDOCLOG CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIANSTRP1001TOTAMTBYITMTP CONSUMPTION Format 1001 – Total Amount by Item Type
P_CO_DIANSTRPAGGRGCREDITOR CONSUMPTION Union Creditors for Colombia DIAN
P_CO_DIANSTRPAGGRGFINDOCUMENT CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIANSTRPAGGRGFORMAT1001 CONSUMPTION Format 1001 – Acctg and Payroll Items
P_CO_DIANSTRPBPTAXITEM CONSUMPTION Format 1005 & 1006 – BP Tax Item
P_CO_DIANSTRPBPTAXITEM2 CONSUMPTION Format 1005 & 1006 – BP Tax Item
P_CO_DIANSTRPBPTAXITEM3 CONSUMPTION Format 1005 & 1006 – BP Tax Item
P_CO_DIANSTRPBPTAXITEM4 CONSUMPTION Format 1005 & 1006 – BP Tax Item
P_CO_DIANSTRPBPTAXITEM5 CONSUMPTION Format 1005 & 1006 – BP Tax Item
P_CO_DIANSTRPCREDITOROPENITM CONSUMPTION Creditor Open Item for Colombia DIAN
P_CO_DIANSTRPCUSTOMEROPENITM CONSUMPTION Priv. Cust. Balances for Colombia DIAN
P_CO_DIANSTRPDEBTOROPENITEM CONSUMPTION Priv. Debtor Balances for Colombia DIAN
P_CO_DIANSTRPFINALCRDTROPENITM CONSUMPTION Fnl Creditor Open Item for Colombia DIAN
P_CO_DIANSTRPFINALCREDITORBAL CONSUMPTION Final Creditor Balance for Colombia DIAN
P_CO_DIANSTRPFINALDBTROPENITM CONSUMPTION Fnl Debtor Open Item for Colombia DIAN
P_CO_DIANSTRPFINALDEBTORBAL CONSUMPTION Final Debtor Balance for Colombia DIAN
P_CO_DIANSTRPFORMAT1001 CONSUMPTION Format 1001 – Payment in Account
P_CO_DIANSTRPFRMT1001MINAMOUNT CONSUMPTION Format 1001 – Minimum Amount
P_CO_DIANSTRPFRMT1008MINAMOUNT CONSUMPTION Minimum Amount For Format 1008
P_CO_DIANSTRPFRMT1009MINAMOUNT CONSUMPTION Minimum Amount for Format 1009
P_CO_DIANSTRPREVENUE CONSUMPTION Format 1007 – Revenue Item
P_CO_DIANSTRPREVENUEBP CONSUMPTION Format 1007 – Revenue Item per BP
P_CO_DIANSTRPSUPLRCUSTOPENITEM CONSUMPTION Priv. Suplr. & Cust. Open Item for DIAN
P_CO_DIANSTRPSUPPLIEROPENITEM CONSUMPTION Supplier Balances for Colombia DIAN
P_CO_DIANSTRPTOTAMTBYCREDITOR CONSUMPTION Total Amount By Creditor for Colombia
P_CO_DIANSTRPTOTAMTBYCREDITOR2 CONSUMPTION Total Creditor Balance for Colombia
P_CO_DIANSTRPTOTAMTBYDEBTOR CONSUMPTION Total Amount by Debtor for Colombia
P_CO_DIANSTRPTOTAMTBYDEBTOR2 CONSUMPTION Total Amount by Debtor for Colombia
P_CO_DIANSTRPTOTAMTBYFORMAT CONSUMPTION Format 1007 – Total Amount by BP
P_CO_DIANSTRPTOTAMTBYFORMAT2 CONSUMPTION Format 1007 – Total Amount by BP
P_CO_DIANSTRPTOTAMTBYITEMTYPE CONSUMPTION Jrnl Entry Itms Tot Amt for BP by Frmt/Itm Type for CO DIAN
P_CO_DIANSTRPWHLDGORVATITEMS CONSUMPTION DEPRECATED – DO NOT USE!
P_CO_DIANSTRPWHLDGTAXITEM CONSUMPTION Withholding Tax Item for Colombia DIAN
P_CO_DIANSTRPWHLDGTAXITEM2 CONSUMPTION Withholding Tax Items 2
P_CO_DIANSTRPWHLDGTAXITEM3 CONSUMPTION Withholding Tax Items 2
P_CO_DIANXREFIDBYBP CONSUMPTION All Formats – Xref ID by BP
P_CO_DIANXREFIDBYBP2 CONSUMPTION All Formats – Xref ID by BP 2
P_CZ_STRPEUTAXCLASSIFICATION CONSUMPTION Rptd and NonRptd items for ECSL – Corr.
P_CZ_STRPEUTAXCLFNCR CONSUMPTION Tax Items for Document Selection – Corr.
P_CZ_STRPREPORTINGGROUPSSELCR CONSUMPTION Rpg. Groups for Doc. Selection – Corr.
P_CZ_STRPRPTDTXITMWITHEUTXCLFN CONSUMPTION Previously Reported Tax Items – Corr.
P_DE_STRPTAXITEMWITHEUSUM CONSUMPTION Aggregate amount for Germany EC Sales List
P_DE_STRPTAXITEMWITHEUSUMT CONSUMPTION The sum total of a filtered range for Germany EC Sales List
P_ES_TAXRETURNBOX CONSUMPTION ATR enabled Tax Items for Modelo 303 Spain
P_FR_AUDITFECACCOUNTLINEITEM CONSUMPTION France Audit File (FEC) ΓÇô ACDOCA-data
P_FR_AUDITFECOPLACCTGDOCITEM CONSUMPTION France Audit File (FEC) ΓÇô BSEG data
P_FR_BOPECO1 CONSUMPTION helper for C_FR_BOPECOCube
P_FR_BOPECO2 CONSUMPTION Aggregation
P_GB_STRPNOTREPTAXBOXITEM CONSUMPTION Not reported tax box items
P_GB_STRPRCNOTRPTDTAXITEM CONSUMPTION GB: Non Reported document for Stat. Rep. – Reverse Charge
P_GB_STRPRCTAXITEMBOXCUBE CONSUMPTION VAT Tax Item box level reporting – Reverse Charge
P_JP_CENTRALBKPAYTWITHAGG2RND CONSUMPTION Central Bank Chart2 Country Aggregation Round
P_JP_CENTRALBKPAYTWITHAGGRND CONSUMPTION Central Bank Chart1 Country Aggregation Round
P_JP_CENTRALBKPAYTWITHCALC1 CONSUMPTION Central Bank Payment Item Calculate 1
P_JP_CENTRALBKPAYTWITHCALC2 CONSUMPTION Central Bank Payment Item Calculate 2
P_JP_CENTRALBKPAYTWITHCHT1SUM CONSUMPTION View for Central Bank Chart1 Summary
P_JP_CENTRALBKPAYTWITHCHT2SUM CONSUMPTION View for Japan Central Bank Payment Chart2 Summary
P_JP_CENTRALBKPAYTWITHCNTY2AGG CONSUMPTION Central Bank Payment Chart2 Country Aggregation
P_JP_CENTRALBKPAYTWITHCNTYAGG CONSUMPTION Central Bank Payment Chart1 Country Aggregation
P_JP_CENTRALBKPAYTWITHITEMS CONSUMPTION View for Japan Central Bank Payment Detail Items
P_LU_STRPNOTRPTDEUTAXCLASS CONSUMPTION Non reported documents for SRF – BE ECSL
P_MX_INVCDESCAMT CONSUMPTION Amount and description
P_MX_INVOICERECEIPTREFERENCE CONSUMPTION Business Partner Tax Item (Journal Entry Item Branch 1)
P_MX_JRNLENTRITMINVCCOMPTYPE CONSUMPTION Select Compesantion type for the document
P_MX_JRNLENTRITMINVCDETAILS CONSUMPTION OperationalAcct with mexico invoice data
P_MX_JRNLENTRITMPAYTDETAILSC CONSUMPTION Journal Entries Items with Payments
P_MX_OPERATIONALACCTDOCITEM CONSUMPTION Journal Entries Items with Payments
P_MX_PAYTDESCAMT CONSUMPTION Amount and description
P_MY_STRPTAXITEM CONSUMPTION Tax Items for Malaysia Statutory Reporting
P_MY_STRPTOTALOUTPUTTAXAMT CONSUMPTION Total Output Tax Amount for Malaysia Statutory Reporting
P_NL_STRPNOTRPTDEUTAXCLASS CONSUMPTION Non reported documents for SRF – BE ECSL
P_NL_STRPNOTRPTDTAXITEM CONSUMPTION Non reported documents for NL VAT reporting
P_NL_STRPNOTRPTDTAXITEM2 CONSUMPTION Non reported documents for NL VAT reporting
P_NL_STRPTAXITEMCUBE_LANG CONSUMPTION Session Lang. for NL VAT Tax Line Items
P_PE_STRPJOURNALENTRYITEM CONSUMPTION Journal Entry Item for Peru in StRp
P_PH_STRPNOTRPTDTAXITEM CONSUMPTION Non Reported document for Statutory Reporting of Philippines
P_PL_STRPEUTAXCLFNCR CONSUMPTION Tax Items for Document Selection – Corr.
P_PL_STRPREPORTINGGROUPSCR CONSUMPTION Reporting Groups – Correction Run
P_PL_STRPREPORTINGGROUPSSELCR CONSUMPTION Rpg. Groups for Doc. Selection – Corr.
P_PL_STRPTRIALBALANCEITEMLOG CONSUMPTION Trial Balance Item – Log of reported documents – Poland
P_PT_DOCITEMWHLDGTXCSHDISCSUM CONSUMPTION VatRegistration Sum
P_PT_DOCITEMWHLDGTXCSHDISCSUMT CONSUMPTION Portugal Annual :Amount Total with parameter
P_PT_DOCITEMWHLDGTXCSHDISCT CONSUMPTION Portugal Annual : Complete Amount Total
P_RO_STRPDEFERREDITEM CONSUMPTION RO: VAT 300 Deferred Items
P_RO_STRPTAXITEMLOG CONSUMPTION Tax Items log for Statutory Reporting
P_SK_STRPEUTAXCLASSIFICATION CONSUMPTION Rptd and NonRptd items for ECSL – Corr.
P_SK_STRPEUTAXCLFNCR CONSUMPTION Tax Items for Document Selection – Corr.
P_SK_STRPREPORTINGGROUPSSELCR CONSUMPTION Rpg. Groups for Doc. Selection – Corr.
P_STRPALLTAXITEM CONSUMPTION Private view to select all the tax items
P_STRPNOTREPORTEDITEM CONSUMPTION Final private view to fetch Not reported items in ACR
P_STRPNOTRPTDITEM CONSUMPTION Private view to fetch Not reported items in ACR
P_STRPNOTRPTDTAXITEM CONSUMPTION Non Reported document for Statutory Reporting
P_STRPRPTDANDNOTRPTDITEM CONSUMPTION Private view to select both reported and not reported docs
P_STRPSALESINVOICEITEM CONSUMPTION Private View for Sales Invoice List
P_TW_STRPNOTRPTDITEMCONSUME CONSUMPTION Consumption View Taiwan not reported item
P_TW_STRPRPTDITEMCONSUME CONSUMPTION Consumption View for Taiwan reported item
P_TW_TAXITEMREVERSAL CONSUMPTION Tax Items with Reversal Logic