R_IntactvABOPRequirementTP

DDL: R_INTACTVABOPREQUIREMENTTP Type: view_entity TRANSACTIONAL
35 Fields 1 Data Sources 3 Associations

Interactive BOP Requirements

R_IntactvABOPRequirementTP is a Transactional CDS View that provides data about "Interactive BOP Requirements" in SAP S/4HANA. It reads from 1 data source (I_IntactvABOPRequirement) and exposes 35 fields with key field IntactvABOPRequirementUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_IntactvABOPRequirement I_IntactvABOPRequirement from

Associations (3)

CardinalityTargetAliasCondition
[1..1] P_IntactvABOPDepdntRlvtCheck _DepdntRlvtCheck $projection.ATPRelevantDocument = _DepdntRlvtCheck.ATPRelevantDocument and $projection.ATPRelevantDocumentItem = _DepdntRlvtCheck.ATPRelevantDocumentItem
[1..1] P_IntactvABOPRqmtAddlFields _IntactvABOPRqmtAddlFields $projection.ATPRelevantDocument = _IntactvABOPRqmtAddlFields.ATPRelevantDocument and $projection.ATPRelevantDocumentItem = _IntactvABOPRqmtAddlFields.ATPRelevantDocumentItem and $projection.ATPRelevantDocScheduleLine = _IntactvABOPRqmtAddlFields.ATPRelevantDocScheduleLine
[1..*] R_IntactvABOPConfirmationTP _IntactvABOPConfirmation

Annotations (10)

NameValueLevelField
EndUserText.label Interactive BOP Requirements view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name IntactvAdvncdBkordrProcgRqmt view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY IntactvABOPRequirementUUID IntactvABOPRequirementUUID IBOP Requirement UUID
IntactvABOPUUID IntactvABOPUUID Interactive Backorder Processing UUID
ATPRelevantDocumentCategory ATPRelevantDocumentCategory ATP: Category of Stock / Receipts / Issues
ATPRelevantDocument ATPRelevantDocument MRP element number
ATPRelevantDocumentItem ATPRelevantDocumentItem MRP elemnt item
ATPRelevantDocScheduleLine ATPRelevantDocScheduleLine Scheduling
Product Product Product Sold
Plant Plant Valuation Area
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit Requested Qty
BaseUnit BaseUnit Unit of Measure
SchedLineIsProdAvailyCheckRlvt SchedLineIsProdAvailyCheckRlvt PAC-Relevant
SchedLineIsProdAllocationRlvt SchedLineIsProdAllocationRlvt PAL-Relevant
SchedLineIsSupplyProtRlvt SchedLineIsSupplyProtRlvt Supply Protection
RqmtIsATPChecked RqmtIsATPChecked TRUE
ABOPRunRequirementPriorityVal ABOPRunRequirementPriorityVal Sched. Line Priority
DeliveryGroup DeliveryGroup Delivery Group
AltvBsdConfSubstitutionStatus AltvBsdConfSubstitutionStatus Sub. Status
AltvBsdConfIsDeactivated AltvBsdConfIsDeactivated TRUE
ATPCheckingGroup ATPCheckingGroup Avail. check
ATPCheckingRule ATPCheckingRule Checking rule
OrderedQuantityInBaseUnit OrderedQuantityInBaseUnit Order quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
_ATPRlvtDocumentCategory _ATPRlvtDocumentCategory
_Plant _Plant
_Product _Product
_SalesOrder _SalesOrder
_StockTransportOrder _StockTransportOrder
_BaseUnit _BaseUnit
_IntactvABOPHeader _IntactvABOPHeader
_IntactvABOPConfirmation _IntactvABOPConfirmation
_DepdntRlvtCheck _DepdntRlvtCheck
_AltvBsdConfSubstnSts _AltvBsdConfSubstnSts
_IntactvABOPRqmtAddlFields _IntactvABOPRqmtAddlFields

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 R_IntactvABOPRequirementTP.
-- 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 R_IntactvABOPRequirementTP AS
SELECT
  IntactvABOPRequirementUUID,
  IntactvABOPUUID,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  Product,
  Plant,
  RequestedDeliveryDate,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  SchedLineIsProdAvailyCheckRlvt,
  SchedLineIsProdAllocationRlvt,
  SchedLineIsSupplyProtRlvt,
  RqmtIsATPChecked,
  ABOPRunRequirementPriorityVal,
  DeliveryGroup,
  AltvBsdConfSubstitutionStatus,
  AltvBsdConfIsDeactivated,
  ATPCheckingGroup,
  ATPCheckingRule,
  OrderedQuantityInBaseUnit,
  OrderQuantityUnit,
  ProductAvailabilityDate
FROM I_IntactvABOPRequirement
LEFT OUTER JOIN P_IntactvABOPDepdntRlvtCheck AS _DepdntRlvtCheck ON ATPRelevantDocument = _DepdntRlvtCheck.ATPRelevantDocument AND ATPRelevantDocumentItem = _DepdntRlvtCheck.ATPRelevantDocumentItem  -- association [1..1]
LEFT OUTER JOIN P_IntactvABOPRqmtAddlFields AS _IntactvABOPRqmtAddlFields ON ATPRelevantDocument = _IntactvABOPRqmtAddlFields.ATPRelevantDocument AND ATPRelevantDocumentItem = _IntactvABOPRqmtAddlFields.ATPRelevantDocumentItem AND ATPRelevantDocScheduleLine = _IntactvABOPRqmtAddlFields.ATPRelevantDocScheduleLine  -- association [1..1]
LEFT OUTER JOIN R_IntactvABOPConfirmationTP AS _IntactvABOPConfirmation ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More