C_FrcElmntToAccountAssgmtTP

DDL: C_FRCELMNTTOACCOUNTASSGMTTP SQL: CFETOACCASSGMTTP Type: view CONSUMPTION
37 Fields 1 Data Sources 9 Associations

C_FrcElmntToAccountAssgmtTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToAccountAssgmtTP) and exposes 37 fields with key fields ForceElementOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToAccountAssgmtTP FrcElmntToAccountAssgmtTP from

Associations (9)

CardinalityTargetAliasCondition
[1..*] C_FrcElmntOrgVH _FrcElmntOrgVH _FrcElmntOrgVH.ForceElementOrgIDForEdit = $projection.ForceElementOrgID
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..1] C_ControllingAreaVH _ControllingAreaVH _ControllingAreaVH.ControllingArea = $projection.FrcElmntOrgControllingArea
[1..1] C_CABusinessAreaValueHelp _CABusinessAreaValueHelp _CABusinessAreaValueHelp.BusinessArea = $projection.FrcElmntOrgBusinessArea
[1..1] C_FrcElmntOrgFinMgmtAreaVH _FrcElmntOrgFinMgmtAreaVH _FrcElmntOrgFinMgmtAreaVH.FinancialManagementArea = $projection.FinancialManagementArea
[1..1] C_FrcElmntOrgCompanyCodeVH _FrcElmntOrgCompanyCodeVH _FrcElmntOrgCompanyCodeVH.CompanyCode = $projection.FrcElmntOrgCompanyCode
[1..1] C_Plantvaluehelp _PlantValueHelp _PlantValueHelp.Plant = $projection.FrcElmntOrgAccountingPlant
[1..1] C_FrcElmntOrgPersonnelAreaVH _FrcElmntOrgPersonnelAreaVH _FrcElmntOrgPersonnelAreaVH.FrcElmntOrgPersonnelArea = $projection.FrcElmntOrgPersonnelArea
[1..1] C_FrcElmntOrgPersSubAreaVH _FrcElmntOrgPersSubAreaVH _FrcElmntOrgPersSubAreaVH.FrcElmntOrgPersonnelArea = $projection.FrcElmntOrgPersonnelArea and _FrcElmntOrgPersSubAreaVH.FrcElmntOrgPersonnelSubArea = $projection.FrcElmntOrgPersonnelSubArea

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFETOACCASSGMTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
Metadata.allowExtensions true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_FrcElmntToAccountAssgmtTP ForceElementOrgID Object ID Processor
KEY FrcElmntOrgPlngStatus I_FrcElmntToAccountAssgmtTP FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate I_FrcElmntToAccountAssgmtTP FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntToAccountAssgmtTP FrcElmntOrgValdtyEndDate End Date
FrcElmntOrgPlanVersion I_FrcElmntToAccountAssgmtTP FrcElmntOrgPlanVersion Plan version
FrcElmntOrgType I_FrcElmntToAccountAssgmtTP FrcElmntOrgType Object type
FrcElmntOrgSubType I_FrcElmntToAccountAssgmtTP FrcElmntOrgSubType Subtype
FrcElmntOrgVariationID I_FrcElmntToAccountAssgmtTP FrcElmntOrgVariationID Variation field
NumberOfForceElementOrg I_FrcElmntToAccountAssgmtTP NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType I_FrcElmntToAccountAssgmtTP FrcElmntOrgInfoType Infotype
FrcElmntOrgCompanyCode I_FrcElmntToAccountAssgmtTP FrcElmntOrgCompanyCode Company Code
CompanyCodeName _FrcElmntOrgCompanyCodeVH CompanyCodeName Company Name
FrcElmntOrgBusinessArea I_FrcElmntToAccountAssgmtTP FrcElmntOrgBusinessArea Business Area
BusinessAreaName _CABusinessAreaValueHelp BusinessAreaName Business Area Name
FrcElmntOrgAccountingPlant I_FrcElmntToAccountAssgmtTP FrcElmntOrgAccountingPlant Plant
PlantName _PlantValueHelp PlantName Plant Name
FrcElmntOrgPersonnelArea I_FrcElmntToAccountAssgmtTP FrcElmntOrgPersonnelArea Personnel area
FrcElmntOrgPersonnelAreaText _FrcElmntOrgPersonnelAreaVH FrcElmntOrgPersonnelAreaText
FrcElmntOrgPersonnelSubArea I_FrcElmntToAccountAssgmtTP FrcElmntOrgPersonnelSubArea Pers. subarea
FrcElmntOrgPersonnelSubAreaTxt _FrcElmntOrgPersSubAreaVH FrcElmntOrgPersonnelSubAreaTxt
FrcElmntOrgControllingArea I_FrcElmntToAccountAssgmtTP FrcElmntOrgControllingArea CO Area
ControllingAreaName _ControllingAreaVH ControllingAreaName Long Text
FrcElmntOrgName _FrcElmntOrgVH FrcElmntOrgName Name
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntToAccountAssgmtTP FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntToAccountAssgmtTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgPlngStsCritlty I_FrcElmntToAccountAssgmtTP FrcElmntOrgPlngStsCritlty
FinancialManagementArea I_FrcElmntToAccountAssgmtTP FinancialManagementArea FM Area
FinancialManagementAreaName _FrcElmntOrgFinMgmtAreaVH FinancialManagementAreaName
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
_FrcElmntOrgVH _FrcElmntOrgVH
_ControllingAreaVH _ControllingAreaVH
_CABusinessAreaValueHelp _CABusinessAreaValueHelp
_FrcElmntOrgCompanyCodeVH _FrcElmntOrgCompanyCodeVH
_PlantValueHelp _PlantValueHelp
_FrcElmntOrgPersonnelAreaVH _FrcElmntOrgPersonnelAreaVH
_FrcElmntOrgPersSubAreaVH _FrcElmntOrgPersSubAreaVH
_FrcElmntOrgFinMgmtAreaVH _FrcElmntOrgFinMgmtAreaVH

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 C_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: CFETOACCASSGMTTP

