C_SG_SalesPurTransListQuery

SG GST Transaction Listing Query | view: CSGSPLISTQ | Extraction: Not supported | Component: Financials Singapore
Tables used: BKPF, VBRK, VBRP, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSE_CLR, BSEC, VBPA3, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, BNKA, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T005, KNA1, CVI_CUST_LINK, FCLM_BNKA_BP_FS, T012, T685, T685A, MAKT, FCLM_BAM_BNKABP2, LFA1, CVI_VEND_LINK, T007A, T001, T014, T007B, T012D
Column Name Description
CompanyCode Company Code
TaxReportingDate Tax Reporting Date
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
ExternalDocumentID Reference Document Number
FileLineNumber Row Number in File
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
TaxBox Tax Box (Adv. Tax Return)
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
ValidityStartDate Valid From Date for Tax Box Structure
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
TaxGroup Tax Group
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Tax Amount in Reporting Currency
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
TaxAmountInTransCrcy Tax Amount in Transaction Currency
TaxBaseAmtInFrgnCrcy null
TaxAmountInFrgnCrcy null
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
Column Name Description
Column Name Description
TaxReportingDate Tax Reporting Date
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
ValidityStartDate Valid From Date for Tax Box Structure
TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxReportingDocumentDate Reporting Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
JrnlEntryCntrySpecificRef2 Country/Region Specific Reference 2 in the Document
ProductName Product Description TEXT40
TaxRate TaxRate (Percentage)
GLAccount General Ledger Account SAKNR
TaxItemGroup Group Indicator for Tax Line Items NUM03
TaxJurisdiction Tax Jurisdiction TXJCD
Ledger Ledger FINS_LEDGER
ReportingCountry Reporting Country/Region LAND1
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerCountry Business Partner Country/Region LAND1
BusinessPartnerName Business Partner Name TEXT80
CustomerSupplierAddress Business Partner Address
TaxNumber3 Tax Number 3 CHAR18
Master Data Relations Join Conditions
Product Number
  • Client
  • Product Number
  • C_SG_SALESPURTRANSLISTQUERY.MANDT == MARA.MANDT
  • C_SG_SALESPURTRANSLISTQUERY.PRODUCT == MARA.MATNR