| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Service Contract - Items API Service Contracts / Service Contract Lines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CTR1 - Service Contract - Items Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
CTR1.ContractID AS 'Contract No.',
CTR1.Line AS 'Row',
CTR1.ManufSN AS 'Mfr Serial No.',
CTR1.InternalSN AS 'Serial Number',
CTR1.ItemCode AS 'Item No.',
CTR1.ItemName AS 'Item Description',
CTR1.ItemGroup AS 'Item Group',
CTR1.StartDate AS 'Start Date',
CTR1.EndDate AS 'End Date',
CTR1.ItmGrpName AS 'Item Group Name',
CTR1.InsID AS 'Customer Equipment Card ID',
CTR1.TermDate AS 'Termination Date'
FROM CTR1 AS CTR1 Related informationService Contract Lines ServiceContract_Lines Object· Table: CTR1 ServiceContract_Lines is a child object of the ServiceContracts object that represents the line entries of each service contract. This object is part of the Service module.
Source table: CTR1. ![]() Service Contracts OCTR SQL Table Customer Equipment Card OINS SQL Table Items OITM SQL Table Item Groups OITB SQL Table |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |