I_ServiceOrderTP

DDL: I_SERVICEORDERTP Type: view_entity TRANSACTIONAL
86 Fields 1 Data Sources

Service Order - TP

I_ServiceOrderTP is a Transactional CDS View that provides data about "Service Order - TP" in SAP S/4HANA. It reads from 1 data source (R_ServiceOrderTP) and exposes 86 fields with key field ServiceOrder.

Data Sources (1)

SourceAliasJoin Type
R_ServiceOrderTP R_ServiceOrderTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Service Order - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
ObjectModel.sapObjectNodeType.name ServiceOrder view
ObjectModel.representativeKey ServiceOrder view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (86)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder ServiceOrder Transaction ID
ServiceObjectType ServiceObjectType Object Type
ServiceOrderType ServiceOrderType Transaction Type
ServiceOrderUUID ServiceOrderUUID Object GUID
ServiceOrderDescription ServiceOrderDescription
Language Language Report Text Language
PostingDate PostingDate Posting Date for GR
ServiceDocCreationDateTime ServiceDocCreationDateTime
ServiceDocChangedDateTime ServiceDocChangedDateTime
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser
ServiceDocumentChangedByUser ServiceDocumentChangedByUser
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
PaymentTerms PaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
SEPAMandate SEPAMandate SEPA Mandate
SrvcSEPAMandateRelevance SrvcSEPAMandateRelevance
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person Key
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
RespyMgmtServiceTeam RespyMgmtServiceTeam
RespyMgmtGlobalTeamID RespyMgmtGlobalTeamID
ServiceOrderIsNew ServiceOrderIsNew
ServiceOrderIsInProcess ServiceOrderIsInProcess
ServiceOrderIsReleased ServiceOrderIsReleased
ServiceOrderIsCompleted ServiceOrderIsCompleted
ServiceOrderIsRejected ServiceOrderIsRejected
ServiceOrderStatus ServiceOrderStatus
SrvcOrdReldForBillingStatus SrvcOrdReldForBillingStatus
SrvcOrdBillingStatus SrvcOrdBillingStatus
ServiceOrderHasError ServiceOrderHasError
SrvcDocTransferStatus SrvcDocTransferStatus
SrvcOrdExecutionStatus SrvcOrdExecutionStatus
SrvcOrdCreditStatus SrvcOrdCreditStatus
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
ErlstRequestedDeliveryDateTime ErlstRequestedDeliveryDateTime
ServiceDocumentPriority ServiceDocumentPriority
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocGrossAmount ServiceDocGrossAmount
ServiceDocNetAmount ServiceDocNetAmount
ServiceDocTaxAmount ServiceDocTaxAmount
PricingDocument PricingDocument Document Condition
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
ServiceOrderRejectionReason ServiceOrderRejectionReason
SrvcOrdExtReference SrvcOrdExtReference
ReferenceServiceContract ReferenceServiceContract Transaction ID
RefServiceOrderTemplate RefServiceOrderTemplate
ReferenceServiceQtan ReferenceServiceQtan
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
WBSElementExternalID WBSElementExternalID WBS Element External ID
FSMServiceCall FSMServiceCall
_SoldToParty _SoldToParty
_ShipToParty _ShipToParty
_BillToParty _BillToParty
_PayerParty _PayerParty
_ContactPerson _ContactPerson
_RespEmployee _RespEmployee
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_PaymentTerms _PaymentTerms
_PaymentMethod _PaymentMethod
_SrvcSEPAMandateRelevance _SrvcSEPAMandateRelevance
_TransactionCurrency _TransactionCurrency
_ServiceDocumentPriority _ServiceDocumentPriority
_SrvcDocumentRejectionReason _SrvcDocumentRejectionReason
_Confirmation _Confirmation

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ServiceOrderTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ServiceOrderTP AS
SELECT
  ServiceOrder,
  ServiceObjectType,
  ServiceOrderType,
  ServiceOrderUUID,
  ServiceOrderDescription,
  Language,
  PostingDate,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RespyMgmtServiceTeam,
  RespyMgmtGlobalTeamID,
  ServiceOrderIsNew,
  ServiceOrderIsInProcess,
  ServiceOrderIsReleased,
  ServiceOrderIsCompleted,
  ServiceOrderIsRejected,
  ServiceOrderStatus,
  SrvcOrdReldForBillingStatus,
  SrvcOrdBillingStatus,
  ServiceOrderHasError,
  SrvcDocTransferStatus,
  SrvcOrdExecutionStatus,
  SrvcOrdCreditStatus,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ErlstRequestedDeliveryDateTime,
  ServiceDocumentPriority,
  TransactionCurrency,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  PricingDocument,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceOrderRejectionReason,
  SrvcOrdExtReference,
  ReferenceServiceContract,
  RefServiceOrderTemplate,
  ReferenceServiceQtan,
  WBSElementExternalID,
  FSMServiceCall
FROM R_ServiceOrderTP
;

Learn More