R_SESAccountAssignmentTP

DDL: R_SESACCOUNTASSIGNMENTTP Type: view_entity TRANSACTIONAL
68 Fields 1 Data Sources

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.

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 Service Entry Sheet
KEY ServiceEntrySheetItem I_ServiceEntrySheetAcctAssgmt ServiceEntrySheetItem Item Number of SES
KEY AccountAssignment I_ServiceEntrySheetAcctAssgmt AccountAssignment Sender Acct Assgmt
RefDocAccountAssignment I_ServiceEntrySheetAcctAssgmt RefDocAccountAssignment
IsDeleted I_ServiceEntrySheetAcctAssgmt IsDeleted TRUE
QuantityUnit I_ServiceEntrySheetAcctAssgmt QuantityUnit Unit of measure
Quantity I_ServiceEntrySheetAcctAssgmt Quantity Value
NetAmount I_ServiceEntrySheetAcctAssgmt NetAmount Stated Amount
CostCenter I_ServiceEntrySheetAcctAssgmt CostCenter Cost Center
MultipleAcctAssgmtDistrPercent I_ServiceEntrySheetAcctAssgmt MultipleAcctAssgmtDistrPercent Distribution
GLAccount I_ServiceEntrySheetAcctAssgmt GLAccount General Ledger
BusinessArea I_ServiceEntrySheetAcctAssgmt BusinessArea Business Area
SalesOrder I_ServiceEntrySheetAcctAssgmt SalesOrder SD Document
SalesOrderItem I_ServiceEntrySheetAcctAssgmt SalesOrderItem Sales Order Item
SalesOrderScheduleLine I_ServiceEntrySheetAcctAssgmt SalesOrderScheduleLine SOrder schedule
MasterFixedAsset I_ServiceEntrySheetAcctAssgmt MasterFixedAsset Fixed Asset
FixedAsset I_ServiceEntrySheetAcctAssgmt FixedAsset Sub-number
OrderID I_ServiceEntrySheetAcctAssgmt OrderID Order ID
ControllingArea I_ServiceEntrySheetAcctAssgmt ControllingArea Controlling Area
CostObject I_ServiceEntrySheetAcctAssgmt CostObject Cost Object
ProfitabilitySegment I_ServiceEntrySheetAcctAssgmt ProfitabilitySegment Profitability Segment
ProfitCenter I_ServiceEntrySheetAcctAssgmt ProfitCenter Profit Center
WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
WBSElementExternalID I_WBSElementBasicData WBSElementExternalID WBS Element External ID
ProjectNetwork I_ServiceEntrySheetAcctAssgmt ProjectNetwork Order
ProjectNetworkInternalID I_ServiceEntrySheetAcctAssgmt ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivity
NetworkActivityInternalID I_ServiceEntrySheetAcctAssgmt NetworkActivityInternalID Counter
PartnerAccountNumber I_ServiceEntrySheetAcctAssgmt PartnerAccountNumber Partner
REInternalFinNumber I_ServiceEntrySheetAcctAssgmt REInternalFinNumber Real Estate Key
CostCtrActivityType I_ServiceEntrySheetAcctAssgmt CostCtrActivityType Activity Type
BusinessProcess I_ServiceEntrySheetAcctAssgmt BusinessProcess Business Process
SettlementReferenceDate I_ServiceEntrySheetAcctAssgmt SettlementReferenceDate Reference date
GoodsRecipientName I_ServiceEntrySheetAcctAssgmt GoodsRecipientName Recipient Name
UnloadingPointName I_ServiceEntrySheetAcctAssgmt UnloadingPointName Unloading Point Name
OrderInternalID I_ServiceEntrySheetAcctAssgmt OrderInternalID Plan No.f.Oper.
OrderIntBillOfOperationsItem I_ServiceEntrySheetAcctAssgmt OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
CommitmentItem I_CommitmentItem CommitmentItem Commitment item
CommitmentItemShortID
FundsCenter I_ServiceEntrySheetAcctAssgmt FundsCenter Funds Center
Fund I_ServiceEntrySheetAcctAssgmt Fund Sender Fund
FunctionalArea I_ServiceEntrySheetAcctAssgmt FunctionalArea Sendr Fctl Area
EarmarkedFundsDocument I_ServiceEntrySheetAcctAssgmt EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem I_ServiceEntrySheetAcctAssgmt EarmarkedFundsDocumentItem Document Item
BudgetPeriod I_ServiceEntrySheetAcctAssgmt BudgetPeriod Budget Period
GrantID I_ServiceEntrySheetAcctAssgmt GrantID Sender Grant
FundedProgram I_ServiceEntrySheetAcctAssgmt FundedProgram Funded Program
ServiceDocumentType I_ServiceEntrySheetAcctAssgmt ServiceDocumentType Transaction Type
ServiceDocument I_ServiceEntrySheetAcctAssgmt ServiceDocument Transaction ID
ServiceDocumentItem I_ServiceEntrySheetAcctAssgmt ServiceDocumentItem Service Document
CreationDateTime I_ServiceEntrySheetAcctAssgmt CreationDateTime Timestamp
CreatedByUser I_ServiceEntrySheetAcctAssgmt CreatedByUser User Name
LastChangeDateTime I_ServiceEntrySheetAcctAssgmt LastChangeDateTime Timestamp
LastChangedByUser I_ServiceEntrySheetAcctAssgmt LastChangeUser User Name
PurchasingOrganization I_ServiceEntrySheetAcctAssgmt PurchasingOrganization Purchasing Organization
PurchasingGroup I_ServiceEntrySheetAcctAssgmt PurchasingGroup Purchasing Group
Plant I_ServiceEntrySheetAcctAssgmt Plant Valuation Area
IsEndOfPurposeBlocked I_ServiceEntrySheetAcctAssgmt IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
ValidityDate I_ServiceEntrySheetAcctAssgmt ValidityDate Valid On
Currency I_ServiceEntrySheetAcctAssgmt Currency Valuation Crcy
CompanyCode I_ServiceEntrySheetAcctAssgmt CompanyCode Receiver Company Code
ChartOfAccounts I_ServiceEntrySheetAcctAssgmt ChartOfAccounts Node Class
_SESHeader _SESHeader
_ServiceEntrySheetItem _ServiceEntrySheetItem
_UnitValueHelp I_ServiceEntrySheetAcctAssgmt _UnitValueHelp
_Currency I_ServiceEntrySheetAcctAssgmt _Currency
_CompanyCode I_ServiceEntrySheetAcctAssgmt _CompanyCode
_REObjectByIntFinNumber I_ServiceEntrySheetAcctAssgmt _REObjectByIntFinNumber

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 R_SESAccountAssignmentTP.
-- 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.

