ARun_ValAddedSrvcSDRqmtItms

DDL: ARUN_VALADDEDSRVCSDRQMTITMS Type: view Package: ARUN_ITA
22 Fields 2 Data Sources

ARun VAS SD Requiremnt Items

ARun_ValAddedSrvcSDRqmtItms is a CDS View that provides data about "ARun VAS SD Requiremnt Items" in SAP S/4HANA. It reads from 2 data sources (ARun_ValAddedSrvcSDAvalyDte, ARun_ValAddedSrvcSDItms) and exposes 22 fields. Part of development package ARUN_ITA.

Data Sources (2)

SourceAliasJoin Type
ARun_ValAddedSrvcSDAvalyDte _ARunValAddedSrvcSDAvailyDte left_outer
ARun_ValAddedSrvcSDItms _ARunValAddedSrvcSDItms from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ARUNVASSDRQTITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (22)

KeyFieldSource TableSource FieldDescription
RequirementType ARun_ValAddedSrvcSDItms RequirementType RequirementType
SalesDocument ARun_ValAddedSrvcSDAvalyDte SalesDocument SD Document
SalesDocumentItem ARun_ValAddedSrvcSDItms SalesDocumentItem Sales Document Item
ValAddedSrvcItemNumber ARun_ValAddedSrvcSDAvalyDte SalesDocumentItem Sales Document Item
Plant ARun_ValAddedSrvcSDItms Plant Valuation Area
Material ARun_ValAddedSrvcSDItms Material Vehicle Model
ValAddedSrvcHasToBeOrdered ARun_ValAddedSrvcSDItms ValAddedSrvcHasToBeOrdered Req Relevance
ValAddedSrvcIsRlvtForProcmt ARun_ValAddedSrvcSDItms ValAddedSrvcIsRlvtForProcmt Procurmnt Relev
RequestedDate ARun_ValAddedSrvcSDAvalyDte RequestedDate Mat.Avail.Date
ProductAvailabilityDate ARun_ValAddedSrvcSDAvalyDte ProductAvailabilityDate Mat.Avail.Date
SoldToParty ARun_ValAddedSrvcSDItms SoldToParty Sold-to Party
ShipToParty ARun_ValAddedSrvcSDItms ShipToParty Ship-To Party (obsolete)
OrderType ARun_ValAddedSrvcSDItms OrderType Order Type
SalesOrganization ARun_ValAddedSrvcSDItms SalesOrganization Sales Organization
DistributionChannel ARun_ValAddedSrvcSDItms DistributionChannel RefDistCh-Cust/Mat.
Division ARun_ValAddedSrvcSDItms Division Internal Division ID
ARunSupplyAssgmtReleaseRule ARun_ValAddedSrvcSDItms ARunSupplyAssgmtReleaseRule Release Rule
ShippingGroupNumber ARun_ValAddedSrvcSDItms ShippingGroupNumber PSST Group
DeliveryGroup ARun_ValAddedSrvcSDItms DeliveryGroup Delivery Group
RequestedRqmtQtyInBaseUnit ARun_ValAddedSrvcSDItms RequestedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit ARun_ValAddedSrvcSDAvalyDte DeliveredQuantityInBaseUnit
ConfirmedRqmtQtyInBaseUnit ARun_ValAddedSrvcSDAvalyDte ConfirmedRqmtQtyInBaseUnit

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 ARun_ValAddedSrvcSDRqmtItms.
-- 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 ARun_ValAddedSrvcSDRqmtItms AS
SELECT
  _ARunValAddedSrvcSDItms.RequirementType AS RequirementType,
  _ARunValAddedSrvcSDAvailyDte.SalesDocument AS SalesDocument,
  _ARunValAddedSrvcSDItms.SalesDocumentItem AS SalesDocumentItem,
  _ARunValAddedSrvcSDAvailyDte.SalesDocumentItem AS ValAddedSrvcItemNumber,
  _ARunValAddedSrvcSDItms.Plant AS Plant,
  _ARunValAddedSrvcSDItms.Material AS Material,
  _ARunValAddedSrvcSDItms.ValAddedSrvcHasToBeOrdered AS ValAddedSrvcHasToBeOrdered,
  _ARunValAddedSrvcSDItms.ValAddedSrvcIsRlvtForProcmt AS ValAddedSrvcIsRlvtForProcmt,
  _ARunValAddedSrvcSDAvailyDte.RequestedDate AS RequestedDate,
  _ARunValAddedSrvcSDAvailyDte.ProductAvailabilityDate AS ProductAvailabilityDate,
  _ARunValAddedSrvcSDItms.SoldToParty AS SoldToParty,
  _ARunValAddedSrvcSDItms.ShipToParty AS ShipToParty,
  _ARunValAddedSrvcSDItms.OrderType AS OrderType,
  _ARunValAddedSrvcSDItms.SalesOrganization AS SalesOrganization,
  _ARunValAddedSrvcSDItms.DistributionChannel AS DistributionChannel,
  _ARunValAddedSrvcSDItms.Division AS Division,
  _ARunValAddedSrvcSDItms.ARunSupplyAssgmtReleaseRule AS ARunSupplyAssgmtReleaseRule,
  _ARunValAddedSrvcSDItms.ShippingGroupNumber AS ShippingGroupNumber,
  _ARunValAddedSrvcSDItms.DeliveryGroup AS DeliveryGroup,
  _ARunValAddedSrvcSDItms.RequestedRqmtQtyInBaseUnit AS RequestedRqmtQtyInBaseUnit,
  _ARunValAddedSrvcSDAvailyDte.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  _ARunValAddedSrvcSDAvailyDte.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit
FROM ARun_ValAddedSrvcSDItms AS _ARunValAddedSrvcSDItms
LEFT OUTER JOIN ARun_ValAddedSrvcSDAvalyDte AS _ARunValAddedSrvcSDAvailyDte ON /* join condition not captured in parsed metadata */
;

Learn More