I_SERVICEDOCUMENTITEM
Service Transaction Item
I_SERVICEDOCUMENTITEM is a CDS View in S/4HANA. Service Transaction Item. It contains 39 fields. 45 CDS views read from this table.
CDS Views using this table (45)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_BusSolnOrdItmUserStatus | view | inner | COMPOSITE | Item User Status |
| A_ServiceConfItemUserStatus | view | inner | COMPOSITE | Service Confirmation Item User Status |
| A_ServiceOrdItemUserStatus | view | inner | COMPOSITE | Service Order Item User Status |
| A_SrvcOrdTmplItemPartner | view | inner | COMPOSITE | Service Order Template Item Partner |
| A_SrvcOrdTmplItemUserStatus | view | inner | COMPOSITE | Service Order Template Item User Status |
| A_SrvcOrdTmplItmPartnerAddress | view_entity | inner | COMPOSITE | Partner Address of Service Order Template Item |
| C_BuSoPrtfloSubscrpnContrItmVH | view | from | CONSUMPTION | Value Help: Subscrip. Contract Item |
| C_BusSolnPrtfloSrvcContrItmVH | view | from | CONSUMPTION | Value Help: Service Contract Item |
| C_BusSolnPrtfloSrvcOrderItmVH | view | from | CONSUMPTION | Value Help: Service Order Item |
| C_DspDocFlwServiceContractItem | view_entity | from | CONSUMPTION | Service Contract Item Attributes |
| C_DspDocFlwSrvcContractItemVH | view_entity | from | CONSUMPTION | Service Contract Item |
| C_InhRepairOpenRepairOrderItem | view_entity | from | CONSUMPTION | Open Repair Order Items |
| I_ServiceDocumentItemEnhcd | view | from | COMPOSITE | Service Transaction Item Enhanced |
| I_SrvcDocItemByDocumentType | view | from | BASIC | Srvc Transaction Item by Transac Type |
| I_SrvcOrdBillgDelayedSituation | view | from | COMPOSITE | Service Order not invoiced situation |
| I_SrvcOrdItemProductDets | view | from | COMPOSITE | Retrieves Items of Serv. Order for Serv. Conf. creation |
| I_SrvcOrdItmExectgEmplSitn | view | from | COMPOSITE | Situation Anchor Missing Exec Employee |
| I_SrvcOrdPlndEndDateSituation | view | from | COMPOSITE | Planned End Date Is After Due Date |
| I_SubscrpnOrdItemDuration | view_entity | inner | COMPOSITE | Item Duration |
| I_SubscrpnOrdItemUserStatus | view_entity | inner | COMPOSITE | Item User Status |
| P_BSQPMSbscrContrToPrvdrContr | view_entity | from | COMPOSITE | |
| P_BSQPMSolnQtanItmProcFlw | view_entity | from | COMPOSITE | |
| P_SrvcConfProduct | view | from | CONSUMPTION | Prod Srvc Order for Srvc Confirmation |
| P_SrvcTransWthSituation | view | from | COMPOSITE | |
| R_BusSolnOrdItemLongTextTP | view_entity | inner | TRANSACTIONAL | Business Solution Order Item Long Text - TP |
| R_BusSolnOrdItmUserStatusTP | view_entity | inner | TRANSACTIONAL | Business Solution Order User Status - TP |
| R_SrvcConfItemLongTextTP | view_entity | inner | TRANSACTIONAL | Long Text for Service Conf Item |
| R_SrvcConfItemUserStatusTP | view_entity | inner | TRANSACTIONAL | Service Confirmation Item User Status - TP |
| R_SrvcContrItemAppointmentTP | view_entity | inner | TRANSACTIONAL | Service Contract Item Appointment - TP |
| R_SrvcContrItemDurationTP | view_entity | inner | TRANSACTIONAL | Service Contract Item Duration - TP |
| R_SrvcContrItemLongTextTP | view_entity | inner | TRANSACTIONAL | Service Contract Item Long Text - TP |
| R_SrvcContrItemPartnerTP | view_entity | inner | TRANSACTIONAL | Service Contract Item Partner - TP |
| R_SrvcContrItemUserStatusTP | view_entity | inner | TRANSACTIONAL | Service Contract Item User Status - TP |
| R_SrvcContrTmplItemDurationTP | view_entity | inner | TRANSACTIONAL | Duration of SrvcContr Template Item - TP |
| R_SrvcContrTmplItemLongTextTP | view_entity | inner | TRANSACTIONAL | Service Contract Template Item Text - TP |
| R_SrvcOrdItemLongTextTP | view_entity | inner | TRANSACTIONAL | Notes Item view for Service Order |
| R_SrvcOrdItemUserStatusTP | view_entity | inner | TRANSACTIONAL | Service Order Item User Status - TP |
| R_SrvcOrdTmplItemLongTextTP | view_entity | inner | TRANSACTIONAL | Long text for Template Item - TP |
| R_SrvcOrdTmplItemUserStatusTP | view_entity | inner | TRANSACTIONAL | Service Order Temp Item User Status - TP |
| R_SrvcQtanItemAppointmentTP | view_entity | inner | TRANSACTIONAL | Service Quotation Item Appointment - TP |
| R_SrvcQtanItemDurationTP | view_entity | inner | TRANSACTIONAL | Service Quotation Item Duration - TP |
| R_SrvcQtanItemLongTextTP | view_entity | inner | TRANSACTIONAL | Long Text for Service Quotation Item |
| R_SrvcQtanItemPartnerTP | view_entity | inner | TRANSACTIONAL | Service Quotation Item Partner - TP |
| R_SrvcQtanItemUserStatusTP | view_entity | inner | TRANSACTIONAL | Service Quotation Item User Status - TP |
| R_SubscrpnContrItemLongTextTP | view_entity | inner | TRANSACTIONAL | Subscription Contr. Item Long Text - TP |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ServiceDocument | BusinessSolutionOrder,PrecedingDocument,ServiceConfirmation,ServiceContract,ServiceContractTemplate,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionContract,SubscriptionOrder | 31 |
| KEY | ServiceDocumentItem | BusinessSolutionOrderItem,PrecedingDocumentItem,ServiceConfirmationItem,ServiceContractItem,ServiceContractTemplateItem,ServiceDocumentItem,ServiceOrderItem,ServiceOrderTemplateItem,ServiceQuotationItem,SubscriptionContractItem,SubscriptionOrderItem | 31 |
| KEY | ServiceDocumentItemUUID | ServiceDocumentItemUUID | 2 |
| KEY | ServiceObjectType | ServiceObjectType | 6 |
| _DistributionChannel | _DistributionChannel | 1 | |
| _Division | _Division | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesGroupOrgUnit_2 | _SalesGroupOrgUnit_2 | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SalesOfficeOrgUnit_2 | _SalesOfficeOrgUnit_2 | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _SalesOrganizationOrgUnit_2 | _SalesOrganizationOrgUnit_2 | 1 | |
| _ServiceDocItemCategory | _ServiceDocItemCategory | 1 | |
| _ServiceDocument | _ServiceDocument | 2 | |
| _ServiceDocumentType | _ServiceDocumentType | 2 | |
| _ServiceObjType | _ServiceObjType | 2 | |
| DistributionChannel | DistributionChannel | 6 | |
| Division | Division | 6 | |
| OriginallyRequestedProduct | Material | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 2 | |
| ReferenceInHouseRepair | ReferenceInHouseRepair | 1 | |
| ReferenceInHouseRepairItem | ReferenceInHouseRepairItem | 1 | |
| ResponsibleEmployee | ResponsibleEmployee | 1 | |
| SalesGroup | SalesGroup | 6 | |
| SalesGroupOrgUnitID | SalesGroupOrgUnitID | 3 | |
| SalesOffice | SalesOffice | 6 | |
| SalesOfficeOrgUnitID | SalesOfficeOrgUnitID | 3 | |
| SalesOrganization | SalesOrganization | 7 | |
| SalesOrganizationOrgUnitID | SalesOrganizationOrgUnitID | 3 | |
| ServiceDocItemCategory | ServiceDocItemCategory | 1 | |
| ServiceDocItemGrossAmount | ServiceDocItemGrossAmount | 1 | |
| ServiceDocumentDescription | ServiceDocumentDescription | 2 | |
| ServiceDocumentItemDescription | MaterialName | 1 | |
| ServiceDocumentItemStatus | ServiceDocumentItemStatus | 1 | |
| ServiceDocumentType | ServiceDocumentType | 5 | |
| ServiceEmployee | ServiceEmployee | 1 | |
| ServiceOrganization | ServiceOrganization | 2 | |
| SoldToParty | SoldToParty | 4 | |
| TransactionCurrency | TransactionCurrency | 1 |
@EndUserText.label: 'Service Transaction Item'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AbapCatalog: {
sqlViewName: 'ISERVDOCITM',
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'ServiceDocumentItem',
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XXL
},
supportedCapabilities: [
#ANALYTICAL_DIMENSION,
#CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE
],
modelingPattern: #ANALYTICAL_DIMENSION
}
@Analytics.dataCategory: #DIMENSION
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
define view I_ServiceDocumentItem
as select from crms4d_serv_i
association [0..1] to I_BusinessPartner as _SoldToParty on $projection.SoldToParty = _SoldToParty.BusinessPartner
association [0..1] to I_BusinessPartner as _RespEmployee on $projection.ResponsibleEmployee = _RespEmployee.BusinessPartner
association [0..1] to I_BusinessPartner as _ServiceTeam on $projection.ServiceTeam = _ServiceTeam.BusinessPartner
association [0..1] to I_BusinessPartner as _ServiceEmployee on $projection.ServiceEmployee = _ServiceEmployee.BusinessPartner
association [0..1] to I_BusinessPartner as _ContactPerson on $projection.ContactPerson = _ContactPerson.BusinessPartner
association [0..1] to I_BusinessPartner as _PayerParty on $projection.PayerParty = _PayerParty.BusinessPartner
association [0..1] to I_BusinessPartner as _BillToParty on $projection.BillToParty = _BillToParty.BusinessPartner
association [0..1] to I_BusinessPartner as _ShipToParty on $projection.ShipToParty = _ShipToParty.BusinessPartner
association [0..1] to I_ServiceDocumentType as _ServiceDocumentType on $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType
association [0..1] to I_ServiceDocItemCategory as _ServiceDocItemCategory on $projection.ServiceDocItemCategory = _ServiceDocItemCategory.ServiceDocItemCategory
association [0..1] to I_ServiceDocumentPriority as _ServiceDocItemPriority on $projection.ServiceDocumentItemPriority = _ServiceDocItemPriority.ServiceDocumentPriority
association [0..1] to I_ServiceDocumentStatus as _ServiceDocItemStatus on $projection.ServiceDocumentItemStatus = _ServiceDocItemStatus.ServiceDocumentStatus
association [0..1] to I_SrvcDocLifecycleStatus as _SrvcDocItmLifecycleStatus on $projection.ServiceDocumentItemStatus = _SrvcDocItmLifecycleStatus.ServiceDocumentStatus
association [0..1] to I_ServiceDocBillingStatus as _ServiceDocItemBillingStatus on $projection.ServiceDocItemBillingStatus = _ServiceDocItemBillingStatus.ServiceDocBillingStatus
association [0..1] to I_SrvcDocRelForBillgSts as _SrvcDocItemIsRelForBillgSts on $projection.SrvcDocItmIsReleasedForBilling = _SrvcDocItemIsRelForBillgSts.ServiceDocIsReleasedForBilling
association [0..1] to I_ServiceDocErrorStatus as _ServiceDocItemHasError on $projection.ServiceDocumentItemHasError = _ServiceDocItemHasError.ServiceDocumentHasError
association [0..1] to I_ServiceDocOpenStatus as _ServiceDocumentIsOpen on $projection.ServiceDocumentItemIsOpen = _ServiceDocumentIsOpen.ServiceDocumentIsOpen
association [1..1] to I_ServiceDocument as _ServiceDocument on $projection.ServiceObjectType = _ServiceDocument.ServiceObjectType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [1..1] to I_CustMgmtBusObjType as _ServiceObjType on $projection.ServiceObjectType = _ServiceObjType.BusinessObjectType
association [0..1] to I_BillingBlockReason as _BillingBlockReason on $projection.BillingBlockReason = _BillingBlockReason.BillingBlockReason
association [0..1] to I_DeliveryBlockReason as _DeliveryBlockReason on $projection.DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason
association [0..*] to I_BillingRequestItem as _BillingRequestItem on $projection.ServiceObjectType = _BillingRequestItem.ServiceObjectType
and $projection.ServiceDocument = _BillingRequestItem.ServiceDocument
and $projection.ServiceDocumentItem = _BillingRequestItem.ServiceDocumentItem
association [0..*] to I_ServiceProductList as _ServiceProductList on $projection.ServiceObjectType = _ServiceProductList.ServiceObjectType
and $projection.ServiceDocument = _ServiceProductList.ServiceDocument
and $projection.ServiceDocumentItem = _ServiceProductList.ServiceDocumentItem
association [0..1] to I_UnitOfMeasure as _BaseUnit on $projection.ServiceDocItemQuantityUnit = _BaseUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _BaseUnit_2 on $projection.SrvcDocItemBaseQuantityUnit = _BaseUnit_2.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _SalesUnit on $projection.ServiceDocItemQuantityUnit = _SalesUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _ServiceDurationUnit on $projection.ServiceDurationUnit = _ServiceDurationUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _ActualServiceDurationUnit on $projection.ActualServiceDurationUnit = _ActualServiceDurationUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _SrvcContrItemExtnDurationUnit on $projection.SrvcContrItemExtnDurationUnit = _SrvcContrItemExtnDurationUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _SrvcContrItemRnwlDurationUnit on $projection.SrvcContrItemRnwlDurationUnit = _SrvcContrItemRnwlDurationUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _VolumeUnit on $projection.ItemVolumeUnit = _VolumeUnit.UnitOfMeasure
association [0..1] to I_UnitOfMeasure as _WeightUnit on $projection.ItemWeightUnit = _WeightUnit.UnitOfMeasure
association [0..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
association [0..1] to I_PaymentTerms as _PaymentTerms on $projection.PaymentTerms = _PaymentTerms.PaymentTerms
association [0..1] to I_SrvcDocPaymentMethod as _PaymentMethod on $projection.PaymentMethod = _PaymentMethod.PaymentMethod
and (
$projection.SalesOrganization = _PaymentMethod.SalesOrganization
or $projection.SalesOrganizationOrgUnitID = _PaymentMethod.OrgUnitTypeIDConcatenated
)
association [0..1] to I_SrvcSEPAMandateRelevance as _SrvcSEPAMandateRelevance on $projection.SrvcSEPAMandateRelevance = _SrvcSEPAMandateRelevance.SrvcSEPAMandateRelevance
association [0..1] to I_ServiceDocumentFixedPrice as _FixedPrice on $projection.ServiceObjectType = _FixedPrice.ServiceObjectType
and $projection.ServiceDocument = _FixedPrice.ServiceDocument
and $projection.ServiceDocumentItem = _FixedPrice.PricingDocumentItem
association [0..*] to I_StatusObjectUUIDStatus as _StatusObjItemStatus on $projection.ServiceDocumentItemUUID = _StatusObjItemStatus.StatusObjectUUID
association [0..1] to I_SalesOrganizationUnit as _ServiceOrganizationOrgUnit on $projection.ServiceOrganization = _ServiceOrganizationOrgUnit.OrganizationalUnit
association [0..1] to I_SalesOrganizationUnit as _RespSrvcOrganizationOrgUnit on $projection.ResponsibleServiceOrganization = _RespSrvcOrganizationOrgUnit.OrganizationalUnit
association [0..1] to I_SalesOrganizationUnit as _SalesOrganizationOrgUnit on $projection.SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit.OrganizationalUnit
association [0..1] to I_SalesOrganizationUnit as _SalesOfficeOrgUnit on $projection.SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.OrganizationalUnit
association [0..1] to I_SalesOrganizationUnit as _SalesGroupOrgUnit on $projection.SalesGroupOrgUnitID = _SalesGroupOrgUnit.OrganizationalUnit
// Added to correct the CRM Organizational Unit
association [0..1] to I_SrvcMgmtOrganizationUnit as _SalesOrganizationOrgUnit_2 on $projection.SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated
association [0..1] to I_SrvcMgmtOrganizationUnit as _SalesOfficeOrgUnit_2 on $projection.SalesOfficeOrgUnitID = _SalesOfficeOrgUnit_2.OrgUnitTypeIDConcatenated
association [0..1] to I_SrvcMgmtOrganizationUnit as _SalesGroupOrgUnit_2 on $projection.SalesGroupOrgUnitID = _SalesGroupOrgUnit_2.OrgUnitTypeIDConcatenated
association [0..1] to I_SrvcMgmtOrganizationUnit as _ServiceOrganizationOrgUnit_2 on $projection.ServiceOrganization = _ServiceOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated
association [0..1] to I_SrvcMgmtOrganizationUnit as _RespSrvcOrganizationOrgUnit_2 on $projection.ResponsibleServiceOrganization = _RespSrvcOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated
//
association [0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
association [0..1] to I_SalesOffice as _SalesOffice on $projection.SalesOffice = _SalesOffice.SalesOffice
association [0..1] to I_SalesGroup as _SalesGroup on $projection.SalesGroup = _SalesGroup.SalesGroup
association [0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
association [0..1] to I_Division as _Division on $projection.Division = _Division.Division
association [0..1] to I_TimeSheetOvertimeCat as _ServiceDocOvertimeCat on $projection.TimeSheetOvertimeCategory = _ServiceDocOvertimeCat.TimeSheetOvertimeCategory
association [0..1] to I_CustomerSupplierIndustry as _Industry on $projection.Industry = _Industry.Industry
association [0..1] to I_SalesDocumentRjcnReason as _ServiceDocItemRejectionReason on $projection.ServiceDocItemRejectionReason = _ServiceDocItemRejectionReason.SalesDocumentRjcnReason
association [0..1] to I_Region as _SoldToPartyRegion on $projection.SoldToPartyRegion = _SoldToPartyRegion.Region
and $projection.SoldToPartyCountry = _SoldToPartyRegion.Country
association [0..1] to I_Country as _SoldToPartyCountry on $projection.SoldToPartyCountry = _SoldToPartyCountry.Country
association [0..1] to I_RespyMgmtTeamHeaderDetail as _ServiceTeamHeader on $projection.RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID
association [0..1] to I_EnterpriseServiceOrg as _EnterpriseServiceOrg on $projection.EnterpriseServiceOrganization = _EnterpriseServiceOrg.EnterpriseServiceOrganization
association [0..1] to E_ServiceDocumentItem as _ServiceDocItemExt on $projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory
and $projection.ServiceDocument = _ServiceDocItemExt.ServiceOrderItem
and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID
association [0..1] to I_CustMgmtDateRule as _BillPlanDateRule on $projection.BillingPlanBillingDateRuleUUID = _BillPlanDateRule.CustMgmtDateRuleUUID
association [0..1] to I_CustMgmtDateRule as _SettlementDateRule on $projection.SettlementPeriodRuleUUID = _SettlementDateRule.CustMgmtDateRuleUUID
association [0..1] to I_ResponseProfile as _ResponseProfile on $projection.ResponseProfile = _ResponseProfile.ResponseProfile
association [0..1] to I_ServiceProfile as _ServiceProfile on $projection.ServiceProfile = _ServiceProfile.ServiceProfile
association [0..*] to I_SubscrpnItmTechResource as _TechResource on $projection.ServiceObjectType = _TechResource.ServiceObjectType
and $projection.ServiceDocument = _TechResource.ServiceDocument
and $projection.ServiceDocumentItem = _TechResource.ServiceDocumentItem
association [0..1] to I_CustMgmtMasterAgrmtItem as _MasterAgrmtItem on _MasterAgrmtItem.ServiceObjectType = 'BUS2000267'
and $projection.CustMgmtMasterAgreement = _MasterAgrmtItem.CustMgmtMasterAgreement
and $projection.CustMgmtMstrAgrmtItem = _MasterAgrmtItem.CustMgmtMstrAgrmtItem
association [0..1] to I_BillableControl as _BillableControl on $projection.BillableControl = _BillableControl.BillableControl
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
association [0..1] to I_ProductGroup_2 as _ProductGroup on $projection.ProductGroup = _ProductGroup.ProductGroup
association [0..1] to I_SrvcMgmtProductHierarchy as _SrvcMgmtProductHierarchy on $projection.ProductHierarchy = _SrvcMgmtProductHierarchy.SrvcProductHierarchy
association [0..1] to I_MaterialPricingGroup as _SrvcMaterialPricingGroup on $projection.SrvcMaterialPricingGroup = _SrvcMaterialPricingGroup.MaterialPricingGroup
association [0..1] to I_MaterialPricingGroup as _MaterialPricingGroup_2 on $projection.MaterialPricingGroup_2 = _MaterialPricingGroup_2.MaterialPricingGroup
association [0..1] to I_AdditionalMaterialGroup1 as _AdditionalMaterialGroup1 on $projection.ProductGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1
association [0..1] to I_AdditionalMaterialGroup2 as _AdditionalMaterialGroup2 on $projection.ProductGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2
association [0..1] to I_AdditionalMaterialGroup3 as _AdditionalMaterialGroup3 on $projection.ProductGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3
association [0..1] to I_AdditionalMaterialGroup4 as _AdditionalMaterialGroup4 on $projection.ProductGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4
association [0..1] to I_AdditionalMaterialGroup5 as _AdditionalMaterialGroup5 on $projection.ProductGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5
association [0..1] to I_CustomerGroup as _CustomerGroup on $projection.CustomerGroup = _CustomerGroup.CustomerGroup
association [0..1] to I_AdditionalCustomerGroup1 as _AdditionalCustomerGroup1 on $projection.AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1
association [0..1] to I_AdditionalCustomerGroup2 as _AdditionalCustomerGroup2 on $projection.AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2
association [0..1] to I_AdditionalCustomerGroup3 as _AdditionalCustomerGroup3 on $projection.AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3
association [0..1] to I_AdditionalCustomerGroup4 as _AdditionalCustomerGroup4 on $projection.AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4
association [0..1] to I_AdditionalCustomerGroup5 as _AdditionalCustomerGroup5 on $projection.AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5
association [0..1] to I_SrvcDocTransferStatus as _SrvcDocItemTransferStatus on $projection.SrvcDocItemTransferStatus = _SrvcDocItemTransferStatus.SrvcDocTransferStatus
association [0..1] to I_SrvcDocItemCreditStatus as _SrvcDocItemCreditStatus on $projection.SrvcDocItemCreditStatus = _SrvcDocItemCreditStatus.SrvcDocItemCreditStatus
association [0..1] to I_SrvcDocItmGTSStatus as _SrvcDocItmGTSEmbargoStatus on $projection.SrvcDocItmGTSEmbargoStatus = _SrvcDocItmGTSEmbargoStatus.SrvcDocItmGTSStatus
association [0..1] to I_SrvcDocItmGTSStatus as _SrvcDocItmGTSLglControlStatus on $projection.SrvcDocItmGTSLglControlStatus = _SrvcDocItmGTSLglControlStatus.SrvcDocItmGTSStatus
association [0..1] to I_SrvcDocItmGTSStatus as _SrvcDocItmGTSScreeningStatus on $projection.SrvcDocItmGTSScreeningStatus = _SrvcDocItmGTSScreeningStatus.SrvcDocItmGTSStatus
association [0..1] to I_SrvcDocItmBslnCostPostgStat as _SrvcDocItmBslnCostPostgStat on $projection.SrvcDocItmBslnCostPostgStatus = _SrvcDocItmBslnCostPostgStat.SrvcDocItmBslnCostPostgStatus
association [0..1] to I_SrvcDocItmBslnCostPostgStat as _SrvcDocItmContinuousCostStat on $projection.SrvcDocItmContinuousCostStatus = _SrvcDocItmContinuousCostStat.SrvcDocItmBslnCostPostgStatus
association [0..1] to I_SrvcDocExecutionStatus as _SrvcDocExecutionStatus on $projection.SrvcDocItemExecutionStatus = _SrvcDocExecutionStatus.SrvcDocExecutionStatus
and $projection.ServiceDocumentItemIsQuotation = _SrvcDocExecutionStatus.ServiceDocumentIsQuotation
association [1..1] to I_Indicator as _SrvcDocIsQuotation on $projection.ServiceDocumentItemIsQuotation = _SrvcDocIsQuotation.IndicatorValue
association [1..1] to I_SrvcDocItemBillgRlvnce as _SrvcDocItemBillgRlvnce on $projection.SrvcDocItmBillingRelevance = _SrvcDocItemBillgRlvnce.SrvcDocItmBillingRelevance
association [0..1] to I_SrvcMgmtBillgPlanTemplate as _SrvcMgmtBillgPlanTemplate on $projection.SrvcDocBillingPlanTemplate = _SrvcMgmtBillgPlanTemplate.SrvcDocBillingPlanTemplate
{
// Header Keys
@ObjectModel.foreignKey.association: '_ServiceObjType'
key objtype_h as ServiceObjectType,
@ObjectModel.foreignKey.association: '_ServiceDocument'
key object_id as ServiceDocument,
@ObjectModel.text.element: 'ServiceDocumentItemDescription'
key number_int as ServiceDocumentItem,
// Header Details
description_h as ServiceDocumentDescription,
// Process Type is required for Search by Document Type view
@ObjectModel.foreignKey.association: '_ServiceDocumentType'
process_type as ServiceDocumentType,
priority as ServiceDocumentItemPriority,
posting_date as PostingDate,
srv_rendered_date as ServicesRenderedDate,
// order_date as SrvcDocItmPostingDateTime,
// valid_from as SrvcDocItmValdtyStartDateTime,
// valid_to as SrvcDocItmValdtyEndDateTime,
cast( order_date as crms4_order_date preserving type ) as SrvcDocItmPostingDateTime,
cast( valid_from as crms4_valid_from preserving type ) as SrvcDocItmValdtyStartDateTime,
cast( valid_to as crms4_valid_to preserving type ) as SrvcDocItmValdtyEndDateTime,
// Item Details
item_guid as ServiceDocumentItemUUID,
item_guid_char as ServiceDocumentItemCharUUID,
objtype_i as ServiceDocumentItemObjectType,
header_guid as ServiceDocumentUUID,
parent as ParentServiceDocumentItemUUID,
@Semantics.text: true
description_i as ServiceDocumentItemDescription,
itm_language as Language,
template_type as ServiceDocumentTemplateType,
created_at_i as ServiceDocItemCreationDateTime,
changed_at_i as ServiceDocItemChangedDateTime,
created_by_i as ServiceDocItemCreatedByUser,
changed_by_i as ServiceDocItemChangedByUser,
ordered_prod as OriginallyRequestedProduct,
//OP2023-FPS02 Partner Product Exposure
cast ( partner_prod as matnr_ku ) as MaterialByCustomer,
@ObjectModel.foreignKey.association: '_Product'
product_id as Product, //represents MATNR & is added to enable JOIN with MVKE
@ObjectModel.foreignKey.association: '_ServiceDocItemCategory'
itm_type as ServiceDocItemCategory,
@ObjectModel.foreignKey.association: '_ProfitCenter'
profit_center as ProfitCenter,
cost_center as ResponsibleCostCenter,
@ObjectModel.foreignKey.association: '_ControllingArea'
kokrs as ControllingArea,
profit_determine_date as ProfitCenterDeterminationDate,
refbussolnord as RefBusinessSolutionOrder,
refbussolnorditm as RefBusinessSolutionOrderItem,
receiving_sales_org as IntcoRcvgSalesOrganization,
planning_plant as MaintenancePlanningPlant,
work_center_object_id as WorkCenterInternalID,
// Item - Cumulated Value
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDocItemQuantityUnit'} }
ordered_quantity as SrvcDocItmRequestedQuantity,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
billed_value as InvoiceAmountInInvoiceDocCrcy,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDocItemQuantityUnit'} }
billed_quantity as InvoiceQuantity,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDocItemQuantityUnit'} }
dlv_quantity as SrvcDocItmDeliveredQuantity,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDocItemQuantityUnit'} }
released_quantity as SrvcDocItmReleasedQuantity,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDocItemQuantityUnit'} }
confirmed_qty as CumulativeConfirmedQuantity,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
released_value as SrvcDocItmReldAmtInTransCrcy,
// Item - Product
process_qty_num as SrvcDocItmOrdToBaseQtyNmrtr,
process_qty_den as SrvcDocItmOrdToBaseQtyDnmntr,
exponent10 as OrderToBaseQuantityExponent,
@ObjectModel.foreignKey.association: '_SalesUnit'
@Semantics.unitOfMeasure:true
process_qty_unit as ServiceDocItemQuantityUnit,
@ObjectModel.foreignKey.association: '_BaseUnit_2'
@Semantics.unitOfMeasure:true
base_qty_unit as SrvcDocItemBaseQuantityUnit,
batch as Batch,
valuation_type_mat as ValuationType,
// Billing Set
bill_date as BillingDateTime,
invcr_date as BillingDocCreationDateTime,
billplan_timezone as BillingPlanTimeZone,
billplan_type as SrvcDocBillingPlanType,
@ObjectModel.foreignKey.association: '_SrvcMgmtBillgPlanTemplate'
billplan_template_id as SrvcDocBillingPlanTemplate,
// Item Pricing
price_source as BillingPriceSourceName,
// Partner Details
@ObjectModel.foreignKey.association: '_SoldToParty'
sold_to_party as SoldToParty,
@ObjectModel.foreignKey.association: '_SoldToPartyCountry'
sold_to_country as SoldToPartyCountry,
@ObjectModel.foreignKey.association: '_SoldToPartyRegion'
sold_to_region as SoldToPartyRegion,
@ObjectModel.foreignKey.association: '_ServiceTeam'
service_team as ServiceTeam,
@ObjectModel.foreignKey.association: '_RespEmployee'
person_resp as ResponsibleEmployee,
@ObjectModel.foreignKey.association: '_ServiceEmployee'
service_employee as ServiceEmployee,
@ObjectModel.foreignKey.association: '_ContactPerson'
contact_person as ContactPerson,
@ObjectModel.foreignKey.association: '_PayerParty'
payer as PayerParty,
@ObjectModel.foreignKey.association: '_BillToParty'
bill_to_party as BillToParty,
@ObjectModel.foreignKey.association: '_ShipToParty'
ship_to_party as ShipToParty,
// Status
@ObjectModel.foreignKey.association: '_SrvcDocItmLifecycleStatus'
stat_lifecycle as ServiceDocumentItemStatus,
@ObjectModel.foreignKey.association: '_ServiceDocItemHasError'
stat_error as ServiceDocumentItemHasError,
@ObjectModel.foreignKey.association: '_ServiceDocItemBillingStatus'
stat_billing as ServiceDocItemBillingStatus,
@ObjectModel.foreignKey.association: '_SrvcDocItemIsRelForBillgSts'
stat_for_billing as SrvcDocItmIsReleasedForBilling,
@ObjectModel.foreignKey.association: '_ServiceDocumentIsOpen'
stat_open as ServiceDocumentItemIsOpen,
stat_delivery as SrvcDocItmDeliveryStatus,
stat_goods_issue as SrvcDocItmGoodsIssueStatus,
stat_released as ServiceDocumentItemIsReleased,
stat_cancelled as ServiceDocumentItemIsRejected,
@Semantics.booleanIndicator:true
stat_withdrawn as SrvcDocItemIsWithdrawn,
@ObjectModel.foreignKey.association: '_SrvcDocIsQuotation'
stat_quotation as ServiceDocumentItemIsQuotation,
@ObjectModel.foreignKey.association: '_SrvcDocItemTransferStatus'
stat_transfer as SrvcDocItemTransferStatus,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'SrvcDocItemExecutionStatus'
stat_maintenance as MaintSrvcOrdExecutionStatus,
@ObjectModel.foreignKey.association: '_SrvcDocExecutionStatus'
stat_maintenance as SrvcDocItemExecutionStatus,
// Item - Schedule Line
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDocItemQuantityUnit'} }
order_qty as ServiceDocumentItemQuantity,
// Pricing Parameter Set
@ObjectModel.foreignKey.association: '_TransactionCurrency'
@Semantics.currencyCode:true
currency as TransactionCurrency,
ref_currency as StatisticsCurrency,
exchg_type as ExchangeRateType,
exchg_date as ExchangeRateDate,
exchg_rate as AccountingExchangeRate,
@ObjectModel.foreignKey.association: '_PaymentTerms'
pmnttrms as PaymentTerms,
@ObjectModel.foreignKey.association: '_PaymentMethod'
payment_method as PaymentMethod,
@ObjectModel.foreignKey.association: '_SrvcSEPAMandateRelevance'
sepa_on as SrvcSEPAMandateRelevance,
mandate_id as SEPAMandate,
wbs_element as WBSElementInternalID,
@ObjectModel.foreignKey.association: '_BillableControl'
ac_indicator as BillableControl,
// Item - Pricing
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
net_value_i as ServiceDocumentItemNetAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
tax_amount_i as ServiceDocumentItemTaxAmount,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
gross_value_i as ServiceDocItemGrossAmount,
cpq_price_ref_header_id as PriceReferenceCPQQuotation,
cpq_price_ref_item_id as PriceReferenceCPQQuotationItem,
price_date as PricingDate,
// Billing Set
@ObjectModel.foreignKey.association: '_BillingBlockReason'
billing_block as BillingBlockReason,
@ObjectModel.foreignKey.association: '_SrvcDocItemBillgRlvnce'
billing_relevance as SrvcDocItmBillingRelevance,
dip_profile as DynItemProcessorPrfl,
// Item Product
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'SrvcMaterialPricingGroup'
@ObjectModel.foreignKey.association: '_ProductGroup'
prod_pr_group as ProductGroup,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'MaterialPricingGroup_2'
@ObjectModel.foreignKey.association: '_SrvcMaterialPricingGroup'
prod_pr_group as SrvcMaterialPricingGroup,
@ObjectModel.foreignKey.association: '_MaterialPricingGroup_2'
prod_pr_group as MaterialPricingGroup_2,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup1'
prc_group1 as ProductGroup1,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup2'
prc_group2 as ProductGroup2,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup3'
prc_group3 as ProductGroup3,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup4'
prc_group4 as ProductGroup4,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup5'
prc_group5 as ProductGroup5,
@ObjectModel.foreignKey.association: '_SrvcMgmtProductHierarchy'
prod_hierarchy as ProductHierarchy,
// Item - Sales Set
@ObjectModel.foreignKey.association: '_Industry'
industry as Industry,
po_number_sold as PurchaseOrderByCustomer,
po_number_ship as PurchaseOrderByShipToParty,
po_date_ship as CustPurOrdDateByShipToParty,
@ObjectModel.foreignKey.association: '_ServiceDocItemRejectionReason'
rejection as ServiceDocItemRejectionReason,
@ObjectModel.foreignKey.association: '_CustomerGroup'
cust_group as CustomerGroup,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup1'
cust_group1 as AdditionalCustomerGroup1,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup2'
cust_group2 as AdditionalCustomerGroup2,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup3'
cust_group3 as AdditionalCustomerGroup3,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup4'
cust_group4 as AdditionalCustomerGroup4,
@ObjectModel.foreignKey.association: '_AdditionalCustomerGroup5'
cust_group5 as AdditionalCustomerGroup5,
plant as Plant,
// Service Subject
catlvlguid01_01 as ServiceSchema1Category1UUID,
catlvlguid02_01 as ServiceSchema1Category2UUID,
catlvlguid03_01 as ServiceSchema1Category3UUID,
catlvlguid04_01 as ServiceSchema1Category4UUID,
catlvlguid05_01 as ServiceSchema1Category5UUID,
catlvlguid06_01 as ServiceSchema1Category6UUID,
catlvlguid07_01 as ServiceSchema1Category7UUID,
catlvlguid08_01 as ServiceSchema1Category8UUID,
catlvlguid09_01 as ServiceSchema1Category9UUID,
catlvlguid10_01 as ServiceSchema1Category10UUID,
asp_id_01 as SrvcCatztnSchema1,
cat_id_01 as SrvcCatztnSchemaCategory1,
catlvlguid01_02 as ServiceSchema2Category1UUID,
catlvlguid02_02 as ServiceSchema2Category2UUID,
catlvlguid03_02 as ServiceSchema2Category3UUID,
catlvlguid04_02 as ServiceSchema2Category4UUID,
catlvlguid05_02 as ServiceSchema2Category5UUID,
catlvlguid06_02 as ServiceSchema2Category6UUID,
catlvlguid07_02 as ServiceSchema2Category7UUID,
catlvlguid08_02 as ServiceSchema2Category8UUID,
catlvlguid09_02 as ServiceSchema2Category9UUID,
catlvlguid10_02 as ServiceSchema2Category10UUID,
asp_id_02 as SrvcCatztnSchema2,
cat_id_02 as SrvcCatztnSchemaCategory2,
// Item - Billing Plan
billplan_d_rule_period_date as SettlementPeriodRuleUUID,
billplan_d_rule_bill_date as BillingPlanBillingDateRuleUUID,
billplan_d_rule_price_date as BillingPlanPriceDateRule,
billingplanisfinalized as BillingPlanIsFinalized,
// Organization Unit Set
@ObjectModel.foreignKey.association: '_SalesOrganizationOrgUnit_2'
sales_org as SalesOrganizationOrgUnitID,
@ObjectModel.foreignKey.association: '_SalesOfficeOrgUnit_2'
sales_office as SalesOfficeOrgUnitID,
@ObjectModel.foreignKey.association: '_SalesGroupOrgUnit_2'
sales_group as SalesGroupOrgUnitID,
@ObjectModel.foreignKey.association: '_DistributionChannel'
dis_channel as DistributionChannel,
@ObjectModel.foreignKey.association: '_Division'
division as Division,
sales_org_resp as ResponsibleSalesOrganization,
@ObjectModel.foreignKey.association: '_ServiceOrganizationOrgUnit_2'
service_org as ServiceOrganization,
@ObjectModel.foreignKey.association: '_RespSrvcOrganizationOrgUnit_2'
service_org_resp as ResponsibleServiceOrganization,
// Organizational units with the S/4 SD codes
@ObjectModel.foreignKey.association: '_SalesOrganization'
sales_org_sd as SalesOrganization,
@ObjectModel.foreignKey.association: '_SalesOffice'
sales_office_sd as SalesOffice,
@ObjectModel.foreignKey.association: '_SalesGroup'
sales_group_sd as SalesGroup,
// Service Organizational Units with S/4 Code
service_team_rm as RespyMgmtServiceTeam,
@ObjectModel.foreignKey.association: '_EnterpriseServiceOrg'
enterprise_service_org as EnterpriseServiceOrganization,
//Service Organization-Enterprise Project
proj_org_id as EnterpriseProjectServiceOrg,
// Dates
srv_cust_beg as RequestedServiceStartDateTime,
srv_cust_end as RequestedServiceEndDateTime,
contstart as ServiceContrItemStartDateTime,
contend as ServiceContrItemEndDateTime,
srv_rfirst as ServiceFirstResponseByDateTime,
srv_rready as SrvcDocItemSLADueByDateTime,
srvc_actual as ActualServiceStartDateTime,
srvc_act_to as ActualServiceEndDateTime,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ServiceWorkDuration_2'
srq_work_dura as ServiceWorkDuration,
srq_work_dura_2 as ServiceWorkDuration_2,
srq_work_unit as ServiceWorkDurationUnit,
@Semantics.dateTime: true
cont_start_ts as SrvcDocItmTmeSliceStrtDteTme,
@Semantics.dateTime: true
cont_end_ts as SrvcDocItmTmeSliceEndDteTme,
@Semantics.dateTime: true
auto_renew_start as SrvcContrItemRenewalDateTime,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'SrvcContrItemRnwlDurationUnit'} }
auto_renew_period as SrvcContrItemRnwlDuration,
@ObjectModel.foreignKey.association: '_SrvcContrItemRnwlDurationUnit'
@Semantics.unitOfMeasure:true
auto_renew_period_unit as SrvcContrItemRnwlDurationUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'SrvcContrItemExtnDurationUnit'} }
auto_renew_exten as SrvcContrItemExtensionDuration,
@ObjectModel.foreignKey.association: '_SrvcContrItemExtnDurationUnit'
@Semantics.unitOfMeasure:true
auto_renew_exten_unit as SrvcContrItemExtnDurationUnit,
spla_planfr as PlannedServiceStartDateTime,
spla_planto as PlannedServiceEndDateTime,
grace_period as SrvcDocItemGracePeriod,
grace_period_unit as SrvcDocItemGracePeriodUnit,
grace_period_end as SrvcDocItmGrcePerdEndDateTime,
biz_valid_start as SbscrContrItmBizValdStrtDteTme,
biz_valid_end as SbscrContrItmBizValdEndDteTme,
itm_usage as SrvcDocSubitemOrigin,
itm_type_usage as SrvcDocItemCategoryUsage,
cast(ac_object_type as crmt_ac_object_type_no_conv preserving type ) as SrvcDocItmAcctAssgmtObjectType,
ac_assignment as SrvcDocItmAcctAssgmtObject,
// Item - Service
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ActualServiceDurationUnit'} }
srv_conf_time as ActualServiceDuration,
@ObjectModel.foreignKey.association: '_ActualServiceDurationUnit'
@Semantics.unitOfMeasure:true
srv_conf_tunit as ActualServiceDurationUnit,
confirm_relevant as SrvcOrderConfirmationRelevance, // Despite the DB field name, this is not a boolean value
service_type as ServiceTransactionChargeType,
valuation_type as SrvcTransactionValuationType,
@ObjectModel.foreignKey.association: '_ResponseProfile'
srv_escal as ResponseProfile,
@ObjectModel.foreignKey.association: '_ServiceProfile'
srv_serwi as ServiceProfile,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ServiceDurationUnit'} }
duration as ServiceDuration,
@ObjectModel.foreignKey.association: '_ServiceDurationUnit'
@Semantics.unitOfMeasure:true
duration_unit as ServiceDurationUnit,
@ObjectModel.foreignKey.association: '_ServiceDocOvertimeCat'
overtime_cat as TimeSheetOvertimeCategory,
// Business Solution Quotation
warranty_id as MasterWarranty,
contract_account as ContractAccount,
probability as ItemOrderProbabilityInPercent,
stat_accepted as QuotationIsAccepted,
int_obj_no as ConfigurationNumber,
incoterms1 as IncotermsPart1,
incoterms2 as IncotermsPart2,
dlv_prio as DeliveryPriority,
ordercombind as OrderCombinationIsAllowed,
part_dlv_itm as PartialDeliveryIsAllowed,
ci_billing_cycle as CABillgCycle,
revacc_refid as RevenueAccountingReference,
revacc_reftype as RevenueAccountingRefType,
// ac_object_type as SettAccAssgmntObjectType,
// ac_assignment as SettlementAccountAssignment,
// price_source as PriceSource,
// Volume & Weights
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'ItemWeightUnit'} }
gross_weight_i as ItemGrossWeight,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
net_weight_i as ItemNetWeight,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_WeightUnit'
weight_unit_i as ItemWeightUnit,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
volume_i as ItemVolume,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_VolumeUnit'
volume_unit_i as ItemVolumeUnit,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'CustomerPriceGroup'
price_grp as MaterialPricingGroup,
price_grp as CustomerPriceGroup,
// Delivery details
dlv_group as DeliveryGroup,
@ObjectModel.foreignKey.association: '_deliveryBlockReason'
delivery_block as DeliveryBlockReason,
@Semantics.dateTime: true
first_conf_date as ErlstConfirmedDeliveryDateTime,
@Semantics.dateTime: true
latest_conf_date as LtstConfirmedDeliveryDateTime,
cast(first_req_date as tzntstmps) as RequestedDeliveryDateTime,
// cast(first_conf_date as tzntstmps) as FirstConfdDeliveryDateTime,
// Item - Subscription specific data
prod_sel_type as SubscrpnOrdProdSelType,
ci_contract_id as SubscriptionContract,
btmf_process as SrvcTransChangeProcess,
btmf_process_type as SrvcTransChangeProcessType,
ci_contract_item as SrvcTransChgProcSourceItemUUID,
ma_head_objid as CustMgmtMasterAgreement,
ma_item_objid as CustMgmtMstrAgrmtItem,
stat_activation as SubscrpnContrActivationStatus,
stat_cont_ts as SubscrpnContrTimeSliceStatus,
pool_agr_ref as SharingContractID,
ccm_version as CrsCatalogMappingVersionNumber,
ma_root_objid as CustMgmtMstrAgrmtParentItem,
sharing_group_id as SubscrpnContractSharingGroupID,
ci_partner_rule as CAPartnerSettlementRule,
changeprocessgroup as ChangeProcessGroup,
phase_indicator as BusSolutionQtnItemIsPhased,
successor_of as BusSolnQtnItmPhasedPrdcssrItem,
cont_ref_item as SubscriptionContractItem,
withdrawal_reason as SrvcDocItemWithdrawalReason,
refund_code as SrvcDocItemRefundType,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
recurring_charge as SrvcDocItmRecrrgChrgNetAmount,
@Semantics.booleanIndicator:true
default_terms_ovrwrt as SubscrpnContrTrmsAreSpecified,
@Semantics.booleanIndicator:true
midbillcycexprtnallwd as MidBillgCycExprtnIsAllowed,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
recurring_tax as SrvcDocItmRecrrgChrgTaxAmount,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
recurring_gross as SrvcDocItmRecrrgChrgGrossAmt,
rec_duration as SrvcDocItmRecrrgChrgDuration,
rec_time_unit as SrvcDocItmRecrrgChrgDurnUnit,
cont_ref as SubscriptionContractReference,
subscrpnbillgcycle as SubscriptionBillingCycle,
subscriptioncontractexternalid as SubscriptionContractExternalID,
ma_share_ref as SbscrShContrSvTrMtAgrItmUUID,
ma_share_ref_prod_id as SbscrShContrSvTrMtAgrItmCstPrd,
@Semantics.booleanIndicator: true
case fix_config
when 'A' then 'X'
else ''
end as SvTrMtAgrItmIsFxdConfign,
ci_billing_plan_cycle as SubscrpnContrItmBillgPlnCyc,
// Cancellation
cancparty as ServiceDocumentItemCanclnParty,
canc_reason as ServiceDocumentItmCanclnReason,
cancproc as SrvcDocItmCanclnProcedure,
// Auto renew
auto_renew_period as ServiceDocumentRnwlDuration,
auto_renew_period_unit as ServiceDocRnwlDurationUnit,
auto_renew_exten as ServiceDocExtensionDuration,
auto_renew_exten_unit as ServiceDocExtnDurationUnit,
// Subscription Contract
auto_renew_indicator as SubscrpnContrAutoRnwlIsActv,
// In-House Repair Reference
ref_inhouse_repair as ReferenceInHouseRepair,
ref_inhouse_repair_item as ReferenceInHouseRepairItem,
has_ref_inhouse_repair as RefInHouseRepairIsExisting,
//BOM
bom_item_node_number as BillOfMaterialItemNodeNumber,
// Credit Status
@ObjectModel.foreignKey.association: '_SrvcDocItemCreditStatus'
stat_credit as SrvcDocItemCreditStatus,
// GTS Embargo Status
@ObjectModel.foreignKey.association: '_SrvcDocItmGTSEmbargoStatus'
stat_gts_embargo as SrvcDocItmGTSEmbargoStatus,
// GTS Screening Status
@ObjectModel.foreignKey.association: '_SrvcDocItmGTSScreeningStatus'
stat_gts_screening as SrvcDocItmGTSScreeningStatus,
// GTS Legal Control
@ObjectModel.foreignKey.association: '_SrvcDocItmGTSLglControlStatus'
stat_gts_legal_control as SrvcDocItmGTSLglControlStatus,
@ObjectModel.foreignKey.association: '_SrvcDocItmBslnCostPostgStat'
stat_bsln_cost_postg as SrvcDocItmBslnCostPostgStatus,
// Cost Posting Status for Continuous Planning
@ObjectModel.foreignKey.association: '_SrvcDocItmContinuousCostStat'
stat_cont_cost_calc as SrvcDocItmContinuousCostStatus,
is_unplanned_item as SrvcDocItemIsUnplanned,
//Shipping
ship_cond as ShippingCondition,
//FPS02 Development
subst_reason as MaterialSubstitutionReason,
// Associations
// Item Key Association
_ServiceObjType,
_ServiceDocument,
// Header Details
_ServiceDocumentType,
_ServiceDocItemPriority,
// Item Details
_ServiceDocItemCategory,
_ProfitCenter,
_ControllingArea,
_SrvcMgmtProductHierarchy,
// Partner
_SoldToParty,
_RespEmployee,
_ServiceTeam,
_ServiceEmployee,
_ContactPerson,
_PayerParty,
_BillToParty,
_ShipToParty,
// Status
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SrvcDocItmLifecycleStatus'
_ServiceDocItemStatus,
_SrvcDocItmLifecycleStatus,
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_ServiceDocItemHasError,
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_ServiceDocItemBillingStatus,
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_SrvcDocItemIsRelForBillgSts,
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_ServiceDocumentIsOpen,
// Billing Set
_BillingBlockReason,
_SrvcDocItemBillgRlvnce,
_BillingRequestItem,
_ServiceProductList,
_SrvcMgmtBillgPlanTemplate,
// Item - Product
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_BaseUnit_2'
_BaseUnit,
_BaseUnit_2,
_SalesUnit,
_WeightUnit,
_VolumeUnit,
_TransactionCurrency,
_PaymentTerms,
_PaymentMethod,
//sepa mandate
_SrvcSEPAMandateRelevance,
_FixedPrice,
_StatusObjItemStatus,
// Organization Unit Set
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SalesOrganizationOrgUnit_2'
_SalesOrganizationOrgUnit,
_SalesOrganizationOrgUnit_2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SalesOfficeOrgUnit_2'
_SalesOfficeOrgUnit,
_SalesOfficeOrgUnit_2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SalesGroupOrgUnit_2'
_SalesGroupOrgUnit,
_SalesGroupOrgUnit_2,
_SalesOrganization,
_SalesOffice,
_SalesGroup,
_Division,
_DistributionChannel,
_ServiceTeamHeader,
_EnterpriseServiceOrg,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ServiceOrganizationOrgUnit_2'
_ServiceOrganizationOrgUnit,
_ServiceOrganizationOrgUnit_2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_RespSrvcOrganizationOrgUnit_2'
_RespSrvcOrganizationOrgUnit,
_RespSrvcOrganizationOrgUnit_2,
_ServiceDocOvertimeCat,
_Industry,
_ServiceDocItemRejectionReason,
_SoldToPartyRegion,
_SoldToPartyCountry,
_SettlementDateRule,
_BillPlanDateRule,
_ResponseProfile,
_ServiceProfile,
_TechResource,
_MasterAgrmtItem,
_BillableControl,
_DeliveryBlockReason,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SrvcMaterialPricingGroup'
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_ProductGroup,
_Product,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_MaterialPricingGroup_2'
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_SrvcMaterialPricingGroup,
_MaterialPricingGroup_2,
_AdditionalMaterialGroup1,
_AdditionalMaterialGroup2,
_AdditionalMaterialGroup3,
_AdditionalMaterialGroup4,
_AdditionalMaterialGroup5,
_CustomerGroup,
_AdditionalCustomerGroup1,
_AdditionalCustomerGroup2,
_AdditionalCustomerGroup3,
_AdditionalCustomerGroup4,
_AdditionalCustomerGroup5,
_SrvcDocItemTransferStatus,
// Item - Service Assocations
_ActualServiceDurationUnit,
_ServiceDurationUnit,
_SrvcContrItemRnwlDurationUnit,
_SrvcContrItemExtnDurationUnit,
// Credit Status association
_SrvcDocItemCreditStatus,
// GTS Legal Control Status association
_SrvcDocItmGTSLglControlStatus,
//GTS Screening Status
_SrvcDocItmGTSScreeningStatus,
//GTS Embargo Status
_SrvcDocItmGTSEmbargoStatus,
// Baseline Cost Posting status
_SrvcDocItmBslnCostPostgStat,
// Cost Calculation Status for Continuous Planning
_SrvcDocItmContinuousCostStat,
// Service Document Execution Status
_SrvcDocExecutionStatus,
_SrvcDocIsQuotation,
//RAP : Inheritance of Complex Set
item_no_partner as SrvcDocItmPartReferenceItem,
ref_guid_appt as SrvcDocItmApptRefObjectUUID,
item_no_appt as SrvcDocItmApptReferenceItem
}