I_ABOPVariantSimlnSchedLine

DDL: I_ABOPVARIANTSIMLNSCHEDLINE SQL: IABOPVARSIMSL Type: view BASIC

ABOP Variant Simulation Schedule Line

I_ABOPVariantSimlnSchedLine is a Basic CDS View that provides data about "ABOP Variant Simulation Schedule Line" in SAP S/4HANA. It reads from 1 data source (atp_bop_var_smsl) and exposes 20 fields with key field ABOPVariantSimlnSchedLineUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
atp_bop_var_smsl atp_bop_var_smsl from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ABOPVariantSimulation _Simulation _Simulation.ABOPVariantSimulationUUID = $projection.ABOPVariantSimulationUUID
[1..1] I_ABOPVariant _Variant _Variant.ABOPVariantUUID = $projection.ABOPVariantUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IABOPVARSIMSL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label ABOP Variant Simulation Schedule Line view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ABOPVariantSimlnSchedLineUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ABOPVariantSimlnSchedLineUUID abopvariantsimlnschedlineuuid Simulation Sline ID
ABOPVariantSimulationUUID abopvariantsimulationuuid Simulation UUID
ABOPVariantUUID abopvariantuuid BOP Variant UUID
ATPRelevantDocumentCategory atprelevantdocumentcategory ATP: Category of Stock / Receipts / Issues
ATPRelevantDocument atprelevantdocument MRP element number
ATPRelevantDocumentItem atprelevantdocumentitem MRP elemnt item
ATPRelevantDocScheduleLine atprelevantdocscheduleline Scheduling
SelectionSequencePosition selectionsequenceposition Sched. Line Priority
ABOPSegmentUUID abopsegmentuuid BOP Segment UUID
ABOPSegmentName abopsegmentname Segment Name
ABOPConfirmationStrategy abopconfirmationstrategy Confirmation Strategy
Product product Product Sold
Plant plant Valuation Area
Recipient recipient To
SchedLineIsProdAvailyCheckRlvt schedlineisprodavailycheckrlvt PAC-Relevant
SchedLineIsProdAllocationRlvt schedlineisprodallocationrlvt PAL-Relevant
SchedLineIsSupplyAssgmtRlvt schedlineissupplyassgmtrlvt ARun-Relevant
ScheduleLineIsSelected schedulelineisselected TRUE
_Simulation _Simulation
_Variant _Variant

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_ABOPVariantSimlnSchedLine.
-- 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: IABOPVARSIMSL

CREATE VIEW I_ABOPVariantSimlnSchedLine AS
SELECT
  ABOPVariantSimlnSchedLineUUID,
  ABOPVariantSimulationUUID,
  ABOPVariantUUID,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  SelectionSequencePosition,
  ABOPSegmentUUID,
  ABOPSegmentName,
  ABOPConfirmationStrategy,
  Product,
  Plant,
  Recipient,
  SchedLineIsProdAvailyCheckRlvt,
  SchedLineIsProdAllocationRlvt,
  SchedLineIsSupplyAssgmtRlvt,
  ScheduleLineIsSelected
FROM atp_bop_var_smsl
LEFT OUTER JOIN I_ABOPVariantSimulation AS _Simulation ON _Simulation.ABOPVariantSimulationUUID = ABOPVariantSimulationUUID  -- association [1..1]
LEFT OUTER JOIN I_ABOPVariant AS _Variant ON _Variant.ABOPVariantUUID = ABOPVariantUUID  -- association [1..1]
;