P_ACMAppliedApplicationData

DDL: P_ACMAPPLIEDAPPLICATIONDATA SQL: PCTRAPPLDETS Type: view COMPOSITE
12 Fields 1 Data Sources

P_ACMAppliedApplicationData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ACMAppldApplDocData) and exposes 12 fields with key fields ContractApplicationUUID, ContractApplicationVersion.

Data Sources (1)

SourceAliasJoin Type
I_ACMAppldApplDocData AppData from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCTRAPPLDETS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ContractApplicationUUID ApplUniversallyUniIdentifier GUID (Hex) Specified by the Application
KEY ContractApplicationVersion ApplicationVersion Application Version
ReferenceDocumentType
ApplicationDocument
ApplicationDocumentItem ReferenceDocumentItem Reference item
ContractNum ContractNum Trading Contract
TradingContractItem TradingContractItem Item Number
ContractApplicationStatus ApplicationStatus
PredecessorDocumentNumber PrecedingDocument SD Document
PredecessorDocumentItem PrecedingDocumentItem Item
CommodityQuantityInBaseUnit CommodityQuantityInBaseUnit Applied Quantity
BaseUnitofMeasure BaseUnitofMeasure Base Unit

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 P_ACMAppliedApplicationData.
-- 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.
-- SQL view name: PCTRAPPLDETS

CREATE VIEW P_ACMAppliedApplicationData AS
SELECT
  ApplUniversallyUniIdentifier AS ContractApplicationUUID,
  ApplicationVersion AS ContractApplicationVersion,
  lpad(ReferenceDocumentNumber,10,'0') AS ApplicationDocument,
  ReferenceDocumentItem AS ApplicationDocumentItem,
  ContractNum,
  TradingContractItem,
  ApplicationStatus AS ContractApplicationStatus,
  PrecedingDocument AS PredecessorDocumentNumber,
  PrecedingDocumentItem AS PredecessorDocumentItem,
  CommodityQuantityInBaseUnit,
  BaseUnitofMeasure
FROM I_ACMAppldApplDocData AS AppData
;

Learn More