A_BSQItmTechRsceWithSlot

DDL: A_BSQITMTECHRSCEWITHSLOT Type: view_entity COMPOSITE
6 Fields 1 Data Sources 1 Associations

Item Technical Resource With Slot

A_BSQItmTechRsceWithSlot is a Composite CDS View that provides data about "Item Technical Resource With Slot" in SAP S/4HANA. It reads from 1 data source (I_BusSolnQtanItmTechRsce) and exposes 6 fields with key fields BusinessSolutionQuotation, BusSolutionQuotationItem, CATechnicalResourceIDType, CATechnicalResourceIDSlot. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusSolnQtanItmTechRsce I_BusSolnQtanItmTechRsce from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_BusinessSolutionQuotation _BusinessSolutionQuotation $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation

Annotations (11)

NameValueLevelField
EndUserText.label Item Technical Resource With Slot view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation BusinessSolutionQuotation Transaction ID
KEY BusSolutionQuotationItem BusSolutionQuotationItem Item Number in Doc.
KEY CATechnicalResourceIDType CATechnicalResourceIDType Type of ID
KEY CATechnicalResourceIDSlot CATechnicalResourceIDSlot Slot of Tech. Res.
CATechnicalResourceID CATechnicalResourceID ID
_BusinessSolutionQuotation _BusinessSolutionQuotation

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 A_BSQItmTechRsceWithSlot.
-- 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 A_BSQItmTechRsceWithSlot AS
SELECT
  BusinessSolutionQuotation,
  BusSolutionQuotationItem,
  CATechnicalResourceIDType,
  CATechnicalResourceIDSlot,
  CATechnicalResourceID
FROM I_BusSolnQtanItmTechRsce
LEFT OUTER JOIN A_BusinessSolutionQuotation AS _BusinessSolutionQuotation ON BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation  -- association [1..1]
;

Learn More