I_ACMAPPLDOCITEM
Application Document item Data
I_ACMAPPLDOCITEM is a CDS View in S/4HANA. Application Document item Data. It contains 14 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ACMApplicationOverview | view | inner | TRANSACTIONAL | Interface Layer for ACM Application Overview |
| I_ApplicationDocContractOption | view | from | BASIC | Interface Layer of Application Document Contract Option Data |
| I_ApplicationDocStorDets | view | from | COMPOSITE | Interface Layer for App Doc Storage Details |
| I_ApplicationOverviewStstc | view | inner | COMPOSITE | Interface view for Application Document Overview Statistics |
Fields (14)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| ACMApplDocIsBackToBack | ACMApplDocIsBackToBack | 1 | |
| ACMApplOvwSpotFlag | ACMApplOvwSpotFlag | 1 | |
| ACMPredecessorDocumentNumber | ACMPredecessorDocumentNumber | 1 | |
| ApplicationHasCallOff | ApplicationHasCallOff | 1 | |
| Counterparty | Counterparty | 1 | |
| DeliveryEndDate | DeliveryEndDate | 1 | |
| DeliveryStartDate | DeliveryStartDate | 1 | |
| LDCIsMultipleBuySellRelevant | LDCIsMultipleBuySellRelevant | 1 | |
| LoadDataCaptureObjId | LoadDataCaptureObjId | 1 | |
| Material | Material | 1 | |
| NominationNumber | NominationNumber | 1 | |
| PredecessorDocumentNumber | PredecessorDocumentNumber | 1 | |
| TrdgContrItemApplicationQty | TrdgContrItemApplicationQty | 1 | |
| UnitOfMeasure | UnitOfMeasure | 1 |
@AbapCatalog.sqlViewName: 'IACMAPPLDOCITM'
@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: #XL
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Application Document item Data'
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
define view I_ACMApplDocItem
as select from /accgo/t_cas_cai as Item
{
key appldoc as ApplicationDocument,
key item as ReferenceApplicationItem,
key side as ReferenceApplicationSide,
key sub_item as ReferenceApplicationSubItem,
item_guid as ContractApplicationItemUUID,
budat as DocumentDate,
appl_objnr as ObjectInternalID,
matnr as Material,
uis_id as LoadDataCaptureObjId,
pred_doc_type3 as PrecedingDocumentType,
//substring(pred_doc3, 1 , 10) as PredecessorDocumentNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ACMPredecessorDocumentNumber'
pred_doc3 as PredecessorDocumentNumber,
// cast( pred_doc3 as /accgo/e_appldoc ) as PredecessorDocumentNumber,
cast(substring(pred_doc3, 1 , 10) as /accgo/e_appldoc ) as ACMPredecessorDocumentNumber,
pred_side3 as PredecessorDocumentSide,
uis_guid as LDCKey,
in_transit as IsApplicationItemInTransit,
is_planned as ApplicationHasCallOff,
nomtk as NominationNumber,
scalp_rel as ACMApplDocIsBackToBack,
mbs_rel as LDCIsMultipleBuySellRelevant,
strg_start_date as StorageStartDate,
strg_end_date as StorageEndDate,
whr_type as WarehouseReceiptType,
whr_id as WarehouseReceiptNo,
whr_start_date as WarehouseReceiptStartDate,
whr_end_date as WarehouseReceiptEndDate,
obligation_type as WarehouseReceiptObligationType,
@Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedQuantityUnit'
whr_qty as WarehouseReceiptedQuantity,
@Semantics.unitOfMeasure: true
whr_uom as WarehouseReceiptedQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedOpenQtyUnit'
open_whr_qty as WarehouseReceiptedOpenQty,
@Semantics.unitOfMeasure: true
open_whr_uom as WarehouseReceiptedOpenQtyUnit,
strg_rates_locked as StorageRatesLockedValue,
strg_free_days as StorageFreeDaysValue,
strg_agreement as StorageAgreement,
strg_agreement_item as StorageAgreementItem,
created_by as ApplDocumentCreatedBy,
changed_by as ApplDocumentChangedBy,
tstmp_to_dats( created_on, //Convert To Date
abap_system_timezone( $session.client,'NULL' ),
$session.client,
'NULL' ) as ApplicationItemCreatedOnDate,
tstmp_to_dats( changed_on, //Convert To Date
abap_system_timezone( $session.client,'NULL' ),
$session.client,
'NULL' ) as ApplicationItemChangedOnDate,
delivery_date_eod as DeliveryDate,
load_location as ACMApplDocContrOptnLoadLoc,
discharge_loc as ACMApplDocContrOptnDschrgdLoc,
crop_season_id as ACMContractOptionsCropSeasonID,
source_loc as SourceLocation,
vktra as ModeOfTransport,
means_trnspt as MeansOfTransport,
del_period as DeliveryStartDate,
del_period_end as DeliveryEndDate,
// cast(lifnr as lifnr preserving type ) as Counterparty,
case
when side = 'M'
then cast(lifnr as lifnr preserving type )
when side = 'V'
then cast(kunnr as lifnr preserving type )
end as Counterparty,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
item_qty as TrdgContrItemApplicationQty,
@Semantics.unitOfMeasure: true
item_uom as UnitOfMeasure,
// BOC FPS02 1909 Functionality 01/16/2020
spot_eod as ACMApplOvwSpotFlag
// EOC FPS02 1909 Functionality 01/16/2020
}
where
item_cat <> 'T' // Parent Item
and(
appl_objnr is not initial
or stl_objnr is not initial
)
/* Commented For Performance Improvement */
// side = 'M'
//union select distinct from /accgo/t_cas_cai
//{
// key appldoc as ApplicationDocument,
// key item as ReferenceApplicationItem,
// key side as ReferenceApplicationSide,
// key sub_item as ReferenceApplicationSubItem,
// item_guid as ContractApplicationItemUUID,
// budat as DocumentDate,
// appl_objnr as ObjectInternalID,
// matnr as Material,
// uis_id as LoadDataCaptureObjId,
// pred_doc_type3 as PrecedingDocumentType,
// // substring(pred_doc3, 1 , 10) as PredecessorDocumentNumber,
// @API.element.releaseState: #DEPRECATED
// @API.element.successor: 'ACMPredecessorDocumentNumber'
// pred_doc3 as PredecessorDocumentNumber,
// cast(substring(pred_doc3, 1 , 10) as /accgo/e_appldoc ) as ACMPredecessorDocumentNumber,
// pred_side3 as PredecessorDocumentSide,
// uis_guid as LDCKey,
// in_transit as IsApplicationItemInTransit,
// is_planned as ApplicationHasCallOff,
// nomtk as NominationNumber,
// scalp_rel as ACMApplDocIsBackToBack,
// mbs_rel as LDCIsMultipleBuySellRelevant,
// strg_start_date as StorageStartDate,
// strg_end_date as StorageEndDate,
// whr_type as WarehouseReceiptType,
// whr_id as WarehouseReceiptNo,
// whr_start_date as WarehouseReceiptStartDate,
// whr_end_date as WarehouseReceiptEndDate,
// obligation_type as WarehouseReceiptObligationType,
// @Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedQuantityUnit'
// whr_qty as WarehouseReceiptedQuantity,
// @Semantics.unitOfMeasure: true
// whr_uom as WarehouseReceiptedQuantityUnit,
// @Semantics.quantity.unitOfMeasure: 'WarehouseReceiptedOpenQtyUnit'
// open_whr_qty as WarehouseReceiptedOpenQty,
// @Semantics.unitOfMeasure: true
// open_whr_uom as WarehouseReceiptedOpenQtyUnit,
// strg_rates_locked as StorageRatesLockedValue,
// strg_free_days as StorageFreeDaysValue,
// strg_agreement as StorageAgreement,
// strg_agreement_item as StorageAgreementItem,
// created_by as ApplDocumentCreatedBy,
// changed_by as ApplDocumentChangedBy,
//
// tstmp_to_dats( created_on, //Convert To Date
// abap_system_timezone( $session.client,'NULL' ),
// $session.client,
// 'NULL' ) as ApplicationItemCreatedOnDate,
//
//
// tstmp_to_dats( changed_on, //Convert To Date
// abap_system_timezone( $session.client,'NULL' ),
// $session.client,
// 'NULL' ) as ApplicationItemChangedOnDate,
//
// delivery_date_eod as DeliveryDate,
// load_location as ACMApplDocContrOptnLoadLoc,
// discharge_loc as ACMApplDocContrOptnDschrgdLoc,
// crop_season_id as ACMContractOptionsCropSeasonID,
// source_loc as SourceLocation,
// vktra as ModeOfTransport,
// means_trnspt as MeansOfTransport,
// del_period as DeliveryStartDate,
// del_period_end as DeliveryEndDate,
//
// cast(kunnr as lifnr preserving type ) as Counterparty,
// @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
// item_qty as TrdgContrItemApplicationQty,
// @Semantics.unitOfMeasure: true
// item_uom as UnitOfMeasure,
// // BOC FPS02 1909 Functionality 01/16/2020
// spot_eod as ACMApplOvwSpotFlag
// // EOC FPS02 1909 Functionality 01/16/2020
//}
//where
// side = 'V'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_CAS_CAI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/