A_BusSolnOrdSrvcContractItem

Service Contract Item | view: ABSOSRVCTRITM | TRAN | Extraction: Not supported | Component: S4CRM: Solution Order

Tables used: CRMS4D_EXT_REF, CRMS4D_SERV_I, TIMERUNA, TVAGT, TIMERULEH

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (3)
📅 Dates
☰ Categorical (2)
Other (15)
🔗 Relations (12)

Column Name	Description
BusinessSolutionOrder	Transaction ID
BusinessSolutionOrderItem	Shortened Item Number in Document

Column Name	Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount	Net Value

Column Name	Description
📏 Unit of Measure in Which the Product Is Sold (QuantityUnit):
Quantity	CRM: Order Quantity
📏 UOM for Auto Renewal Period (SrvcContrItemRnwlDurationUnit):
SrvcContrItemRnwlDuration	Unit for Auto Renewal Period
SrvcContrItemExtensionDuration	Unit for Contract Extension

Column Name	Description

Column Name	Description
BusSolnOrdItmIsReleased	Release Status	Show values
BusSolnOrdItmIsRejected	Cancellation Status	Show values

Column Name	Description	Domain name
BusinessSolutionOrderItemUUID	GUID of a CRM Order Object	SYSUUID
Product	Product Name Entered	CRM_ORDERED_PROD
BusSolnOrdItmDescription	Product Description	CRM_PRSHTEXT40_DB
Language	Short Text Language for an Item	SYLANGU
BusSolnOrdItmExtReference	External Reference Number	CRMS4_EXT_REF_NUM
BusSolnOrdItmIsCompleted	null
BusSolnOrdItmDistrStatus	null
BusSolnOrdItmDistrStatusName	null
BusSolnOrdItmRjcnReasonText	Description	TEXT40
ServiceProfile	Service Profile	CRM_SRV_SERWI
ResponseProfile	Response Profile	CRM_SRV_ESCAL
BillingPlanBillingDateRule	Name for Date Rule	TIMENAME
SettlementPeriodRule	Name for Date Rule	TIMENAME
ServiceContrItemStartDateTime	Contract Start date	DEC15
ServiceContrItemEndDateTime	Contract End Date	DEC15

Master Data Relations	Join Conditions
Business Partner: Billing Block Reason Business Partner: Billing Block Reason Client	`A_BUSSOLNORDSRVCCONTRACTITEM.BILLINGBLOCKREASON == TVFS.FAKSP` `A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == TVFS.MANDT`
Bill-To Party Client Bill-To Party	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == BUT000.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.BILLTOPARTY == BUT000.PARTNER`
Item Category Client Item Category	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == CRMC_ITEM_TYPE.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.BUSSOLNORDITMCATEGORY == CRMC_ITEM_TYPE.ITM_TYPE`
Cancellation Reason Code Client Cancellation Reason Code	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == TVAG.MANDT` `A_BUSSOLNORDSRVCCONTRACTITEM.BUSSOLNORDITMRJCNREASON == TVAG.ABGRU`
Customer Contact Person Client Customer Contact Person	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == BUT000.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.CONTACTPERSON == BUT000.PARTNER`
Payer Client Payer	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == BUT000.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.PAYERPARTY == BUT000.PARTNER`
Terms of Payment Client Terms of Payment ?	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == T052.MANDT` `A_BUSSOLNORDSRVCCONTRACTITEM.PAYMENTTERMS == T052.ZTERM` `A_BUSSOLNORDSRVCCONTRACTITEM.[column in domain "DZTAGG_052"] == T052.ZTAGG`
Employee Responsible Client Employee Responsible	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == BUT000.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.PERSONRESPONSIBLE == BUT000.PARTNER`
Unit of Measure in Which the Product Is Sold Client Unit of Measure in Which the Product Is Sold	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == T006.MANDT` `A_BUSSOLNORDSRVCCONTRACTITEM.QUANTITYUNIT == T006.MSEHI`
Ship-To Party Client Ship-To Party	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == BUT000.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.SHIPTOPARTY == BUT000.PARTNER`
Sold-To Party Client Sold-To Party	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == BUT000.CLIENT` `A_BUSSOLNORDSRVCCONTRACTITEM.SOLDTOPARTY == BUT000.PARTNER`
Currency Client Currency	`A_BUSSOLNORDSRVCCONTRACTITEM.MANDT == TCURC.MANDT` `A_BUSSOLNORDSRVCCONTRACTITEM.TRANSACTIONCURRENCY == TCURC.WAERS`