I_AlgnmtRunDet

Alignment Run | view: IALIGNMTDET | TRAN | Extraction: Not supported | Component: Purchasing
Column Name Description
PurReqnAlgnmtRunUUID RunId GUID
PurReqnAlignmentID Alignment GUID
Product Material Number
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value in Document Currency
Column Name Description
📏 Base Unit of Measure (AlgnmtAggrgQtyUnitOfMsmt):
RequestedQuantity Purchase requisition quantity
AlignedPurOrdItmQtyInBaseUoM Quantity
Column Name Description
RequestedDeliveryDate Requested Delivery Date
FashionCancelDate Cancellation Date
Column Name Description
PurReqnHasCrossPlantAlignment Cross plant indicator Show values
PurReqnHasCrossSeasonAlignment Cross season indicator Show values
PurReqnHasCrossSgmtAlignment Align PReq to PO having different stock segment Show values
ProductCategory Product Category Show values
PurReqnAlgnmtRunStatus Alignment Status Show values
PurReqnAlgnmtRunMode Run Mode Show values
Column Name Description Domain name
PurchaseRequisition Purchase Requisition Number BANFN
PurchaseRequisitionItem Item number of purchase requisition BNFPO
SalesDocument Sales and Distribution Document Number VBELN
SalesDocumentItem Sales Document Item POSNR
PurchaseRequisitionItemPlant Plant WERKS
PurReqnItemPlantName Plant Name TEXT30
PurchaseReqnItemSeasonYear Season Year FSH_CJAHR
PurchaseReqnItemSeason Season RFM_SAISO
PurchaseReqnItemCollection Fashion Collection FSH_COLLECTION
PurchaseReqnItemTheme Fashion Theme FSH_THEME
DistributionChannel Distribution Channel VTWEG
Division Division SPART
PurchaseReqnItemStockSegment Stock Segment SGT_SRCA
ProposedPurchasingDocument Purchasing Document Number EBELN
ProposedPurchasingDocumentItem Item Number of Purchasing Document EBELP
PurchaseOrderSupplier Vendor's account number LIFNR
PurchaseOrderSupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurOrderItemPlant Plant WERKS
PurOrdItemPlantName Plant Name TEXT30
PurchaseOrderItemSeasonYear Season Year FSH_CJAHR
PurchaseOrderItemSeason Season RFM_SAISO
PurchaseOrderItemCollection Fashion Collection FSH_COLLECTION
PurchaseOrderItemTheme Fashion Theme FSH_THEME
PurchaseOrderItemStockSegment Stock Segment SGT_SRCA
AlignedPurchasingDocument Purchasing Document Number EBELN
AlignedPurchasingDocumentItem Item Number of Purchasing Document EBELP
PurReqnHasAlignmentProposal Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
PurchasingDocumentItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
ReasonCode null
PurReqnCrsSeasonAlgnmtName Char 60 CHAR60
PurReqnCrsPlantAlgnmtName Char 60 CHAR60
PurReqnHasCrossSgmtAlgnmtName Char 60 CHAR60
PurReqnAlgnmtRunText RunID Description RFM_RUNID_DESCRIPTION
UserName Name of Person Responsible for Creating the Object USNAM
StartDate Creation Date Time TZNTSTMPL
Master Data Relations Join Conditions
Cross-Plant Configurable Product
  • Client
  • Cross-Plant Configurable Product
  • I_ALGNMTRUNDET.MANDT == MARA.MANDT
  • I_ALGNMTRUNDET.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Client
  • Customer Group
  • I_ALGNMTRUNDET.MANDT == T151.MANDT
  • I_ALGNMTRUNDET.CUSTOMERGROUP == T151.KDGRP
Material Group
  • Client
  • Product Group
  • I_ALGNMTRUNDET.MANDT == T023.MANDT
  • I_ALGNMTRUNDET.PRODUCTGROUP == T023.MATKL
Purchase Requisition Document Type
  • Client
  • ?
  • Purchase Requisition Document Type
  • I_ALGNMTRUNDET.MANDT == T161.MANDT
  • I_ALGNMTRUNDET.[column in domain "BSTYP"] == T161.BSTYP
  • I_ALGNMTRUNDET.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • I_ALGNMTRUNDET.MANDT == T024.MANDT
  • I_ALGNMTRUNDET.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • I_ALGNMTRUNDET.PURCHASINGORGANIZATION == T024E.EKORG
  • I_ALGNMTRUNDET.MANDT == T024E.MANDT
Order type in order header
  • Sales Order Type
  • Client
  • I_ALGNMTRUNDET.SALESORDERTYPE == TVAK.AUART
  • I_ALGNMTRUNDET.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_ALGNMTRUNDET.SALESORGANIZATION == TVKO.VKORG
  • I_ALGNMTRUNDET.MANDT == TVKO.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • I_ALGNMTRUNDET.MANDT == KNA1.MANDT
  • I_ALGNMTRUNDET.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • SD Document Currency
  • Client
  • I_ALGNMTRUNDET.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_ALGNMTRUNDET.MANDT == TCURC.MANDT