I_SlsDocSchedLineAnalytics

DDL: I_SLSDOCSCHEDLINEANALYTICS SQL: ISDSCHEDLINENANA Type: view COMPOSITE
74 Fields 1 Data Sources 1 Associations

Sales Document Schedule Line Analytics

I_SlsDocSchedLineAnalytics is a Composite CDS View that provides data about "Sales Document Schedule Line Analytics" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 74 fields with key fields SalesDocument, SalesDocumentItem, ScheduleLine. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine SL from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _StatisticsCurrency $projection.StatisticsCurrency = _StatisticsCurrency.Currency

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Sales Document Schedule Line Analytics view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName ISDSCHEDLINENANA view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
KEY ScheduleLine ScheduleLine Schedule Line
SalesOrganization _SalesDocument SalesOrganization Sales Organization
DistributionChannel _SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesDocument OrganizationDivision Org. Division
SDDocumentCategory _SalesDocument SDDocumentCategory Document Cat.
_SDDocumentCategory _SalesDocument _SDDocumentCategory
Material _SalesDocumentItem Material Vehicle Model
Product _SalesDocumentItem Product Product Sold
OriginallyRequestedMaterial _SalesDocumentItem OriginallyRequestedMaterial
InternationalArticleNumber _SalesDocumentItem InternationalArticleNumber EAN/UPC
Batch
ProductHierarchyNode _SalesDocumentItem ProductHierarchyNode Prod. Hierarchy
MaterialGroup _SalesDocumentItem MaterialGroup Product Group
ProductGroup _SalesDocumentItem ProductGroup Product Sold Group
AdditionalMaterialGroup1 _SalesDocumentItem AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 _SalesDocumentItem AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 _SalesDocumentItem AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 _SalesDocumentItem AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 _SalesDocumentItem AdditionalMaterialGroup5 MaterialGroup 5
ProfitCenter _SalesDocumentItem ProfitCenter Profit Center
SalesOffice _SalesDocument SalesOffice Sales Office
SalesGroup _SalesDocument SalesGroup Sales Group
SoldToParty _SalesDocument SoldToParty Sold-to Party
SoldToPartyName
CustomerGroup _SalesDocument CustomerGroup Customer Group
AdditionalCustomerGroup1
_AdditionalCustomerGroup1 _SalesDocument _AdditionalCustomerGroup1
AdditionalCustomerGroup2 _SalesDocument AdditionalCustomerGroup2 Customer Grp 2
_AdditionalCustomerGroup2 _SalesDocument _AdditionalCustomerGroup2
AdditionalCustomerGroup3 _SalesDocument AdditionalCustomerGroup3 Customer Grp 3
_AdditionalCustomerGroup3 _SalesDocument _AdditionalCustomerGroup3
AdditionalCustomerGroup4 _SalesDocument AdditionalCustomerGroup4 Customer Grp 4
_AdditionalCustomerGroup4 _SalesDocument _AdditionalCustomerGroup4
AdditionalCustomerGroup5 _SalesDocument AdditionalCustomerGroup5 Customer Grp 5
_AdditionalCustomerGroup5 _SalesDocument _AdditionalCustomerGroup5
SoldToPartyClassification
SalesDistrict _SalesDocument SalesDistrict Sales District
SalesDocumentType _SalesDocument SalesDocumentType Sales Doc. Type
DCLCheckSalesDocumentGoodsIssueDate
CreationDate
OpenSlsOrdersForDelivNetAmount Open Delivery Amount
OpenSlsOrdersForDelivNetAmount Open Delivery Amount
TransactionCurrency TransactionCurrency Transaction Currency
OpnSlsOrdrsForDelivQuantity Open Quantity
BaseUnit BaseUnit Unit of Measure
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_SalesOrganization _SalesDocument _SalesOrganization
_CustomerGroup _SalesDocument _CustomerGroup
_BaseUnit _BaseUnit
_AdditionalMaterialGroup1 _SalesDocumentItem _AdditionalMaterialGroup1
_AdditionalMaterialGroup2 _SalesDocumentItem _AdditionalMaterialGroup2
_AdditionalMaterialGroup3 _SalesDocumentItem _AdditionalMaterialGroup3
_AdditionalMaterialGroup4 _SalesDocumentItem _AdditionalMaterialGroup4
_AdditionalMaterialGroup5 _SalesDocumentItem _AdditionalMaterialGroup5
_OrganizationDivision _SalesDocument _OrganizationDivision
_DistributionChannel _SalesDocument _DistributionChannel
_Material _SalesDocumentItem _Material
_Product _SalesDocumentItem _Product
_ProductText _SalesDocumentItem _ProductText
_MaterialGroup _SalesDocumentItem _MaterialGroup
_ProductGroup _SalesDocumentItem _ProductGroup
_SalesOffice _SalesDocument _SalesOffice
_SalesGroup _SalesDocument _SalesGroup
_SalesDistrict _SalesDocument _SalesDistrict
_SoldToParty _SalesDocument _SoldToParty
_CustomerClassification
ShippingPoint _SalesDocumentItem ShippingPoint Shipping Point
_ShippingPoint _SalesDocumentItem _ShippingPoint
_StatisticsCurrency _StatisticsCurrency
_TransactionCurrency _TransactionCurrency
_OriginallyRequestedMaterial _SalesDocumentItem _OriginallyRequestedMaterial

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_SlsDocSchedLineAnalytics.
-- 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: ISDSCHEDLINENANA

