C_ATPRlvtProdAssgdSlsDocItemVH

DDL: C_ATPRLVTPRODASSGDSLSDOCITEMVH Type: view_entity CONSUMPTION Package: ODATA_ATP_DISP_PROD_AVAILY
13 Fields 1 Data Sources 2 OData Services

ATP Relevant Product Sales Document Item

C_ATPRlvtProdAssgdSlsDocItemVH is a Consumption CDS View that provides data about "ATP Relevant Product Sales Document Item" in SAP S/4HANA. It reads from 1 data source (I_ATPRlvtProdAssgdSlsDocItmDsp) and exposes 13 fields with key fields Product, MRPArea, SalesDocument, SalesDocumentItem. It is exposed through 2 OData services (ASQL_F7884, UI_DISPLAY_PRODUCT_AVAILY). Part of development package ODATA_ATP_DISP_PROD_AVAILY.

Data Sources (1)

SourceAliasJoin Type
I_ATPRlvtProdAssgdSlsDocItmDsp I_ATPRlvtProdAssgdSlsDocItmDsp from

Annotations (11)

NameValueLevelField
EndUserText.label ATP Relevant Product Sales Document Item view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey SalesDocumentItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7884 ASQL_F7884 C2 NOT_RELEASED
UI_DISPLAY_PRODUCT_AVAILY UI_DISPLAY_PRODUCT_AVAILY V4 C1 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product
KEY MRPArea MRPArea MRP Area
KEY SalesDocument SalesDocument Sales Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
SoldToParty SoldToParty Sold-to Party
SalesDocumentType SalesDocumentType Sales Document Type
Plant Plant Valuation Area
SalesDocumentItemText _SalesDocumentItem SalesDocumentItemText Sales Document Item Description
CreationDate _SalesDocumentItem CreationDate Created On
CreatedByUser _SalesDocumentItem CreatedByUser Created By
OrganizationDivision _SalesDocumentItem OrganizationDivision Org. Division
SalesOrganization _SalesDocumentItem SalesOrganization Sales Organization
DistributionChannel _SalesDocumentItem DistributionChannel RefDistCh-Cust/Mat.

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 C_ATPRlvtProdAssgdSlsDocItemVH.
-- 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 C_ATPRlvtProdAssgdSlsDocItemVH AS
SELECT
  Product,
  MRPArea,
  SalesDocument,
  SalesDocumentItem,
  SoldToParty,
  SalesDocumentType,
  Plant,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  _SalesDocumentItem.CreationDate AS CreationDate,
  _SalesDocumentItem.CreatedByUser AS CreatedByUser,
  _SalesDocumentItem.OrganizationDivision AS OrganizationDivision,
  _SalesDocumentItem.SalesOrganization AS SalesOrganization,
  _SalesDocumentItem.DistributionChannel AS DistributionChannel
FROM I_ATPRlvtProdAssgdSlsDocItmDsp
;

Learn More