|
|
API OSAL
OSAL - Outgoing Table
Business Partner OCRD SQL Table
Payment Terms OCTG SQL Table
Landed Costs OIPF SQL Table
Object Settings - History ADP1 SQL Table
Sales Employee OSLP 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 | Document Number | Int | 11 | NUM | No | |||
| BaseDocNum KEY | Base Document Number | Int | 11 | BASE_DOC | No | |||
| Printed | Printed | VarChar | Y) Copy N) Original | 1 | N | |||
| ObjType KEY | Object Type | nVarChar | 20 | ADP1 Object Settings - History | OBJECT | No | ||
| DocDate | Posting Date | Date | 8 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | BP Name | nVarChar | 100 | |||||
| FreZoneNum | ID Number | nVarChar | 8 | |||||
| Shiper | Sender | nVarChar | 100 | |||||
| Address | Address | nVarChar | 127 | |||||
| FromCntry | Country - Origin | nVarChar | 100 | |||||
| ToCntry | Country - Destination | nVarChar | 100 | |||||
| FromPort | Origin Port | nVarChar | 100 | |||||
| ToPort | Destination Port | nVarChar | 100 | |||||
| AirPlane | Ship/Aircraft | nVarChar | 50 | |||||
| AirPlanNum | No. of Ships/Aircraft | nVarChar | 40 | |||||
| TotalFob | Total | Num | 20 | |||||
| Taxes | Taxes | Num | 20 | |||||
| Insurance | Insurance | Num | 20 | |||||
| Others | Other | Num | 20 | |||||
| TotalCif | Document Total | Num | 20 | |||||
| Ref1 | Reference 1 | nVarChar | 11 | |||||
| Ref2 | Reference 2 | nVarChar | 11 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| GroupNum | Payment Terms Code | Int | 6 | OCTG Payment Terms | ||||
| DocTime | Document Time | Int | 6 | |||||
| SlpCode | Sales Employee | Int | 11 | OSLP Sales Employee | -1 | |||
| TrnspCode | Delivery Code | Int | 6 | OSHP Delivery Types | -1 | |||
| PartSupply | Delivery of Goods | VarChar | Y) Yes N) No | 1 | Y | |||
| ImportEnt | Landed Costs | Int | 11 | OIPF Landed Costs | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| NumForPrn | Base Doc. No. for Printing | nVarChar | 16 | |||||
| PurPackMsr | Packaging UoM Name | nVarChar | 8 | |||||
| Series KEY | Series | Int | 6 | SERIES | No | |||
| BaseDocObj | Base Document Object Type | Int | 6 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OSAL.DocEntry AS 'Internal Number',
OSAL.DocNum AS 'Document Number',
OSAL.BaseDocNum AS 'Base Document Number',
OSAL.Printed AS 'Printed',
OSAL.ObjType AS 'Object Type',
OSAL.DocDate AS 'Posting Date',
OSAL.DocDueDate AS 'Due Date',
OSAL.CardCode AS 'BP Code',
OSAL.CardName AS 'BP Name',
OSAL.FreZoneNum AS 'ID Number',
OSAL.Shiper AS 'Sender',
OSAL.Address AS 'Address',
OSAL.FromCntry AS 'Country - Origin',
OSAL.ToCntry AS 'Country - Destination',
OSAL.FromPort AS 'Origin Port',
OSAL.ToPort AS 'Destination Port',
OSAL.AirPlane AS 'Ship/Aircraft',
OSAL.AirPlanNum AS 'No. of Ships/Aircraft',
OSAL.TotalFob AS 'Total',
OSAL.Taxes AS 'Taxes',
OSAL.Insurance AS 'Insurance',
OSAL.Others AS 'Other',
OSAL.TotalCif AS 'Document Total',
OSAL.Ref1 AS 'Reference 1',
OSAL.Ref2 AS 'Reference 2',
OSAL.Comments AS 'Remarks',
OSAL.GroupNum AS 'Payment Terms Code',
OSAL.DocTime AS 'Document Time',
OSAL.SlpCode AS 'Sales Employee',
OSAL.TrnspCode AS 'Delivery Code',
OSAL.PartSupply AS 'Delivery of Goods',
OSAL.ImportEnt AS 'Landed Costs',
OSAL.CreateDate AS 'Creation Date',
OSAL.UpdateDate AS 'Date of Update',
OSAL.NumForPrn AS 'Base Doc. No. for Printing',
OSAL.PurPackMsr AS 'Packaging UoM Name',
OSAL.Series AS 'Series',
OSAL.BaseDocObj AS 'Base Document Object Type',
OSAL.DataSource AS 'Data Source',
OSAL.UserSign AS 'User Signature'
FROM OSAL AS OSAL
Related information
Business Partner OCRD SQL Table
Payment Terms OCTG SQL Table
Landed Costs OIPF SQL Table
Object Settings - History ADP1 SQL Table
Sales Employee OSLP SQL Table
Delivery Types OSHP SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
