|
|
API OINS / / Customer Equipment Cards
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | insID KEY UNIQUE | Equipment Card No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| customer KEY | Customer Code | nVarChar | 15 | OCRD Business Partner | C_ITM_SN_S | No | ||
| custmrName | Customer Name | nVarChar | 100 | |||||
| contactCod | Contact Person Code | Int | 11 | OCPR Contact Persons | ||||
| directCsmr | Direct Customer | nVarChar | 15 | |||||
| drctCsmNam | Direct Customer Name | nVarChar | 100 | |||||
| manufSN | Mfr Serial No. | nVarChar | 36 | |||||
| internalSN | Serial Number | nVarChar | 36 | |||||
| warranty | Warranty | VarChar | Y) Yes N) No | 1 | N | |||
| wrrntyStrt | Warranty Start Date | Date | 8 | |||||
| wrrntyEnd | Warranty End Date | Date | 8 | |||||
| responsVal | Time Required for Response | Int | 6 | |||||
| responsUnt | Time Unit | VarChar | H) Hour(s) D) Day(s) | 1 | D | |||
| itemCode KEY | Item No. | nVarChar | 20 | OITM Items | ITM_INTSN | No | ||
| itemName | Item Description | nVarChar | 100 | |||||
| itemGroup | Item Group | Int | 6 | OITB Item Groups | ||||
| manufDate | Manufacture Date | Date | 8 | |||||
| delivery | Delivery Key | Int | 11 | ODLN Delivery | ||||
| deliveryNo | Delivery Number | Int | 11 | |||||
| invoice | Invoice Key | Int | 11 | OINV A/R Invoice | ||||
| invoiceNum | Invoice Number | Int | 11 | |||||
| dlvryDate | Delivery Date | Date | 8 | |||||
| cntctPhone | Contact Phone | nVarChar | 20 | |||||
| street | Street | nVarChar | 100 | |||||
| block | Block | nVarChar | 100 | |||||
| zip | Zip Code | nVarChar | 20 | |||||
| city | City | nVarChar | 100 | |||||
| county | County | nVarChar | 100 | |||||
| country | Country | nVarChar | 3 | OCRY Countries | ||||
| state | State | nVarChar | 3 | OCST States | ||||
| instLction | Installation Location | nVarChar | 127 | |||||
| contract | Contract | Int | 11 | OCTR Service Contracts | ||||
| cntrctStrt | Contract Start Date | Date | 8 | |||||
| cntrctEnd | Contract End Date | Date | 8 | |||||
| attachment | Attachments | Text | 16 | |||||
| objType | Object Type | nVarChar | 20 | 176 | ||||
| logInstanc | Log Instance | Int | 11 | |||||
| userSign | Creating User | Int | 6 | OUSR Users | ||||
| createDate | Creation Date | Date | 8 | |||||
| userSign2 | Updating User | Int | 6 | OUSR Users | ||||
| updateDate | Date of Update | Date | 8 | |||||
| Building | Building/Floor/Room | Text | 16 | |||||
| status | Status | VarChar | A) Active R) Returned T) Terminated L) Loaned I) In Repair Lab | 1 | A | |||
| replcIns | The CEC this replaced | Int | 11 | OINS Customer Equipment Card | ||||
| repByIns | The CEC this is replaced by | Int | 11 | OINS Customer Equipment Card | ||||
| technician | Default Technician | Int | 11 | OHEM Employees | ||||
| territory | Default Territory | Int | 11 | OTER Territories | ||||
| AtcEntry | Attachment Entry | Int | 11 | OATC Attachments | ||||
| Transfered | Year Transfer | VarChar | 1 | N | ||||
| AddrType | Address Type | nVarChar | 100 | |||||
| Instance | Instance | Int | 6 | 0 | ||||
| StreetNo | Street No. | nVarChar | 100 |
Table relationship map
SELECT statement
SELECT
OINS.insID AS 'Equipment Card No.',
OINS.customer AS 'Customer Code',
OINS.custmrName AS 'Customer Name',
OINS.contactCod AS 'Contact Person Code',
OINS.directCsmr AS 'Direct Customer',
OINS.drctCsmNam AS 'Direct Customer Name',
OINS.manufSN AS 'Mfr Serial No.',
OINS.internalSN AS 'Serial Number',
OINS.warranty AS 'Warranty',
OINS.wrrntyStrt AS 'Warranty Start Date',
OINS.wrrntyEnd AS 'Warranty End Date',
OINS.responsVal AS 'Time Required for Response',
OINS.responsUnt AS 'Time Unit',
OINS.itemCode AS 'Item No.',
OINS.itemName AS 'Item Description',
OINS.itemGroup AS 'Item Group',
OINS.manufDate AS 'Manufacture Date',
OINS.delivery AS 'Delivery Key',
OINS.deliveryNo AS 'Delivery Number',
OINS.invoice AS 'Invoice Key',
OINS.invoiceNum AS 'Invoice Number',
OINS.dlvryDate AS 'Delivery Date',
OINS.cntctPhone AS 'Contact Phone',
OINS.street AS 'Street',
OINS.block AS 'Block',
OINS.zip AS 'Zip Code',
OINS.city AS 'City',
OINS.county AS 'County',
OINS.country AS 'Country',
OINS.state AS 'State',
OINS.instLction AS 'Installation Location',
OINS.contract AS 'Contract',
OINS.cntrctStrt AS 'Contract Start Date',
OINS.cntrctEnd AS 'Contract End Date',
OINS.attachment AS 'Attachments',
OINS.objType AS 'Object Type',
OINS.logInstanc AS 'Log Instance',
OINS.userSign AS 'Creating User',
OINS.createDate AS 'Creation Date',
OINS.userSign2 AS 'Updating User',
OINS.updateDate AS 'Date of Update',
OINS.Building AS 'Building/Floor/Room',
OINS.status AS 'Status',
OINS.replcIns AS 'The CEC this replaced',
OINS.repByIns AS 'The CEC this is replaced by',
OINS.technician AS 'Default Technician',
OINS.territory AS 'Default Territory',
OINS.AtcEntry AS 'Attachment Entry',
OINS.Transfered AS 'Year Transfer',
OINS.AddrType AS 'Address Type',
OINS.Instance AS 'Instance',
OINS.StreetNo AS 'Street No.'
FROM OINS AS OINS
Related information
Customer Equipment Cards CustomerEquipmentCards Object· Table: OINS
CustomerEquipmentCards is a business object that represents the customer equipment cards in the Services module.
This object enables you to:
Add a customer equipment card.
Retrieve a customer equipment card by its key.
Update a customer...
Document Installments Document_Installments Object
A child object of Documents object representing the installments feature in marketing documents.
Source tables: INV6, OPCH6.
Parent: Documents Documents Object· Table: OIGE OIGN Customer Equipment Card OINS SQL Table
Attachments OATC SQL Table
Contact Persons OCPR SQL Table
Service Contracts OCTR SQL Table
Countries OCRY SQL Table
Business Partner OCRD SQL Table
Delivery ODLN SQL Table
A/R Invoice OINV SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
States OCST SQL Table
Employees OHEM SQL Table
Territories OTER SQL Table
Users OUSR SQL Table
CustomerEquipmentCards
Enumeration
Method
Property
Block
DB
City
DB
ContactPhone
DB
CountryCode
DB
County
DB
CustomerCode
DB
CustomerName
DB
DeliveryCode
DB
DeliveryDate
DB
InvoiceCode
DB
ItemCode
DB
ReplacedBySN
DB
ReplaceSN
DB
StateCode
DB
Street
DB
ZipCode
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates