A_ServiceOrder_2

DDL: A_SERVICEORDER_2 Type: view_entity CONSUMPTION
72 Fields 1 Data Sources

Service Order

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

Data Sources (1)

SourceAliasJoin Type
R_ServiceOrderTP R_ServiceOrderTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Service Order view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name ServiceOrder_Type view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder ServiceOrder Transaction ID
ServiceObjectType ServiceObjectType Object Type
ServiceOrderType ServiceOrderType Transaction Type
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
ResponsibleSalesOrganization ResponsibleSalesOrganization
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
RespyMgmtServiceTeam RespyMgmtServiceTeam
RespyMgmtGlobalTeamID RespyMgmtGlobalTeamID
EnterpriseServiceOrganization EnterpriseServiceOrganization
ServiceDocumentCategory ServiceDocumentCategory
SrvcOrdGTSEmbargoStatus SrvcOrdGTSEmbargoStatus
SrvcOrdGTSScreeningStatus SrvcOrdGTSScreeningStatus
SrvcOrdGTSLglControlStatus SrvcOrdGTSLglControlStatus
SrvcOrdIsBusinessCompleted SrvcOrdIsBusinessCompleted
SrvcOrdIsBusinessReopened SrvcOrdIsBusinessReopened
ShippingCondition ShippingCondition Shipping Conditions
ServiceOrderIsNew ServiceOrderIsNew
ServiceOrderIsInProcess ServiceOrderIsInProcess
ServiceOrderIsReleased ServiceOrderIsReleased
ServiceOrderIsCompleted ServiceOrderIsCompleted
ServiceOrderIsRejected ServiceOrderIsRejected
ServiceOrderStatus ServiceOrderStatus
SrvcOrdReldForBillingStatus SrvcOrdReldForBillingStatus
SrvcOrdBillingStatus SrvcOrdBillingStatus
ServiceOrderHasError ServiceOrderHasError
SrvcDocTransferStatus SrvcDocTransferStatus
SrvcOrdExecutionStatus SrvcOrdExecutionStatus
SrvcOrdCreditStatus SrvcOrdCreditStatus
SrvcDocWarrantyStatus SrvcDocWarrantyStatus
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
RefServiceOrderTemplate RefServiceOrderTemplate
ReferenceServiceQtan ReferenceServiceQtan
ReferenceServiceRequest ReferenceServiceRequest
WBSElementExternalID WBSElementExternalID WBS Element External ID
FSMServiceCall FSMServiceCall
SrvcCloudVersion2ServiceOrder SrvcCloudVersion2ServiceOrder

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 A_ServiceOrder_2.
-- 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 A_ServiceOrder_2 AS
SELECT
  ServiceOrder,
  ServiceObjectType,
  ServiceOrderType,
  ServiceOrderDescription,
  Language,
  PostingDate,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ResponsibleSalesOrganization,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RespyMgmtServiceTeam,
  RespyMgmtGlobalTeamID,
  EnterpriseServiceOrganization,
  ServiceDocumentCategory,
  SrvcOrdGTSEmbargoStatus,
  SrvcOrdGTSScreeningStatus,
  SrvcOrdGTSLglControlStatus,
  SrvcOrdIsBusinessCompleted,
  SrvcOrdIsBusinessReopened,
  ShippingCondition,
  ServiceOrderIsNew,
  ServiceOrderIsInProcess,
  ServiceOrderIsReleased,
  ServiceOrderIsCompleted,
  ServiceOrderIsRejected,
  ServiceOrderStatus,
  SrvcOrdReldForBillingStatus,
  SrvcOrdBillingStatus,
  ServiceOrderHasError,
  SrvcDocTransferStatus,
  SrvcOrdExecutionStatus,
  SrvcOrdCreditStatus,
  SrvcDocWarrantyStatus,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ErlstRequestedDeliveryDateTime,
  ServiceDocumentPriority,
  TransactionCurrency,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  PricingDocument,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceOrderRejectionReason,
  SrvcOrdExtReference,
  RefServiceOrderTemplate,
  ReferenceServiceQtan,
  ReferenceServiceRequest,
  WBSElementExternalID,
  FSMServiceCall,
  SrvcCloudVersion2ServiceOrder
FROM R_ServiceOrderTP
;

Learn More