P_SG_StRpTaxItemFromBilling

Tax Item from Billing Document | view: PSGSTRPTAXITMFB | Extraction: Not supported | Component: Financials Singapore
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
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
TaxGroup Tax Group
BillingDocument Billing Document
BillingDocumentItem Billing Item
Column Name Description
TaxBaseAmountInTransCrcy null
TaxAmountInTransCrcy null
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
Column Name Description
Column Name Description
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
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentReferenceID Document Reference ID XBLNR1
JrnlEntryCntrySpecificRef2 Country/Region Specific Reference 2 in the Document FAC_GLO_REF2_HD
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
TaxNumber1 Tax Number 1 STCD1
TaxNumber3 Tax Number 3 CHAR18
Master Data Relations Join Conditions
Product Number
  • Client
  • Product Number
  • P_SG_STRPTAXITEMFROMBILLING.MANDT == MARA.MANDT
  • P_SG_STRPTAXITEMFROMBILLING.PRODUCT == MARA.MATNR