|
|
DTW Sales Tax Invoice - Rows1
API Tax Invoices / Tax Invoice Lines
OTXD - Tax Invoice Draft Table
Tax Invoice Lines TaxInvoice_Lines Object· Table: TSI1
Parent: Tax Invoices TaxInvoices Object· Table: OTSI
Business Place OBPL SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Object Settings - History ADP1 SQL Table
Period Indicator OPID SQL Table
Journal Entry OJDT SQL Table
Delivery Types OSHP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| DocType | Document Type | VarChar | I) Invoice P) Payment J) Journal Entry C) Correction Invoice D) Down Payment A) Alteration Invoice B) Alteration Correction Invoice | 1 | I | |||
| CANCELED | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| HandWriten | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | |||
| Printed | Printed | VarChar | Y) Yes N) No | 1 | N | |||
| Transfered | Year Transfer | VarChar | Y) Yes N) No | 1 | N | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 194 | |||
| DocDate | Posting Date | Date | 8 | |||||
| CardCode | Customer Code | nVarChar | 15 | OCRD Business Partner | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| Series | Series | Int | 6 | 0 | ||||
| Segment | Segment | Int | 6 | 0 | ||||
| CntctCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| VatDate | Document Date | Date | 8 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| TrnspCode | Shipping Type | Int | 6 | OSHP Delivery Types | -1 | |||
| ShipToCode | Ship-to Code | nVarChar | 50 | |||||
| Address | Bill to | nVarChar | 127 | |||||
| Address2 | Ship To | nVarChar | 127 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CurSource | Base Currency | VarChar | L) Local Currency S) System Currency C) BP Currency | 1 | C | |||
| DocCur | Document Currency | nVarChar | 3 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| NumAtCard | BP Reference No. | nVarChar | 100 | |||||
| CardName | Customer/Vendor Name | nVarChar | 100 | |||||
| CancelDate | Cancel Date | Date | 8 | |||||
| DocTotal | Document Total | Num | 20 | |||||
| VatSum | Total Tax | Num | 20 | |||||
| PayRefNo | Payment Ref. No. | nVarChar | 16 | |||||
| PayRefDate | Payment Ref. Date | Date | 8 | |||||
| TaxMethod | Taxation Method | VarChar | S) On Shipment P) On Payment | 1 | S | |||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| IsDpm | IS Down Payment | VarChar | Y) Yes N) No | 1 | N | |||
| AltRev | Alteration Revision | Int | 11 | 0 | ||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| JrnlMemo | Journal Remark | nVarChar | 50 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VATRegNum | Branch Reg. No. | nVarChar | 32 |
Table relationship map
SELECT statement
SELECT
OTXD.DocEntry AS 'Internal Number',
OTXD.DocNum AS 'Document Number',
OTXD.DocType AS 'Document Type',
OTXD.CANCELED AS 'Canceled',
OTXD.HandWriten AS 'Manual Numbering',
OTXD.Printed AS 'Printed',
OTXD.Transfered AS 'Year Transfer',
OTXD.ObjType AS 'Object Type',
OTXD.DocDate AS 'Posting Date',
OTXD.CardCode AS 'Customer Code',
OTXD.CreateDate AS 'Creation Date',
OTXD.UpdateDate AS 'Date of Update',
OTXD.DocDueDate AS 'Due Date',
OTXD.Series AS 'Series',
OTXD.Segment AS 'Segment',
OTXD.CntctCode AS 'Contact Person',
OTXD.VatDate AS 'Document Date',
OTXD.Comments AS 'Remarks',
OTXD.TrnspCode AS 'Shipping Type',
OTXD.ShipToCode AS 'Ship-to Code',
OTXD.Address AS 'Bill to',
OTXD.Address2 AS 'Ship To',
OTXD.LogInstanc AS 'Log Instance',
OTXD.CurSource AS 'Base Currency',
OTXD.DocCur AS 'Document Currency',
OTXD.UserSign AS 'User Signature',
OTXD.UserSign2 AS 'Updating User',
OTXD.NumAtCard AS 'BP Reference No.',
OTXD.CardName AS 'Customer/Vendor Name',
OTXD.CancelDate AS 'Cancel Date',
OTXD.DocTotal AS 'Document Total',
OTXD.VatSum AS 'Total Tax',
OTXD.PayRefNo AS 'Payment Ref. No.',
OTXD.PayRefDate AS 'Payment Ref. Date',
OTXD.TaxMethod AS 'Taxation Method',
OTXD.AtcEntry AS 'Attachment Entry',
OTXD.IsDpm AS 'IS Down Payment',
OTXD.AltRev AS 'Alteration Revision',
OTXD.PIndicator AS 'Period Indicator',
OTXD.TransId AS 'Transaction Number',
OTXD.JrnlMemo AS 'Journal Remark',
OTXD.BPLId AS 'Branch',
OTXD.BPLName AS 'Branch Name',
OTXD.VATRegNum AS 'Branch Reg. No.'
FROM OTXD AS OTXD
Related information
Tax Invoice Lines TaxInvoice_Lines Object· Table: TSI1
TaxInvoice_Lines is a child object of the TaxInvoices object that represents the line entries of each tax invoice document.
Source table: TSI1 for sales invoices, TPI1 for purchase invoices, or TXD1 for journal entry.
Parent: Tax Invoices TaxInvoices Object· Table: OTSI Business Place OBPL SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Object Settings - History ADP1 SQL Table
Period Indicator OPID SQL Table
Journal Entry OJDT SQL Table
Delivery Types OSHP SQL Table
Users OUSR SQL Table
TaxInvoices
Object
TaxInvoice_Lines
Method
Property
BaseEntry
DB
BaseType
DB
LineNum
DB
Reference
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
