R_BusinessSolutionQuotationTP

DDL: R_BUSINESSSOLUTIONQUOTATIONTP Type: view_entity TRANSACTIONAL
59 Fields 2 Data Sources 8 Associations

Business Solution Quotation - TP

R_BusinessSolutionQuotationTP is a Transactional CDS View that provides data about "Business Solution Quotation - TP" in SAP S/4HANA. It reads from 2 data sources (I_BusSolutionQuotationType, I_ServiceDocumentEnhcd) and exposes 59 fields with key field BusinessSolutionQuotation. It has 8 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BusSolutionQuotationType BusSolutionQuotationType inner
I_ServiceDocumentEnhcd ServiceDocumentEnhcd from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_SrvcLifeCycleSystemStatusT _LifecycleUserStsText $projection.ServiceDocumentStatus = _LifecycleUserStsText.SrvcLifeCycleSystemStatus and _LifecycleUserStsText.Language = $session.system_language
[0..1] I_SrvcMgmtBPQuickView_2 _SrvcDocBPRespEmployee $projection.RespEmployeeBusinessPartnerId = _SrvcDocBPRespEmployee.BusinessPartner
[1] I_SrvcDocRejectionStatus _ServiceDocCancelled $projection.BusSolnQuotationIsRejected = _ServiceDocCancelled.ServiceDocumentIsRejected
[1] I_SrvcDocReleaseStatus _ServiceDocReleaseStatus $projection.BusSolnQuotationIsReleased = _ServiceDocReleaseStatus.ServiceDocumentIsReleased
[0..1] I_ServiceDocumentPriorityText _ServiceDocumentPriorityText $projection.ServiceDocumentPriority = _ServiceDocumentPriorityText.ServiceDocumentPriority and _ServiceDocumentPriorityText.Language = $session.system_language
[1] I_BusinessPartner _ServiceDocCreatedBy $projection.ServiceDocumentCreatedByUser = _ServiceDocCreatedBy.BusinessPartner
[1] P_BusSolnQtanAcceptanceStatus _SolnQtanAccptcStatus $projection.BusinessSolutionQuotation = _SolnQtanAccptcStatus.BusinessSolutionQuotation
[0..*] R_BusSolnQtanItemTP _BusinessSolutionQtanItemTP

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Solution Quotation - TP view
ObjectModel.sapObjectNodeType.name BusinessSolutionQuotation view
ObjectModel.representativeKey BusinessSolutionQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation I_ServiceDocumentEnhcd ServiceDocument Transaction ID
CustMgmtObjectType I_ServiceDocumentEnhcd ServiceObjectType Object Type
BusSolutionQuotationType I_ServiceDocumentEnhcd ServiceDocumentType Transaction Type
BusSolutionQuotationUUID I_ServiceDocumentEnhcd ServiceDocumentUUID Object GUID
BusSolnQtanDescription I_ServiceDocumentEnhcd ServiceDocumentDescription
SalesOrganization I_ServiceDocumentEnhcd SalesOrganization Sales Organization
DistributionChannel I_ServiceDocumentEnhcd DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentEnhcd Division Internal Division ID
SalesOffice I_ServiceDocumentEnhcd SalesOffice Sales Office
SalesGroup I_ServiceDocumentEnhcd SalesGroup Sales Group
SalesOrganizationOrgUnitID I_ServiceDocumentEnhcd SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentEnhcd SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentEnhcd SalesGroupOrgUnitID
ServiceOrganization I_ServiceDocumentEnhcd ServiceOrganization
RespEmployeeBusinessPartnerId I_ServiceDocumentEnhcd ResponsibleEmployee Employee Resp.
SoldToParty I_ServiceDocumentEnhcd SoldToParty Sold-to Party
ServiceDocumentStatus I_ServiceDocumentEnhcd ServiceDocumentStatus
ServiceDocumentStatusName _LifecycleUserStsText SrvcLifeCycleSystemStatusName
CreationDate I_ServiceDocumentEnhcd ServiceDocumentCreationDate
ServiceDocumentCreatedByUser I_ServiceDocumentEnhcd ServiceDocumentCreatedByUser
TransactionCurrency I_ServiceDocumentEnhcd TransactionCurrency Transaction Currency
ServiceDocNetAmount I_ServiceDocumentEnhcd ServiceDocNetAmount
ServiceDocumentHasError I_ServiceDocumentEnhcd ServiceDocumentHasError
BusSolnQtanExtReference
PostingDate I_ServiceDocumentEnhcd PostingDate Posting Date for GR
SoldToPartyCountry I_ServiceDocumentEnhcd SoldToPartyCountry
ServiceDocumentPriority I_ServiceDocumentEnhcd ServiceDocumentPriority
BillToParty I_ServiceDocumentEnhcd BillToParty Inv. Recipient
PayerParty I_ServiceDocumentEnhcd PayerParty Payer
BusSolnQuotationIsRejected I_ServiceDocumentEnhcd ServiceDocumentIsRejected
BusSolnQuotationIsReleased I_ServiceDocumentEnhcd ServiceDocumentIsReleased
SrvcQuotationValidityStartDate I_ServiceDocumentEnhcd SrvcQuotationValidityStartDate
SrvcQuotationValidityEndDate I_ServiceDocumentEnhcd SrvcQuotationValidityEndDate
ServiceDocGrossAmount I_ServiceDocumentEnhcd ServiceDocGrossAmount
ContactPersonBusinessPartnerId I_ServiceDocumentEnhcd ContactPerson Contact Person Key
ContactPersonName
SrvcDocAcceptanceStatusText
_SoldToParty I_ServiceDocumentEnhcd _SoldToParty
_TransactionCurrency I_ServiceDocumentEnhcd _TransactionCurrency
_ServiceDocHasError I_ServiceDocumentEnhcd _ServiceDocHasError
_ServiceObjType I_ServiceDocumentEnhcd _ServiceObjType
_ContactPerson I_ServiceDocumentEnhcd _ContactPerson
_SalesOrganization I_ServiceDocumentEnhcd _SalesOrganization
_DistributionChannel I_ServiceDocumentEnhcd _DistributionChannel
_Division I_ServiceDocumentEnhcd _Division
_SalesOffice I_ServiceDocumentEnhcd _SalesOffice
_SalesGroup I_ServiceDocumentEnhcd _SalesGroup
_SalesOrganizationOrgUnit_2 I_ServiceDocumentEnhcd _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 I_ServiceDocumentEnhcd _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 I_ServiceDocumentEnhcd _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 I_ServiceDocumentEnhcd _ServiceOrganizationOrgUnit_2
_RespEmployee I_ServiceDocumentEnhcd _RespEmployee
_BusinessSolutionQtanItemTP _BusinessSolutionQtanItemTP
_LifecycleUserStsText _LifecycleUserStsText
_SrvcDocBPRespEmployee _SrvcDocBPRespEmployee
_ServiceDocCancelled _ServiceDocCancelled
_ServiceDocReleaseStatus _ServiceDocReleaseStatus
_ServiceDocCreatedBy _ServiceDocCreatedBy
_ServiceDocumentPriorityText _ServiceDocumentPriorityText

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 R_BusinessSolutionQuotationTP.
-- 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 R_BusinessSolutionQuotationTP AS
SELECT
  ServiceDocumentEnhcd.ServiceDocument AS BusinessSolutionQuotation,
  ServiceDocumentEnhcd.ServiceObjectType AS CustMgmtObjectType,
  ServiceDocumentEnhcd.ServiceDocumentType AS BusSolutionQuotationType,
  ServiceDocumentEnhcd.ServiceDocumentUUID AS BusSolutionQuotationUUID,
  ServiceDocumentEnhcd.ServiceDocumentDescription AS BusSolnQtanDescription,
  ServiceDocumentEnhcd.SalesOrganization AS SalesOrganization,
  ServiceDocumentEnhcd.DistributionChannel AS DistributionChannel,
  ServiceDocumentEnhcd.Division AS Division,
  ServiceDocumentEnhcd.SalesOffice AS SalesOffice,
  ServiceDocumentEnhcd.SalesGroup AS SalesGroup,
  ServiceDocumentEnhcd.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocumentEnhcd.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocumentEnhcd.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocumentEnhcd.ServiceOrganization AS ServiceOrganization,
  ServiceDocumentEnhcd.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceDocumentEnhcd.SoldToParty AS SoldToParty,
  ServiceDocumentEnhcd.ServiceDocumentStatus AS ServiceDocumentStatus,
  _LifecycleUserStsText.SrvcLifeCycleSystemStatusName AS ServiceDocumentStatusName,
  ServiceDocumentEnhcd.ServiceDocumentCreationDate AS CreationDate,
  ServiceDocumentEnhcd.ServiceDocumentCreatedByUser AS ServiceDocumentCreatedByUser,
  ServiceDocumentEnhcd.TransactionCurrency AS TransactionCurrency,
  ServiceDocumentEnhcd.ServiceDocNetAmount AS ServiceDocNetAmount,
  ServiceDocumentEnhcd.ServiceDocumentHasError AS ServiceDocumentHasError,
  cast(ServiceDocumentEnhcd.PurchaseOrderByCustomer as crmt_ext_ref_num ) AS BusSolnQtanExtReference,
  ServiceDocumentEnhcd.PostingDate AS PostingDate,
  ServiceDocumentEnhcd.SoldToPartyCountry AS SoldToPartyCountry,
  ServiceDocumentEnhcd.ServiceDocumentPriority AS ServiceDocumentPriority,
  ServiceDocumentEnhcd.BillToParty AS BillToParty,
  ServiceDocumentEnhcd.PayerParty AS PayerParty,
  ServiceDocumentEnhcd.ServiceDocumentIsRejected AS BusSolnQuotationIsRejected,
  ServiceDocumentEnhcd.ServiceDocumentIsReleased AS BusSolnQuotationIsReleased,
  ServiceDocumentEnhcd.SrvcQuotationValidityStartDate AS SrvcQuotationValidityStartDate,
  ServiceDocumentEnhcd.SrvcQuotationValidityEndDate AS SrvcQuotationValidityEndDate,
  ServiceDocumentEnhcd.ServiceDocGrossAmount AS ServiceDocGrossAmount,
  ServiceDocumentEnhcd.ContactPerson AS ContactPersonBusinessPartnerId,
  ServiceDocumentEnhcd._ContactPerson.BusinessPartnerName AS ContactPersonName,
  _SolnQtanAccptcStatus._SolnQtanAcceptanceStatusText.SrvcDocAcceptanceStatusText AS SrvcDocAcceptanceStatusText,
  ServiceDocumentEnhcd._SoldToParty AS _SoldToParty,
  ServiceDocumentEnhcd._TransactionCurrency AS _TransactionCurrency,
  ServiceDocumentEnhcd._ServiceDocHasError AS _ServiceDocHasError,
  ServiceDocumentEnhcd._ServiceObjType AS _ServiceObjType,
  ServiceDocumentEnhcd._ContactPerson AS _ContactPerson,
  ServiceDocumentEnhcd._SalesOrganization AS _SalesOrganization,
  ServiceDocumentEnhcd._DistributionChannel AS _DistributionChannel,
  ServiceDocumentEnhcd._Division AS _Division,
  ServiceDocumentEnhcd._SalesOffice AS _SalesOffice,
  ServiceDocumentEnhcd._SalesGroup AS _SalesGroup,
  ServiceDocumentEnhcd._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  ServiceDocumentEnhcd._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  ServiceDocumentEnhcd._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  ServiceDocumentEnhcd._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
  ServiceDocumentEnhcd._RespEmployee AS _RespEmployee
