ARun_ValAddedSrvcSTODmndDocs

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

P_ARunValAddedSrvcSTODmndDocs

ARun_ValAddedSrvcSTODmndDocs is a CDS View that provides data about "P_ARunValAddedSrvcSTODmndDocs" in SAP S/4HANA. It reads from 2 data sources (ARun_ValAddedSrvcMatlPlant, ARun_ValAddedSrvcSTORqmtItms) and exposes 22 fields. Part of development package ARUN_ITA.

Data Sources (2)

SourceAliasJoin Type
ARun_ValAddedSrvcMatlPlant _ARunValAddedSrvcMatlPlant inner
ARun_ValAddedSrvcSTORqmtItms _ARunValAddedSrvcSTORqmtItms from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ARUNVASSTODMND 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_ValAddedSrvcSTORqmtItms RequirementType RequirementType
PurchaseOrder ARun_ValAddedSrvcSTORqmtItms PurchaseOrder Purchasing Document
PurchaseOrderItem ARun_ValAddedSrvcSTORqmtItms PurchaseOrderItem Purchasing Document Item
ValAddedSrvcItemNumber ARun_ValAddedSrvcSTORqmtItms ValAddedSrvcItemNumber Purchasing Document Item
ValAddedSrvcHasToBeOrdered ARun_ValAddedSrvcSTORqmtItms ValAddedSrvcHasToBeOrdered
Plant ARun_ValAddedSrvcSTORqmtItms Plant Valuation Area
Material ARun_ValAddedSrvcSTORqmtItms Material Vehicle Model
RqmtIsSupAssgmtRelevant ARun_ValAddedSrvcMatlPlant RqmtIsSupAssgmtRelevant ARun
IsInternalBatchManaged ARun_ValAddedSrvcMatlPlant IsInternalBatchManaged Batches
RequestedDate ARun_ValAddedSrvcSTORqmtItms RequestedDate
ProductAvailabilityDate ARun_ValAddedSrvcSTORqmtItms ProductAvailabilityDate Mat.Avail.Date
RequestedRqmtQtyInBaseUnit ARun_ValAddedSrvcSTORqmtItms RequestedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit ARun_ValAddedSrvcSTORqmtItms DeliveredQuantityInBaseUnit
ConfirmedRqmtQtyInBaseUnit ARun_ValAddedSrvcSTORqmtItms ConfirmedRqmtQtyInBaseUnit
SalesOrganization ARun_ValAddedSrvcSTORqmtItms SalesOrganization Sales Organization
DistributionChannel ARun_ValAddedSrvcSTORqmtItms DistributionChannel RefDistCh-Cust/Mat.
Division ARun_ValAddedSrvcSTORqmtItms Division Internal Division ID
OrderType ARun_ValAddedSrvcSTORqmtItms OrderType Order Type
SoldToParty ARun_ValAddedSrvcSTORqmtItms SoldToParty Sold-to Party
ShipToParty ARun_ValAddedSrvcSTORqmtItms ShipToParty Ship-To Party (obsolete)
ShippingGroupNumber ARun_ValAddedSrvcSTORqmtItms ShippingGroupNumber PSST Group
CrossPlantConfigurableProduct ARun_ValAddedSrvcMatlPlant CrossPlantConfigurableProduct Cross-plant CP

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_ValAddedSrvcSTODmndDocs.
-- 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_ValAddedSrvcSTODmndDocs AS
SELECT
  _ARunValAddedSrvcSTORqmtItms.RequirementType AS RequirementType,
  _ARunValAddedSrvcSTORqmtItms.PurchaseOrder AS PurchaseOrder,
  _ARunValAddedSrvcSTORqmtItms.PurchaseOrderItem AS PurchaseOrderItem,
  _ARunValAddedSrvcSTORqmtItms.ValAddedSrvcItemNumber AS ValAddedSrvcItemNumber,
  _ARunValAddedSrvcSTORqmtItms.ValAddedSrvcHasToBeOrdered AS ValAddedSrvcHasToBeOrdered,
  _ARunValAddedSrvcSTORqmtItms.Plant AS Plant,
  _ARunValAddedSrvcSTORqmtItms.Material AS Material,
  _ARunValAddedSrvcMatlPlant.RqmtIsSupAssgmtRelevant AS RqmtIsSupAssgmtRelevant,
  _ARunValAddedSrvcMatlPlant.IsInternalBatchManaged AS IsInternalBatchManaged,
  _ARunValAddedSrvcSTORqmtItms.RequestedDate AS RequestedDate,
  _ARunValAddedSrvcSTORqmtItms.ProductAvailabilityDate AS ProductAvailabilityDate,
  _ARunValAddedSrvcSTORqmtItms.RequestedRqmtQtyInBaseUnit AS RequestedRqmtQtyInBaseUnit,
  _ARunValAddedSrvcSTORqmtItms.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  _ARunValAddedSrvcSTORqmtItms.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
  _ARunValAddedSrvcSTORqmtItms.SalesOrganization AS SalesOrganization,
  _ARunValAddedSrvcSTORqmtItms.DistributionChannel AS DistributionChannel,
  _ARunValAddedSrvcSTORqmtItms.Division AS Division,
  _ARunValAddedSrvcSTORqmtItms.OrderType AS OrderType,
  _ARunValAddedSrvcSTORqmtItms.SoldToParty AS SoldToParty,
  _ARunValAddedSrvcSTORqmtItms.ShipToParty AS ShipToParty,
  _ARunValAddedSrvcSTORqmtItms.ShippingGroupNumber AS ShippingGroupNumber,
  _ARunValAddedSrvcMatlPlant.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct
FROM ARun_ValAddedSrvcSTORqmtItms AS _ARunValAddedSrvcSTORqmtItms
INNER JOIN ARun_ValAddedSrvcMatlPlant AS _ARunValAddedSrvcMatlPlant ON /* join condition not captured in parsed metadata */
;

Learn More