I_SG_SalesPurTransListCube

SG GST Transaction Listing Cube | view: ISGSPTRANLISTC | TRAN | 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
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
ExternalDocumentID Reference Document Number
FileLineNumber Row Number in File
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
💲 Company Code Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy Tax Base in Reporting Currency
TaxAmountInCountryCrcy Tax Amount in Reporting Currency
💲 Company Code Currency (AdditionalCurrency1):
TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Local Currency 2
TaxAmountInAdditionalCurrency1 Tax Amount in Local Currency 2
💲 Company Code Currency (AdditionalCurrency2):
TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Local Currency 3
TaxAmountInAdditionalCurrency2 Tax Amount in Local Currency 3
Column Name Description
Column Name Description
ValidityStartDate Valid From Date for Tax Box Structure
ValidFrom Valid From Date for Tax Box Structure
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxReportingDate Tax Reporting Date
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
AssignmentReference null
DocumentItemText Item Text TEXT50
JrnlEntryCntrySpecificRef2 Country/Region Specific Reference 2 in the Document FAC_GLO_REF2_HD
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
  • I_SG_SALESPURTRANSLISTCUBE.MANDT == MARA.MANDT
  • I_SG_SALESPURTRANSLISTCUBE.PRODUCT == MARA.MATNR