I_AlgnmtRunDet

DDL: I_ALGNMTRUNDET SQL: IALIGNMTDET Type: view COMPOSITE Package: RFM_ALIGNMENT_MONITOR
73 Fields 1 Data Sources 6 Associations

Alignment Run

I_AlgnmtRunDet is a Composite CDS View (Cube) that provides data about "Alignment Run" in SAP S/4HANA. It reads from 1 data source (I_PurReqnAlgnmtMntrProdDetails) and exposes 73 fields with key fields PurReqnAlgnmtRunUUID, PurReqnAlignmentID, Product. It has 6 associations to related views. Part of development package RFM_ALIGNMENT_MONITOR.

Data Sources (1)

SourceAliasJoin Type
I_PurReqnAlgnmtMntrProdDetails I_PurReqnAlgnmtMntrProdDetails from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_AlgnmtRunDetFailureReason _FailReason $projection.PurReqnAlignmentID = _FailReason.PurReqnAlignmentID
[1..1] I_PurReqnAlgnmtMntrJobDetails _Head $projection.PurReqnAlgnmtRunUUID = _Head.PurReqnAlgnmtRunUUID
[1..1] I_AlgnmtRunVH _RunValueHelp $projection.PurReqnAlgnmtRunUUID = _RunValueHelp.PurReqnAlgnmtRunUUID
[0..1] I_PurchasingDocument _PurchasingDocument $projection.ProposedPurchasingDocument = _PurchasingDocument.PurchasingDocument
[0..1] I_SalesOrder _SalesOrder $projection.SalesDocument = _SalesOrder.SalesOrder
[1..1] I_Purchaserequisition _PurchaseReqn $projection.PurchaseRequisition = _PurchaseReqn.PurchaseRequisition

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IALIGNMTDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Alignment Run view
VDM.viewType #COMPOSITE view
Analytics.internalName #LOCAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY PurReqnAlgnmtRunUUID PurReqnAlgnmtRunUUID
KEY PurReqnAlignmentID PurReqnAlignmentID
KEY Product Product Product Sold
ProductGroup _Product ProductGroup Product Sold Group
CrossPlantConfigurableProduct _Product CrossPlantConfigurableProduct Cross-plant CP
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
SalesDocument _PurReqnAcctAssgmt SalesOrder SD Document
SalesDocumentItem _PurReqnAcctAssgmt SalesOrderItem Sales Order Item
RequestedQuantity RequestedQuantity Requested Quantity
PurchaseRequisitionUnit PurchaseRequisitionUnit
PurchaseRequisitionItemPlant PurchaseRequisitionItemPlant
PurReqnItemPlantName PurReqnItemPlantName Plant Name
PurchaseReqnItemSeasonYear PurchaseReqnItemSeasonYear
PurchaseReqnItemSeason PurchaseReqnItemSeason
PurchaseReqnItemCollection PurchaseReqnItemCollection
PurchaseReqnItemTheme PurchaseReqnItemTheme
SalesOrganization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SoldToParty
CustomerGroup
SalesOrderType
RequestedDeliveryDate
FashionCancelDate
TransactionCurrency
NetAmount
PurchaseReqnItemStockSegment PurchaseReqnItemStockSegment
ProposedPurchasingDocument ProposedPurchasingDocument
ProposedPurchasingDocumentItem ProposedPurchasingDocumentItem
PurchaseOrderSupplier PurchaseOrderSupplier
PurchaseOrderSupplierName _PurchaseOrderSupplier SupplierName Supplier Name
PurchasingDocumentType _PurchaseReqn PurchaseRequisitionType Order Type
PurchasingOrganization _PurchasingDocument PurchasingOrganization Purchasing Organization
PurchasingOrganizationName
PurchasingGroup _PurchasingDocument PurchasingGroup Purchasing Group
PurOrderItemPlant PurOrderItemPlant
PurOrdItemPlantName PurOrdItemPlantName Plant Name
PurchaseOrderItemSeasonYear PurchaseOrderItemSeasonYear
PurchaseOrderItemSeason PurchaseOrderItemSeason
PurchaseOrderItemCollection PurchaseOrderItemCollection
PurchaseOrderItemTheme PurchaseOrderItemTheme
PurchaseOrderItemStockSegment PurchaseOrderItemStockSegment
AlignedPurchasingDocument AlignedPurchasingDocument
AlignedPurchasingDocumentItem AlignedPurchasingDocumentItem
PurReqnHasAlignmentProposal PurReqnHasAlignmentProposal
AlignedPurOrdItmQtyInBaseUoM AlignedPurOrdItmQtyInBaseUoM
AlignedPurOrdItemBaseUnit AlignedPurOrdItemBaseUnit
PurchasingDocumentItemUniqueID PurchasingDocumentItemUniqueID Document Item
ReasonCode _FailReason ReasonCode Reason Code
RFMAlgnmtRunRsnCode _FailReason RFMAlgnmtRunRsnCode
PurReqnHasCrossPlantAlignment PurReqnHasCrossPlantAlignment
PurReqnHasCrossSeasonAlignment PurReqnHasCrossSeasonAlignment
PurReqnHasCrossSgmtAlignment PurReqnHasCrossSgmtAlignment
PurReqnCrsSeasonAlgnmtName PurReqnCrsSeasonAlgnmtName
PurReqnCrsPlantAlgnmtName PurReqnCrsPlantAlgnmtName
PurReqnHasCrossSgmtAlgnmtName PurReqnHasCrossSgmtAlgnmtName
ProductCategory _Product ProductCategory Prod Category
PurReqnAlgnmtRunText _Head PurReqnAlgnmtRunText
UserName _Head UserName User who owns item
StartDate _Head StartDate Valid From
PurReqnAlgnmtRunStatus _Head PurReqnAlgnmtRunStatus
PurReqnAlgnmtRunMode _Head PurReqnAlgnmtRunMode
AlgnmtAggrgQtyUnitOfMsmt
_Product _Product
_PurReqnItemPlant _PurReqnItemPlant
_Head _Head
_RunValueHelp _RunValueHelp
_PurchasingDocument _PurchasingDocument
_SalesOrder _SalesOrder
_FailReason _FailReason
_TransactionCurrency
_PurchaseReqn _PurchaseReqn

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_AlgnmtRunDet.
-- 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: IALIGNMTDET

