C_BusSolnQtanObjPgItemTP

DDL: C_BUSSOLNQTANOBJPGITEMTP Type: view_entity CONSUMPTION

Business Solution Quotation Item - TP

C_BusSolnQtanObjPgItemTP is a Consumption CDS View that provides data about "Business Solution Quotation Item - TP" in SAP S/4HANA. It reads from 1 data source (R_BusSolnQtanItemTP) and exposes 29 fields with key fields BusinessSolutionQuotation, CustMgmtObjectType, ServiceDocumentItem.

Data Sources (1)

SourceAliasJoin Type
R_BusSolnQtanItemTP R_BusSolnQtanItemTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Business Solution Quotation Item - TP view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #MANDATORY view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation BusinessSolutionQuotation Transaction ID
KEY CustMgmtObjectType CustMgmtObjectType Object Type
KEY ServiceDocumentItem ServiceDocumentItem Service Document
Product Product Product Sold
BusSolnQtanItemDescription BusSolnQtanItemDescription
BusSolnQtanItemCategory BusSolnQtanItemCategory
ServiceDocumentItemUUID ServiceDocumentItemUUID
ParentServiceDocumentItemUUID ParentServiceDocumentItemUUID
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ServiceDocumentType ServiceDocumentType Transaction Type
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
ServiceOrganization ServiceOrganization
SalesGroupOrgUnitID SalesGroupOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
_Product _Product
_ServiceDocItemCategory _ServiceDocItemCategory
_ServiceDocument _ServiceDocument
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
_TransactionCurrency _TransactionCurrency

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_BusSolnQtanObjPgItemTP.
-- 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_BusSolnQtanObjPgItemTP AS
SELECT
  BusinessSolutionQuotation,
  CustMgmtObjectType,
  ServiceDocumentItem,
  Product,
  BusSolnQtanItemDescription,
  BusSolnQtanItemCategory,
  ServiceDocumentItemUUID,
  ParentServiceDocumentItemUUID,
  Quantity,
  QuantityUnit,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ServiceDocumentType,
  SalesGroup,
  SalesOffice,
  Division,
  DistributionChannel,
  SalesOrganization,
  SalesOrganizationOrgUnitID,
  ServiceOrganization,
  SalesGroupOrgUnitID,
  SalesOfficeOrgUnitID,
  RespEmployeeBusinessPartnerId
FROM R_BusSolnQtanItemTP
;