|
|
API OTSI / Tax Invoices
OTSI - Sales Tax Invoice Table
Tax Invoices TaxInvoices Object· Table: OTSI
OTSI SQL Table
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 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. No. 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
OTSI.DocEntry AS 'Internal Number',
OTSI.DocNum AS 'Document Number',
OTSI.DocType AS 'Document Type',
OTSI.CANCELED AS 'Canceled',
OTSI.HandWriten AS 'Manual Numbering',
OTSI.Printed AS 'Printed',
OTSI.Transfered AS 'Year Transfer',
OTSI.ObjType AS 'Object Type',
OTSI.DocDate AS 'Posting Date',
OTSI.CardCode AS 'Customer Code',
OTSI.CreateDate AS 'Creation Date',
OTSI.UpdateDate AS 'Date of Update',
OTSI.DocDueDate AS 'Due Date',
OTSI.Series AS 'Series',
OTSI.Segment AS 'Segment',
OTSI.CntctCode AS 'Contact Person',
OTSI.VatDate AS 'Document Date',
OTSI.Comments AS 'Remarks',
OTSI.TrnspCode AS 'Shipping Type',
OTSI.ShipToCode AS 'Ship-to Code',
OTSI.Address AS 'Bill to',
OTSI.Address2 AS 'Ship To',
OTSI.LogInstanc AS 'Log Instance',
OTSI.CurSource AS 'Base Currency',
OTSI.DocCur AS 'Document Currency',
OTSI.UserSign AS 'User Signature',
OTSI.UserSign2 AS 'Updating User',
OTSI.NumAtCard AS 'BP Reference No.',
OTSI.CardName AS 'Customer/Vendor Name',
OTSI.CancelDate AS 'Cancel Date',
OTSI.DocTotal AS 'Document Total',
OTSI.VatSum AS 'Total Tax',
OTSI.PayRefNo AS 'Payment Ref. No.',
OTSI.PayRefDate AS 'Payment Ref. No. Date',
OTSI.TaxMethod AS 'Taxation Method',
OTSI.AtcEntry AS 'Attachment Entry',
OTSI.IsDpm AS 'IS Down Payment',
OTSI.AltRev AS 'Alteration Revision',
OTSI.PIndicator AS 'Period Indicator',
OTSI.TransId AS 'Transaction Number',
OTSI.JrnlMemo AS 'Journal Remark',
OTSI.BPLId AS 'Branch',
OTSI.BPLName AS 'Branch Name',
OTSI.VATRegNum AS 'Branch Reg. No.'
FROM OTSI AS OTSI
Related information
Tax Invoices TaxInvoices Object· Table: OTSI
TaxInvoices is a business object that represents the header data of a Tax Invoice document.
Source table: OTSI for sales invoices, OTPI for purchase invoices, or OTXD for journal entry according to the DocType valid value.
OTSI SQL Table
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
Enumeration
Method
Object
TaxInvoice_Lines TSI1
Property
Address
DB
Address2
DB
CancelDate
DB
CardCode
DB
Comments
DB
CreationDate
DB
DocCurrency
DB
DocDate
DB
DocDueDate
DB
DocEntry
DB
DocNum
DB
DocType
DB
PaymentRefNo
DB
Printed
DB
Segment
DB
Series
DB
ShipToCode
DB
TaxDate
DB
TaxTotal
DB
UpdateDate
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
