I_SERVICEDOCUMENTITEMENHCD

CDS View
247 Fields 157 CDS Views

Service Transaction Item Enhanced

I_SERVICEDOCUMENTITEMENHCD is a CDS View in S/4HANA. Service Transaction Item Enhanced. It contains 247 fields. 157 CDS views read from this table.

CDS Views using this table (157)

ViewTypeJoinVDMDescription
A_BusSolnOrdEntProjectItem view from COMPOSITE Enterprise Project Item
A_BusSolnOrderExpenseItem view from COMPOSITE Expense Item
A_BusSolnOrderSalesItem view from COMPOSITE Sales Order Item
A_BusSolnOrderServiceItem view from COMPOSITE Service Order Item
A_BusSolnOrdSrvcContractItem view from COMPOSITE Service Contract Item
A_BusSolnOrdSrvcPrtItem view from COMPOSITE Service Part Item
A_BusSolnOrdSubscrpnBillgItem view from COMPOSITE Subscription Billing Item
A_BusSolnQtanBundleItem view from COMPOSITE Solution Quotation Bundle Item
A_BusSolnQtanExpenseItem view from COMPOSITE Expense Item
A_BusSolnQtanItemQualification view_entity inner CONSUMPTION Solution Quotation Qualification item Details
A_BusSolnQtanSalesItem view from COMPOSITE Sales Item
A_BusSolnQtanServiceItem view from COMPOSITE Service Item
A_BusSolnQtanSrvcContrItem view from COMPOSITE Service Contract Item
A_BusSolnQtanSrvcPrtItem view from COMPOSITE Service Part Item
A_BusSolnQtanSubscrpnItem view from COMPOSITE Subscription Related Item
A_ServiceConfirmationItem view from COMPOSITE Service Confirmation Item
A_ServiceContractItem view from CONSUMPTION Service Contract Item
A_ServiceContrItmReleasedOrder view inner CONSUMPTION Item Released Order
A_ServiceOrderItem view from COMPOSITE Service Order Items
A_ServiceOrderTemplateItem view from COMPOSITE Service Order Template Items
A_ServiceQuotationItem view from COMPOSITE Service Quotation Item
A_SrvcOrdItemQualification view_entity inner COMPOSITE Srvc Order Item Qualification Details
A_SrvcOrdItmInHouseRepairItem view_entity from CONSUMPTION In-House Service Object of Srvc Ord Itm
A_SrvcOrdItmRefSrvcOrdTmpl view inner COMPOSITE Service Order Item Reference Template
A_SrvcQtanItmInHouseRepairItem view_entity from CONSUMPTION In-House Service Object of Srvc Qtan Itm
A_SubscriptionContractItem view_entity from CONSUMPTION Subscription Contract Item
A_SvTrMtAgrItmReltdSbscrContr view_entity from CONSUMPTION Item Related Subscription Contract
A_SvTrMtAgrItmReltdSbscrOrd view_entity from CONSUMPTION Item Related Subscription Order
A_SvTrMtAgrItmReltdSolnQtn view_entity from CONSUMPTION Item Related Solution Quotation
A_SvTrMtAgrReltdSbscrContr view_entity from CONSUMPTION Header Related Subscription Contract
A_SvTrMtAgrReltdSbscrOrd view_entity from CONSUMPTION Header Related Subscription Order
A_SvTrMtAgrReltdSolnQtn view_entity from CONSUMPTION Header Related Solution Quotation
C_BSOrdItmProcFlwRefSrvcContr view from CONSUMPTION SrvcContrItmPrdcssr Attrib BSOrd Prgrs
C_BSOrdItmProcFlwRoot view from CONSUMPTION BSOrd Item Attrib for BSOrd Prgrs
C_BSOrdItmProcFlwSrvcConf view from CONSUMPTION SrvcConf Item Attrib for BSOrd Prgrs
C_BSOrdItmProcFlwSrvcContr view from CONSUMPTION SrvcContr Item Attrib for BSOrd Prgrs
C_BSOrdItmProcFlwSrvcOrd view from CONSUMPTION SrvcOrd Item Attrib for BSOrd Prgrs
C_BSQPMBusSolnQtanItem view_entity from CONSUMPTION BSQPM Solution Quotation Item Attribute
C_BSQPMSbscrContrItem view_entity from CONSUMPTION BSQPM Subscription Contract Item Attrib
C_BSQPMServiceConfirmationItem view_entity from CONSUMPTION BSQPM Service Confrmation Item Attribute
C_BSQPMServiceContractItem view_entity from CONSUMPTION BSQPM Service Contract Item Attribute
C_BSQPMServiceOrderItem view_entity from CONSUMPTION BSQPM Service Order Item Attribute
C_BusinessSolutionOrderItemDEX view from CONSUMPTION Data Extraction for Bussiness Solution Order
C_BusSolnOrdItemRelationships view inner CONSUMPTION Solution Order Item Relationship
C_BusSolnOrdItmSitnReltdInfo view from CONSUMPTION Solution Order Situation Related Information
C_BusSolnOrdNetAmountSitn view from CONSUMPTION Situation for project cost change
C_BusSolnOrdPlndDteSitn2 view inner CONSUMPTION Trigger CDS view planned date reached
C_BusSolnQtanItemDEX view_entity from CONSUMPTION Solution Quotation Item Extraction
C_ServiceConfirmationItemDEX view from CONSUMPTION Data Extraction for Service Confirmation
C_ServiceContractItemDEX view from CONSUMPTION Data Extraction for Service Contract
C_ServiceDocumentItem view from CONSUMPTION Service Document Item
C_ServiceOrderItemDEX view from CONSUMPTION Data Extraction for Service Order
C_ServiceQuotationItemDEX view_entity from CONSUMPTION Data Extraction for Srvc Quotation Item
C_SrvcConfirmationItem view from CONSUMPTION Confirmations
C_SrvcConfItmObjPgPricingDets view from CONSUMPTION Service Confirmation Item Price Details
C_SrvcConfTransHistory view from CONSUMPTION View for Service Confirmation Transaction History
C_SrvcContrItemBillgValSitn view from CONSUMPTION Contract with Zero Billing Value
C_SrvcContrItmFutrPrcNotif view_entity from CONSUMPTION SrvcContr Item with Price Check Notif
C_SrvcContrItmFutrPrcNotifSitn view_entity from CONSUMPTION Trigger for Price Check Situation
C_SrvcContrItmListRptAndObjPg view from CONSUMPTION Service Contract Item
C_SrvcContrItmObjPgPrcDets view from CONSUMPTION Price Details
C_SrvcDocItemProcessFlow view_entity from CONSUMPTION Service Document Item Process Flow Node
C_SrvcDocItemTransHistory view from CONSUMPTION View for Service Document Item Transaction History
C_SrvcOrderItmObjPgPricingDets view from CONSUMPTION Service Order Item Price Details
C_SrvcOrdTmplItemObjPg view from CONSUMPTION Item
C_SrvcQtanItemListRptAndObjPg view from CONSUMPTION Service Quotation Item
C_SrvOrderItemListRptAndObjPg view from CONSUMPTION Service Order Item
I_BusSolnOrderItemSituation view from COMPOSITE Solution Order Item Situation View
I_BusSolnOrdItemRelationships view from COMPOSITE Solution Order Item Relationships
I_BusSolnOrdItmBasicFinancial view from COMPOSITE Solution Order Item for Fin Reporting
I_ServiceContractItemVH view from COMPOSITE Service Contract Item Value Help
I_SrvcConfReldForPrtlBillg view from COMPOSITE Partial Billing Based on Service Conf
I_SrvcContrItemSituationAnchor view from COMPOSITE Service Contract Items Situation Anchor
I_SrvcDocItmDocumentFlow view from COMPOSITE Transaction History on Item Level
I_SrvcDocStatusChangeDocument view inner COMPOSITE Change Documents for Status
I_SrvcOrdBslnCostPostgSitn view from COMPOSITE Baseline Cost Posting of Service Order Situ
I_SrvcOrdBySrvcEmployee view from COMPOSITE Get service documents responsible by the service employee
I_SrvcOrdItmReleasedForBillg view from COMPOSITE Service Order Item Released for Billing
I_SrvcOrdProcmtMisgConfAnchor view from COMPOSITE Sitn Handling for missing confirmations
I_SubscriptionContractItem view_entity from COMPOSITE Subscription Contract Item
I_SubscriptionContractItemSitn view_entity from COMPOSITE SOM Subcription Contract End Situation
I_SubscriptionOrderItem view_entity from COMPOSITE Subscription Order Item
I_SubscrpnContrItemDistrSitn view_entity from COMPOSITE Subcription Contract Distribution Situation
P_BSOrdGLAcctLineItemCube view from COMPOSITE
P_BSQPMSrvcDocFllwUpDoc view_entity from COMPOSITE
P_BSQPMSrvcDocFllwUpDoc view_entity inner COMPOSITE
P_BSQPMSrvcDocFUPBizOrdDoc view_entity from COMPOSITE
P_BSQPMSrvcOrdToPurOrd view_entity from COMPOSITE Service order to Purchase order flow
P_BusSolnOrdEntProjectFlwLvl1 view inner CONSUMPTION Solution Order Enterprise Project Flow: Level 1
P_BusSolnOrdFlwLvl0 view from CONSUMPTION Solution Order Flow Level 0
P_BusSolnOrdItemData view_entity from COMPOSITE P view for OVP Card
P_BusSolnOrdItemRelationships view from COMPOSITE Solution Order Item Relationships
P_BusSolnOrdItmFinData view from COMPOSITE
P_BusSolnOrdItmWithHdrStat view from COMPOSITE
P_BusSolnOrdSlsOrdFlwLvl0 view from CONSUMPTION Solution Order Sales Order Flow Level 0
P_BusSolnOrdSlsOrdFlwLvl1 view inner CONSUMPTION Solution Order Sales Order Flow Level 1
P_BusSolnOrdSrvcContrFlwLvl1 view from CONSUMPTION Solution Order Service Contract Flow: Level 1
P_BusSolnOrdSrvcContrFlwLvl1 view inner CONSUMPTION Solution Order Service Contract Flow: Level 1
P_BusSolnOrdSrvcOrdFlwLvl0 view inner CONSUMPTION Solution OrderService Order Flow: Level 0
P_BusSolnOrdSrvcOrdFlwLvl1 view from CONSUMPTION Solution Order Service Order Flow: Level 1
P_BusSolnOrdSrvcOrdFlwLvl1 view inner CONSUMPTION Solution Order Service Order Flow: Level 1
P_BusSolnOrdSrvcOrdFlwLvl2 view inner CONSUMPTION Solution Order Service Order Flow: Level 2
P_BusSolnOrdSrvcOrdFlwLvl21 view inner CONSUMPTION Solution OrderService Order Flow: Level 21
P_BUSSOLNORDSUBSCRPNFLWVL1 view inner CONSUMPTION Solution Order Subscription Flow: Level1
P_BusSolnQtanItemAccptcStatus view_entity from COMPOSITE
P_ConfItemDates view from COMPOSITE
P_ExprgSrvcContrItmValdtyDays view from COMPOSITE
P_ServiceConfItmRefSrvcOrd view_entity inner COMPOSITE Reference Service Order of Service Confirmation Item
P_ServiceContractIssueKey view left_outer COMPOSITE
P_ServiceContractIssueKey view union_all COMPOSITE
P_ServiceContractItemDateConv view from COMPOSITE
P_ServiceDocItemAvgDuration view from COMPOSITE
P_ServiceDocItemNote view inner COMPOSITE Service Transaction Notes
P_ServiceOrderIssueKey view from COMPOSITE
P_ServiceOrderIssueKey view inner COMPOSITE
P_ServiceOrderIssueKey view union_all COMPOSITE
P_ServiceOrderItemDateConv view from COMPOSITE
P_SRVCConfForOrder view from COMPOSITE
P_SrvcConfOpenPrdcssr view from COMPOSITE
P_SrvcContrItmBillgBlkSitn view from COMPOSITE
P_SrvcContrItmRelDueSituation view from COMPOSITE
P_SrvcContrItmSettlmtDetails view from COMPOSITE
P_SrvcContrItmWithCloudCheck view from COMPOSITE
P_SrvcDocItemPartner view_entity from COMPOSITE Service Transaction Item Partner
P_SrvcDocItemPartner view_entity union_all COMPOSITE Service Transaction Item Partner
P_SrvcOpenOrderWorkList view_entity from COMPOSITE
P_SrvcOrdItmFUPSrvcContrDets view from COMPOSITE
P_SrvcOrdItmMinFirstRspByDate view from COMPOSITE
P_SrvcOrdItmMinPlndEndDate view from COMPOSITE
P_SrvcOrdItmMinPlndStartDate view from COMPOSITE
P_SrvcOrdItmMinSLADueByDate view from COMPOSITE
P_SrvcOrdItmWthSrvcContrDets view from COMPOSITE
P_SrvcTransactionIssueItemC001 view inner COMPOSITE
P_SrvcTransactionIssueItemC002 view inner COMPOSITE
P_SrvcTransactionIssueItemC003 view inner COMPOSITE
P_SrvcTransactionIssueItemC004 view inner COMPOSITE
P_SrvcTransactionIssueItemE001 view from COMPOSITE
P_SRVCTRANSACTIONISSUETIMESTMP view from COMPOSITE
P_UpcgSrvcContrItemDateConv view from COMPOSITE Date Conversion for contract dashboard
R_BusinessSolutionOrderItemTP view_entity from TRANSACTIONAL Business Solution Order Item -TP
R_BusSolnOrdItmFUPSubscrpnTP view_entity inner TRANSACTIONAL Business Solution Order Item Follow-up Subscription - TP
R_BusSolnQtanItemTP view_entity from TRANSACTIONAL Business Solution Quotation Item - TP
R_ServiceConfirmationItemTP view_entity from TRANSACTIONAL Service Confirmation Item - TP
R_ServiceContractItemTP view_entity from TRANSACTIONAL Service Contract Item - TP
R_ServiceDocumentItemTP view from TRANSACTIONAL Transaction Process: Service Item
R_ServiceOrderItemTP view_entity from TRANSACTIONAL Service Order Item - TP
R_ServiceOrderTemplateItemTP view_entity from TRANSACTIONAL Service Order Template Item - TP
R_ServiceQuotationItemTP view_entity from TRANSACTIONAL Service Quotation Item - TP
R_SrvcConfItmFUPCtrlgDocTP view_entity from TRANSACTIONAL Item Follow up Controlling Document - TP
R_SrvcConfItmFUPTimeSheetTP view_entity from TRANSACTIONAL Item Follow-Up Time Sheet - TP
R_SrvcContrItemPriceElementTP view_entity inner TRANSACTIONAL Service Contract Item Price Element - TP
R_SrvcContrTmplItemTP view_entity from TRANSACTIONAL Service Contract Template Item - TP
R_SrvcOrdItemFUPServiceOrderTP view_entity from TRANSACTIONAL Item Follow-Up Service Order - TP
R_SrvcOrdItmInhRepairItemTP view_entity from TRANSACTIONAL In-House Srv Object of Srv Ord Item - TP
R_SrvcQtanItemPartnerAddressTP view_entity from TRANSACTIONAL Partner Addr of Srvc Qtan Item - TP
R_SrvcQtanItmFUPSrvcOrdTP view_entity from TRANSACTIONAL Item Follow-Up Service Order - TP
R_SrvcQtanItmInhRepairItemTP view_entity from TRANSACTIONAL In-House Srvc Obj of Srvc Qtan Itm - TP