FROM I_ServiceDocumentEnhcd AS ServiceDocumentEnhcd
INNER JOIN I_BusSolutionQuotationType AS BusSolutionQuotationType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SrvcLifeCycleSystemStatusT AS _LifecycleUserStsText ON ServiceDocumentStatus = _LifecycleUserStsText.SrvcLifeCycleSystemStatus AND _LifecycleUserStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtBPQuickView_2 AS _SrvcDocBPRespEmployee ON RespEmployeeBusinessPartnerId = _SrvcDocBPRespEmployee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocRejectionStatus AS _ServiceDocCancelled ON BusSolnQuotationIsRejected = _ServiceDocCancelled.ServiceDocumentIsRejected  -- association [1]
LEFT OUTER JOIN I_SrvcDocReleaseStatus AS _ServiceDocReleaseStatus ON BusSolnQuotationIsReleased = _ServiceDocReleaseStatus.ServiceDocumentIsReleased  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentPriorityText AS _ServiceDocumentPriorityText ON ServiceDocumentPriority = _ServiceDocumentPriorityText.ServiceDocumentPriority AND _ServiceDocumentPriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServiceDocCreatedBy ON ServiceDocumentCreatedByUser = _ServiceDocCreatedBy.BusinessPartner  -- association [1]
LEFT OUTER JOIN P_BusSolnQtanAcceptanceStatus AS _SolnQtanAccptcStatus ON BusinessSolutionQuotation = _SolnQtanAccptcStatus.BusinessSolutionQuotation  -- association [1]
LEFT OUTER JOIN R_BusSolnQtanItemTP AS _BusinessSolutionQtanItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More