I_BusinessSolutionOrderTP

DDL: I_BUSINESSSOLUTIONORDERTP Type: view_entity TRANSACTIONAL
57 Fields 1 Data Sources

Business Solution Order - TP

I_BusinessSolutionOrderTP is a Transactional CDS View that provides data about "Business Solution Order - TP" in SAP S/4HANA. It reads from 1 data source (R_BusinessSolutionOrderTP) and exposes 57 fields with key field BusinessSolutionOrder.

Data Sources (1)

SourceAliasJoin Type
R_BusinessSolutionOrderTP R_BusinessSolutionOrderTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BusinessSolutionOrder view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
ObjectModel.representativeKey BusinessSolutionOrder 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 - TP view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
BusSolnOrdType BusSolnOrdType Transaction Type
BusinessSolutionOrderUUID BusinessSolutionOrderUUID Object GUID
BusSolnOrdDescription BusSolnOrdDescription
Language Language Report Text Language
PostingDate PostingDate Posting Date for GR
ServiceDocCreationDateTime ServiceDocCreationDateTime
ServiceDocChangedDateTime ServiceDocChangedDateTime
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser
ServiceDocumentChangedByUser ServiceDocumentChangedByUser
BusSolnOrdExtReference BusSolnOrdExtReference
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.
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
BusSolnOrdIsNew BusSolnOrdIsNew
BusSolnOrdIsInProcess BusSolnOrdIsInProcess
BusSolnOrdIsReleased BusSolnOrdIsReleased
BusSolnOrdIsCompleted BusSolnOrdIsCompleted
BusSolnOrdStatus BusSolnOrdStatus
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
BusSolnOrdHasError BusSolnOrdHasError
PaymentTerms PaymentTerms Pyt Terms
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocNetAmount ServiceDocNetAmount
ServiceDocGrossAmount ServiceDocGrossAmount
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ServiceObjectType ServiceObjectType Object Type
_ContactPerson _ContactPerson
_RespEmployee _RespEmployee
_ServiceObjType _ServiceObjType
_SoldToParty _SoldToParty
_ShipToParty _ShipToParty
_BillToParty _BillToParty
_PayerParty _PayerParty
_PersonResponsible _PersonResponsible
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_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 I_BusinessSolutionOrderTP.
-- 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_BusinessSolutionOrderTP AS
SELECT
  BusinessSolutionOrder,
  BusSolnOrdType,
  BusinessSolutionOrderUUID,
  BusSolnOrdDescription,
  Language,
  PostingDate,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  BusSolnOrdExtReference,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  CustomerPurchaseOrderDate,
  BusSolnOrdIsNew,
  BusSolnOrdIsInProcess,
  BusSolnOrdIsReleased,
  BusSolnOrdIsCompleted,
  BusSolnOrdStatus,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  BusSolnOrdHasError,
  PaymentTerms,
  PurchaseOrderByCustomer,
  TransactionCurrency,
  ServiceDocNetAmount,
  ServiceDocGrossAmount,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ServiceObjectType
FROM R_BusinessSolutionOrderTP
;

Learn More