I_FrcElmntToAccountAssgmtTP

DDL: I_FRCELMNTTOACCOUNTASSGMTTP SQL: IFETOACCASSGMTTP Type: view TRANSACTIONAL
23 Fields 1 Data Sources

Transactional processing View of FE Org Account Assignment

I_FrcElmntToAccountAssgmtTP is a Transactional CDS View that provides data about "Transactional processing View of FE Org Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToAccountAssignment) and exposes 23 fields with key fields ForceElementOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToAccountAssignment FrcElmntToAccountAssignment from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IFETOACCASSGMTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence DFS_FETOACASMT_D view
EndUserText.label Transactional processing View of FE Org Account Assignment view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_FrcElmntToAccountAssignment ForceElementOrgID Object ID Processor
KEY FrcElmntOrgPlngStatus I_FrcElmntToAccountAssignment FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate I_FrcElmntToAccountAssignment FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntToAccountAssignment FrcElmntOrgValdtyEndDate End Date
FrcElmntOrgPlanVersion I_FrcElmntToAccountAssignment FrcElmntOrgPlanVersion Plan version
FrcElmntOrgType I_FrcElmntToAccountAssignment FrcElmntOrgType Object type
FrcElmntOrgSubType I_FrcElmntToAccountAssignment FrcElmntOrgSubType Subtype
FrcElmntOrgVariationID I_FrcElmntToAccountAssignment FrcElmntOrgVariationID Variation field
NumberOfForceElementOrg I_FrcElmntToAccountAssignment NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType I_FrcElmntToAccountAssignment FrcElmntOrgInfoType Infotype
FrcElmntOrgCompanyCode I_FrcElmntToAccountAssignment FrcElmntOrgCompanyCode Company Code
FrcElmntOrgBusinessArea I_FrcElmntToAccountAssignment FrcElmntOrgBusinessArea Business Area
FrcElmntOrgAccountingPlant I_FrcElmntToAccountAssignment FrcElmntOrgAccountingPlant Plant
FrcElmntOrgPersonnelArea I_FrcElmntToAccountAssignment FrcElmntOrgPersonnelArea Personnel area
FrcElmntOrgPersonnelSubArea I_FrcElmntToAccountAssignment FrcElmntOrgPersonnelSubArea Pers. subarea
FrcElmntOrgControllingArea I_FrcElmntToAccountAssignment FrcElmntOrgControllingArea CO Area
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntToAccountAssignment FrcElmntOrgValdtyStartDate Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntToAccountAssignment FrcElmntOrgValdtyEndDate End Date
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty
FrcElmntOrgMeasureUUID
FrcElmntOrgMeasureType
FrcElmntOrgMeasureDesc
FinancialManagementArea I_FrcElmntToAccountAssignment FinancialManagementArea FM Area

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 I_FrcElmntToAccountAssgmtTP.
-- 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: IFETOACCASSGMTTP

CREATE VIEW I_FrcElmntToAccountAssgmtTP AS
SELECT
  FrcElmntToAccountAssignment.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntToAccountAssignment.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntToAccountAssignment.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToAccountAssignment.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntToAccountAssignment.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntToAccountAssignment.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntToAccountAssignment.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntToAccountAssignment.FrcElmntOrgVariationID AS FrcElmntOrgVariationID,
  FrcElmntToAccountAssignment.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToAccountAssignment.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntToAccountAssignment.FrcElmntOrgCompanyCode AS FrcElmntOrgCompanyCode,
  FrcElmntToAccountAssignment.FrcElmntOrgBusinessArea AS FrcElmntOrgBusinessArea,
  FrcElmntToAccountAssignment.FrcElmntOrgAccountingPlant AS FrcElmntOrgAccountingPlant,
  FrcElmntToAccountAssignment.FrcElmntOrgPersonnelArea AS FrcElmntOrgPersonnelArea,
  FrcElmntToAccountAssignment.FrcElmntOrgPersonnelSubArea AS FrcElmntOrgPersonnelSubArea,
  FrcElmntToAccountAssignment.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  FrcElmntToAccountAssignment.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToAccountAssignment.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgPlngStsCritlty,
  cast (' ' as scmg_case_guid) AS FrcElmntOrgMeasureUUID,
  cast (' ' as /isdfps/orgm_type) AS FrcElmntOrgMeasureType,
  cast (' ' as /isdfps/orgm_type_text) AS FrcElmntOrgMeasureDesc,
  FrcElmntToAccountAssignment.FinancialManagementArea AS FinancialManagementArea
FROM I_FrcElmntToAccountAssignment AS FrcElmntToAccountAssignment
;

Learn More