I_BusinessSolutionOrderItemTP

DDL: I_BUSINESSSOLUTIONORDERITEMTP Type: view_entity TRANSACTIONAL
105 Fields 1 Data Sources

Business Solution Order Item - TP

I_BusinessSolutionOrderItemTP is a Transactional CDS View that provides data about "Business Solution Order Item - TP" in SAP S/4HANA. It reads from 1 data source (R_BusinessSolutionOrderItemTP) and exposes 105 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem.

Data Sources (1)

SourceAliasJoin Type
R_BusinessSolutionOrderItemTP R_BusinessSolutionOrderItemTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
ObjectModel.representativeKey BusinessSolutionOrderItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Business Solution Order Item - TP view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem Solution Order Item
ParentBusSolnOrdItem ParentBusSolnOrdItem Service Document
BusSolnOrdItmCategory BusSolnOrdItmCategory
BusinessSolutionOrderItemUUID BusinessSolutionOrderItemUUID
ServiceDocumentItemCharUUID ServiceDocumentItemCharUUID
BusSolnOrdItmDescription BusSolnOrdItmDescription
Language Language Report Text Language
PostingDate PostingDate Posting Date for GR
PlannedServiceStartDateTime PlannedServiceStartDateTime
PlannedServiceEndDateTime PlannedServiceEndDateTime
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
RequestedDeliveryUTCDateTime RequestedDeliveryUTCDateTime Req. Delivery Date
ServiceDocItemCreationDateTime ServiceDocItemCreationDateTime
ServiceDocItemChangedDateTime ServiceDocItemChangedDateTime
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser
ServiceDocItemChangedByUser ServiceDocItemChangedByUser
BusSolnOrdExtReference BusSolnOrdExtReference
BusSolnOrdItmExtReference BusSolnOrdItmExtReference
Product Product Product Sold
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person Key
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
ProjectManager ProjectManager Busn. Partner
ServicePerformer ServicePerformer Service Performer
BusSolnOrdItmIsNew BusSolnOrdItmIsNew
BusSolnOrdItmIsInProcess BusSolnOrdItmIsInProcess
BusSolnOrdItmIsReleased BusSolnOrdItmIsReleased
BusSolnOrdItmIsCompleted BusSolnOrdItmIsCompleted
BusSolnOrdItmStatus BusSolnOrdItmStatus
BusSolnOrdItmIsRejected BusSolnOrdItmIsRejected
ServiceDocItemBillingStatus ServiceDocItemBillingStatus
SrvcDocItmDeliveryStatus SrvcDocItmDeliveryStatus
SrvcDocItemTransferStatus SrvcDocItemTransferStatus
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
EnterpriseProjectServiceOrg EnterpriseProjectServiceOrg Service Org.
ReferenceServiceContract ReferenceServiceContract
ReferenceServiceContractItem ReferenceServiceContractItem
SrvcContrDetnIsSpprsd SrvcContrDetnIsSpprsd
BillingBlockReason BillingBlockReason
BusSolnOrdItmRjcnReason BusSolnOrdItmRjcnReason
MaterialPricingGroup MaterialPricingGroup
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
PaymentTerms PaymentTerms Pyt Terms
ProfitCenter ProfitCenter Profit Center
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit SrvcContrItemExtnDurationUnit
SrvcMgmtBillgPlanBillgDateRule SrvcMgmtBillgPlanBillgDateRule
SettlementPeriodRule SettlementPeriodRule
SubscrpnContrTrmsAreSpecified SubscrpnContrTrmsAreSpecified
MidBillgCycExprtnIsAllowed MidBillgCycExprtnIsAllowed
SubscrpnContrAutoRnwlIsActv SubscrpnContrAutoRnwlIsActv
SubscriptionBillingCycle SubscriptionBillingCycle
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ItemGrossWeight ItemGrossWeight Gross Weight
ItemNetWeight ItemNetWeight Net Weight
ItemVolume ItemVolume Volume
ItemVolumeUnit ItemVolumeUnit Volume Unit
ItemWeightUnit ItemWeightUnit Unit of Weight
DeliveryBlockReason DeliveryBlockReason Delivery Block
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent Order Probab.
IncotermsPart1 IncotermsPart1 Incoterms
IncotermsPart2 IncotermsPart2 Incoterms 2
OrderCombinationIsAllowed OrderCombinationIsAllowed Order Combinat.
DeliveryGroup DeliveryGroup Delivery Group
DeliveryPriority DeliveryPriority Delivery Prior.
Plant Plant Valuation Area
ResponseProfile ResponseProfile Response Prof.
ServiceProfile ServiceProfile Service Profile
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceObjectType ServiceObjectType Object Type
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SrvcDocItmApptRefObjectUUID SrvcDocItmApptRefObjectUUID
_SoldToParty _SoldToParty
_ShipToParty _ShipToParty
_BillToParty _BillToParty
_PayerParty _PayerParty
_ContactPerson _ContactPerson
_RespEmployee _RespEmployee
_BusSolnOrdItemStatus _BusSolnOrdItemStatus
_RejectionReasonText _RejectionReasonText
_ServiceDocument _ServiceDocument
_Product _Product
_TransactionCurrency _TransactionCurrency
_ServiceDocItemRejectionReason _ServiceDocItemRejectionReason
_ServiceObjType _ServiceObjType

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_BusinessSolutionOrderItemTP.
-- 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_BusinessSolutionOrderItemTP AS
SELECT
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ParentBusSolnOrdItem,
  BusSolnOrdItmCategory,
  BusinessSolutionOrderItemUUID,
  ServiceDocumentItemCharUUID,
  BusSolnOrdItmDescription,
  Language,
  PostingDate,
  PlannedServiceStartDateTime,
  PlannedServiceEndDateTime,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  RequestedDeliveryUTCDateTime,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  BusSolnOrdExtReference,
  BusSolnOrdItmExtReference,
  Product,
  Quantity,
  QuantityUnit,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  ProjectManager,
  ServicePerformer,
  BusSolnOrdItmIsNew,
  BusSolnOrdItmIsInProcess,
  BusSolnOrdItmIsReleased,
  BusSolnOrdItmIsCompleted,
  BusSolnOrdItmStatus,
  BusSolnOrdItmIsRejected,
  ServiceDocItemBillingStatus,
  SrvcDocItmDeliveryStatus,
  SrvcDocItemTransferStatus,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ResponsibleCostCenter,
  EnterpriseProjectServiceOrg,
  ReferenceServiceContract,
  ReferenceServiceContractItem,
  SrvcContrDetnIsSpprsd,
  BillingBlockReason,
  BusSolnOrdItmRjcnReason,
  MaterialPricingGroup,
  PartialDeliveryIsAllowed,
  PaymentTerms,
  ProfitCenter,
  PurchaseOrderByCustomer,
  TimeSheetOvertimeCategory,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  SrvcMgmtBillgPlanBillgDateRule,
  SettlementPeriodRule,
  SubscrpnContrTrmsAreSpecified,
  MidBillgCycExprtnIsAllowed,
  SubscrpnContrAutoRnwlIsActv,
  SubscriptionBillingCycle,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ItemGrossWeight,
  ItemNetWeight,
  ItemVolume,
  ItemVolumeUnit,
  ItemWeightUnit,
  DeliveryBlockReason,
  ItemOrderProbabilityInPercent,
  IncotermsPart1,
  IncotermsPart2,
  OrderCombinationIsAllowed,
  DeliveryGroup,
  DeliveryPriority,
  Plant,
  ResponseProfile,
  ServiceProfile,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ServiceDocumentType,
  ServiceObjectType,
  SalesOrganizationOrgUnitID,
  SrvcDocItmApptRefObjectUUID
FROM R_BusinessSolutionOrderItemTP
;

Learn More