CREATE VIEW I_AlgnmtRunDet AS
SELECT
  PurReqnAlgnmtRunUUID,
  PurReqnAlignmentID,
  Product,
  _Product.ProductGroup AS ProductGroup,
  _Product.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  _PurReqnAcctAssgmt.SalesOrder AS SalesDocument,
  _PurReqnAcctAssgmt.SalesOrderItem AS SalesDocumentItem,
  RequestedQuantity,
  PurchaseRequisitionUnit,
  PurchaseRequisitionItemPlant,
  PurReqnItemPlantName,
  PurchaseReqnItemSeasonYear,
  PurchaseReqnItemSeason,
  PurchaseReqnItemCollection,
  PurchaseReqnItemTheme,
  _PurReqnAcctAssgmt._SalesOrder.SalesOrganization AS SalesOrganization,
  DistributionChannel,
  Division,
  _PurReqnAcctAssgmt._SalesOrder.SoldToParty AS SoldToParty,
  _PurReqnAcctAssgmt._SalesOrder.CustomerGroup AS CustomerGroup,
  _PurReqnAcctAssgmt._SalesOrder.SalesOrderType AS SalesOrderType,
  _PurReqnAcctAssgmt._SalesOrder.RequestedDeliveryDate AS RequestedDeliveryDate,
  _PurReqnAcctAssgmt._SalesOrder.FashionCancelDate AS FashionCancelDate,
  _PurReqnAcctAssgmt._SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  cast(_PurReqnAcctAssgmt._SalesOrderItem.NetPriceAmount * AlignedPurOrdItmQtyInBaseUoM as netwr) AS NetAmount,
  PurchaseReqnItemStockSegment,
  ProposedPurchasingDocument,
  ProposedPurchasingDocumentItem,
  PurchaseOrderSupplier,
  _PurchaseOrderSupplier.SupplierName AS PurchaseOrderSupplierName,
  _PurchaseReqn.PurchaseRequisitionType AS PurchasingDocumentType,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocument._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  PurOrderItemPlant,
  PurOrdItemPlantName,
  PurchaseOrderItemSeasonYear,
  PurchaseOrderItemSeason,
  PurchaseOrderItemCollection,
  PurchaseOrderItemTheme,
  PurchaseOrderItemStockSegment,
  AlignedPurchasingDocument,
  AlignedPurchasingDocumentItem,
  PurReqnHasAlignmentProposal,
  AlignedPurOrdItmQtyInBaseUoM,
  AlignedPurOrdItemBaseUnit,
  PurchasingDocumentItemUniqueID,
  _FailReason.ReasonCode AS ReasonCode,
  _FailReason.RFMAlgnmtRunRsnCode AS RFMAlgnmtRunRsnCode,
  PurReqnHasCrossPlantAlignment,
  PurReqnHasCrossSeasonAlignment,
  PurReqnHasCrossSgmtAlignment,
  PurReqnCrsSeasonAlgnmtName,
  PurReqnCrsPlantAlgnmtName,
  PurReqnHasCrossSgmtAlgnmtName,
  _Product.ProductCategory AS ProductCategory,
  _Head.PurReqnAlgnmtRunText AS PurReqnAlgnmtRunText,
  _Head.UserName AS UserName,
  _Head.StartDate AS StartDate,
  _Head.PurReqnAlgnmtRunStatus AS PurReqnAlgnmtRunStatus,
  _Head.PurReqnAlgnmtRunMode AS PurReqnAlgnmtRunMode,
  cast( ' ' as meins ) AS AlgnmtAggrgQtyUnitOfMsmt,
  _PurReqnAcctAssgmt._SalesOrderItem._TransactionCurrency AS _TransactionCurrency
FROM I_PurReqnAlgnmtMntrProdDetails
LEFT OUTER JOIN I_AlgnmtRunDetFailureReason AS _FailReason ON PurReqnAlignmentID = _FailReason.PurReqnAlignmentID  -- association [1..1]
LEFT OUTER JOIN I_PurReqnAlgnmtMntrJobDetails AS _Head ON PurReqnAlgnmtRunUUID = _Head.PurReqnAlgnmtRunUUID  -- association [1..1]
LEFT OUTER JOIN I_AlgnmtRunVH AS _RunValueHelp ON PurReqnAlgnmtRunUUID = _RunValueHelp.PurReqnAlgnmtRunUUID  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON ProposedPurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesDocument = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseReqn ON PurchaseRequisition = _PurchaseReqn.PurchaseRequisition  -- association [1..1]
;

Learn More