I_BusSolnOrdItmBasicFinancial

DDL: I_BUSSOLNORDITMBASICFINANCIAL Type: view COMPOSITE
69 Fields 1 Data Sources

Solution Order Item for Fin Reporting

I_BusSolnOrdItmBasicFinancial is a Composite CDS View (Dimension) that provides data about "Solution Order Item for Fin Reporting" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 69 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem.

SAP Help Documentation

CategorySolution Order Management
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides basic solution order data at item level so that it can be integrated into financial reporting. For example, it can be used in financial reporting to get information on a specific solution order item. The view provides the prerequisites for answering the following business questions: What are the total net and gross values of a specific solution order item in the transaction currency? What is the tax amount for each solution order item in the transaction currency? What is the posting date for each solution order item of a specific sold-to party? What is the sales organization of the solution order item with a specific life cycle status? What is the ID of the solution order related to a solution order item posted on a specific date? What is the product that a customer originally requested that is specified in a solution order item? Note For calculating financial KPIs, you need to use this CDS view in combination with CDS views from SAP S/4HANA Finance .

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above.

Structure
Object types This view relates to the following SAP object type: BusinessSolutionOrder . Attributes The following are some important attributes in this CDS view: Controlling area Employee responsible for a solution order ID of a solution order item ID of the solution order related to a specific solution order item Life cycle status of a solution order item Posting date of a solution order Product in a solution order item that a customer originally requested Profit center of a solution order item Sold-to party of a solution order item Total net and gross values of a solution order item Total tax amount of a solution order item in transaction currency Transaction currency

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (17)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IBUSSOLORDITMFR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BusinessSolutionOrderItem view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Solution Order Item for Fin Reporting view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder ServiceDocument Transaction ID
KEY BusinessSolutionOrderItem ServiceDocumentItem Service Document
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentDescription ServiceDocumentDescription
ServiceDocumentType ServiceDocumentType Transaction Type
PostingDate PostingDate Posting Date for GR
BusinessSolutionOrderItemUUID ServiceDocumentItemUUID
ServiceDocumentItemObjectType ServiceDocumentItemObjectType
BusinessSolutionOrderUUID ServiceDocumentUUID Object GUID
ParentServiceDocumentItemUUID ParentServiceDocumentItemUUID
ServiceDocumentItemDescription ServiceDocumentItemDescription
Language Language Report Text Language
OriginallyRequestedProduct OriginallyRequestedProduct
ServiceDocItemCategory ServiceDocItemCategory
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ServiceDocumentItemTaxAmount ServiceDocumentItemTaxAmount
ServiceDocItemGrossAmount ServiceDocItemGrossAmount
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocumentItemQuantity ServiceDocumentItemQuantity
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
ServiceContrItemStartDateTime ServiceContrItemStartDateTime
ServiceContrItemEndDateTime ServiceContrItemEndDateTime
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
SoldToParty SoldToParty Sold-to Party
ResponsibleEmployee ResponsibleEmployee Employee Resp.
ServiceDocumentItemStatus ServiceDocumentItemStatus
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ServiceOrganization ServiceOrganization
ResponsibleServiceOrganization ResponsibleServiceOrganization
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_SalesUnit _SalesUnit
_ServiceDocItemCategory _ServiceDocItemCategory
_ProfitCenter _ProfitCenter
_ControllingArea _ControllingArea
_SoldToParty _SoldToParty
_RespEmployee _RespEmployee
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_DistributionChannel _DistributionChannel
_Division _Division
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_RespSrvcOrganizationOrgUnit _RespSrvcOrganizationOrgUnit
_RespSrvcOrganizationOrgUnit_2 _RespSrvcOrganizationOrgUnit_2
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup

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_BusSolnOrdItmBasicFinancial.
-- 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_BusSolnOrdItmBasicFinancial AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceObjectType,
  ServiceDocumentDescription,
  ServiceDocumentType,
  PostingDate,
  ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID,
  ServiceDocumentItemObjectType,
  ServiceDocumentUUID AS BusinessSolutionOrderUUID,
  ParentServiceDocumentItemUUID,
  ServiceDocumentItemDescription,
  Language,
  OriginallyRequestedProduct,
  ServiceDocItemCategory,
  ProfitCenter,
  ControllingArea,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  ServiceDocItemGrossAmount,
  TransactionCurrency,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  ResponsibleEmployee,
  ServiceDocumentItemStatus,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup
FROM I_ServiceDocumentItemEnhcd
;

Learn More