R_SESAccountAssignmentTP

DDL: R_SESACCOUNTASSIGNMENTTP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_SES

SES Account Assignment

R_SESAccountAssignmentTP is a Transactional CDS View that provides data about "SES Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetAcctAssgmt) and exposes 68 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem, AccountAssignment. Part of development package RAP_MM_PUR_SES.

1 data source(s) 68 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetAcctAssgmt I_ServiceEntrySheetAcctAssgmt from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SES Account Assignment view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey AccountAssignment view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet I_ServiceEntrySheetAcctAssgmt ServiceEntrySheet
KEY ServiceEntrySheetItem I_ServiceEntrySheetAcctAssgmt ServiceEntrySheetItem
KEY AccountAssignment I_ServiceEntrySheetAcctAssgmt AccountAssignment
RefDocAccountAssignment I_ServiceEntrySheetAcctAssgmt RefDocAccountAssignment
IsDeleted I_ServiceEntrySheetAcctAssgmt IsDeleted
QuantityUnit I_ServiceEntrySheetAcctAssgmt QuantityUnit
Quantity I_ServiceEntrySheetAcctAssgmt Quantity
NetAmount I_ServiceEntrySheetAcctAssgmt NetAmount
CostCenter I_ServiceEntrySheetAcctAssgmt CostCenter
MultipleAcctAssgmtDistrPercent I_ServiceEntrySheetAcctAssgmt MultipleAcctAssgmtDistrPercent
GLAccount I_ServiceEntrySheetAcctAssgmt GLAccount
BusinessArea I_ServiceEntrySheetAcctAssgmt BusinessArea
SalesOrder I_ServiceEntrySheetAcctAssgmt SalesOrder
SalesOrderItem I_ServiceEntrySheetAcctAssgmt SalesOrderItem
SalesOrderScheduleLine I_ServiceEntrySheetAcctAssgmt SalesOrderScheduleLine
MasterFixedAsset I_ServiceEntrySheetAcctAssgmt MasterFixedAsset
FixedAsset I_ServiceEntrySheetAcctAssgmt FixedAsset
OrderID I_ServiceEntrySheetAcctAssgmt OrderID
ControllingArea I_ServiceEntrySheetAcctAssgmt ControllingArea
CostObject I_ServiceEntrySheetAcctAssgmt CostObject
ProfitabilitySegment I_ServiceEntrySheetAcctAssgmt ProfitabilitySegment
ProfitCenter I_ServiceEntrySheetAcctAssgmt ProfitCenter
WBSElementInternalID I_WBSElementBasicData WBSElementInternalID
WBSElementExternalID I_WBSElementBasicData WBSElementExternalID
ProjectNetwork I_ServiceEntrySheetAcctAssgmt ProjectNetwork
ProjectNetworkInternalID I_ServiceEntrySheetAcctAssgmt ProjectNetworkInternalID
NetworkActivity
NetworkActivityInternalID I_ServiceEntrySheetAcctAssgmt NetworkActivityInternalID
PartnerAccountNumber I_ServiceEntrySheetAcctAssgmt PartnerAccountNumber
REInternalFinNumber I_ServiceEntrySheetAcctAssgmt REInternalFinNumber
CostCtrActivityType I_ServiceEntrySheetAcctAssgmt CostCtrActivityType
BusinessProcess I_ServiceEntrySheetAcctAssgmt BusinessProcess
SettlementReferenceDate I_ServiceEntrySheetAcctAssgmt SettlementReferenceDate
GoodsRecipientName I_ServiceEntrySheetAcctAssgmt GoodsRecipientName
UnloadingPointName I_ServiceEntrySheetAcctAssgmt UnloadingPointName
OrderInternalID I_ServiceEntrySheetAcctAssgmt OrderInternalID
OrderIntBillOfOperationsItem I_ServiceEntrySheetAcctAssgmt OrderIntBillOfOperationsItem
CommitmentItem I_CommitmentItem CommitmentItem
CommitmentItemShortID
FundsCenter I_ServiceEntrySheetAcctAssgmt FundsCenter
Fund I_ServiceEntrySheetAcctAssgmt Fund
FunctionalArea I_ServiceEntrySheetAcctAssgmt FunctionalArea
EarmarkedFundsDocument I_ServiceEntrySheetAcctAssgmt EarmarkedFundsDocument
EarmarkedFundsDocumentItem I_ServiceEntrySheetAcctAssgmt EarmarkedFundsDocumentItem
BudgetPeriod I_ServiceEntrySheetAcctAssgmt BudgetPeriod
GrantID I_ServiceEntrySheetAcctAssgmt GrantID
FundedProgram I_ServiceEntrySheetAcctAssgmt FundedProgram
ServiceDocumentType I_ServiceEntrySheetAcctAssgmt ServiceDocumentType
ServiceDocument I_ServiceEntrySheetAcctAssgmt ServiceDocument
ServiceDocumentItem I_ServiceEntrySheetAcctAssgmt ServiceDocumentItem
CreationDateTime I_ServiceEntrySheetAcctAssgmt CreationDateTime
CreatedByUser I_ServiceEntrySheetAcctAssgmt CreatedByUser
LastChangeDateTime I_ServiceEntrySheetAcctAssgmt LastChangeDateTime
LastChangedByUser I_ServiceEntrySheetAcctAssgmt LastChangeUser
PurchasingOrganization I_ServiceEntrySheetAcctAssgmt PurchasingOrganization
PurchasingGroup I_ServiceEntrySheetAcctAssgmt PurchasingGroup
Plant I_ServiceEntrySheetAcctAssgmt Plant
IsEndOfPurposeBlocked I_ServiceEntrySheetAcctAssgmt IsEndOfPurposeBlocked
ValidityDate I_ServiceEntrySheetAcctAssgmt ValidityDate
Currency I_ServiceEntrySheetAcctAssgmt Currency
CompanyCode I_ServiceEntrySheetAcctAssgmt CompanyCode
ChartOfAccounts I_ServiceEntrySheetAcctAssgmt ChartOfAccounts
_SESHeader _SESHeader
_ServiceEntrySheetItem _ServiceEntrySheetItem
_UnitValueHelp I_ServiceEntrySheetAcctAssgmt _UnitValueHelp
_Currency I_ServiceEntrySheetAcctAssgmt _Currency
_CompanyCode I_ServiceEntrySheetAcctAssgmt _CompanyCode
_REObjectByIntFinNumber I_ServiceEntrySheetAcctAssgmt _REObjectByIntFinNumber 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'SES Account Assignment'
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.semanticKey:  [ 'ServiceEntrySheet', 'ServiceEntrySheetItem', 'AccountAssignment' ]
@ObjectModel.representativeKey: 'AccountAssignment'

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}

