I_AlignAcctAssgdSlsPurItm

DDL: I_ALIGNACCTASSGDSLSPURITM SQL: IALIGNAASLPURITM Type: view COMPOSITE
59 Fields 1 Data Sources 1 Associations

AA Sales and PR line item for alignment

I_AlignAcctAssgdSlsPurItm is a Composite CDS View that provides data about "AA Sales and PR line item for alignment" in SAP S/4HANA. It reads from 1 data source (I_AlignAcctAssgdPurReqItm) and exposes 59 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_AlignAcctAssgdPurReqItm PurReqItm from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AlignAcctAssgdSlsItmSl _SlsItmSl $projection.SalesOrder = _SlsItmSl.SalesDocument and $projection.SalesOrderItem = _SlsItmSl.SalesDocumentItem and $projection.SalesOrderScheduleLine = _SlsItmSl.ScheduleLine

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IALIGNAASLPURITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label AA Sales and PR line item for alignment view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.preserveKey true view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
CompanyCode Receiver Company Code
PurchaseReqItemSupplier Supplier Supplier
FixedSupplier FixedSupplier Fixed Vendor
PurReqnItemPurchasingOrg PurchasingOrganization Purchasing Organization
PurReqnItemPurchasingGroup PurchasingGroup Purchasing Group
PurchaseRequisitionType PurchaseRequisitionType Order Type
ProductCategory ProductCategory Prod Category
ProductCategoryName
MaterialGroup MaterialGroup Product Group
RequestedQuantity RequestedQuantity Requested Quantity
PurReqnItemPurchaseContract PurchaseContract Purchasing Doc.
PurReqnItemPurContractItem PurchaseContractItem Item
PurchaseRequisitionUnit BaseUnit Unit of Measure
BaseUnit BaseUnit Unit of Measure
PurchaseRequisitionItemPlant Plant Valuation Area
PurchaseReqnItemSeasonYear PurchaseReqnItemSeasonYear
PurchaseReqnItemSeason PurchaseReqnItemSeason
PurchaseReqnItemCollection PurchaseReqnItemCollection
PurchaseReqnItemTheme PurchaseReqnItemTheme
PurchaseReqnItemStockSegment PurchaseReqnItemStockSegment
DeliveryDate DeliveryDate Delivery Date
PurchasingInfoRecord I_AlignAcctAssgdPurReqItm PurchasingInfoRecord Info Record
PurReqnItmPlntCoCodeCrcy PurReqnItmPlntCoCodeCrcy Valuation Crcy
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine SOrder schedule
PurchaseContractQuantityUnit PurchaseContractQuantityUnit Sales Unit
ContractItemQtyToBaseQtyNmrtr ContractItemQtyToBaseQtyNmrtr Equal To
ContractItemQtyToBaseQtyDnmntr ContractItemQtyToBaseQtyDnmntr Denominator
ReqnItmContrItmOpnQtyInBaseUoM ReqnItmContrItmOpnQtyInBaseUoM
SalesDocumentType
SalesOrganization
DistributionChannel
OrganizationDivision
SoldToParty
ShipToParty
Product
BillOfMaterial
ProductName
HigherLevelItem
ProductOfHigherLevelItem
CrossPlantConfigurableProduct
ScheduleLineCategory
SalesAccountAssignmentType
ProductCharacteristic1
ProductCharacteristic1Desc
ProductCharacteristic2
ProductCharacteristic2Desc
ProductCharacteristic3
ProductCharacteristic3Desc
SalesOffice
SDDocumentReason
CreationDate
FashionCancelDate
DeliveryPriority
OrganizationBPName1
_SlsItmSl _SlsItmSl

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_AlignAcctAssgdSlsPurItm.
-- 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: IALIGNAASLPURITM