CREATE VIEW I_SlsDocSchedLineAnalytics AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  _SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  _SalesDocument._SDDocumentCategory AS _SDDocumentCategory,
  _SalesDocumentItem.Material AS Material,
  _SalesDocumentItem.Product AS Product,
  _SalesDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  _SalesDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  _SalesDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  _SalesDocumentItem.MaterialGroup AS MaterialGroup,
  _SalesDocumentItem.ProductGroup AS ProductGroup,
  _SalesDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  _SalesDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  _SalesDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  _SalesDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  _SalesDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  _SalesDocumentItem.ProfitCenter AS ProfitCenter,
  _SalesDocument.SalesOffice AS SalesOffice,
  _SalesDocument.SalesGroup AS SalesGroup,
  _SalesDocument.SoldToParty AS SoldToParty,
  cast(_SalesDocument._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  _SalesDocument.CustomerGroup AS CustomerGroup,
  _SalesDocument._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  _SalesDocument.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  _SalesDocument._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  _SalesDocument.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  _SalesDocument._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  _SalesDocument.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  _SalesDocument._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  _SalesDocument.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  _SalesDocument._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  _SalesDocument._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  _SalesDocument.SalesDistrict AS SalesDistrict,
  _SalesDocument.SalesDocumentType AS SalesDocumentType,
  cast( OpenDeliveryNetAmount as opn_ord_for_del_amt_itc ) AS OpenSlsOrdersForDelivNetAmount,
  TransactionCurrency,
  cast( OpenConfdDelivQtyInBaseUnit as opn_ord_for_del_qty ) AS OpnSlsOrdrsForDelivQuantity,
  BaseUnit,
  _SalesDocument._SalesOrganization AS _SalesOrganization,
  _SalesDocument._CustomerGroup AS _CustomerGroup,
  _SalesDocumentItem._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  _SalesDocumentItem._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  _SalesDocumentItem._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  _SalesDocumentItem._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  _SalesDocumentItem._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  _SalesDocument._OrganizationDivision AS _OrganizationDivision,
  _SalesDocument._DistributionChannel AS _DistributionChannel,
  _SalesDocumentItem._Material AS _Material,
  _SalesDocumentItem._Product AS _Product,
  _SalesDocumentItem._ProductText AS _ProductText,
  _SalesDocumentItem._MaterialGroup AS _MaterialGroup,
  _SalesDocumentItem._ProductGroup AS _ProductGroup,
  _SalesDocument._SalesOffice AS _SalesOffice,
  _SalesDocument._SalesGroup AS _SalesGroup,
  _SalesDocument._SalesDistrict AS _SalesDistrict,
  _SalesDocument._SoldToParty AS _SoldToParty,
  _SalesDocument._SoldToParty._CustomerClassification AS _CustomerClassification,
  _SalesDocumentItem.ShippingPoint AS ShippingPoint,
  _SalesDocumentItem._ShippingPoint AS _ShippingPoint,
  _SalesDocumentItem._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial
FROM I_SalesDocumentScheduleLine AS SL
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
;

Learn More