@Metadata.ignorePropagatedAnnotations: true
define view entity R_SESAccountAssignmentTP
  as select from           I_ServiceEntrySheetAcctAssgmt
    left outer to one join I_CommitmentItem on I_ServiceEntrySheetAcctAssgmt.CommitmentItem = I_CommitmentItem.CommitmentItem
    left outer to one join I_WBSElementBasicData on I_ServiceEntrySheetAcctAssgmt.WBSElementInternalID = I_WBSElementBasicData.WBSElementInternalID
    left outer to one join I_NetworkActivity on I_ServiceEntrySheetAcctAssgmt.ProjectNetwork            = I_NetworkActivity.ProjectNetwork
                                            and I_ServiceEntrySheetAcctAssgmt.ProjectNetworkInternalID  = I_NetworkActivity.ProjectNetworkInternalID
                                            and I_ServiceEntrySheetAcctAssgmt.NetworkActivityInternalID = I_NetworkActivity.NetworkActivityInternalID
  association to parent R_ServiceEntrySheetItemTP as _ServiceEntrySheetItem on  _ServiceEntrySheetItem.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
                                                                            and _ServiceEntrySheetItem.ServiceEntrySheet     = $projection.ServiceEntrySheet

  association to R_ServiceEntrySheetTP            as _SESHeader             on  _SESHeader.ServiceEntrySheet = $projection.ServiceEntrySheet
{
      @ObjectModel.foreignKey.association: '_SESHeader'
  key I_ServiceEntrySheetAcctAssgmt.ServiceEntrySheet,
      @ObjectModel.foreignKey.association: '_ServiceEntrySheetItem'
  key I_ServiceEntrySheetAcctAssgmt.ServiceEntrySheetItem,
  key I_ServiceEntrySheetAcctAssgmt.AccountAssignment,
      I_ServiceEntrySheetAcctAssgmt.RefDocAccountAssignment,
      I_ServiceEntrySheetAcctAssgmt.IsDeleted,
      @ObjectModel.foreignKey.association: '_UnitValueHelp'
      I_ServiceEntrySheetAcctAssgmt.QuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      I_ServiceEntrySheetAcctAssgmt.Quantity,
      @Semantics.amount.currencyCode: 'Currency'
      I_ServiceEntrySheetAcctAssgmt.NetAmount,
      I_ServiceEntrySheetAcctAssgmt.CostCenter,
      I_ServiceEntrySheetAcctAssgmt.MultipleAcctAssgmtDistrPercent,
      I_ServiceEntrySheetAcctAssgmt.GLAccount,
      I_ServiceEntrySheetAcctAssgmt.BusinessArea,
      I_ServiceEntrySheetAcctAssgmt.SalesOrder,
      I_ServiceEntrySheetAcctAssgmt.SalesOrderItem,
      I_ServiceEntrySheetAcctAssgmt.SalesOrderScheduleLine,
      I_ServiceEntrySheetAcctAssgmt.MasterFixedAsset,
      I_ServiceEntrySheetAcctAssgmt.FixedAsset,
      I_ServiceEntrySheetAcctAssgmt.OrderID,
      I_ServiceEntrySheetAcctAssgmt.ControllingArea,
      I_ServiceEntrySheetAcctAssgmt.CostObject,
      I_ServiceEntrySheetAcctAssgmt.ProfitabilitySegment,
      I_ServiceEntrySheetAcctAssgmt.ProfitCenter,
      I_WBSElementBasicData.WBSElementInternalID,
      I_WBSElementBasicData.WBSElementExternalID,
      I_ServiceEntrySheetAcctAssgmt.ProjectNetwork,
      I_ServiceEntrySheetAcctAssgmt.ProjectNetworkInternalID,
      cast ( I_NetworkActivity.NetworkActivity as mm_vornr_receiver preserving type )  as NetworkActivity,
      I_ServiceEntrySheetAcctAssgmt.NetworkActivityInternalID,
      I_ServiceEntrySheetAcctAssgmt.PartnerAccountNumber,
      //cast ( I_ServiceEntrySheetAcctAssgmt.NetworkActivity as mm_vornr_receiver preserving type )  as NetworkActivity,

      //cast ( I_ServiceEntrySheetAcctAssgmt.RealEstateObject as recaimkeyfi )                       as REInternalFinNumber,

      @ObjectModel.foreignKey.association: '_REObjectByIntFinNumber'
      I_ServiceEntrySheetAcctAssgmt.REInternalFinNumber,
      I_ServiceEntrySheetAcctAssgmt.CostCtrActivityType,
      I_ServiceEntrySheetAcctAssgmt.BusinessProcess,
      I_ServiceEntrySheetAcctAssgmt.SettlementReferenceDate,
      I_ServiceEntrySheetAcctAssgmt.GoodsRecipientName,
      I_ServiceEntrySheetAcctAssgmt.UnloadingPointName,
      I_ServiceEntrySheetAcctAssgmt.OrderInternalID,
      I_ServiceEntrySheetAcctAssgmt.OrderIntBillOfOperationsItem,
      I_CommitmentItem.CommitmentItem,
      cast( I_ServiceEntrySheetAcctAssgmt.CommitmentItem as fmis_ci_internalname preserving type ) as CommitmentItemShortID,

      I_ServiceEntrySheetAcctAssgmt.FundsCenter,
      I_ServiceEntrySheetAcctAssgmt.Fund,
      I_ServiceEntrySheetAcctAssgmt.FunctionalArea,
      I_ServiceEntrySheetAcctAssgmt.EarmarkedFundsDocument,
      I_ServiceEntrySheetAcctAssgmt.EarmarkedFundsDocumentItem,
      I_ServiceEntrySheetAcctAssgmt.BudgetPeriod,
      I_ServiceEntrySheetAcctAssgmt.GrantID,
      I_ServiceEntrySheetAcctAssgmt.FundedProgram,
      I_ServiceEntrySheetAcctAssgmt.ServiceDocumentType,
      I_ServiceEntrySheetAcctAssgmt.ServiceDocument,
      I_ServiceEntrySheetAcctAssgmt.ServiceDocumentItem,
      I_ServiceEntrySheetAcctAssgmt.CreationDateTime,
      I_ServiceEntrySheetAcctAssgmt.CreatedByUser,
      I_ServiceEntrySheetAcctAssgmt.LastChangeDateTime,
      I_ServiceEntrySheetAcctAssgmt.LastChangeUser                                                 as LastChangedByUser,
      I_ServiceEntrySheetAcctAssgmt.PurchasingOrganization,
      I_ServiceEntrySheetAcctAssgmt.PurchasingGroup,
      I_ServiceEntrySheetAcctAssgmt.Plant,
      @Semantics.booleanIndicator
      I_ServiceEntrySheetAcctAssgmt.IsEndOfPurposeBlocked,
      I_ServiceEntrySheetAcctAssgmt.ValidityDate,
      @ObjectModel.foreignKey.association: '_Currency'
      I_ServiceEntrySheetAcctAssgmt.Currency,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      I_ServiceEntrySheetAcctAssgmt.CompanyCode,
      I_ServiceEntrySheetAcctAssgmt.ChartOfAccounts,
      /* Associations */
      _SESHeader,
      _ServiceEntrySheetItem,
      I_ServiceEntrySheetAcctAssgmt._UnitValueHelp,
      I_ServiceEntrySheetAcctAssgmt._Currency,
      I_ServiceEntrySheetAcctAssgmt._CompanyCode,
      I_ServiceEntrySheetAcctAssgmt._REObjectByIntFinNumber

}
where
      _SESHeader.ServiceEntrySheet                 is not null
  and _ServiceEntrySheetItem.ServiceEntrySheetItem is not null
  and I_ServiceEntrySheetAcctAssgmt.IsDeleted = ''

Learn More