I_CostRevnReassignmentItemTP
Cost, Revenue Reassgmt Item - Transactional
I_CostRevnReassignmentItemTP is a Transactional CDS View that provides data about "Cost, Revenue Reassgmt Item - Transactional" in SAP S/4HANA. It reads from 1 data source (I_CostRevenueReassignmentItem) and exposes 140 fields with key fields FiscalYear, ReferenceDocument, ControllingArea, CompanyCode, LedgerGLLineItem. It has 2 associations to related views. Part of development package ODATA_REASSIGN_COSTS_REVENUES.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CostRevenueReassignmentItem | _Item | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_CostRevenueReassignmentTP | _Header | $projection.ControllingArea = _Header.ControllingArea and $projection.FiscalYear = _Header.FiscalYear and $projection.ReferenceDocument = _Header.ReferenceDocument |
| [1..1] | E_JournalEntryItem | _Extension | $projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICOSREVREASSITP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Cost, Revenue Reassgmt Item - Transactional | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.writeDraftPersistence | COSREVREASSITMDR | view |
Fields (140)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | FiscalYear | FiscalYear | ||
| KEY | ReferenceDocument | ReferenceDocument | ||
| KEY | ControllingArea | ControllingArea | ||
| KEY | CompanyCode | CompanyCode | ||
| KEY | LedgerGLLineItem | LedgerGLLineItem | ||
| KEY | ReferenceDocumentItem | ReferenceDocumentItem | ||
| AccountingDocument | AccountingDocument | |||
| SourceLedger | SourceLedger | |||
| FiscalYearForEdit | FiscalYear | |||
| ReferenceDocumentForEdit | ReferenceDocumentForEdit | |||
| ControllingAreaForEdit | ControllingArea | |||
| CompanyCodeForEdit | CompanyCode | |||
| LedgerGLLineItemForEdit | LedgerGLLineItem | |||
| ReferenceDocumentItemForEdit | ReferenceDocumentItem | |||
| DocumentItemText | DocumentItemText | |||
| GLAccount | GLAccount | |||
| AccountAssignment | AccountAssignment | |||
| AccountAssignmentType | AccountAssignmentType | |||
| PartnerAccountAssignment | PartnerAccountAssignment | |||
| PartnerAccountAssignmentType | PartnerAccountAssignmentType | |||
| CostCtrActivityType | CostCtrActivityType | |||
| OriginCostCenter | OriginCostCenter | |||
| PartnerCostCenter | PartnerCostCenter | |||
| PartnerCostCtrActivityType | PartnerCostCtrActivityType | |||
| PartnerWBSElementExternalID | PartnerWBSElementExternalID | |||
| PartnerWBSElement | PartnerWBSElement | |||
| WBSElementExternalID | WBSElementExternalID | |||
| WBSElement | WBSElement | |||
| PartnerWBSElementInternalID | PartnerWBSElementInternalID | |||
| WBSElementInternalID | WBSElementInternalID | |||
| PartnerServiceDocumentType | PartnerServiceDocumentType | |||
| PartnerServiceDocument | PartnerServiceDocument | |||
| PartnerServiceDocumentItem | PartnerServiceDocumentItem | |||
| ServiceDocumentType | ServiceDocumentType | |||
| ServiceDocument | ServiceDocument | |||
| ServiceDocumentItem | ServiceDocumentItem | |||
| PartnerProjectNetwork | PartnerProjectNetwork | |||
| PartnerProjectNetworkActivity | PartnerProjectNetworkActivity | |||
| RelatedNetworkActivity | RelatedNetworkActivity | |||
| ProjectNetwork | ProjectNetwork | |||
| PartnerOrder | PartnerOrder | |||
| OrderID | OrderID | |||
| PartnerOrderOperation | PartnerOrderOperation | |||
| OrderOperation | OrderOperation | |||
| PartnerCompanyCode | ||||
| SenderCompanyCode | SenderCompanyCode | |||
| PartnerCostObject | PartnerCostObject | |||
| CostObject | CostObject | |||
| PartnerSalesDocument | PartnerSalesDocument | |||
| PartnerSalesDocumentItem | PartnerSalesDocumentItem | |||
| SalesDocument | SalesDocument | |||
| SalesDocumentItem | SalesDocumentItem | |||
| PersonnelNumber | PersonnelNumber | |||
| PartnerBusinessProcess | PartnerBusinessProcess | |||
| BusinessProcess | BusinessProcess | |||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | |||
| SenderCostRecoveryCode | SenderCostRecoveryCode | |||
| CostRevenueReassignmentAction | ||||
| Status | ||||
| Fund | Fund | |||
| FunctionalArea | FunctionalArea | |||
| GrantID | GrantID | |||
| BudgetPeriod | BudgetPeriod | |||
| PartnerFund | PartnerFund | |||
| PartnerFunctionalArea | PartnerFunctionalArea | |||
| PartnerGrant | PartnerGrant | |||
| PartnerBudgetPeriod | PartnerBudgetPeriod | |||
| WorkItem | WorkItem | |||
| PartnerWorkItem | PartnerWorkItem | |||
| FinancialManagementArea | FinancialManagementArea | |||
| RcvrAcctgIndCode | RcvrAcctgIndCode | |||
| BillableControl | BillableControl | |||
| BaseUnit | BaseUnit | |||
| Quantity | Quantity | |||
| TransactionCurrency | TransactionCurrency | |||
| AmountInTransactionCurrency | AmountInTransactionCurrency | |||
| CompanyCodeCurrency | CompanyCodeCurrency | |||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | |||
| GlobalCurrency | GlobalCurrency | |||
| AmountInGlobalCurrency | AmountInGlobalCurrency | |||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | |||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | |||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | |||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | |||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | |||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | |||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | |||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | |||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | |||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | |||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | |||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | |||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | |||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | |||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | |||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | |||
| FunctionalCurrency | FunctionalCurrency | |||
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | |||
| ChartOfAccounts | ChartOfAccounts | |||
| ControllingBusTransacType | ControllingBusTransacType | |||
| PostingDate | PostingDate | |||
| PartnerProfitabilitySegment | PartnerProfitabilitySegment | |||
| ProfitabilitySegment | ProfitabilitySegment | |||
| PartProfitabilitySgmtIsAssgd | PartProfitabilitySgmtIsAssgd | |||
| ProfitabilitySegmentIsAssigned | ProfitabilitySegmentIsAssigned | |||
| OperatingConcern | OperatingConcern | |||
| ReceiverRECompanyCode | ReceiverRECompanyCode | |||
| REPartnerBusinessEntity | REPartnerBusinessEntity | |||
| RealEstatePartnerBuilding | RealEstatePartnerBuilding | |||
| RealEstatePartnerProperty | RealEstatePartnerProperty | |||
| REPartnerRentalObject | REPartnerRentalObject | |||
| RealEstatePartnerContract | RealEstatePartnerContract | |||
| REPartnerServiceChargeKey | REPartnerServiceChargeKey | |||
| REPartnerSettlementUnitID | REPartnerSettlementUnitID | |||
| PartnerSettlementReferenceDate | PartnerSettlementReferenceDate | |||
| SenderRECompanyCode | SenderRECompanyCode | |||
| REBusinessEntity | REBusinessEntity | |||
| RealEstateBuilding | RealEstateBuilding | |||
| RealEstateProperty | RealEstateProperty | |||
| RERentalObject | RERentalObject | |||
| RealEstateContract | RealEstateContract | |||
| REServiceChargeKey | REServiceChargeKey | |||
| RESettlementUnitID | RESettlementUnitID | |||
| SettlementReferenceDate | SettlementReferenceDate | |||
| ProfitCenter | ProfitCenter | |||
| PartnerProfitCenter | PartnerProfitCenter | |||
| PartnerControllingObject | PartnerControllingObject | |||
| ControllingObject | ControllingObject | |||
| TransactionSubitem | TransactionSubitem | |||
| AccountingDocumentType | I_CostRevenueReassignmentItem | AccountingDocumentType | ||
| _Header | _Header | |||
| _BaseUnit | _BaseUnit | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _Grant | _Grant | |||
| _PartnerGrant | _PartnerGrant | |||
| _BudgetPeriod | _BudgetPeriod | |||
| _PartnerBudgetPeriod | _PartnerBudgetPeriod | |||
| _FunctionalArea | _FunctionalArea | |||
| _PartnerFunctionalArea | _PartnerFunctionalArea |
@AbapCatalog.sqlViewName: 'ICOSREVREASSITP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost, Revenue Reassgmt Item - Transactional'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel:
{
writeDraftPersistence: 'COSREVREASSITMDR',
semanticKey: ['FiscalYearForEdit', 'ReferenceDocumentForEdit', 'ControllingAreaForEdit', 'CompanyCodeForEdit', 'LedgerGLLineItemForEdit', 'ReferenceDocumentItemForEdit'],
createEnabled,
updateEnabled,
deleteEnabled
//entityChangeStateId: 'LastChangeTime'
}
@Consumption.dbHints: ['NO_USE_HEX_PLAN']
define view I_CostRevnReassignmentItemTP
as select from I_CostRevenueReassignmentItem as _Item
association [1..1] to I_CostRevenueReassignmentTP as _Header on $projection.ControllingArea = _Header.ControllingArea
and $projection.FiscalYear = _Header.FiscalYear
and $projection.ReferenceDocument = _Header.ReferenceDocument
association [1..1] to E_JournalEntryItem as _Extension on $projection.SourceLedger = _Extension.SourceLedger
and $projection.CompanyCode = _Extension.CompanyCode
and $projection.FiscalYear = _Extension.FiscalYear
and $projection.AccountingDocument = _Extension.AccountingDocument
and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem
{
key FiscalYear,
key ReferenceDocument,
key ControllingArea,
key CompanyCode,
key LedgerGLLineItem,
key ReferenceDocumentItem,
AccountingDocument,
SourceLedger,
FiscalYear as FiscalYearForEdit,
ReferenceDocumentForEdit,
ControllingArea as ControllingAreaForEdit,
CompanyCode as CompanyCodeForEdit,
LedgerGLLineItem as LedgerGLLineItemForEdit,
ReferenceDocumentItem as ReferenceDocumentItemForEdit,
DocumentItemText,
GLAccount,
AccountAssignment,
AccountAssignmentType,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
CostCtrActivityType,
OriginCostCenter,
PartnerCostCenter,
//Cost Center/Activity Type
PartnerCostCtrActivityType,
//WBS Element
PartnerWBSElementExternalID,
@ObjectModel.readOnly
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PartnerWBSElementExternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PartnerWBSElementExternalID'
PartnerWBSElement,
WBSElementExternalID,
@ObjectModel.readOnly
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementExternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementExternalID'
WBSElement,
@ObjectModel.readOnly
PartnerWBSElementInternalID,
@ObjectModel.readOnly
WBSElementInternalID,
//Service Contract Item and Service Order Item
PartnerServiceDocumentType,
PartnerServiceDocument,
PartnerServiceDocumentItem,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
//Network
PartnerProjectNetwork,
PartnerProjectNetworkActivity,
RelatedNetworkActivity,
ProjectNetwork,
//Activity or Order
PartnerOrder,
OrderID,
//Order operation
PartnerOrderOperation,
OrderOperation,
cast('' as receivercompanycode) as PartnerCompanyCode, //Dummy field, cannot delete, because of db table inconsistency
SenderCompanyCode,
//Cost object
PartnerCostObject,
CostObject,
//Sales Order
PartnerSalesDocument,
PartnerSalesDocumentItem,
SalesDocument,
SalesDocumentItem,
PersonnelNumber,
PartnerBusinessProcess,
BusinessProcess,
JointVentureCostRecoveryCode,
SenderCostRecoveryCode,
cast('' as costrevenuereassignmentaction) as CostRevenueReassignmentAction,
cast('' as fco_drct_acty_is_posted) as Status,
//Public Sector
Fund,
FunctionalArea,
GrantID,
BudgetPeriod,
PartnerFund,
PartnerFunctionalArea,
PartnerGrant,
PartnerBudgetPeriod,
WorkItem,
PartnerWorkItem,
@ObjectModel.readOnly
FinancialManagementArea,
RcvrAcctgIndCode,
BillableControl,
@Semantics.unitOfMeasure:true
BaseUnit,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
Quantity,
@Semantics.currencyCode:true
TransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
AmountInTransactionCurrency,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
AmountInCompanyCodeCurrency,
@Semantics.currencyCode:true
GlobalCurrency,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
AmountInGlobalCurrency,
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
AmountInFreeDefinedCurrency1,
@Semantics.currencyCode:true
FreeDefinedCurrency2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
AmountInFreeDefinedCurrency2,
@Semantics.currencyCode:true
FreeDefinedCurrency3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
AmountInFreeDefinedCurrency3,
@Semantics.currencyCode:true
FreeDefinedCurrency4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
AmountInFreeDefinedCurrency4,
@Semantics.currencyCode:true
FreeDefinedCurrency5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
AmountInFreeDefinedCurrency5,
@Semantics.currencyCode:true
FreeDefinedCurrency6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
AmountInFreeDefinedCurrency6,
@Semantics.currencyCode:true
FreeDefinedCurrency7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
AmountInFreeDefinedCurrency7,
@Semantics.currencyCode:true
FreeDefinedCurrency8,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
AmountInFreeDefinedCurrency8,
@Semantics.currencyCode:true
FunctionalCurrency,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
AmountInFunctionalCurrency,
ChartOfAccounts,
ControllingBusTransacType,
PostingDate,
PartnerProfitabilitySegment,
ProfitabilitySegment,
@ObjectModel.readOnly
@Semantics.booleanIndicator
PartProfitabilitySgmtIsAssgd,
@ObjectModel.readOnly
@Semantics.booleanIndicator
ProfitabilitySegmentIsAssigned,
@ObjectModel.readOnly
OperatingConcern,
ReceiverRECompanyCode,
REPartnerBusinessEntity,
RealEstatePartnerBuilding,
RealEstatePartnerProperty,
REPartnerRentalObject,
RealEstatePartnerContract,
REPartnerServiceChargeKey,
REPartnerSettlementUnitID,
PartnerSettlementReferenceDate,
SenderRECompanyCode,
REBusinessEntity,
RealEstateBuilding,
RealEstateProperty,
RERentalObject,
RealEstateContract,
REServiceChargeKey,
RESettlementUnitID,
SettlementReferenceDate,
ProfitCenter,
PartnerProfitCenter,
PartnerControllingObject,
ControllingObject,
TransactionSubitem,
@ObjectModel.readOnly: true
_Item.AccountingDocumentType,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
_Header,
_BaseUnit,
_Fund,
_PartnerFund,
_Grant,
_PartnerGrant,
_BudgetPeriod,
_PartnerBudgetPeriod,
_FunctionalArea,
_PartnerFunctionalArea
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA