I_ServiceQuotationTP

DDL: I_SERVICEQUOTATIONTP Type: view_entity TRANSACTIONAL

Service Quotation - TP

I_ServiceQuotationTP is a Transactional CDS View that provides data about "Service Quotation - TP" in SAP S/4HANA. It reads from 1 data source (R_ServiceQuotationTP) and exposes 69 fields with key field ServiceQuotation.

Data Sources (1)

SourceAliasJoin Type
R_ServiceQuotationTP R_ServiceQuotationTP projection

Annotations (11)

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

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation ServiceQuotation Transaction ID
ServiceObjectType ServiceObjectType Object Type
ServiceQuotationType ServiceQuotationType Transaction Type
ServiceQuotationUUID ServiceQuotationUUID Object GUID
ServiceQuotationDescription ServiceQuotationDescription
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)
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
ServiceQuotationIsNew ServiceQuotationIsNew
ServiceQuotationIsInProcess ServiceQuotationIsInProcess
ServiceQuotationIsReleased ServiceQuotationIsReleased
ServiceQuotationIsCompleted ServiceQuotationIsCompleted
ServiceQuotationStatus ServiceQuotationStatus
ServiceQuotationHasError ServiceQuotationHasError
SrvcDocRejectionStatus SrvcDocRejectionStatus
SrvcQtanGTSEmbargoStatus SrvcQtanGTSEmbargoStatus
SrvcQtanGTSLglControlStatus SrvcQtanGTSLglControlStatus
SrvcQtanGTSScreeningStatus SrvcQtanGTSScreeningStatus
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
SrvcQtanValidityStartDateTime SrvcQtanValidityStartDateTime
SrvcQtanValidityEndDateTime SrvcQtanValidityEndDateTime
ServiceDocumentPriority ServiceDocumentPriority
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocGrossAmount ServiceDocGrossAmount
ServiceDocNetAmount ServiceDocNetAmount
ServiceDocTaxAmount ServiceDocTaxAmount
PricingDocument PricingDocument Document Condition
SrvcQuotationRejectionReason SrvcQuotationRejectionReason
ServiceQtanExtReference ServiceQtanExtReference
ReferenceServiceContract ReferenceServiceContract
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_SoldToParty _SoldToParty
_ShipToParty _ShipToParty
_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
_ServiceTeamHeader _ServiceTeamHeader
_SrvcQtanStatus _SrvcQtanStatus
_ServiceDocumentPriority _ServiceDocumentPriority
_TransactionCurrency _TransactionCurrency
_SrvcDocumentRejectionReason _SrvcDocumentRejectionReason

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_ServiceQuotationTP.
-- 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_ServiceQuotationTP AS
SELECT
  ServiceQuotation,
  ServiceObjectType,
  ServiceQuotationType,
  ServiceQuotationUUID,
  ServiceQuotationDescription,
  Language,
  PostingDate,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  SoldToParty,
  ShipToParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RespyMgmtServiceTeam,
  RespyMgmtGlobalTeamID,
  ServiceQuotationIsNew,
  ServiceQuotationIsInProcess,
  ServiceQuotationIsReleased,
  ServiceQuotationIsCompleted,
  ServiceQuotationStatus,
  ServiceQuotationHasError,
  SrvcDocRejectionStatus,
  SrvcQtanGTSEmbargoStatus,
  SrvcQtanGTSLglControlStatus,
  SrvcQtanGTSScreeningStatus,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  SrvcQtanValidityStartDateTime,
  SrvcQtanValidityEndDateTime,
  ServiceDocumentPriority,
  TransactionCurrency,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  PricingDocument,
  SrvcQuotationRejectionReason,
  ServiceQtanExtReference,
  ReferenceServiceContract
FROM R_ServiceQuotationTP
;