A_SrvcEntrShtAcctAssignment

DDL: A_SRVCENTRSHTACCTASSIGNMENT SQL: ASRVCENTRSHTACCT Type: view BASIC

Account Assignment

A_SrvcEntrShtAcctAssignment is a Basic CDS View that provides data about "Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_SrvEntrySheetAcctAssgmtBasic) and exposes 48 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem, AccountAssignment.

Data Sources (1)

SourceAliasJoin Type
I_SrvEntrySheetAcctAssgmtBasic I_SrvEntrySheetAcctAssgmtBasic from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASRVCENTRSHTACCT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Account Assignment view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem
KEY AccountAssignment AccountAssignment
AccountAssignmentUUID AccountAssignmentUUID
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
Plant I_SrvEntrySheetAcctAssgmtBasic Plant
BusinessArea I_SrvEntrySheetAcctAssgmtBasic BusinessArea
CommitmentItem
ControllingArea I_SrvEntrySheetAcctAssgmtBasic ControllingArea
CostCenter I_SrvEntrySheetAcctAssgmtBasic CostCenter
CostObject I_SrvEntrySheetAcctAssgmtBasic CostObject
CreatedByUser I_SrvEntrySheetAcctAssgmtBasic CreatedByUser
CreationDateTime CreationDateTime
EarmarkedFundsDocument EarmarkedFundsDocument
FixedAsset FixedAsset
FunctionalArea I_SrvEntrySheetAcctAssgmtBasic FunctionalArea
Fund Fund
FundsCenter FundsCenter
GLAccount GLAccount
IsDeleted IsDeleted
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangeUser
MasterFixedAsset MasterFixedAsset
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent
NetworkActivityInternalID NetworkActivityInternalID
OrderID OrderID
PartnerAccountNumber PartnerAccountNumber
ProfitCenter I_SrvEntrySheetAcctAssgmtBasic ProfitCenter
ProfitabilitySegment ProfitabilitySegment
ProjectNetwork ProjectNetwork
ProjectNetworkInternalID ProjectNetworkInternalID
Quantity Quantity
QuantityUnit QuantityUnit
RealEstateObject
RefDocAccountAssignment RefDocAccountAssignment
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
SalesOrderScheduleLine SalesOrderScheduleLine
ServiceEntrySheetItemUUID ServiceEntrySheetItemUUID
ServiceEntrySheetUUID ServiceEntrySheetUUID
WBSElementInternalID I_WBSElementByInternalKey WBSElementInternalID
WBSElement I_WBSElementByInternalKey WBSElement
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
Currency I_SrvEntrySheetAcctAssgmtBasic Currency
NetAmount I_SrvEntrySheetAcctAssgmtBasic NetAmount
@AbapCatalog.sqlViewName: 'ASRVCENTRSHTACCT'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Account Assignment'
@VDM.viewType : #BASIC
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #L,
   usageType.dataClass: #TRANSACTIONAL,
   createEnabled: false,
   updateEnabled: true,
   deleteEnabled: false
}
define view A_SrvcEntrShtAcctAssignment as
  select from I_SrvEntrySheetAcctAssgmtBasic
      left outer to one join I_WBSElementByInternalKey on I_SrvEntrySheetAcctAssgmtBasic.WBSElementInternalID = I_WBSElementByInternalKey.WBSElementInternalID
 {
 key ServiceEntrySheet,
 key ServiceEntrySheetItem,
 key AccountAssignment,

 AccountAssignmentUUID,
 PurchasingOrganization,
 PurchasingGroup,
 I_SrvEntrySheetAcctAssgmtBasic.Plant,
 I_SrvEntrySheetAcctAssgmtBasic.BusinessArea,
 cast( CommitmentItemShortID as fipos preserving type ) as CommitmentItem,
 I_SrvEntrySheetAcctAssgmtBasic.ControllingArea,
 I_SrvEntrySheetAcctAssgmtBasic.CostCenter,
 I_SrvEntrySheetAcctAssgmtBasic.CostObject,
 I_SrvEntrySheetAcctAssgmtBasic.CreatedByUser,
 CreationDateTime,
 EarmarkedFundsDocument,
 FixedAsset,
 I_SrvEntrySheetAcctAssgmtBasic.FunctionalArea,
 Fund,
 FundsCenter,
 GLAccount,
 IsDeleted,
 LastChangeDateTime,
 LastChangeUser as LastChangedByUser,
 MasterFixedAsset,
 MultipleAcctAssgmtDistrPercent,
 NetworkActivityInternalID,
 OrderID,
 PartnerAccountNumber,
 I_SrvEntrySheetAcctAssgmtBasic.ProfitCenter,
 ProfitabilitySegment,
 ProjectNetwork,
 ProjectNetworkInternalID,

 @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
 Quantity,

 @Semantics.unitOfMeasure: true
 QuantityUnit,

 cast( I_SrvEntrySheetAcctAssgmtBasic.REInternalFinNumber as imkey ) as RealEstateObject, //with conv. exit

 RefDocAccountAssignment,
 SalesOrder,
 SalesOrderItem,
 SalesOrderScheduleLine,
 ServiceEntrySheetItemUUID,
 ServiceEntrySheetUUID,
 I_WBSElementByInternalKey.WBSElementInternalID,
 I_WBSElementByInternalKey.WBSElement,

 @ObjectModel.sapObjectNodeTypeReference: 'ServiceDocumentType'
 ServiceDocumentType,
 ServiceDocument,
 ServiceDocumentItem,

 @Semantics.currencyCode:true
 @ObjectModel.sapObjectNodeTypeReference: 'Currency'
 I_SrvEntrySheetAcctAssgmtBasic.Currency,

 @Semantics.amount.currencyCode: 'Currency'
 I_SrvEntrySheetAcctAssgmtBasic.NetAmount

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SRVENTRYSHEETACCTASSGMTBASIC",
"I_WBSELEMENTBYINTERNALKEY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/