CREATE VIEW C_FrcElmntToAccountAssgmtTP AS
SELECT
  FrcElmntToAccountAssgmtTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgVariationID AS FrcElmntOrgVariationID,
  FrcElmntToAccountAssgmtTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgCompanyCode AS FrcElmntOrgCompanyCode,
  _FrcElmntOrgCompanyCodeVH.CompanyCodeName AS CompanyCodeName,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgBusinessArea AS FrcElmntOrgBusinessArea,
  _CABusinessAreaValueHelp.BusinessAreaName AS BusinessAreaName,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgAccountingPlant AS FrcElmntOrgAccountingPlant,
  _PlantValueHelp.PlantName AS PlantName,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgPersonnelArea AS FrcElmntOrgPersonnelArea,
  _FrcElmntOrgPersonnelAreaVH.FrcElmntOrgPersonnelAreaText AS FrcElmntOrgPersonnelAreaText,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgPersonnelSubArea AS FrcElmntOrgPersonnelSubArea,
  _FrcElmntOrgPersSubAreaVH.FrcElmntOrgPersonnelSubAreaTxt AS FrcElmntOrgPersonnelSubAreaTxt,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToAccountAssgmtTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToAccountAssgmtTP.FinancialManagementArea AS FinancialManagementArea,
  _FrcElmntOrgFinMgmtAreaVH.FinancialManagementAreaName AS FinancialManagementAreaName,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName
FROM I_FrcElmntToAccountAssgmtTP AS FrcElmntToAccountAssgmtTP
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_ControllingAreaVH AS _ControllingAreaVH ON _ControllingAreaVH.ControllingArea = FrcElmntOrgControllingArea  -- association [1..1]
LEFT OUTER JOIN C_CABusinessAreaValueHelp AS _CABusinessAreaValueHelp ON _CABusinessAreaValueHelp.BusinessArea = FrcElmntOrgBusinessArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgFinMgmtAreaVH AS _FrcElmntOrgFinMgmtAreaVH ON _FrcElmntOrgFinMgmtAreaVH.FinancialManagementArea = FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgCompanyCodeVH AS _FrcElmntOrgCompanyCodeVH ON _FrcElmntOrgCompanyCodeVH.CompanyCode = FrcElmntOrgCompanyCode  -- association [1..1]
LEFT OUTER JOIN C_Plantvaluehelp AS _PlantValueHelp ON _PlantValueHelp.Plant = FrcElmntOrgAccountingPlant  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPersonnelAreaVH AS _FrcElmntOrgPersonnelAreaVH ON _FrcElmntOrgPersonnelAreaVH.FrcElmntOrgPersonnelArea = FrcElmntOrgPersonnelArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPersSubAreaVH AS _FrcElmntOrgPersSubAreaVH ON _FrcElmntOrgPersSubAreaVH.FrcElmntOrgPersonnelArea = FrcElmntOrgPersonnelArea AND _FrcElmntOrgPersSubAreaVH.FrcElmntOrgPersonnelSubArea = FrcElmntOrgPersonnelSubArea  -- association [1..1]
;

Learn More