A_SrvcEntrShtAcctAssignment

DDL: A_SRVCENTRSHTACCTASSIGNMENT SQL: ASRVCENTRSHTACCT Type: view BASIC
48 Fields 1 Data Sources

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 Service Entry Sheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem Item Number of SES
KEY AccountAssignment AccountAssignment Sender Acct Assgmt
AccountAssignmentUUID AccountAssignmentUUID Key
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant I_SrvEntrySheetAcctAssgmtBasic Plant Valuation Area
BusinessArea I_SrvEntrySheetAcctAssgmtBasic BusinessArea Business Area
CommitmentItem Commitment Item Short ID
ControllingArea I_SrvEntrySheetAcctAssgmtBasic ControllingArea Controlling Area
CostCenter I_SrvEntrySheetAcctAssgmtBasic CostCenter Cost Center
CostObject I_SrvEntrySheetAcctAssgmtBasic CostObject Cost Object
CreatedByUser I_SrvEntrySheetAcctAssgmtBasic CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
FixedAsset FixedAsset Sub-number
FunctionalArea I_SrvEntrySheetAcctAssgmtBasic FunctionalArea Sendr Fctl Area
Fund Fund Sender Fund
FundsCenter FundsCenter Funds Center
GLAccount GLAccount General Ledger
IsDeleted IsDeleted TRUE
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangeUser User Name
MasterFixedAsset MasterFixedAsset Fixed Asset
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent Distribution
NetworkActivityInternalID NetworkActivityInternalID Counter
OrderID OrderID Order ID
PartnerAccountNumber PartnerAccountNumber Partner
ProfitCenter I_SrvEntrySheetAcctAssgmtBasic ProfitCenter Profit Center
ProfitabilitySegment ProfitabilitySegment Profitability Segment
ProjectNetwork ProjectNetwork Order
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
RealEstateObject
RefDocAccountAssignment RefDocAccountAssignment PO Item Acc Ass
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine SOrder schedule
ServiceEntrySheetItemUUID ServiceEntrySheetItemUUID Key
ServiceEntrySheetUUID ServiceEntrySheetUUID Key
WBSElementInternalID I_WBSElementByInternalKey WBSElementInternalID WBS Internal ID
WBSElement I_WBSElementByInternalKey WBSElement WBS Internal ID
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
Currency I_SrvEntrySheetAcctAssgmtBasic Currency Valuation Crcy
NetAmount I_SrvEntrySheetAcctAssgmtBasic NetAmount Stated Amount

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_SrvcEntrShtAcctAssignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ASRVCENTRSHTACCT

CREATE VIEW A_SrvcEntrShtAcctAssignment AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetItem,
  AccountAssignment,
  AccountAssignmentUUID,
  PurchasingOrganization,
  PurchasingGroup,
  I_SrvEntrySheetAcctAssgmtBasic.Plant AS Plant,
  I_SrvEntrySheetAcctAssgmtBasic.BusinessArea AS BusinessArea,
  cast( CommitmentItemShortID as fipos preserving type ) AS CommitmentItem,
  I_SrvEntrySheetAcctAssgmtBasic.ControllingArea AS ControllingArea,
  I_SrvEntrySheetAcctAssgmtBasic.CostCenter AS CostCenter,
  I_SrvEntrySheetAcctAssgmtBasic.CostObject AS CostObject,
  I_SrvEntrySheetAcctAssgmtBasic.CreatedByUser AS CreatedByUser,
  CreationDateTime,
  EarmarkedFundsDocument,
  FixedAsset,
  I_SrvEntrySheetAcctAssgmtBasic.FunctionalArea AS FunctionalArea,
  Fund,
  FundsCenter,
  GLAccount,
  IsDeleted,
  LastChangeDateTime,
  LastChangeUser AS LastChangedByUser,
  MasterFixedAsset,
  MultipleAcctAssgmtDistrPercent,
  NetworkActivityInternalID,
  OrderID,
  PartnerAccountNumber,
  I_SrvEntrySheetAcctAssgmtBasic.ProfitCenter AS ProfitCenter,
  ProfitabilitySegment,
  ProjectNetwork,
  ProjectNetworkInternalID,
  Quantity,
  QuantityUnit,
  cast( I_SrvEntrySheetAcctAssgmtBasic.REInternalFinNumber as imkey ) AS RealEstateObject,
  RefDocAccountAssignment,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  ServiceEntrySheetItemUUID,
  ServiceEntrySheetUUID,
  I_WBSElementByInternalKey.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElementByInternalKey.WBSElement AS WBSElement,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  I_SrvEntrySheetAcctAssgmtBasic.Currency AS Currency,
  I_SrvEntrySheetAcctAssgmtBasic.NetAmount AS NetAmount
FROM I_SrvEntrySheetAcctAssgmtBasic
;

Learn More