CREATE VIEW R_SESAccountAssignmentTP AS
SELECT
  I_ServiceEntrySheetAcctAssgmt.ServiceEntrySheet AS ServiceEntrySheet,
  I_ServiceEntrySheetAcctAssgmt.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  I_ServiceEntrySheetAcctAssgmt.AccountAssignment AS AccountAssignment,
  I_ServiceEntrySheetAcctAssgmt.RefDocAccountAssignment AS RefDocAccountAssignment,
  I_ServiceEntrySheetAcctAssgmt.IsDeleted AS IsDeleted,
  I_ServiceEntrySheetAcctAssgmt.QuantityUnit AS QuantityUnit,
  I_ServiceEntrySheetAcctAssgmt.Quantity AS Quantity,
  I_ServiceEntrySheetAcctAssgmt.NetAmount AS NetAmount,
  I_ServiceEntrySheetAcctAssgmt.CostCenter AS CostCenter,
  I_ServiceEntrySheetAcctAssgmt.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  I_ServiceEntrySheetAcctAssgmt.GLAccount AS GLAccount,
  I_ServiceEntrySheetAcctAssgmt.BusinessArea AS BusinessArea,
  I_ServiceEntrySheetAcctAssgmt.SalesOrder AS SalesOrder,
  I_ServiceEntrySheetAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  I_ServiceEntrySheetAcctAssgmt.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_ServiceEntrySheetAcctAssgmt.MasterFixedAsset AS MasterFixedAsset,
  I_ServiceEntrySheetAcctAssgmt.FixedAsset AS FixedAsset,
  I_ServiceEntrySheetAcctAssgmt.OrderID AS OrderID,
  I_ServiceEntrySheetAcctAssgmt.ControllingArea AS ControllingArea,
  I_ServiceEntrySheetAcctAssgmt.CostObject AS CostObject,
  I_ServiceEntrySheetAcctAssgmt.ProfitabilitySegment AS ProfitabilitySegment,
  I_ServiceEntrySheetAcctAssgmt.ProfitCenter AS ProfitCenter,
  I_WBSElementBasicData.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  I_ServiceEntrySheetAcctAssgmt.ProjectNetwork AS ProjectNetwork,
  I_ServiceEntrySheetAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  cast ( I_NetworkActivity.NetworkActivity as mm_vornr_receiver preserving type ) AS NetworkActivity,
  I_ServiceEntrySheetAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_ServiceEntrySheetAcctAssgmt.PartnerAccountNumber AS PartnerAccountNumber,
  I_ServiceEntrySheetAcctAssgmt.REInternalFinNumber AS REInternalFinNumber,
  I_ServiceEntrySheetAcctAssgmt.CostCtrActivityType AS CostCtrActivityType,
  I_ServiceEntrySheetAcctAssgmt.BusinessProcess AS BusinessProcess,
  I_ServiceEntrySheetAcctAssgmt.SettlementReferenceDate AS SettlementReferenceDate,
  I_ServiceEntrySheetAcctAssgmt.GoodsRecipientName AS GoodsRecipientName,
  I_ServiceEntrySheetAcctAssgmt.UnloadingPointName AS UnloadingPointName,
  I_ServiceEntrySheetAcctAssgmt.OrderInternalID AS OrderInternalID,
  I_ServiceEntrySheetAcctAssgmt.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_CommitmentItem.CommitmentItem AS CommitmentItem,
  cast( I_ServiceEntrySheetAcctAssgmt.CommitmentItem as fmis_ci_internalname preserving type ) AS CommitmentItemShortID,
  I_ServiceEntrySheetAcctAssgmt.FundsCenter AS FundsCenter,
  I_ServiceEntrySheetAcctAssgmt.Fund AS Fund,
  I_ServiceEntrySheetAcctAssgmt.FunctionalArea AS FunctionalArea,
  I_ServiceEntrySheetAcctAssgmt.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_ServiceEntrySheetAcctAssgmt.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_ServiceEntrySheetAcctAssgmt.BudgetPeriod AS BudgetPeriod,
  I_ServiceEntrySheetAcctAssgmt.GrantID AS GrantID,
  I_ServiceEntrySheetAcctAssgmt.FundedProgram AS FundedProgram,
  I_ServiceEntrySheetAcctAssgmt.ServiceDocumentType AS ServiceDocumentType,
  I_ServiceEntrySheetAcctAssgmt.ServiceDocument AS ServiceDocument,
  I_ServiceEntrySheetAcctAssgmt.ServiceDocumentItem AS ServiceDocumentItem,
  I_ServiceEntrySheetAcctAssgmt.CreationDateTime AS CreationDateTime,
  I_ServiceEntrySheetAcctAssgmt.CreatedByUser AS CreatedByUser,
  I_ServiceEntrySheetAcctAssgmt.LastChangeDateTime AS LastChangeDateTime,
  I_ServiceEntrySheetAcctAssgmt.LastChangeUser AS LastChangedByUser,
  I_ServiceEntrySheetAcctAssgmt.PurchasingOrganization AS PurchasingOrganization,
  I_ServiceEntrySheetAcctAssgmt.PurchasingGroup AS PurchasingGroup,
  I_ServiceEntrySheetAcctAssgmt.Plant AS Plant,
  I_ServiceEntrySheetAcctAssgmt.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_ServiceEntrySheetAcctAssgmt.ValidityDate AS ValidityDate,
  I_ServiceEntrySheetAcctAssgmt.Currency AS Currency,
  I_ServiceEntrySheetAcctAssgmt.CompanyCode AS CompanyCode,
  I_ServiceEntrySheetAcctAssgmt.ChartOfAccounts AS ChartOfAccounts,
  I_ServiceEntrySheetAcctAssgmt._UnitValueHelp AS _UnitValueHelp,
  I_ServiceEntrySheetAcctAssgmt._Currency AS _Currency,
  I_ServiceEntrySheetAcctAssgmt._CompanyCode AS _CompanyCode,
  I_ServiceEntrySheetAcctAssgmt._REObjectByIntFinNumber AS _REObjectByIntFinNumber
FROM I_ServiceEntrySheetAcctAssgmt
;

Learn More