CREATE VIEW I_AlignAcctAssgdSlsPurItm AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  cast (CompanyCode as bukrs) AS CompanyCode,
  Supplier AS PurchaseReqItemSupplier,
  FixedSupplier,
  PurchasingOrganization AS PurReqnItemPurchasingOrg,
  PurchasingGroup AS PurReqnItemPurchasingGroup,
  PurchaseRequisitionType,
  ProductCategory,
  _SlsItmSl[1:inner]._ProductCategory.Name AS ProductCategoryName,
  MaterialGroup,
  RequestedQuantity,
  PurchaseContract AS PurReqnItemPurchaseContract,
  PurchaseContractItem AS PurReqnItemPurContractItem,
  BaseUnit AS PurchaseRequisitionUnit,
  BaseUnit,
  Plant AS PurchaseRequisitionItemPlant,
  PurchaseReqnItemSeasonYear,
  PurchaseReqnItemSeason,
  PurchaseReqnItemCollection,
  PurchaseReqnItemTheme,
  PurchaseReqnItemStockSegment,
  DeliveryDate,
  PurReqItm.PurchasingInfoRecord AS PurchasingInfoRecord,
  PurReqnItmPlntCoCodeCrcy,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  PurchaseContractQuantityUnit,
  ContractItemQtyToBaseQtyNmrtr,
  ContractItemQtyToBaseQtyDnmntr,
  ReqnItmContrItmOpnQtyInBaseUoM,
  _SlsItmSl[1:inner].SalesDocumentType AS SalesDocumentType,
  _SlsItmSl[1:inner].SalesOrganization AS SalesOrganization,
  _SlsItmSl[1:inner].DistributionChannel AS DistributionChannel,
  _SlsItmSl[1:inner].OrganizationDivision AS OrganizationDivision,
  _SlsItmSl[1:inner].SoldToParty AS SoldToParty,
  _SlsItmSl[1:inner].ShipToParty AS ShipToParty,
  _SlsItmSl[1:inner].Product AS Product,
  _SlsItmSl[1:inner].BillOfMaterial AS BillOfMaterial,
  _SlsItmSl[1:inner].ProductName AS ProductName,
  _SlsItmSl[1:inner].HigherLevelItem AS HigherLevelItem,
  _SlsItmSl[1:inner].ProductOfHigherLevelItem AS ProductOfHigherLevelItem,
  _SlsItmSl[1:inner].CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _SlsItmSl[1:inner].ScheduleLineCategory AS ScheduleLineCategory,
  _SlsItmSl[1:inner].SalesAccountAssignmentType AS SalesAccountAssignmentType,
  _SlsItmSl[1:inner].ProductCharacteristic1 AS ProductCharacteristic1,
  _SlsItmSl[1:inner]._ProdCharc1ValueT.RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  _SlsItmSl[1:inner].ProductCharacteristic2 AS ProductCharacteristic2,
  _SlsItmSl[1:inner]._ProdCharc2ValueT.RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  _SlsItmSl[1:inner].ProductCharacteristic3 AS ProductCharacteristic3,
  _SlsItmSl[1:inner]._ProdCharc3ValueT.RetailCharacteristicValueDesc AS ProductCharacteristic3Desc,
  _SlsItmSl[1:inner].SalesOffice AS SalesOffice,
  _SlsItmSl[1:inner].SDDocumentReason AS SDDocumentReason,
  _SlsItmSl[1:inner].CreationDate AS CreationDate,
  _SlsItmSl[1:inner].FashionCancelDate AS FashionCancelDate,
  _SlsItmSl[1:inner].DeliveryPriority AS DeliveryPriority,
  _SlsItmSl[1:inner].OrganizationBPName1 AS OrganizationBPName1
FROM I_AlignAcctAssgdPurReqItm AS PurReqItm
LEFT OUTER JOIN I_AlignAcctAssgdSlsItmSl AS _SlsItmSl ON SalesOrder = _SlsItmSl.SalesDocument AND SalesOrderItem = _SlsItmSl.SalesDocumentItem AND SalesOrderScheduleLine = _SlsItmSl.ScheduleLine  -- association [1..1]
;

Learn More