A_PurchasingQuotaArrangement_2

DDL: A_PURCHASINGQUOTAARRANGEMENT_2 Type: view_entity CONSUMPTION
12 Fields 1 Data Sources

Quota Arrangement

A_PurchasingQuotaArrangement_2 is a Consumption CDS View that provides data about "Quota Arrangement" in SAP S/4HANA. It reads from 1 data source (R_PurgQuotaArrgmtTP) and exposes 12 fields with key field QuotaArrangement.

Data Sources (1)

SourceAliasJoin Type
R_PurgQuotaArrgmtTP R_PurgQuotaArrgmtTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Quota Arrangement view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
OData.entityType.name PurchasingQuotaArrangement_Type view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY QuotaArrangement QuotaArrangement Quota arr.
Material Material Vehicle Model
Plant Plant Valuation Area
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
MinQtyForSpltQuota MinQtyForSpltQuota
LastChangeDateTime LastChangeDateTime Timestamp
UserDescription UserDescription Full Name
MaterialBaseUnit MaterialBaseUnit Valuation Unit
BaseUnitISOCode BaseUnitISOCode

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 A_PurchasingQuotaArrangement_2.
-- 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 A_PurchasingQuotaArrangement_2 AS
SELECT
  QuotaArrangement,
  Material,
  Plant,
  ValidityEndDate,
  ValidityStartDate,
  CreationDate,
  CreatedByUser,
  MinQtyForSpltQuota,
  LastChangeDateTime,
  UserDescription,
  MaterialBaseUnit,
  BaseUnitISOCode
FROM R_PurgQuotaArrgmtTP
;

Learn More