I_ACMAPPDOCLATESTVERSION1
Interface App Doc Latest Version Data
I_ACMAPPDOCLATESTVERSION1 is a CDS View in S/4HANA. Interface App Doc Latest Version Data. It contains 14 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ACMAppDocDPQSEvaluation | view | inner | COMPOSITE | Interface DPQS Evaluation |
| I_ACMAppDocToleranceDet | view | inner | COMPOSITE | Interface Tolerance Eval Details |
| I_ACMApplicationOverview1 | view | from | COMPOSITE | Interface ACM Application Overview1 |
Fields (14)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ReferenceApplicationDocument | ReferenceApplicationDocument | 2 |
| KEY | ReferenceApplicationItem | ReferenceApplicationItem | 3 |
| ACMOverfillQuantity | ACMOverfillQuantity | 1 | |
| ACMUnderFillQuantity | ACMUnderFillQuantity | 1 | |
| ApplDocumentCreatedBy | ApplDocumentChangedBy,ApplDocumentCreatedBy | 1 | |
| ApplicationItemChangedOnDate | ApplicationItemChangedOnDate | 1 | |
| ApplicationItemCreatedOnDate | ApplicationItemCreatedOnDate | 1 | |
| ContractApplicationUUID | ContractApplicationUUID | 1 | |
| ContractApplicationVersion | ContractApplicationVersion | 1 | |
| DeliveryDate | DeliveryDate | 1 | |
| ReferenceApplicationSide | ReferenceApplicationSide | 1 | |
| ReferenceApplicationSubItem | ReferenceApplicationSubItem | 1 | |
| TradingContractItem | TradingContractItem | 1 | |
| TradingContractNumber | TradingContractNumber | 1 |
@AbapCatalog.sqlViewName: 'IACMAPPLATESTVER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.preserveKey:true
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
@EndUserText.label: 'Interface App Doc Latest Version Data'
define view I_ACMAppDocLatestVersion1
as select from P_ACMApplicationLatestVersion
{
key ContractApplicationUUID,
key ContractApplicationVersion,
ReferenceApplicationDocument,
ReferenceApplicationItem,
ReferenceApplicationSide,
ReferenceApplicationSubItem,
ContractNum as TradingContractNumber,
ContractItem as TradingContractItem,
DeliveryDate,
@Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
ACMOverfillQuantity,
@Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
ACMUnderFillQuantity,
@Semantics.unitOfMeasure: true
TrdgContractApplUnitOfMeasure,
CreatedBy as ApplDocumentCreatedBy,
ChangedBy as ApplDocumentChangedBy,
tstmp_to_dats( CreatedOn, //Convert To Date
abap_system_timezone( $session.client,'NULL' ),
$session.client,
'NULL' ) as ApplicationItemCreatedOnDate,
tstmp_to_dats( ChangedOn, //Convert To Date
abap_system_timezone( $session.client,'NULL' ),
$session.client,
'NULL' ) as ApplicationItemChangedOnDate,
cast( ContractApplicationStatus as char1 ) as ContractApplicationStatus,
ConversionFactorNmrtrValue,
ConversionFactorDnmntrValue,
UnitOfMeasure,
ACMRepositoryWeightAppUUID,
LatestGroupVersion
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ACMAPPLICATIONLATESTVERSION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/