C_IntactvABOPRequirementTP

DDL: C_INTACTVABOPREQUIREMENTTP Type: view_entity CONSUMPTION
44 Fields 1 Data Sources 1 Associations 1 OData Services

Interactive BOP Requirement

C_IntactvABOPRequirementTP is a Consumption CDS View that provides data about "Interactive BOP Requirement" in SAP S/4HANA. It reads from 1 data source (R_IntactvABOPRequirementTP) and exposes 44 fields with key field IntactvABOPRequirementUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_INTACTV_ADVNCD_BOP_M).

Data Sources (1)

SourceAliasJoin Type
R_IntactvABOPRequirementTP R_IntactvABOPRequirementTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_IntactvABOPRequirementTP _DeliveryGroup $projection.IntactvABOPUUID = _DeliveryGroup.IntactvABOPUUID and $projection.ATPRelevantDocumentCategory = _DeliveryGroup.ATPRelevantDocumentCategory and $projection.ATPRelevantDocument = _DeliveryGroup.ATPRelevantDocument and $projection.DeliveryGroup = _DeliveryGroup.DeliveryGroup

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Interactive BOP Requirement view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_INTACTV_ADVNCD_BOP_M UI_INTACTV_ADVNCD_BOP_04 V4 C1 NOT_RELEASED

Fields (44)

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 Requirement
ATPRelevantDocumentItem ATPRelevantDocumentItem Item
ATPRelevantDocScheduleLine ATPRelevantDocScheduleLine Scheduling
Product Product Product Sold
ProductName Material Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit Requested Qty
BaseUnit BaseUnit Unit of Measure
virtualMissingQuantitybsatp_sum_cnfqty
virtualRqmtIsLockedboole_d Locked
SchedLineIsProdAvailyCheckRlvt SchedLineIsProdAvailyCheckRlvt PAL-Relevant
SchedLineIsProdAllocationRlvt SchedLineIsProdAllocationRlvt PAC-Relevant
SchedLineIsSupplyProtRlvt SchedLineIsSupplyProtRlvt SUP-Relevant
ABOPRunRequirementPriorityVal ABOPRunRequirementPriorityVal Sched. Line Priority
RqmtIsATPChecked RqmtIsATPChecked TRUE
DeliveryGroup DeliveryGroup Delivery Group
AltvBsdConfSubstitutionStatus AltvBsdConfSubstitutionStatus Sub. Status
AltvBsdConfSubStatusDesc
AltvBsdConfIsDeactivated AltvBsdConfIsDeactivated TRUE
ATPCheckingGroup ATPCheckingGroup Avail. check
ATPCheckingRule ATPCheckingRule Checking rule
OrderedQuantityInBaseUnit OrderedQuantityInBaseUnit Order quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
Customer _DepdntRlvtCheck Customer Recipient
CustomerName _DepdntRlvtCheck CustomerName Name of Customer
ATPRqmtHasDeliveryGroup _DepdntRlvtCheck ATPRqmtHasDeliveryGroup
ATPRqmtHasAltvBsdConf _DepdntRlvtCheck ATPRqmtHasAltvBsdConf
ATPRqmtHasBOM _DepdntRlvtCheck ATPRqmtHasBOM
HigherLevelItem _DepdntRlvtCheck HigherLevelItem Higher-Lev.Item
ATPFCFSPriorityValue _IntactvABOPRqmtAddlFields ATPFCFSPriorityValue FCFS Priority
_ATPRlvtDocumentCategory _ATPRlvtDocumentCategory
_SalesOrder _SalesOrder
_StockTransportOrder _StockTransportOrder
_BaseUnit _BaseUnit
_Plant _Plant
_Product _Product
_DeliveryGroup _DeliveryGroup
_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 C_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 C_IntactvABOPRequirementTP AS
SELECT
  IntactvABOPRequirementUUID,
  IntactvABOPUUID,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  Product,
  _Product._Text[1:Language=$session.system_language].ProductName AS ProductName,
  Plant,
  _Plant.PlantName AS PlantName,
  RequestedDeliveryDate,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  virtual MissingQuantity : bsatp_sum_cnfqty AS virtualMissingQuantitybsatp_sum_cnfqty,
  virtual RqmtIsLocked : boole_d AS virtualRqmtIsLockedboole_d,
  SchedLineIsProdAvailyCheckRlvt,
  SchedLineIsProdAllocationRlvt,
  SchedLineIsSupplyProtRlvt,
  ABOPRunRequirementPriorityVal,
  RqmtIsATPChecked,
  DeliveryGroup,
  AltvBsdConfSubstitutionStatus,
  _AltvBsdConfSubstnSts._Text[1:Language=$session.system_language].AltvBsdConfSubStatusDesc AS AltvBsdConfSubStatusDesc,
  AltvBsdConfIsDeactivated,
  ATPCheckingGroup,
  ATPCheckingRule,
  OrderedQuantityInBaseUnit,
  OrderQuantityUnit,
  ProductAvailabilityDate,
  _DepdntRlvtCheck.Customer AS Customer,
  _DepdntRlvtCheck.CustomerName AS CustomerName,
  _DepdntRlvtCheck.ATPRqmtHasDeliveryGroup AS ATPRqmtHasDeliveryGroup,
  _DepdntRlvtCheck.ATPRqmtHasAltvBsdConf AS ATPRqmtHasAltvBsdConf,
  _DepdntRlvtCheck.ATPRqmtHasBOM AS ATPRqmtHasBOM,
  _DepdntRlvtCheck.HigherLevelItem AS HigherLevelItem,
  _IntactvABOPRqmtAddlFields.ATPFCFSPriorityValue AS ATPFCFSPriorityValue
FROM R_IntactvABOPRequirementTP
LEFT OUTER JOIN C_IntactvABOPRequirementTP AS _DeliveryGroup ON IntactvABOPUUID = _DeliveryGroup.IntactvABOPUUID AND ATPRelevantDocumentCategory = _DeliveryGroup.ATPRelevantDocumentCategory AND ATPRelevantDocument = _DeliveryGroup.ATPRelevantDocument AND DeliveryGroup = _DeliveryGroup.DeliveryGroup  -- association [1..*]
;

Learn More