|
|
API WTQ13
WTQ13 - Inventory Transfer Request Rows - Distributed Freights Table
Inventory Transfer Request OWTQ SQL Table
Freight Setup OEXD SQL Table
Currency Codes OCRN SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Sales Tax Codes OSTC SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Document ID | Int | 11 | OWTQ Inventory Transfer Request | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| GroupNum | Group Number | Int | 11 | |||||
| ExpnsCode | Freight Code | Int | 11 | OEXD Freight Setup | ||||
| LineTotal | Total | Num | 20 | |||||
| TotalFrgn | Total (FC) | Num | 20 | |||||
| TotalSumSy | Total (SC) | Num | 20 | |||||
| PaidToDate | Paid to Date | Num | 20 | |||||
| PaidFC | Paid (FC) | Num | 20 | |||||
| PaidSys | Paid (SC) | Num | 20 | |||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 1250000001 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| TaxStatus | Tax Liable | VarChar | Y) Yes N) No | 1 | Y | |||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatPrcnt | Row Tax % | Num | 20 | |||||
| VatSum | Tax Amount | Num | 20 | |||||
| VatSumFrgn | Tax Amount (FC) | Num | 20 | |||||
| VatSumSy | Tax Amount (SC) | Num | 20 | |||||
| DedVatSum | Deductible Tax Amount | Num | 20 | |||||
| DedVatSumF | Deductible Tax Amount (FC) | Num | 20 | |||||
| DedVatSumS | Deductible Tax Amount (SC) | Num | 20 | |||||
| IsAcquistn | Acquisition Tax | VarChar | Y) Yes N) No | 1 | N | |||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| TaxType | Tax Type | VarChar | Y) Normal Tax N) No Tax U) Use Tax | 1 | Y | |||
| VatApplied | VAT Applied | Num | 20 | |||||
| VatAppldFC | VAT Applied Frgn | Num | 20 | |||||
| VatAppldSC | VAT Applied Sys | Num | 20 | |||||
| EquVatPer | Equalization Tax % | Num | 20 | |||||
| EquVatSum | Total Equalization Tax | Num | 20 | |||||
| EquVatSumF | Total Equalization Tax (FC) | Num | 20 | |||||
| EquVatSumS | Total Equalization Tax (SC) | Num | 20 | |||||
| lineVat | Net Tax Amount | Num | 20 | |||||
| lineVatlF | Net Tax Amount (FC) | Num | 20 | |||||
| lineVatS | Net Tax Amount (SC) | Num | 20 | |||||
| WtLiable | WTax Liable | VarChar | Y) Yes N) No | 1 | ||||
| BaseMethod | Base Method | VarChar | N) None Q) Quantity V) Volume W) Weight T) Total A) All | 1 | ||||
| Stock | Stock | VarChar | Y) Yes N) No | 1 | N | |||
| LstPchPrce | Last Purchase Price | VarChar | Y) Yes N) No | 1 | ||||
| AnalysRpt | Analysis Report | VarChar | Y) Yes N) No | 1 | N | |||
| BaseAbsEnt | Base Abs Entry | Int | 11 | -1 | ||||
| BaseType | Base Document Type | Int | 11 | |||||
| BaseRef | Base Document Reference | Int | 11 | |||||
| BaseLnNum | Base Document Line No. | Int | 11 | |||||
| TrgType | Target Type | Int | 11 | |||||
| TrgAbsEnt | Target Abs. Entry | Int | 11 | -1 | ||||
| BaseGroup | Base Document Group | Int | 11 | -1 | ||||
| Status | Status | VarChar | O) Open C) Close | 1 | O | |||
| TrgGroup | Target Group | Int | 11 | -1 | ||||
| VisOrder | Visual Order | Int | 11 | |||||
| DistrbMthd | Distribution Method | VarChar | N) None Q) Quantity V) Volume W) Weight E) Equally T) Row Total | 1 | ||||
| DistribExp | Distribute Freights | VarChar | Y) Yes N) No | 1 | ||||
| FixCurr | Fixation Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| VatDscntPr | Tax Discount % | Num | 20 | |||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes |
Table relationship map
SELECT statement
SELECT
WTQ13.DocEntry AS 'Internal Document ID',
WTQ13.LineNum AS 'Row Number',
WTQ13.GroupNum AS 'Group Number',
WTQ13.ExpnsCode AS 'Freight Code',
WTQ13.LineTotal AS 'Total',
WTQ13.TotalFrgn AS 'Total (FC)',
WTQ13.TotalSumSy AS 'Total (SC)',
WTQ13.PaidToDate AS 'Paid to Date',
WTQ13.PaidFC AS 'Paid (FC)',
WTQ13.PaidSys AS 'Paid (SC)',
WTQ13.ObjType AS 'Object Type',
WTQ13.LogInstanc AS 'Log Instance',
WTQ13.TaxStatus AS 'Tax Liable',
WTQ13.VatGroup AS 'Tax Group',
WTQ13.VatPrcnt AS 'Row Tax %',
WTQ13.VatSum AS 'Tax Amount',
WTQ13.VatSumFrgn AS 'Tax Amount (FC)',
WTQ13.VatSumSy AS 'Tax Amount (SC)',
WTQ13.DedVatSum AS 'Deductible Tax Amount',
WTQ13.DedVatSumF AS 'Deductible Tax Amount (FC)',
WTQ13.DedVatSumS AS 'Deductible Tax Amount (SC)',
WTQ13.IsAcquistn AS 'Acquisition Tax',
WTQ13.TaxCode AS 'Tax Code',
WTQ13.TaxType AS 'Tax Type',
WTQ13.VatApplied AS 'VAT Applied',
WTQ13.VatAppldFC AS 'VAT Applied Frgn',
WTQ13.VatAppldSC AS 'VAT Applied Sys',
WTQ13.EquVatPer AS 'Equalization Tax %',
WTQ13.EquVatSum AS 'Total Equalization Tax',
WTQ13.EquVatSumF AS 'Total Equalization Tax (FC)',
WTQ13.EquVatSumS AS 'Total Equalization Tax (SC)',
WTQ13.lineVat AS 'Net Tax Amount',
WTQ13.lineVatlF AS 'Net Tax Amount (FC)',
WTQ13.lineVatS AS 'Net Tax Amount (SC)',
WTQ13.WtLiable AS 'WTax Liable',
WTQ13.BaseMethod AS 'Base Method',
WTQ13.Stock AS 'Stock',
WTQ13.LstPchPrce AS 'Last Purchase Price',
WTQ13.AnalysRpt AS 'Analysis Report',
WTQ13.BaseAbsEnt AS 'Base Abs Entry',
WTQ13.BaseType AS 'Base Document Type',
WTQ13.BaseRef AS 'Base Document Reference',
WTQ13.BaseLnNum AS 'Base Document Line No.',
WTQ13.TrgType AS 'Target Type',
WTQ13.TrgAbsEnt AS 'Target Abs. Entry',
WTQ13.BaseGroup AS 'Base Document Group',
WTQ13.Status AS 'Status',
WTQ13.TrgGroup AS 'Target Group',
WTQ13.VisOrder AS 'Visual Order',
WTQ13.DistrbMthd AS 'Distribution Method',
WTQ13.DistribExp AS 'Distribute Freights',
WTQ13.FixCurr AS 'Fixation Currency',
WTQ13.VatDscntPr AS 'Tax Discount %',
WTQ13.OcrCode AS 'Distribution Rule',
WTQ13.OcrCode2 AS 'Distribution Rule 2',
WTQ13.OcrCode3 AS 'Distribution Rule 3',
WTQ13.OcrCode4 AS 'Distribution Rule 4',
WTQ13.OcrCode5 AS 'Distribution Rule 5',
WTQ13.Project AS 'Project Code'
FROM WTQ13 AS WTQ13
Related information
Inventory Transfer Request OWTQ SQL Table
Freight Setup OEXD SQL Table
Currency Codes OCRN SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Sales Tax Codes OSTC SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
