I_ACMAPPLICATIONDOCITEM1

CDS View

Basic Application Doc Item Data

I_ACMAPPLICATIONDOCITEM1 is a CDS View in S/4HANA. Basic Application Doc Item Data. It contains 17 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 17 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMAppDocDPQSUoMCnvrsn view inner COMPOSITE ACM DPQS quantity UoM conversion
I_ACMAppDocQuality view from COMPOSITE Q Repository Grades Application Doc
I_ACMApplicationOverview1 view inner COMPOSITE Interface ACM Application Overview1

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ApplicationDocument ApplicationDocument 1
KEY ReferenceApplicationItem ReferenceApplicationItem 2
ACMAppDocBaseUoM ACMAppDocBaseUoM 1
ACMApplOvwSpotFlag ACMApplOvwSpotFlag 1
ACMDecimalGrossQuantity ACMDecimalGrossQuantity 1
ACMNetQuantity ACMNetQuantity 1
ApplDocumentChangedBy ApplDocumentChangedBy 1
ApplDocumentCreatedBy ApplDocumentCreatedBy 1
ApplicationItemChangedOnDate ApplicationItemChangedOnDate 1
ApplicationItemCreatedOnDate ApplicationItemCreatedOnDate 1
ContractApplicationItemUUID ContractApplicationUUID 1
Counterparty Counterparty 1
DeliveryDate DeliveryDate 1
LoadDataCaptureObjId LoadDataCaptureObjId 1
Plant Plant 1
ReferenceApplicationSide ReferenceApplicationSide 1
UnitOfMeasure UnitOfMeasure 1 
@AbapCatalog.sqlViewName: 'IACMAPPITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
@EndUserText.label: 'Basic Application Doc Item Data'
define view I_ACMApplicationDocItem1
  as select from I_ACMAppDocumentItem as Item
{
  key ApplicationDocument,
  key ReferenceApplicationItem,
  key ReferenceApplicationSide,
  key ACMApplicationDocumentSubItem,
      ContractApplicationItemUUID,
      DocumentDate,
      ObjectInternalID,
      ACMSettlementStatusObject,
      ACMStorageStatusObject,
      Material,
      Plant,
      LoadDataCaptureObjId,
      LDCKey,
      StorageStartDate,
      StorageEndDate,
      WarehouseReceiptType,
      WarehouseReceiptNo,
      WarehouseReceiptStartDate,
      WarehouseReceiptEndDate,
      WarehouseReceiptObligationType,
//      @Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedQuantityUnit'

//      WarehouseReceiptedQuantity,

      ACMWarehouseReceiptQtyVal,
      @Semantics.unitOfMeasure: true
      WarehouseReceiptedQuantityUnit,
//      @Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedOpenQtyUnit'

//      WarehouseReceiptedOpenQty,

      ACMWarehouseReceiptOpenQtyVal,
      @Semantics.unitOfMeasure: true
      WarehouseReceiptedOpenQtyUnit,
      StorageRatesLockedValue,
      StorageFreeDaysValue,
      StorageAgreement,
      StorageAgreementItem,
      ApplDocumentCreatedBy,
      ApplDocumentChangedBy,
      ApplicationItemCreatedOnDate,
      ApplicationItemChangedOnDate,
      DeliveryDate,
      ACMApplDocContrOptnLoadLoc,
      ACMApplDocContrOptnDschrgdLoc,
      ACMContractOptionsCropSeasonID,
      ACMContrOptionsSourceLocation,
      ModeOfTransport,
      ACMContrOptionsMnsOfTransport,
      DeliveryStartDate,
      DeliveryEndDate,
      cast( ReferenceVendor as lifnr preserving type )    as Counterparty,
      @Semantics.unitOfMeasure: true
      UnitOfMeasure,
      ACMApplOvwSpotFlag,
      @Semantics.quantity.unitOfMeasure: 'ACMAppDocBaseUoM'
      ACMDecimalGrossQuantity,
      @Semantics.quantity.unitOfMeasure: 'ACMAppDocBaseUoM'
      ACMNetQuantity,
      @Semantics.unitOfMeasure: true
      ACMAppDocBaseUoM,
      ConversionFactorNmrtrValue,
      ConversionFactorDnmntrValue
}

where
     ReferenceApplicationSide    =  'M'

union select distinct from I_ACMAppDocumentItem as Item
{
  key ApplicationDocument,
  key ReferenceApplicationItem,
  key ReferenceApplicationSide,
  key ACMApplicationDocumentSubItem,
      ContractApplicationItemUUID,
      DocumentDate,
      ObjectInternalID,
      ACMSettlementStatusObject,
      ACMStorageStatusObject,
      Material,
      Plant,
      LoadDataCaptureObjId,
      LDCKey,
      StorageStartDate,
      StorageEndDate,
      WarehouseReceiptType,
      WarehouseReceiptNo,
      WarehouseReceiptStartDate,
      WarehouseReceiptEndDate,
      WarehouseReceiptObligationType,
//      @Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedQuantityUnit'

//      WarehouseReceiptedQuantity,

      ACMWarehouseReceiptQtyVal,
      @Semantics.unitOfMeasure: true
      WarehouseReceiptedQuantityUnit,
//      @Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedOpenQtyUnit'

//      WarehouseReceiptedOpenQty,

      ACMWarehouseReceiptOpenQtyVal,
      @Semantics.unitOfMeasure: true
      WarehouseReceiptedOpenQtyUnit,
      StorageRatesLockedValue,
      StorageFreeDaysValue,
      StorageAgreement,
      StorageAgreementItem,
      ApplDocumentCreatedBy,
      ApplDocumentChangedBy,
      ApplicationItemCreatedOnDate,
      ApplicationItemChangedOnDate,
      DeliveryDate,
      ACMApplDocContrOptnLoadLoc,
      ACMApplDocContrOptnDschrgdLoc,
      ACMContractOptionsCropSeasonID,
      ACMContrOptionsSourceLocation,
      ModeOfTransport,
      ACMContrOptionsMnsOfTransport,
      DeliveryStartDate,
      DeliveryEndDate,
      cast( CustomerNum as kunnr preserving type )    as Counterparty,
      @Semantics.unitOfMeasure: true
      UnitOfMeasure,
      ACMApplOvwSpotFlag,
      @Semantics.quantity.unitOfMeasure: 'ACMAppDocBaseUoM'
      ACMDecimalGrossQuantity,
      @Semantics.quantity.unitOfMeasure: 'ACMAppDocBaseUoM'
      ACMNetQuantity,
      @Semantics.unitOfMeasure: true
      ACMAppDocBaseUoM,
      ConversionFactorNmrtrValue,
      ConversionFactorDnmntrValue
}

where
     ReferenceApplicationSide    =  'V'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMAPPDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More