I_BusinessSolutionOrderStdVH

DDL: I_BUSINESSSOLUTIONORDERSTDVH SQL: IBUSSOLNORDVH Type: view COMPOSITE
34 Fields 1 Data Sources 1 Associations

Solution Order Value Help

I_BusinessSolutionOrderStdVH is a Composite CDS View that provides data about "Solution Order Value Help" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 34 fields with key field BusinessSolutionOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CustMgmtLifecycleUserStsText _CustMgmtLifecycleUserStsText $projection.ServiceDocumentStatus = _CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus and _CustMgmtLifecycleUserStsText.Language = $session.system_language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IBUSSOLNORDVH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey BusinessSolutionOrder view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Solution Order Value Help view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
Consumption.ranked true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder ServiceDocument Solution Order ID
BusSolnOrdDescription ServiceDocumentDescription Solution Order Description
SoldToParty SoldToParty Sold-to Party
BusinessPartnerName _SoldToParty BusinessPartnerName Sold-To Party
PurchaseOrderByCustomer PurchaseOrderByCustomer External Reference
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceObjectType ServiceObjectType Object Type
SalesOrganization SalesOrganization Sales Organization
ServiceDocumentStatus ServiceDocumentStatus Life Cycle Status
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group
ServiceOrganization ServiceOrganization Service Organization
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SoldToParty _SoldToParty
_ServiceDocumentStatus _ServiceDocumentStatus
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2

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_BusinessSolutionOrderStdVH.
-- 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.
-- SQL view name: IBUSSOLNORDVH

CREATE VIEW I_BusinessSolutionOrderStdVH AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentDescription AS BusSolnOrdDescription,
  SoldToParty,
  _SoldToParty.BusinessPartnerName AS BusinessPartnerName,
  PurchaseOrderByCustomer,
  ServiceDocumentType,
  ServiceObjectType,
  SalesOrganization,
  ServiceDocumentStatus,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM I_ServiceDocument
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _CustMgmtLifecycleUserStsText ON ServiceDocumentStatus = _CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus AND _CustMgmtLifecycleUserStsText.Language = $session.system_language  -- association [0..1]
;

Learn More