Fields (247)

KeyField CDS FieldsUsed in Views
KEY ServiceDocument BusinessSolutionOrder,BusinessSolutionQuotation,PrecedingDocument,ServiceConfirmation,ServiceContract,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionContract,SubsequentDocument 50
KEY ServiceDocumentItem BusinessSolutionOrderItem,BusSolutionQuotationItem,CustomerProjectItem,PrecedingDocumentItem,ServiceConfirmationItem,ServiceContractItem,ServiceDocumentItem,ServiceOrderItem,ServiceQuotationItem,SubscriptionContractItem,SubsequentDocumentItem 47
KEY ServiceDocumentItemUUID BusinessSolutionOrderItemUUID,BusSolnQuotationItemUUID,ServiceConfirmationItemUUID,ServiceContractItemUUID,ServiceDocumentItemUUID,ServiceOrderItemUUID,SubscriptionContractItemUUID 17
KEY ServiceDocumentType BusSolnOrdType,BusSolutionQuotationType,ServiceContractType,ServiceDocumentType 31
KEY ServiceObjectType CustMgmtObjectType,ServiceObjectType 41
_BillableControl _BillableControl 1
_BillToParty _BillToParty 1
_ContactPerson _ContactPerson 1
_DistributionChannel _DistributionChannel 5
_Division _Division 5
_PayerParty _PayerParty 1
_PaymentTerms _PaymentTerms 3
_Product _Product 1
_RespEmployee _RespEmployee 9
_RespSrvcOrganizationOrgUnit _RespSrvcOrganizationOrgUnit 1
_RespSrvcOrganizationOrgUnit_2 _RespSrvcOrganizationOrgUnit_2 1
_SalesGroup _SalesGroup 5
_SalesGroupOrgUnit _SalesGroupOrgUnit 5
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2 4
_SalesOffice _SalesOffice 5
_SalesOfficeOrgUnit _SalesOfficeOrgUnit 5
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2 5
_SalesOrganization _SalesOrganization 5
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 5
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 5
_SalesUnit _SalesUnit 1
_ServiceDocItemBillingStatus _ServiceDocItemBillingStatus 1
_ServiceDocItemCategory _ServiceDocItemCategory 4
_ServiceDocItemHasError _ServiceDocItemHasError 1
_ServiceDocItemPriority _ServiceDocItemPriority 1
_ServiceDocItemRefObj _ServiceDocItemRefObj 1
_ServiceDocItemRejectionReason _ServiceDocItemRejectionReason 1
_ServiceDocItemStatus _ServiceDocItemStatus 5
_ServiceDocOvertimeCat _ServiceDocOvertimeCat 1
_ServiceDocument _ServiceDocument 7
_ServiceDocumentIsOpen _ServiceDocumentIsOpen 1
_ServiceDocumentType _ServiceDocumentType 7
_ServiceEmployee _ServiceEmployee 2
_ServiceObjType _ServiceObjType 6
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit 6
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2 5
_ServiceTeam _ServiceTeam 1
_ShipToParty _ShipToParty 1
_SoldToParty _SoldToParty 3
_SoldToPartyCountry _SoldToPartyCountry 1
_SoldToPartyRegion _SoldToPartyRegion 1
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus 5
_TransactionCurrency _TransactionCurrency 4
AccountingExchangeRate AccountingExchangeRate 4
ActualServiceDuration ActualServiceDuration 1
ActualServiceDurationUnit ActualServiceDurationUnit 1
ActualServiceEndDateTime ActualServiceEndDateTime 1
ActualServiceStartDateTime ActualServiceStartDateTime 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1 4
AdditionalCustomerGroup2 AdditionalCustomerGroup2 4
AdditionalCustomerGroup3 AdditionalCustomerGroup3 4
AdditionalCustomerGroup4 AdditionalCustomerGroup4 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 4
BillableControl BillableControl 8
BillingBlockReason BillingBlockReason 6
BillingPriceSourceName BillingPriceSourceName 2
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 1
BillToParty BillToParty 5
BusSolnQtnItmPhasedPrdcssrItem BusSolnQtnItmPhasedPrdcssrItem 1
BusSolutionQtnItemIsPhased BusSolutionQtnItemIsPhased 2
CABillgCycle CABillgCycle 1
CAPartnerSettlementRule CAPartnerSettlementRule 1
ChangeProcessGroup ChangeProcessGroup 1
ContactPerson ContactPerson,ContactPersonBusinessPartnerId 7
ContractAccount ContractAccount 1
ControllingArea ControllingArea 4
CrsCatalogMappingVersionNumber CrsCatalogMappingVersionNumber 1
CumulativeConfirmedQuantity CumulativeConfirmedQuantity 1
CustMgmtMasterAgreement CustMgmtMasterAgreement 1
CustMgmtMstrAgrmtItem CustMgmtMstrAgrmtItem 1
CustMgmtMstrAgrmtParentItem CustMgmtMstrAgrmtParentItem 1
CustomerGroup CustomerGroup 4
DeliveryBlockReason DeliveryBlockReason 1
DeliveryPriority DeliveryPriority 2
DistributionChannel DistributionChannel 30
Division Division 30
DocumentDescription DocumentDescription 2
EnterpriseProjectServiceOrg EnterpriseProjectServiceOrg 1
ExchangeRateDate ExchangeRateDate 5
ExchangeRateType ExchangeRateType 5
IncotermsPart1 IncotermsPart1 2
IncotermsPart2 IncotermsPart2 2
Industry Industry 1
InvoiceAmountInInvoiceDocCrcy InvoiceAmountInInvoiceDocCrcy 3
InvoiceQuantity InvoiceQuantity 3
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent 1
Language Language 2
LtstConfirmedDeliveryDateTime LtstConfirmedDeliveryDateTime 4
MasterWarranty MasterWarranty 1
MaterialByCustomer MaterialByCustomer 1
MaterialSubstitutionReason MaterialSubstitutionReason 1
MidBillgCycExprtnIsAllowed MidBillgCycExprtnIsAllowed 1
OrderCombinationIsAllowed OrderCombinationIsAllowed 2
OrderToBaseQuantityExponent OrderToBaseQuantityExponent 4
OriginallyRequestedProduct OriginallyRequestedProduct 9
ParentServiceDocumentItemUUID ParentServiceDocumentItemUUID 7
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 2
PayerParty PayerParty 5
PaymentMethod PaymentMethod 1
PaymentTerms PaymentTerms 7
PlannedServiceEndDate PlannedServiceEndDate 1
PlannedServiceEndDateTime PlannedServiceEndDateTime 7
PlannedServiceStartDate PlannedServiceStartDate 1
PlannedServiceStartDateTime PlannedServiceStartDateTime 6
Plant Plant 1
PostingDate PostingDate 7
PriceReferenceCPQQuotation PriceReferenceCPQQuotation 1
PriceReferenceCPQQuotationItem PriceReferenceCPQQuotationItem 1
Product Product,ProductID 12
ProductGroup ProductGroup,SrvcMaterialPricingGroup 2
ProductGroup1 ProductGroup1 4
ProductGroup2 ProductGroup2 4
ProductGroup3 ProductGroup3 4
ProductGroup4 ProductGroup4 4
ProductGroup5 ProductGroup5 4
ProductHierarchy ProductHierarchy 3
ProfitCenter ProfitCenter 4
ProfitCenterDeterminationDate ProfitCenterDeterminationDate 4
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
PurchaseOrderByShipToParty PurchaseOrderByShipToParty 1
QuotationIsAccepted BusSolnQtanItemIsAccepted,QuotationIsAccepted 3
RefBusinessSolutionOrder RefBusinessSolutionOrder 6
RefBusinessSolutionOrderItem RefBusinessSolutionOrderItem 5
RequestedDeliveryUTCDateTime RequestedDeliveryUTCDateTime 1
RequestedServiceEndDateTime RequestedServiceEndDateTime 6
RequestedServiceStartDate RequestedServiceStartDate 2
RequestedServiceStartDateTime RequestedServiceStartDateTime 7
ResponseProfile ResponseProfile 3
ResponsibleCostCenter ResponsibleCostCenter 1
ResponsibleEmployee RespEmployeeBusinessPartnerId,ResponsibleEmployee 26
ResponsibleSalesOrganization ResponsibleSalesOrganization 7
ResponsibleServiceOrganization ResponsibleServiceOrganization 5
RevenueAccountingReference RevenueAccountingReference 1
RevenueAccountingRefType RevenueAccountingRefType 1
SalesGroup SalesGroup 30
SalesGroupOrgUnitID SalesGroupOrgUnitID 29
SalesOffice SalesOffice 30
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 29
SalesOrganization SalesOrganization 31
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 29
SbscrContrItmBizValdEndDteTme SbscrContrItmBizValdEndDteTme 1
SbscrContrItmBizValdStrtDteTme SbscrContrItmBizValdStrtDteTme 1
SEPAMandate SEPAMandate 1
ServiceContractItemEndDate ServiceContractItemEndDate,SubscrpnContrItemEndDate 5
ServiceContractItemStartDate ServiceContractItemStartDate 4
ServiceContrItemEndDateTime ServiceContrItemEndDateTime,SubscrpnContrItmEndDateTime 2
ServiceContrItemStartDateTime ServiceContrItemStartDateTime,SubscrpnContrItmStartDateTime 2
ServiceDocItemBillingStatus ServiceContrItemBillingStatus,ServiceDocItemBillingStatus 8
ServiceDocItemCategory BusSolnOrdItmCategory,BusSolnQtanItemCategory,ServiceContractItemCategory,ServiceDocItemCategory 18
ServiceDocItemChangedByUser ServiceDocItemChangedByUser 1
ServiceDocItemChangedDateTime ServiceDocItemChangedDateTime 1
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser 1
ServiceDocItemCreationDate CreationDate 1
ServiceDocItemCreationDateTime ServiceDocItemCreationDateTime 1
ServiceDocItemGrossAmount ServiceContractItemGrossAmount,ServiceDocItemGrossAmount,SrvcOrdGrossAmount 11
ServiceDocItemQuantityUnit QuantityUnit,ServiceContrItemQuantityUnit,ServiceDocItemQuantityUnit 13
ServiceDocItemRejectionReason BusSolnQtanItmRjcnReason,ServiceContractItmCanclnReason,ServiceDocItemRejectionReason 7
ServiceDocumentDescription ServiceDocumentDescription,ServiceOrderDescription 3
ServiceDocumentItemCanclnParty SbscrContrItemCanclnParty,ServiceDocumentItemCanclnParty 2
ServiceDocumentItemCharUUID BusSolnOrderItemCharUUID,ServiceDocumentItemCharUUID,ServiceOrderItemCharUUID,SubscrpnContrItmCharUUID 13
ServiceDocumentItemDescription BusSolnQtanItemDescription,ProductName,ServiceDocumentItemDescription 7
ServiceDocumentItemHasError HasError,ServiceContractItemHasError,ServiceDocumentItemHasError 12
ServiceDocumentItemIsOpen ServiceDocumentItemIsOpen 5
ServiceDocumentItemIsQuotation ServiceDocumentItemIsQuotation 3
ServiceDocumentItemIsRejected BusSolnQtanItemIsRejected,ServiceContractItemIsCanceled,ServiceDocumentItemIsRejected 9
ServiceDocumentItemIsReleased BusSolnQtanItemIsReleased,ServiceContractItemIsReleased,ServiceDocumentItemIsReleased 6
ServiceDocumentItemNetAmount NetAmount,ServiceContractItemNetAmount,ServiceDocumentItemNetAmount 12
ServiceDocumentItemObjectType ServiceDocumentItemObjectType 9
ServiceDocumentItemPriority ServiceDocumentItemPriority 4
ServiceDocumentItemQuantity Quantity,ServiceContractItemQuantity,ServiceDocumentItemQuantity 12
ServiceDocumentItemStatus ServiceContractItemStatus,ServiceDocumentItemStatus 17
ServiceDocumentItemTaxAmount ServiceDocumentItemTaxAmount 1
ServiceDocumentItmCanclnReason SbscrContrItemCanclnReason,ServiceDocumentItmCanclnReason 2
ServiceDocumentTemplateType ServiceDocumentTemplateType 2
ServiceDocumentUUID ServiceDocumentUUID 4
ServiceDuration ServiceDuration 3
ServiceDurationUnit ServiceDurationUnit 3
ServiceEmployee ServiceEmployee 7
ServiceFirstResponseByDateTime ServiceFirstResponseByDateTime 1
ServiceOrganization ServiceOrganization 28
ServiceProfile ServiceProfile 3
ServiceTeam ServiceTeam 7
ServiceTransactionChargeType ServiceTransactionChargeType 2
SharingContractID SharingContractID 1
ShipToParty ShipToParty 5
SoldToParty SoldToParty 16
SoldToPartyCountry SoldToPartyCountry 7
SoldToPartyRegion SoldToPartyRegion 7
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration 1
SrvcContrItemExtnDurationUnit SrvcContrItemExtnDurationUnit 1
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration 1
SrvcContrItemRnwlDurationUnit SrvcContrItemRnwlDurationUnit 1
SrvcDocItemBaseQuantityUnit SrvcDocItemBaseQuantityUnit 4
SrvcDocItemCreditStatus BusSolnQtanItemCreditStatus,SrvcDocItemCreditStatus 3
SrvcDocItemExecutionStatus SrvcDocItemExecutionStatus 1
SrvcDocItemIsUnplanned SrvcDocItemIsUnplanned,SrvcOrdItemIsUnplanned 2
SrvcDocItemSLADueByDateTime SrvcDocItemSLADueByDateTime 2
SrvcDocItemTransferStatus SrvcDocItemTransferStatus 1
SrvcDocItmCanclnProcedure SbscrContrItmCanclnProcedure,SrvcDocItmCanclnProcedure 2
SrvcDocItmDeliveredQuantity SrvcDocItmDeliveredQuantity 3
SrvcDocItmDeliveryStatus SrvcDocItmDeliveryStatus 8
SrvcDocItmGoodsIssueStatus SrvcDocItmGoodsIssueStatus 3
SrvcDocItmGrcePerdEndDateTime SbscrContrItmGrcePerdDteTme 1
SrvcDocItmGTSEmbargoStatus SrvcDocItmGTSEmbargoStatus 1
SrvcDocItmGTSLglControlStatus SrvcDocItmGTSLglControlStatus 1
SrvcDocItmGTSScreeningStatus SrvcDocItmGTSScreeningStatus 1
SrvcDocItmIsReleasedForBilling SrvcDocItmIsReleasedForBilling 6
SrvcDocItmOrdToBaseQtyDnmntr SrvcDocItmOrdToBaseQtyDnmntr 4
SrvcDocItmOrdToBaseQtyNmrtr SrvcDocItmOrdToBaseQtyNmrtr 4
SrvcDocItmPostingDateTime SrvcDocItmPostingDateTime 1
SrvcDocItmRecrrgChrgDuration SrvcDocItmRecrrgChrgDuration 1
SrvcDocItmRecrrgChrgDurnUnit SrvcDocItmRecrrgChrgDurnUnit 1
SrvcDocItmRecrrgChrgGrossAmt SrvcDocItmRecrrgChrgGrossAmt 1
SrvcDocItmRecrrgChrgNetAmount SrvcDocItmRecrrgChrgNetAmount 1
SrvcDocItmRecrrgChrgTaxAmount SrvcDocItmRecrrgChrgTaxAmount 1
SrvcDocItmReldAmtInTransCrcy SrvcDocItmReldAmtInTransCrcy 2
SrvcDocItmReleasedQuantity SrvcDocItmReleasedQuantity 2
SrvcDocItmRequestedQuantity SrvcDocItmRequestedQuantity 3
SrvcDocItmTmeSliceEndDteTme SbscrContrTimeSliceEndDteTme 2
SrvcDocItmTmeSliceStrtDteTme SbscrContrTimeSliceStrtDteTme 2
SrvcDocItmValdtyEndDateTime SrvcDocItmValdtyEndDateTime 2
SrvcDocItmValdtyStartDateTime SrvcDocItmValdtyStartDateTime 2
SrvcMaterialPricingGroup SrvcMaterialPricingGroup 2
SrvcOrderConfirmationRelevance SrvcOrderConfirmationRelevance 1
SrvcSEPAMandateRelevance SrvcSEPAMandateRelevance 1
SrvcTransactionValuationType SrvcTransactionValuationType 2
StatisticsCurrency ReferenceCurrency,StatisticsCurrency 5
SubscriptionBillingCycle SubscriptionBillingCycle 1
SubscriptionContract CAProviderContract,SubscriptionContractExternalID 3
SubscriptionContractItem SubscriptionContractItem 1
SubscriptionContractReference SubscriptionContractReference 1
SubscrpnContrActivationStatus SubscrpnContrActivationStatus 1
SubscrpnContractSharingGroupID SubscrpnContractSharingGroupID 1
SubscrpnContrAutoRnwlIsActv SubscrpnContrAutoRnwlIsActv 2
SubscrpnContrItmBillgPlnCyc SubscrpnContrItmBillgPlnCyc 1
SubscrpnContrTimeSliceStatus SubscrpnContrTimeSliceStatus 2
SubscrpnContrTrmsAreSpecified SubscrpnContrTrmsAreSpecified 1
SubscrpnOrdProdSelType SubscrpnOrdProdSelType 1
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 2
TransactionCurrency TransactionCurrency 17
WBSElement WBSElementExternalID 1
WBSElementInternalID WBSElementInternalID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Service Transaction Item Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEDOCUMENTITEMENHCD (
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTITEMUUID,
    SERVICEDOCUMENTTYPE,
    SERVICEOBJECTTYPE,
    _BILLABLECONTROL,
    _BILLTOPARTY,
    _CONTACTPERSON,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _PAYERPARTY,
    _PAYMENTTERMS,
    _PRODUCT,
    _RESPEMPLOYEE,
    _RESPSRVCORGANIZATIONORGUNIT,
    _RESPSRVCORGANIZATIONORGUNIT_2,
    _SALESGROUP,
    _SALESGROUPORGUNIT,
    _SALESGROUPORGUNIT_2,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT,
    _SALESOFFICEORGUNIT_2,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT,
    _SALESORGANIZATIONORGUNIT_2,
    _SALESUNIT,
    _SERVICEDOCITEMBILLINGSTATUS,
    _SERVICEDOCITEMCATEGORY,
    _SERVICEDOCITEMHASERROR,
    _SERVICEDOCITEMPRIORITY,
    _SERVICEDOCITEMREFOBJ,
    _SERVICEDOCITEMREJECTIONREASON,
    _SERVICEDOCITEMSTATUS,
    _SERVICEDOCOVERTIMECAT,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTISOPEN,
    _SERVICEDOCUMENTTYPE,
    _SERVICEEMPLOYEE,
    _SERVICEOBJTYPE,
    _SERVICEORGANIZATIONORGUNIT,
    _SERVICEORGANIZATIONORGUNIT_2,
    _SERVICETEAM,
    _SHIPTOPARTY,
    _SOLDTOPARTY,
    _SOLDTOPARTYCOUNTRY,
    _SOLDTOPARTYREGION,
    _SRVCDOCITMLIFECYCLESTATUS,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGEXCHANGERATE,
    ACTUALSERVICEDURATION,
    ACTUALSERVICEDURATIONUNIT,
    ACTUALSERVICEENDDATETIME,
    ACTUALSERVICESTARTDATETIME,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    BILLABLECONTROL,
    BILLINGBLOCKREASON,
    BILLINGPRICESOURCENAME,
    BILLOFMATERIALITEMNODENUMBER,
    BILLTOPARTY,
    BUSSOLNQTNITMPHASEDPRDCSSRITEM,
    BUSSOLUTIONQTNITEMISPHASED,
    CABILLGCYCLE,
    CAPARTNERSETTLEMENTRULE,
    CHANGEPROCESSGROUP,
    CONTACTPERSON,
    CONTRACTACCOUNT,
    CONTROLLINGAREA,
    CRSCATALOGMAPPINGVERSIONNUMBER,
    CUMULATIVECONFIRMEDQUANTITY,
    CUSTMGMTMASTERAGREEMENT,
    CUSTMGMTMSTRAGRMTITEM,
    CUSTMGMTMSTRAGRMTPARENTITEM,
    CUSTOMERGROUP,
    DELIVERYBLOCKREASON,
    DELIVERYPRIORITY,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDESCRIPTION,
    ENTERPRISEPROJECTSERVICEORG,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    INCOTERMSPART1,
    INCOTERMSPART2,
    INDUSTRY,
    INVOICEAMOUNTININVOICEDOCCRCY,
    INVOICEQUANTITY,
    ITEMORDERPROBABILITYINPERCENT,
    LANGUAGE,
    LTSTCONFIRMEDDELIVERYDATETIME,
    MASTERWARRANTY,
    MATERIALBYCUSTOMER,
    MATERIALSUBSTITUTIONREASON,
    MIDBILLGCYCEXPRTNISALLOWED,
    ORDERCOMBINATIONISALLOWED,
    ORDERTOBASEQUANTITYEXPONENT,
    ORIGINALLYREQUESTEDPRODUCT,
    PARENTSERVICEDOCUMENTITEMUUID,
    PARTIALDELIVERYISALLOWED,
    PAYERPARTY,
    PAYMENTMETHOD,
    PAYMENTTERMS,
    PLANNEDSERVICEENDDATE,
    PLANNEDSERVICEENDDATETIME,
    PLANNEDSERVICESTARTDATE,
    PLANNEDSERVICESTARTDATETIME,
    PLANT,
    POSTINGDATE,
    PRICEREFERENCECPQQUOTATION,
    PRICEREFERENCECPQQUOTATIONITEM,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTGROUP1,
    PRODUCTGROUP2,
    PRODUCTGROUP3,
    PRODUCTGROUP4,
    PRODUCTGROUP5,
    PRODUCTHIERARCHY,
    PROFITCENTER,
    PROFITCENTERDETERMINATIONDATE,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    QUOTATIONISACCEPTED,
    REFBUSINESSSOLUTIONORDER,
    REFBUSINESSSOLUTIONORDERITEM,
    REQUESTEDDELIVERYUTCDATETIME,
    REQUESTEDSERVICEENDDATETIME,
    REQUESTEDSERVICESTARTDATE,
    REQUESTEDSERVICESTARTDATETIME,
    RESPONSEPROFILE,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLEEMPLOYEE,
    RESPONSIBLESALESORGANIZATION,
    RESPONSIBLESERVICEORGANIZATION,
    REVENUEACCOUNTINGREFERENCE,
    REVENUEACCOUNTINGREFTYPE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SBSCRCONTRITMBIZVALDENDDTETME,
    SBSCRCONTRITMBIZVALDSTRTDTETME,
    SEPAMANDATE,
    SERVICECONTRACTITEMENDDATE,
    SERVICECONTRACTITEMSTARTDATE,
    SERVICECONTRITEMENDDATETIME,
    SERVICECONTRITEMSTARTDATETIME,
    SERVICEDOCITEMBILLINGSTATUS,
    SERVICEDOCITEMCATEGORY,
    SERVICEDOCITEMCHANGEDBYUSER,
    SERVICEDOCITEMCHANGEDDATETIME,
    SERVICEDOCITEMCREATEDBYUSER,
    SERVICEDOCITEMCREATIONDATE,
    SERVICEDOCITEMCREATIONDATETIME,
    SERVICEDOCITEMGROSSAMOUNT,
    SERVICEDOCITEMQUANTITYUNIT,
    SERVICEDOCITEMREJECTIONREASON,
    SERVICEDOCUMENTDESCRIPTION,
    SERVICEDOCUMENTITEMCANCLNPARTY,
    SERVICEDOCUMENTITEMCHARUUID,
    SERVICEDOCUMENTITEMDESCRIPTION,
    SERVICEDOCUMENTITEMHASERROR,
    SERVICEDOCUMENTITEMISOPEN,
    SERVICEDOCUMENTITEMISQUOTATION,
    SERVICEDOCUMENTITEMISREJECTED,
    SERVICEDOCUMENTITEMISRELEASED,
    SERVICEDOCUMENTITEMNETAMOUNT,
    SERVICEDOCUMENTITEMOBJECTTYPE,
    SERVICEDOCUMENTITEMPRIORITY,
    SERVICEDOCUMENTITEMQUANTITY,
    SERVICEDOCUMENTITEMSTATUS,
    SERVICEDOCUMENTITEMTAXAMOUNT,
    SERVICEDOCUMENTITMCANCLNREASON,
    SERVICEDOCUMENTTEMPLATETYPE,
    SERVICEDOCUMENTUUID,
    SERVICEDURATION,
    SERVICEDURATIONUNIT,
    SERVICEEMPLOYEE,
    SERVICEFIRSTRESPONSEBYDATETIME,
    SERVICEORGANIZATION,
    SERVICEPROFILE,
    SERVICETEAM,
    SERVICETRANSACTIONCHARGETYPE,
    SHARINGCONTRACTID,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SOLDTOPARTYCOUNTRY,
    SOLDTOPARTYREGION,
    SRVCCONTRITEMEXTENSIONDURATION,
    SRVCCONTRITEMEXTNDURATIONUNIT,
    SRVCCONTRITEMRNWLDURATION,
    SRVCCONTRITEMRNWLDURATIONUNIT,
    SRVCDOCITEMBASEQUANTITYUNIT,
    SRVCDOCITEMCREDITSTATUS,
    SRVCDOCITEMEXECUTIONSTATUS,
    SRVCDOCITEMISUNPLANNED,
    SRVCDOCITEMSLADUEBYDATETIME,
    SRVCDOCITEMTRANSFERSTATUS,
    SRVCDOCITMCANCLNPROCEDURE,
    SRVCDOCITMDELIVEREDQUANTITY,
    SRVCDOCITMDELIVERYSTATUS,
    SRVCDOCITMGOODSISSUESTATUS,
    SRVCDOCITMGRCEPERDENDDATETIME,
    SRVCDOCITMGTSEMBARGOSTATUS,
    SRVCDOCITMGTSLGLCONTROLSTATUS,
    SRVCDOCITMGTSSCREENINGSTATUS,
    SRVCDOCITMISRELEASEDFORBILLING,
    SRVCDOCITMORDTOBASEQTYDNMNTR,
    SRVCDOCITMORDTOBASEQTYNMRTR,
    SRVCDOCITMPOSTINGDATETIME,
    SRVCDOCITMRECRRGCHRGDURATION,
    SRVCDOCITMRECRRGCHRGDURNUNIT,
    SRVCDOCITMRECRRGCHRGGROSSAMT,
    SRVCDOCITMRECRRGCHRGNETAMOUNT,
    SRVCDOCITMRECRRGCHRGTAXAMOUNT,
    SRVCDOCITMRELDAMTINTRANSCRCY,
    SRVCDOCITMRELEASEDQUANTITY,
    SRVCDOCITMREQUESTEDQUANTITY,
    SRVCDOCITMTMESLICEENDDTETME,
    SRVCDOCITMTMESLICESTRTDTETME,
    SRVCDOCITMVALDTYENDDATETIME,
    SRVCDOCITMVALDTYSTARTDATETIME,
    SRVCMATERIALPRICINGGROUP,
    SRVCORDERCONFIRMATIONRELEVANCE,
    SRVCSEPAMANDATERELEVANCE,
    SRVCTRANSACTIONVALUATIONTYPE,
    STATISTICSCURRENCY,
    SUBSCRIPTIONBILLINGCYCLE,
    SUBSCRIPTIONCONTRACT,
    SUBSCRIPTIONCONTRACTITEM,
    SUBSCRIPTIONCONTRACTREFERENCE,
    SUBSCRPNCONTRACTIVATIONSTATUS,
    SUBSCRPNCONTRACTSHARINGGROUPID,
    SUBSCRPNCONTRAUTORNWLISACTV,
    SUBSCRPNCONTRITMBILLGPLNCYC,
    SUBSCRPNCONTRTIMESLICESTATUS,
    SUBSCRPNCONTRTRMSARESPECIFIED,
    SUBSCRPNORDPRODSELTYPE,
    TIMESHEETOVERTIMECATEGORY,
    TRANSACTIONCURRENCY,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEDOCUMENTITEMUUID, SERVICEDOCUMENTTYPE, SERVICEOBJECTTYPE)
);

Learn More