C_ABOPRunIterationRqmt_2

DDL: C_ABOPRUNITERATIONRQMT_2 Type: view_entity CONSUMPTION

Requested Schedule Line in BOP

C_ABOPRunIterationRqmt_2 is a Consumption CDS View that provides data about "Requested Schedule Line in BOP" in SAP S/4HANA. It reads from 1 data source (I_ABOPRunIterationRqmt_2) and exposes 69 fields with key field ATPRequirementUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ABOPRunIterationRqmt_2 I_ABOPRunIterationRqmt_2 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ABOPRunItrtnConfirmation_2 _Confirmations $projection.ATPRequirementUUID = _Confirmations.ATPRequirementUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Requested Schedule Line in BOP view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY ATPRequirementUUID ATPRequirementUUID Requirement UUID
ATPCheckIterationUUID ATPCheckIterationUUID Check Iteration UUID
ATPCheckUUID ATPCheckUUID Check ID
AssignedATPRelevantDocument AssignedATPRelevantDocument Sales Order
ATPRelevantDocumentItem ATPRelevantDocumentItem MRP elemnt item
ATPRelevantDocScheduleLine ATPRelevantDocScheduleLine Scheduling
ATPRelevantDocumentCategory ATPRelevantDocumentCategory ATP: Category of Stock / Receipts / Issues
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
ProductName
PlantName _SupplyingPlant PlantName Plant Name
StorageLocationName _SupplyingStorageLocation StorageLocationName Storage Loc. Name
ABOPConfirmationStrategy ABOPConfirmationStrategy Confirmation Strategy
ABOPConfirmationStrategyText _ABOPStrategyText ABOPConfirmationStrategyText Strategy Description
Recipient Recipient To
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
IdentifiableRecipient IdentifiableRecipient Recipient
RecipientText RecipientText Recipient Description
ATPRecipientType ATPRecipientType
SourceDocumentSemanticObject SourceDocumentSemanticObject
ABOPRqmtEvaluationSequence ABOPRqmtEvaluationSequence Processing Sequence
ABOPSegmentUUID ABOPSegmentUUID BOP Segment UUID
ABOPSegmentName ABOPSegmentName Segment Name
ABOPSegmentDescription ABOPSegmentDescription Segment Description
ReqdProdAvailabilityUTCDateTme ReqdProdAvailabilityUTCDateTme Requested Date
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit Requested Qty
ErlstConfdProdAvailyDteTmeBfr ErlstConfdProdAvailyDteTmeBfr Earliest Confirmation Data Before
ErlstConfdProdAvailyDteTmeAft ErlstConfdProdAvailyDteTmeAft Earliest Confirmation Data After
LatestConfdProdAvailyDteTmeBfr LatestConfdProdAvailyDteTmeBfr Latest Confirmation Data Before
LatestConfdProdAvailyDteTmeAft LatestConfdProdAvailyDteTmeAft Latest Confirmation Data After
ConfdQtyBeforeRunInBaseUnit ConfdQtyBeforeRunInBaseUnit Confirmation Qty Before
ConfdQtyAfterRunInBaseUnit ConfdQtyAfterRunInBaseUnit Confirmation Qty After
RqmtHasSubstitutionsAfterRun RqmtHasSubstitutionsAfterRun
RqmtIsSupAssgmtRelevant RqmtIsSupAssgmtRelevant
OnTimeConfdQtyBfrRunInBaseUnit OnTimeConfdQtyBfrRunInBaseUnit On-Time Confirmation Qty Before
OnTimeConfdQtyAftRunInBaseUnit OnTimeConfdQtyAftRunInBaseUnit On-Time Confirmation Qty After
ErlstConfdQtyBfrRunInBaseUnit ErlstConfdQtyBfrRunInBaseUnit Earliest Confirmation Qty Before
ErlstConfdQtyAftRunInBaseUnit ErlstConfdQtyAftRunInBaseUnit Earliest Confirmation Qty After
NumberOfRequirementsWithIssues NumberOfRequirementsWithIssues
NmbrOfRqmtsWithOrderUpdtIssues NmbrOfRqmtsWithOrderUpdtIssues
ATPCheckItemStatus ATPCheckItemStatus
ABOPRqmtSelectionChangeType ABOPRqmtSelectionChangeType Requirement Change Type
ABOPRqmtSelectionChangeTypeTxt ABOPRqmtSelectionChangeTypeTxt Requirement Change Type Description
ATPCheckIterationHasAborted ATPCheckIterationHasAborted
AdvancedATPIsActive AdvancedATPIsActive
BaseUnit BaseUnit Unit of Measure
ATPConfirmationStatus ATPConfirmationStatus
ABOPRunStatus ABOPRunStatus
ATPCheckItemStatusText ATPCheckItemStatusText
ATPConfirmationStatusDesc ATPConfirmationStatusDesc
RqmtIsFullyConfdAfterRun RqmtIsFullyConfdAfterRun
RqmtIsFullyConfdOnTimeAfterRun RqmtIsFullyConfdOnTimeAfterRun
SupAssgmtQtyAftRunInBaseUnit SupAssgmtQtyAftRunInBaseUnit
SupAssgmtQtyBfrRunInBaseUnit SupAssgmtQtyBfrRunInBaseUnit
SupAssgmtItemStatus SupAssgmtItemStatus
SupAssgmtItemStatusText SupAssgmtItemStatusText
ReqdProdAvailabilityTimeZone ReqdProdAvailabilityTimeZone Time Zone
LatestConfdProdAvailyTmznBfr LatestConfdProdAvailyTmznBfr
ErlstConfdProdAvailyTmznBfr ErlstConfdProdAvailyTmznBfr
ErlstConfdProdAvailyTmznAft ErlstConfdProdAvailyTmznAft
LatestConfdProdAvailyTmznAft LatestConfdProdAvailyTmznAft
LatestSupAssgmtTmznBeforeRun LatestSupAssgmtTmznBeforeRun
_Confirmations _Confirmations
_ABOPStrategyText _ABOPStrategyText
_ProductText _ProductText
_SupplyingPlant _SupplyingPlant
_SupplyingStorageLocation _SupplyingStorageLocation
_ItemStatusText _ItemStatusText

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 C_ABOPRunIterationRqmt_2.
-- 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 C_ABOPRunIterationRqmt_2 AS
SELECT
  ATPRequirementUUID,
  ATPCheckIterationUUID,
  ATPCheckUUID,
  AssignedATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  ATPRelevantDocumentCategory,
  Material,
  Plant,
  StorageLocation,
  _ProductText[1: Language = $session.system_language ].ProductName AS ProductName,
  _SupplyingPlant.PlantName AS PlantName,
  _SupplyingStorageLocation.StorageLocationName AS StorageLocationName,
  ABOPConfirmationStrategy,
  _ABOPStrategyText.ABOPConfirmationStrategyText AS ABOPConfirmationStrategyText,
  Recipient,
  IsBusinessPurposeCompleted,
  IdentifiableRecipient,
  RecipientText,
  ATPRecipientType,
  SourceDocumentSemanticObject,
  ABOPRqmtEvaluationSequence,
  ABOPSegmentUUID,
  ABOPSegmentName,
  ABOPSegmentDescription,
  ReqdProdAvailabilityUTCDateTme,
  RequestedQuantityInBaseUnit,
  ErlstConfdProdAvailyDteTmeBfr,
  ErlstConfdProdAvailyDteTmeAft,
  LatestConfdProdAvailyDteTmeBfr,
  LatestConfdProdAvailyDteTmeAft,
  ConfdQtyBeforeRunInBaseUnit,
  ConfdQtyAfterRunInBaseUnit,
  RqmtHasSubstitutionsAfterRun,
  RqmtIsSupAssgmtRelevant,
  OnTimeConfdQtyBfrRunInBaseUnit,
  OnTimeConfdQtyAftRunInBaseUnit,
  ErlstConfdQtyBfrRunInBaseUnit,
  ErlstConfdQtyAftRunInBaseUnit,
  NumberOfRequirementsWithIssues,
  NmbrOfRqmtsWithOrderUpdtIssues,
  ATPCheckItemStatus,
  ABOPRqmtSelectionChangeType,
  ABOPRqmtSelectionChangeTypeTxt,
  ATPCheckIterationHasAborted,
  AdvancedATPIsActive,
  BaseUnit,
  ATPConfirmationStatus,
  ABOPRunStatus,
  ATPCheckItemStatusText,
  ATPConfirmationStatusDesc,
  RqmtIsFullyConfdAfterRun,
  RqmtIsFullyConfdOnTimeAfterRun,
  SupAssgmtQtyAftRunInBaseUnit,
  SupAssgmtQtyBfrRunInBaseUnit,
  SupAssgmtItemStatus,
  SupAssgmtItemStatusText,
  ReqdProdAvailabilityTimeZone,
  LatestConfdProdAvailyTmznBfr,
  ErlstConfdProdAvailyTmznBfr,
  ErlstConfdProdAvailyTmznAft,
  LatestConfdProdAvailyTmznAft,
  LatestSupAssgmtTmznBeforeRun
FROM I_ABOPRunIterationRqmt_2
LEFT OUTER JOIN C_ABOPRunItrtnConfirmation_2 AS _Confirmations ON ATPRequirementUUID = _Confirmations.ATPRequirementUUID  -- association [0..*]
;