ARun_ValAddedSrvcDmndDocs
ARun_ValAddedSrvcDmndDocs is a CDS View in SAP S/4HANA. It reads from 2 data sources (ARun_ValAddedSrvcSDAssgmt, ARun_ValAddedSrvcSTOAssgmt) and exposes 71 fields.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| ARun_ValAddedSrvcSDAssgmt | _ARunValAddedSrvcSDAssgmt | from |
| ARun_ValAddedSrvcSTOAssgmt | _ARunValAddedSrvcSTOAssgmt | union_all |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| AbapCatalog.sqlViewName | ARUNVASDMNDDOCS | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view |
Fields (71)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| RequirementType | ARun_ValAddedSrvcSDAssgmt | RequirementType | RequirementType | |
| RequirementDocumentNumber | ARun_ValAddedSrvcSDAssgmt | SalesDocument | Purchasing Document | |
| RequirementDocumentItem | ARun_ValAddedSrvcSDAssgmt | SalesDocumentItem | Sales Document Item | |
| ValAddedSrvcItemNumber | ARun_ValAddedSrvcSDAssgmt | ValAddedSrvcItemNumber | ||
| ValAddedSrvcHasToBeOrdered | ARun_ValAddedSrvcSDAssgmt | ValAddedSrvcHasToBeOrdered | ||
| ValAddedSrvcIsRlvtForProcmt | ARun_ValAddedSrvcSDAssgmt | ValAddedSrvcIsRlvtForProcmt | ||
| Plant | ARun_ValAddedSrvcSDAssgmt | Plant | Valuation Area | |
| Material | ARun_ValAddedSrvcSDAssgmt | Material | Vehicle Model | |
| RqmtIsSupAssgmtRelevant | ARun_ValAddedSrvcSDAssgmt | RqmtIsSupAssgmtRelevant | ||
| IsInternalBatchManaged | ARun_ValAddedSrvcSDAssgmt | IsInternalBatchManaged | Batches | |
| RequestedDate | ARun_ValAddedSrvcSDAssgmt | RequestedDate | ||
| ProductAvailabilityDate | ARun_ValAddedSrvcSDAssgmt | ProductAvailabilityDate | Mat.Avail.Date | |
| RequestedRqmtQtyInBaseUnit | ARun_ValAddedSrvcSDAssgmt | RequestedRqmtQtyInBaseUnit | ||
| DeliveredQuantityInBaseUnit | ARun_ValAddedSrvcSDAssgmt | DeliveredQuantityInBaseUnit | ||
| ConfirmedRqmtQtyInBaseUnit | ARun_ValAddedSrvcSDAssgmt | ConfirmedRqmtQtyInBaseUnit | ||
| SalesOrganization | ARun_ValAddedSrvcSDAssgmt | SalesOrganization | Sales Organization | |
| DistributionChannel | ARun_ValAddedSrvcSDAssgmt | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | ARun_ValAddedSrvcSDAssgmt | Division | Internal Division ID | |
| OrderType | ARun_ValAddedSrvcSDAssgmt | OrderType | Order Type | |
| SoldToParty | ARun_ValAddedSrvcSDAssgmt | SoldToParty | Sold-to Party | |
| ShipToParty | ARun_ValAddedSrvcSDAssgmt | ShipToParty | Ship-To Party (obsolete) | |
| DeliveryGroup | ARun_ValAddedSrvcSDAssgmt | DeliveryGroup | Delivery Group | |
| ShippingGroupNumber | ARun_ValAddedSrvcSDAssgmt | ShippingGroupNumber | PSST Group | |
| ARunSupplyAssgmtReleaseRule | ARun_ValAddedSrvcSDAssgmt | ARunSupplyAssgmtReleaseRule | Release Rule | |
| ARunUUID | ARun_ValAddedSrvcSDAssgmt | ARunUUID | ||
| CrossPlantConfigurableProduct | ARun_ValAddedSrvcSDAssgmt | CrossPlantConfigurableProduct | Cross-plant CP | |
| SupplyAssignmentStatus | ARun_ValAddedSrvcSDAssgmt | SupplyAssignmentStatus | ||
| AssignedSupplyType | ARun_ValAddedSrvcSDAssgmt | AssignedSupplyType | ||
| StorageLocation | ARun_ValAddedSrvcSDAssgmt | StorageLocation | StorageLocation | |
| Batch | ARun_ValAddedSrvcSDAssgmt | Batch | Lot No. | |
| InboundDelivery | ARun_ValAddedSrvcSDAssgmt | InboundDelivery | LE Delivery | |
| InboundDeliveryItem | ARun_ValAddedSrvcSDAssgmt | InboundDeliveryItem | Item | |
| HigherLvlItmOfBatSpltItm | ARun_ValAddedSrvcSDAssgmt | HigherLvlItmOfBatSpltItm | ||
| SupplyDeliveryDate | ARun_ValAddedSrvcSDAssgmt | SupplyDeliveryDate | ||
| AssignedQuantityInBaseUnit | ARun_ValAddedSrvcSDAssgmt | AssignedQuantityInBaseUnit | ||
| RequirementTypeasRequirementType | ||||
| RequirementDocumentNumber | ARun_ValAddedSrvcSTOAssgmt | PurchaseOrder | Purchasing Document | |
| RequirementDocumentItem | Sales Document Item | |||
| ValAddedSrvcItemNumber | ||||
| ValAddedSrvcHasToBeOrdered | ARun_ValAddedSrvcSTOAssgmt | ValAddedSrvcHasToBeOrdered | ||
| ValAddedSrvcIsRlvtForProcmt | ||||
| Plant | ARun_ValAddedSrvcSTOAssgmt | Plant | Valuation Area | |
| Material | ARun_ValAddedSrvcSTOAssgmt | Material | Vehicle Model | |
| RqmtIsSupAssgmtRelevant | ARun_ValAddedSrvcSTOAssgmt | RqmtIsSupAssgmtRelevant | ||
| IsInternalBatchManaged | ARun_ValAddedSrvcSTOAssgmt | IsInternalBatchManaged | Batches | |
| RequestedDate | ARun_ValAddedSrvcSTOAssgmt | RequestedDate | ||
| ProductAvailabilityDate | ARun_ValAddedSrvcSTOAssgmt | ProductAvailabilityDate | Mat.Avail.Date | |
| RequestedRqmtQtyInBaseUnit | ARun_ValAddedSrvcSTOAssgmt | RequestedRqmtQtyInBaseUnit | ||
| DeliveredQuantityInBaseUnit | ARun_ValAddedSrvcSTOAssgmt | DeliveredQuantityInBaseUnit | ||
| ConfirmedRqmtQtyInBaseUnit | ARun_ValAddedSrvcSTOAssgmt | ConfirmedRqmtQtyInBaseUnit | ||
| SalesOrganization | ARun_ValAddedSrvcSTOAssgmt | SalesOrganization | Sales Organization | |
| DistributionChannel | ARun_ValAddedSrvcSTOAssgmt | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | ARun_ValAddedSrvcSTOAssgmt | Division | Internal Division ID | |
| OrderType | ARun_ValAddedSrvcSTOAssgmt | OrderType | Order Type | |
| SoldToParty | ARun_ValAddedSrvcSTOAssgmt | SoldToParty | Sold-to Party | |
| ShipToParty | ARun_ValAddedSrvcSTOAssgmt | ShipToParty | Ship-To Party (obsolete) | |
| DeliveryGroup | Delivery Group | |||
| ShippingGroupNumber | ARun_ValAddedSrvcSTOAssgmt | ShippingGroupNumber | PSST Group | |
| ARunSupplyAssgmtReleaseRule | Release Rule | |||
| ARunUUID | ARun_ValAddedSrvcSTOAssgmt | ARunUUID | ||
| CrossPlantConfigurableProduct | ARun_ValAddedSrvcSTOAssgmt | CrossPlantConfigurableProduct | Cross-plant CP | |
| SupplyAssignmentStatus | ARun_ValAddedSrvcSTOAssgmt | SupplyAssignmentStatus | ||
| AssignedSupplyType | ARun_ValAddedSrvcSTOAssgmt | AssignedSupplyType | ||
| StorageLocation | ARun_ValAddedSrvcSTOAssgmt | StorageLocation | StorageLocation | |
| Batch | ARun_ValAddedSrvcSTOAssgmt | Batch | Lot No. | |
| InboundDelivery | ARun_ValAddedSrvcSTOAssgmt | InboundDelivery | LE Delivery | |
| InboundDeliveryItem | ARun_ValAddedSrvcSTOAssgmt | InboundDeliveryItem | Item | |
| HigherLvlItmOfBatSpltItm | ARun_ValAddedSrvcSTOAssgmt | HigherLvlItmOfBatSpltItm | ||
| SupplyDeliveryDate | ARun_ValAddedSrvcSTOAssgmt | SupplyDeliveryDate | ||
| AssignedQuantityInBaseUnit | ARun_ValAddedSrvcSTOAssgmt | AssignedQuantityInBaseUnit | ||
| BaseUnit | ARun_ValAddedSrvcSTOAssgmt | BaseUnit | Unit of Measure |
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_ValAddedSrvcDmndDocs.
-- 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_ValAddedSrvcDmndDocs AS
SELECT
_ARunValAddedSrvcSDAssgmt.RequirementType AS RequirementType,
_ARunValAddedSrvcSDAssgmt.SalesDocument AS RequirementDocumentNumber,
_ARunValAddedSrvcSDAssgmt.SalesDocumentItem AS RequirementDocumentItem,
_ARunValAddedSrvcSDAssgmt.ValAddedSrvcItemNumber AS ValAddedSrvcItemNumber,
_ARunValAddedSrvcSDAssgmt.ValAddedSrvcHasToBeOrdered AS ValAddedSrvcHasToBeOrdered,
_ARunValAddedSrvcSDAssgmt.ValAddedSrvcIsRlvtForProcmt AS ValAddedSrvcIsRlvtForProcmt,
_ARunValAddedSrvcSDAssgmt.Plant AS Plant,
_ARunValAddedSrvcSDAssgmt.Material AS Material,
_ARunValAddedSrvcSDAssgmt.RqmtIsSupAssgmtRelevant AS RqmtIsSupAssgmtRelevant,
_ARunValAddedSrvcSDAssgmt.IsInternalBatchManaged AS IsInternalBatchManaged,
_ARunValAddedSrvcSDAssgmt.RequestedDate AS RequestedDate,
_ARunValAddedSrvcSDAssgmt.ProductAvailabilityDate AS ProductAvailabilityDate,
_ARunValAddedSrvcSDAssgmt.RequestedRqmtQtyInBaseUnit AS RequestedRqmtQtyInBaseUnit,
_ARunValAddedSrvcSDAssgmt.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
_ARunValAddedSrvcSDAssgmt.ConfirmedRqmtQtyInBaseUnit AS ConfirmedRqmtQtyInBaseUnit,
_ARunValAddedSrvcSDAssgmt.SalesOrganization AS SalesOrganization,
_ARunValAddedSrvcSDAssgmt.DistributionChannel AS DistributionChannel,
_ARunValAddedSrvcSDAssgmt.Division AS Division,
_ARunValAddedSrvcSDAssgmt.OrderType AS OrderType,
_ARunValAddedSrvcSDAssgmt.SoldToParty AS SoldToParty,
_ARunValAddedSrvcSDAssgmt.ShipToParty AS ShipToParty,
_ARunValAddedSrvcSDAssgmt.DeliveryGroup AS DeliveryGroup,
_ARunValAddedSrvcSDAssgmt.ShippingGroupNumber AS ShippingGroupNumber,
_ARunValAddedSrvcSDAssgmt.ARunSupplyAssgmtReleaseRule AS ARunSupplyAssgmtReleaseRule,
_ARunValAddedSrvcSDAssgmt.ARunUUID AS ARunUUID,
_ARunValAddedSrvcSDAssgmt.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
_ARunValAddedSrvcSDAssgmt.SupplyAssignmentStatus AS SupplyAssignmentStatus,
_ARunValAddedSrvcSDAssgmt.AssignedSupplyType AS AssignedSupplyType,
_ARunValAddedSrvcSDAssgmt.StorageLocation AS StorageLocation,
_ARunValAddedSrvcSDAssgmt.Batch AS Batch,
_ARunValAddedSrvcSDAssgmt.InboundDelivery AS InboundDelivery,
_ARunValAddedSrvcSDAssgmt.InboundDeliveryItem AS InboundDeliveryItem,
_ARunValAddedSrvcSDAssgmt.HigherLvlItmOfBatSpltItm AS HigherLvlItmOfBatSpltItm,
_ARunValAddedSrvcSDAssgmt.SupplyDeliveryDate AS SupplyDeliveryDate,
_ARunValAddedSrvcSDAssgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
_ARunValAddedSrvcSDAssgmt.BaseUnit as BaseUnit AS RequirementTypeasRequirementType,
_ARunValAddedSrvcSTOAssgmt.BaseUnit AS BaseUnit
FROM ARun_ValAddedSrvcSDAssgmt AS _ARunValAddedSrvcSDAssgmt
-- UNION ALL with additional select branch(es): ARun_ValAddedSrvcSTOAssgmt
;Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA