I_IntactvABOPConfirmation

DDL: I_INTACTVABOPCONFIRMATION Type: view_entity BASIC
37 Fields 1 Data Sources 6 Associations

IBOP Confirmation

I_IntactvABOPConfirmation is a Basic CDS View that provides data about "IBOP Confirmation" in SAP S/4HANA. It reads from 1 data source (atp_ibop_conf) and exposes 37 fields with key field IntactvABOPConfirmationUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
atp_ibop_conf atp_ibop_conf from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_IntactvABOPRequirement _IntactvABOPRequirement $projection.IntactvABOPRequirementUUID = _IntactvABOPRequirement.IntactvABOPRequirementUUID
[0..1] I_IntactvABOPHeader _IntactvABOPHeader $projection.IntactvABOPUUID = _IntactvABOPHeader.IntactvABOPUUID
[0..1] I_ATPRelevantDocumentCategory _ATPRlvtDocumentCategory $projection.ATPRelevantDocumentCategory = _ATPRlvtDocumentCategory.ATPRelevantDocumentCategory
[0..1] I_SalesOrder _SalesOrder $projection.ATPRelevantDocument = _SalesOrder.SalesOrder
[0..1] I_StockTransportOrder _StockTransportOrder $projection.ATPRelevantDocument = _StockTransportOrder.PurchaseOrder
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label IBOP Confirmation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey IntactvABOPConfirmationUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY IntactvABOPConfirmationUUID intactvabopconfirmationuuid IBOP Confirmation UUID
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 atprelevantdocreqscheduleline Schedule Line
ATPRelevantDocConfdSchedLine atprelevantdocconfdschedline Schedule Line
ConfirmedQuantityInBaseUnit confirmedquantityinbaseunit Sum of Confirmed Quantities
BaseUnit baseunit Unit of Measure
ProductAvailabilityDate productavailabilitydate Mat.Avail.Date
ProductAvailabilityTime productavailabilitytime Matl Staging Tme
ProductAvailabilityTimeZone productavailabilitytimezone Time Zone
TransportationPlanningDate transportationplanningdate TranspPlngDate
TransportationPlanningTime transportationplanningtime Tr. Plan. Time
TransportationPlanningTimeZone transportationplanningtimezone Time Zone
LoadingDate loadingdate Loading Date
LoadingTime loadingtime Loading Time
LoadingTimeZone loadingtimezone Time Zone
GoodsIssueDate goodsissuedate Goods Issue Date CCD
GoodsIssueTime goodsissuetime GI Time
GoodsIssueTimeZone goodsissuetimezone Time Zone
DeliveryDate deliverydate Delivery Date
DeliveryTime deliverytime TimeOfDelivery
DeliveryTimeZone deliverytimezone Time Zone
UnloadingDate unloadingdate GR End Date
UnloadingTime unloadingtime GR End Time
UnloadingTimeZone unloadingtimezone Time Zone
PrevConfirmedQtyInBaseUnit prevconfirmedqtyinbaseunit Sum of Confirmed Quantities
PrevProductAvailabilityDate prevproductavailabilitydate Mat.Avail.Date
PrevConfdDeliveryDate prevconfddeliverydate Delivery date
_IntactvABOPHeader _IntactvABOPHeader
_IntactvABOPRequirement _IntactvABOPRequirement
_ATPRlvtDocumentCategory _ATPRlvtDocumentCategory
_SalesOrder _SalesOrder
_StockTransportOrder _StockTransportOrder
_BaseUnit _BaseUnit

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_IntactvABOPConfirmation.
-- 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 I_IntactvABOPConfirmation AS
SELECT
  IntactvABOPConfirmationUUID,
  IntactvABOPRequirementUUID,
  IntactvABOPUUID,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  atprelevantdocreqscheduleline AS ATPRelevantDocScheduleLine,
  ATPRelevantDocConfdSchedLine,
  ConfirmedQuantityInBaseUnit,
  BaseUnit,
  ProductAvailabilityDate,
  ProductAvailabilityTime,
  ProductAvailabilityTimeZone,
  TransportationPlanningDate,
  TransportationPlanningTime,
  TransportationPlanningTimeZone,
  LoadingDate,
  LoadingTime,
  LoadingTimeZone,
  GoodsIssueDate,
  GoodsIssueTime,
  GoodsIssueTimeZone,
  DeliveryDate,
  DeliveryTime,
  DeliveryTimeZone,
  UnloadingDate,
  UnloadingTime,
  UnloadingTimeZone,
  PrevConfirmedQtyInBaseUnit,
  PrevProductAvailabilityDate,
  PrevConfdDeliveryDate
FROM atp_ibop_conf
LEFT OUTER JOIN I_IntactvABOPRequirement AS _IntactvABOPRequirement ON IntactvABOPRequirementUUID = _IntactvABOPRequirement.IntactvABOPRequirementUUID  -- association [0..1]
LEFT OUTER JOIN I_IntactvABOPHeader AS _IntactvABOPHeader ON IntactvABOPUUID = _IntactvABOPHeader.IntactvABOPUUID  -- association [0..1]
LEFT OUTER JOIN I_ATPRelevantDocumentCategory AS _ATPRlvtDocumentCategory ON ATPRelevantDocumentCategory = _ATPRlvtDocumentCategory.ATPRelevantDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON ATPRelevantDocument = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_StockTransportOrder AS _StockTransportOrder ON ATPRelevantDocument = _StockTransportOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;

Learn More