C_BusSolnQtanManageTP

DDL: C_BUSSOLNQTANMANAGETP Type: view_entity CONSUMPTION
51 Fields 1 Data Sources 3 Associations

Business Solution Quotation Manage TP

C_BusSolnQtanManageTP is a Consumption CDS View that provides data about "Business Solution Quotation Manage TP" in SAP S/4HANA. It reads from 1 data source (R_BusinessSolutionQuotationTP) and exposes 51 fields with key field BusinessSolutionQuotation. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_BusinessSolutionQuotationTP R_BusinessSolutionQuotationTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_Q2CCustomerQuickView _Q2CCustomerQuickView $projection.SoldToParty = _Q2CCustomerQuickView.Customer
[0..1] C_SrvcMgmtCntctPersnQuickVw _SrvcMgmtCntctPersnQuickVw $projection.ContactPersonBusinessPartnerId = _SrvcMgmtCntctPersnQuickVw.BusinessPartner
[0..1] C_SrvcMgmtRespEmplQuickVw _SrvcMgmtRespEmplQuickVw $projection.RespEmployeeBusinessPartnerId = _SrvcMgmtRespEmplQuickVw.BusinessPartner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey BusinessSolutionQuotation view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Consumption.semanticObject BusinessSolutionQuotation view
EndUserText.label Business Solution Quotation Manage TP view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation BusinessSolutionQuotation ID
BusSolnQtanDescription BusSolnQtanDescription Description
CustMgmtObjectType CustMgmtObjectType Object Type
SoldToParty SoldToParty Sold-to Party
SoldToPartyName _SoldToParty BusinessPartnerFullName Sold-To Party Name
FirstName _SoldToParty FirstName First Name
LastName _SoldToParty LastName Last Name
OrganizationBPName1 _SoldToParty OrganizationBPName1 Organization Business Partner Name1
OrganizationBPName2 _SoldToParty OrganizationBPName2 Organization Business Partner Name2
ServiceDocumentStatus ServiceDocumentStatus Life Cycle Status
ServiceDocumentStatusName ServiceDocumentStatusName Life Cycle Status Name
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocNetAmount ServiceDocNetAmount Net Value
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Responsible
ResponsibleEmployeeName _RespEmployee BusinessPartnerFullName Employee Responsible Name
BusSolutionQuotationType BusSolutionQuotationType Solution Quotation Type
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact
ContactPersonName ContactPersonName Contact Person Name
ServiceDocumentHasError ServiceDocumentHasError Error Status
ServiceDocumentHasErrorNamelocalized Error Status Text
CreationDate CreationDate Created On
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser Created By
BusSolnQtanExtReference BusSolnQtanExtReference External Reference
PostingDate PostingDate Posting Date
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel Distribution Channel
Division Division Division
SrvcQuotationValidityStartDate SrvcQuotationValidityStartDate Valid From
SrvcQuotationValidityEndDate SrvcQuotationValidityEndDate Valid To
QuotationIsAccepted QuotationIsAccepted Acceptance Status
SrvcDocAcceptanceStatusText SrvcDocAcceptanceStatusText
SoldToPartyCountry SoldToPartyCountry Sold-to-Country/Region
BillToParty BillToParty Bill-to Party
PayerParty PayerParty Payer
BusSolnQuotationIsRejected BusSolnQuotationIsRejected Cancellation Status
SrvcDocRejectionStatusTextlocalized Cancellation Status Text
BusSolnQuotationIsReleased BusSolnQuotationIsReleased Release Status
SrvcDocReleasedStatusTextlocalized Service Document Released Status Text
ServiceDocumentPriority ServiceDocumentPriority Priority
ServiceDocumentPriorityName _ServiceDocumentPriorityText ServiceDocumentPriorityName Priority Text
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office Org Unit ID
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group Org Unit ID
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization Org Unit ID
ServiceOrganization ServiceOrganization Service Organization
ServiceDocGrossAmount ServiceDocGrossAmount Gross Value
virtualProductIDproductnumber
_Q2CCustomerQuickView _Q2CCustomerQuickView
_SrvcMgmtCntctPersnQuickVw _SrvcMgmtCntctPersnQuickVw
_SrvcMgmtRespEmplQuickVw _SrvcMgmtRespEmplQuickVw

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 C_BusSolnQtanManageTP.
-- 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 C_BusSolnQtanManageTP AS
SELECT
  BusinessSolutionQuotation,
  BusSolnQtanDescription,
  CustMgmtObjectType,
  SoldToParty,
  _SoldToParty.BusinessPartnerFullName AS SoldToPartyName,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  ServiceDocumentStatus,
  ServiceDocumentStatusName,
  TransactionCurrency,
  ServiceDocNetAmount,
  RespEmployeeBusinessPartnerId,
  _RespEmployee.BusinessPartnerFullName AS ResponsibleEmployeeName,
  BusSolutionQuotationType,
  ContactPersonBusinessPartnerId,
  ContactPersonName,
  ServiceDocumentHasError,
  _ServiceDocHasError._ServiceDocHasErrorText.ServiceDocumentHasErrorName : localized AS ServiceDocumentHasErrorNamelocalized,
  CreationDate,
  ServiceDocumentCreatedByUser,
  BusSolnQtanExtReference,
  PostingDate,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SrvcQuotationValidityStartDate,
  SrvcQuotationValidityEndDate,
  QuotationIsAccepted,
  SrvcDocAcceptanceStatusText,
  SoldToPartyCountry,
  BillToParty,
  PayerParty,
  BusSolnQuotationIsRejected,
  _ServiceDocCancelled._SrvcDocRejectionStatusText.SrvcDocRejectionStatusText : localized AS SrvcDocRejectionStatusTextlocalized,
  BusSolnQuotationIsReleased,
  _ServiceDocReleaseStatus._SrvcDocReleaseStatusText.SrvcDocReleasedStatusText : localized AS SrvcDocReleasedStatusTextlocalized,
  ServiceDocumentPriority,
  _ServiceDocumentPriorityText.ServiceDocumentPriorityName AS ServiceDocumentPriorityName,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  SalesOrganizationOrgUnitID,
  ServiceOrganization,
  ServiceDocGrossAmount,
  virtual ProductID : productnumber AS virtualProductIDproductnumber
FROM R_BusinessSolutionQuotationTP
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _Q2CCustomerQuickView ON SoldToParty = _Q2CCustomerQuickView.Customer  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtCntctPersnQuickVw AS _SrvcMgmtCntctPersnQuickVw ON ContactPersonBusinessPartnerId = _SrvcMgmtCntctPersnQuickVw.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtRespEmplQuickVw AS _SrvcMgmtRespEmplQuickVw ON RespEmployeeBusinessPartnerId = _SrvcMgmtRespEmplQuickVw.BusinessPartner  -- association [0..1]
;

Learn More