@AbapCatalog.sqlViewName: 'CCTRFSACCTASSGMT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Contract FactSheet Account Assignment'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@UI.headerInfo:{
typeName: 'Account Assignment',
typeNamePlural: 'Account Assignments',
title: {value: 'AccountAssignment'}
}
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view C_ContractFactSheetAcctAssgmt
as select from I_PurCtrAccount as Document
---Association to the Contracts FactSheet Header View
association [1..1] to C_ContractFs as _PurchaseContract on $projection.PurchaseContract = _PurchaseContract.PurchaseContract
// --- Association to the Contracts FactSheet Item View
association [1..1] to C_ContractItemFs as _PurchaseContractItem on $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem
and $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract
association [1..1] to I_InternalOrder as _InternalOrder on $projection.OrderID = _InternalOrder.InternalOrder
association [1..1] to I_CompanyCode as _CompanyCode on $projection.companycode = _CompanyCode.CompanyCode
association [0..1] to I_MM_InternalOrderVH as _MM_InternalOrderVH on $projection.OrderID = _MM_InternalOrderVH.InternalOrder
association [0..*] to I_MM_ProfitCenterValueHelp as _MM_ProfitCenterValueHelp on $projection.ControllingArea = _MM_ProfitCenterValueHelp.ControllingArea
and $projection.ProfitCenter = _MM_ProfitCenterValueHelp.ProfitCenter
association [0..1] to I_MM_ProjectNetworkVH as _MM_ProjectNetworkVH on $projection.ProjectNetwork = _MM_ProjectNetworkVH.ProjectNetwork
association [0..1] to I_MM_WBSElementValueHelp as _MM_WBSElementValueHelp on $projection.WBSElementInternalID = _MM_WBSElementValueHelp.WBSElementInternalID
association [0..1] to I_WBSElementByInternalKey as _WBSElementByInternalKeyVH on $projection.WBSElementInternalID = _WBSElementByInternalKeyVH.WBSElementInternalID
association [0..*] to I_MM_CommitmentItemVH as _MM_CommitmentItemVH on $projection.CommitmentItem = _MM_CommitmentItemVH.CommitmentItem
association [0..*] to I_FundStdVH as _FundStdVH on $projection.Fund = _FundStdVH.Fund
association [0..1] to I_BudgetPeriodStdVH as _BudgetPeriodStdVH on _BudgetPeriodStdVH.BudgetPeriod = $projection.BudgetPeriod
//new F4 helps
// association [0..1] to I_MM_CostCenterValueHelp as _MM_CostCenterValueHelp on $projection.CostCenter = _MM_CostCenterValueHelp.CostCenter
// and $projection.ControllingArea = _MM_CostCenterValueHelp.ControllingArea
// and $projection.ValidityDate <= _MM_CostCenterValueHelp.ValidityEndDate
// association [0..1] to I_MM_FixedAssetValueHelp as _MM_FixedAssetValueHelp on $projection.FixedAsset = _MM_FixedAssetValueHelp.FixedAsset
// and $projection.MasterFixedAsset = _MM_FixedAssetValueHelp.MasterFixedAsset
// and $projection.companycode = _MM_FixedAssetValueHelp.CompanyCode
// association [1..1] to I_Ordertypes as _Ordertypes on $projection.OrderID = _Ordertypes.OrderType //replaced by I_InternalOrder for CDS hardening
// association [0..1] to I_MM_ControllingAreaVH as _MM_ControllingAreaVH on _MM_ControllingAreaVH.ControllingArea = $projection.ControllingArea
// association [0..1] to I_MM_SalesOrderValueHelp as _MM_SalesOrderValueHelp on $projection.SalesOrder = _MM_SalesOrderValueHelp.SalesOrder
// association [0..1] to I_MM_SalesOrderItemVH as _MM_SalesOrderItemVH on $projection.SalesOrder = _MM_SalesOrderItemVH.SalesOrder
// and $projection.SalesOrderItem = _MM_SalesOrderItemVH.SalesOrderItem
// association [0..1] to I_MM_NetworkActivityVH as _MM_NetworkActivityVH on $projection.ProjectNetwork = _MM_NetworkActivityVH.ProjectNetwork
// and $projection.NetworkActivity = _MM_NetworkActivityVH.NetworkActivity
//association [0..1] to I_MM_GLAccountVH as _MM_GLAccountVH on $projection.GLAccount = _MM_GLAccountVH.GLAccount
// and $projection.companycode = _MM_GLAccountVH.CompanyCode
{
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
@EndUserText.label: 'Purchasing Doc. Item No.'
key Document.PurchaseContractItem,
@UI.lineItem.position: 10
//key Document.AccountAssignment,
key cast(AccountAssignment as accas) as AccountAssignment,
key Document.PurchaseContract,
// @UI.hidden: true
// Document.PurchaseContractForEdit,
// @UI.hidden: true
// Document.PurchaseContractItemForEdit,
@UI:{ identification: {position: 10, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
//@Consumption.valueHelp: '_MM_CostCenterValueHelp'
// @Consumption.valueHelpDefinition: [{ entity:{ name:'I_MM_CostCenterValueHelp',
// element:'CostCenter'},
// additionalBinding: [{ localElement: 'ControllingArea',
// element: 'ControllingArea'},
// {localElement: 'ValidityDate',
// element: 'ValidityEndDate' }]
//
// }]
//@ObjectModel.foreignKey.association: '_MM_CostCenterValueHelp'
//@ObjectModel.foreignKey.association: '_CostCenter'
Document.CostCenter,
@UI:{ identification: {position: 40, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @Consumption.valueHelp: '_MM_FixedAssetValueHelp'
// @ObjectModel.foreignKey.association: '_MM_FixedAssetValueHelp'
// @Consumption.valueHelpDefinition: [{ entity:{ name:'I_MM_FixedAssetValueHelp',
// element:'MasterFixedAsset'},
// additionalBinding: [{ localElement: 'FixedAsset',
// element: 'FixedAsset'},
// {localElement: 'CompanyCode',
// element: 'CompanyCode' }]
//
// }]
// @ObjectModel.foreignKey.association: '_FixedAsset'
Document.MasterFixedAsset,
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 60, importance: #HIGH}
}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
//@Consumption.valueHelp: '_MM_ProjectNetworkVH'
//@ObjectModel.foreignKey.association: '_MM_ProjectNetworkVH'
// @Consumption.valueHelpDefinition: [{
// entity: { name: 'I_MM_ProjectNetworkVH',
// element: 'ProjectNetwork' }
// }]
Document.ProjectNetwork,
@UI.lineItem.position: 30
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 30, importance: #HIGH}
}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.Quantity,
//@ObjectModel.readOnly: true
@UI.lineItem.position: 40
@UI:{ identification: {position: 20, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.MultipleAcctAssgmtDistrPercent,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
@UI.hidden: true
@UI.lineItem.position: 50
@Semantics.amount.currencyCode: 'DocumentCurrency'
Document.PurgDocNetAmount,
Document.IsDeleted,
@UI.lineItem.position: 20
@UI:{ identification: {position: 30, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
//@Consumption.valueHelp: '_MM_GLAccountVH'
//@ObjectModel.foreignKey.association: '_MM_GLAccountVH'
//@ObjectModel: [{foreignKey.association: '_GLAccount'}]
// @Consumption.valueHelpDefinition: [{
// entity: { name: 'I_MM_GLAccountVH',
// element: 'GLAccount' },
// additionalBinding: [{ localElement: 'CompanyCode',
// element: 'CompanyCode'}]
// }]
Document.GLAccount,
@UI:{ identification: {position: 90, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
//@ObjectModel: [{ foreignKey.association: '_BusinessArea' }]
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_BusinessAreaStdVH',
// element: 'BusinessArea' }
// }]
Document.BusinessArea,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @ObjectModel: [{ foreignKey.association: '_MM_SalesOrderValueHelp' }]
@UI:{ identification: {position: 100, importance: #HIGH}}
// @Consumption.valueHelp: '_MM_SalesOrderValueHelp'
// @ObjectModel: [{ foreignKey.association: '_BusinessArea' }]
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_MM_SalesOrderValueHelp',
// element: 'SalesOrder' }
// }]
Document.SalesOrder,
@UI:{ identification: {position: 110, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
@EndUserText.label: 'Sales Doc. Item No.'
Document.SalesOrderItem,
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 50, importance: #HIGH}
}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.SalesOrderScheduleLine,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @Consumption.valueHelp: '_MM_FixedAssetValueHelp'
// @ObjectModel.foreignKey.association: '_MM_FixedAssetValueHelp'
@UI:{ identification: {position: 50, importance: #HIGH}}
// @Consumption.valueHelpDefinition: [{ entity:{ name:'I_MM_FixedAssetValueHelp',
// element:'FixedAsset'},
// additionalBinding: [{ localElement: 'MasterFixedAsset',
// element: 'MasterFixedAsset'},
// {localElement: 'CompanyCode',
// element: 'CompanyCode' }]
//
// }]
//@ObjectModel.foreignKey.association: '_FixedAsset'
Document.FixedAsset,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @ObjectModel: [{ foreignKey.association: '_MM_InternalOrderVH' }] //@ObjectModel: [{ foreignKey.association: '_Ordertypes' }] InternalOrder
//@Consumption.valueHelp: '_MM_InternalOrderVH' //@Consumption.valueHelp: '_Ordertypes'
@UI:{ identification: {position: 60, importance: #HIGH}}
Document.OrderID,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 10, importance: #HIGH}
}
Document.UnloadingPointName,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @ObjectModel: [{ foreignKey.association: '_MM_ControllingAreaVH' }]
// @Consumption.valueHelp: '_MM_ControllingAreaVH'
// @ObjectModel.foreignKey.association: '_MM_ControllingAreaVH'
// @Consumption.valueHelpDefinition: [{ entity:{ name:'I_MM_ControllingAreaVH',
// element:'ControllingArea'}
//
// }]
// @ObjectModel.foreignKey.association: '_ControllingArea'
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 10, importance: #HIGH}
}
Document.ControllingArea,
@UI:{ identification: {position: 120, importance: #HIGH}}
Document.CostObject,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// Document.ProfitabilitySegment,
cast( Document.ProfitabilitySegment as rkeobjnr_char ) as ProfitabilitySegment,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @ObjectModel: [{ foreignKey.association: '_MM_ProfitCenterValueHelp' }]
//@Consumption.valueHelp: '_MM_ProfitCenterValueHelp'
@UI:{ identification: {position: 140, importance: #HIGH}}
Document.ProfitCenter,
@UI.hidden: true
//Document.WBSElementInternalID,
Document.WBSElementInternalID_2 as WBSElementInternalID,
@UI:{ identification: {position: 150, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_MM_WBSElementValueHelp',
// element: 'WBSElement' },
// additionalBinding:
// [{localElement:'WBSElementInternalID',
// element:'WBSElementInternalID', usage:#RESULT}]
//
// }]
Document.WBSElementExternalID as WBSElement,
@UI.hidden: true
//@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
Document.WBSDescription,
@UI:{ identification: {position: 70, importance: #HIGH}}
@EndUserText.label: 'Opertn Task List No.'
Document.ProjectNetworkInternalID,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @UI.hidden: true
//@Consumption.valueHelp: '_MM_CommitmentItemVH'
@UI:{ identification: {position: 170, importance: #HIGH}}
@EndUserText.label: 'Commitment Item'
// Document.CommitmentItem,
cast(CommitmentItem as fm_fipex ) as CommitmentItem,
// Document.FundsCenter, // removed as per guidelines
//@Consumption.valueHelp: '_FundStdVH'
@UI:{ identification: {position: 160, importance: #HIGH}}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.Fund, // enabled for PSM Account Assignment
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @ObjectModel: [{ foreignKey.association: '_FunctionalArea' }]
//@Consumption.valueHelp: '_FunctionalArea'
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'I_FunctionalArea',
// element: 'FunctionalArea' }
// }]
@UI:{ identification: {position: 80, importance: #HIGH}}
Document.FunctionalArea,
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 50, importance: #HIGH}
}
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.GoodsRecipientName,
Document.IsFinallyInvoiced,
//Document.RealEstateObject,
cast( REInternalFinNumber as recaimkeyfi ) as RealEstateObject,
@UI:{ identification: {position: 70, importance: #HIGH}}
@EndUserText.label: 'Internal Counter'
Document.NetworkActivityInternalID,
Document.PartnerAccountNumber,
Document.JointVentureRecoveryCode,
@UI:{
fieldGroup: {qualifier: 'SecondGroup', position: 40, importance: #HIGH}
}
@EndUserText.label: 'Reference Date'
Document.SettlementReferenceDate,
@UI.hidden: true
Document.OrderInternalID,
@ObjectModel.readOnly: true // added for removing error- Transient field ORDERINTBILLOFOPERATIONSITEM requires the annotation '@ObjectModel.readOnly'.
@EndUserText.label: 'General Counter'
cast (Document.OrderIntBillOfOperationsItem as mm_oa_co_aplzl) as OrderIntBillOfOperationsItem,
Document.TaxCode,
Document.TaxJurisdiction,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Document.NonDeductibleInputTaxAmount,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
// @ObjectModel: [{ foreignKey.association: '_CostCenterActivityType' }]
// @Consumption.valueHelp: '_CostCenterActivityType'
@UI:{ identification: {position: 130, importance: #HIGH}}
Document.CostCtrActivityType,
//@Consumption.valueHelpDefinition: [{ entity: { name : 'I_GrantStdVH', element: 'GrantID' } }]
@UI:{ identification: {position: 190, importance: #HIGH}}
Document.GrantID,
//@Consumption.valueHelp: '_BudgetPeriodStdVH'
@UI:{ identification: {position: 200, importance: #HIGH}}
Document.BudgetPeriod,
//@ObjectModel.readOnly:'EXTERNAL_CALCULATION'
Document.EarmarkedFundsDocument,
Document.ValidityDate,
@ObjectModel.readOnly: true
//@ObjectModel.foreignKey.association: '_CompanyCode'
//@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeVH', element: 'CompanyCode' } } ]
_PurchaseContract.CompanyCode,
@ObjectModel.readOnly: true
Document.DocumentCurrency,
@ObjectModel.readOnly: true
@EndUserText.label: 'Order Unit'
Document.OrderQuantityUnit,
// @ObjectModel.readOnly: true
// @UI.hidden: true
// _PurchaseContractItemWD.Plant,
_PurchaseContract,
_PurchaseContractItem,
//@Consumption: {
// hidden: true
// }
//_BusinessArea,
//_GLAccount,
//_CostCenter,
//_FixedAsset,
//_ControllingArea,
//_FunctionalArea,
// new F4 help associations
// _MM_CostCenterValueHelp,
// _MM_FixedAssetValueHelp,
_MM_InternalOrderVH,
// _MM_NetworkActivityVH,
_MM_ProfitCenterValueHelp,
_MM_ProjectNetworkVH,
// _MM_SalesOrderValueHelp,
// _MM_SalesOrderItemVH,
_MM_WBSElementValueHelp,
//_WBSElementByInternalKey,
_WBSElementByInternalKeyVH,
_MM_CommitmentItemVH,
_BudgetPeriodStdVH,
// _MM_GLAccountVH,
_FundStdVH,
// _MM_ControllingAreaVH,
//@Consumption.hidden: true
_CompanyCode
}
where
IsDeleted = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CONTRACTFS",
"I_PURCTRACCOUNT"
],
"ASSOCIATED":
[
"C_CONTRACTFS",
"C_CONTRACTITEMFS",
"I_BUDGETPERIODSTDVH",
"I_COMPANYCODE",
"I_FUNDSTDVH",
"I_INTERNALORDER",
"I_MM_COMMITMENTITEMVH",
"I_MM_INTERNALORDERVH",
"I_MM_PROFITCENTERVALUEHELP",
"I_MM_PROJECTNETWORKVH",
"I_MM_WBSELEMENTVALUEHELP",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/