C_OrglChangeTransferPostg

DDL: C_ORGLCHANGETRANSFERPOSTG SQL: CORGLCHGTRPO Type: view CONSUMPTION
99 Fields 1 Data Sources 1 Associations

Organizational Change Report - Financial Data

C_OrglChangeTransferPostg is a Consumption CDS View that provides data about "Organizational Change Report - Financial Data" in SAP S/4HANA. It reads from 1 data source (I_OrglChgTransfPostgCube) and exposes 99 fields with key field GLAccount. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OrglChgTransfPostgCube I_OrglChgTransfPostgCube from

Parameters (4)

NameTypeDefault
P_Language sylangu
P_BusinessUser syuname
P_OrganizationalChange finoc_orgl_change
P_OrglChangeEffectiveDate finoc_effective_date

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OrganizationalChangeVH _OrganizationalChangeVH _OrganizationalChangeVH.OrganizationalChange = :P_OrganizationalChange

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CORGLCHGTRPO view
EndUserText.label Organizational Change Report - Financial Data view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
Analytics.settings.zeroValues.handling #HIDE_IF_ALL view
Analytics.settings.zeroValues.hideOnAxis #ROWS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (99)

KeyFieldSource TableSource FieldDescription
lookupEntityI_OrganizationalChange
resultElementOrglChangeEffectiveDate
P_OrganizationalChange
KEY GLAccount GLAccount General Ledger
GLAccountName
Segment Segment Segment number
FREECostCtrActivityType
BusinessTransactionType BusinessTransactionType Bus.transaction
CalendarMonth CalendarMonth Calendar Month
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarWeek CalendarWeek Calendar Week
CalendarYear CalendarYear Year
ChartOfAccounts ChartOfAccounts Node Class
CompanyCode CompanyCode Receiver Company Code
CompanyCodeCurrency CompanyCodeCurrency Local Currency
FunctionalCurrency FunctionalCurrency Functional Currency
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
Customer Customer Sold-to Party
CustomerGroup CustomerGroup Customer Group
Supplier Supplier Supplier
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
FiscalPeriod FiscalPeriod Tax period
FiscalYear FiscalYear G/L Fiscal Year
FiscalQuarter FiscalQuarter
FiscalWeek FiscalWeek
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearQuarter FiscalYearQuarter
FiscalYearWeek FiscalYearWeek
FiscalYearVariant FiscalYearVariant FY Variant
FunctionalArea FunctionalArea Sendr Fctl Area
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AccountingDocument AccountingDocument Journal Entry
Ledger Ledger Ledger
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
LedgerFiscalYear LedgerFiscalYear
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
OrderID OrderID Order ID
OrganizationalChange OrganizationalChange Organizational Change
OrglChangeEffectiveDate OrglChangeEffectiveDate Effective Date
OriginProfitCenter OriginProfitCenter
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerOrder PartnerOrder Partner Order
PartnerOrder_2 PartnerOrder_2
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerProjectExternalID PartnerProjectExternalID Partner Project External ID
PartnerWBSElementExternalID PartnerWBSElementExternalID Partner WBSElmnt ext
PostingDate PostingDate Posting Date for GR
Product Product Product Sold
SoldProduct SoldProduct Product Sold
ProjectExternalID ProjectExternalID Project def.
SalesOrganization SalesOrganization Sales Organization
SoldProductGroup Product Sold Group
PartnerCompany PartnerCompany Trading Partner
TransactionCurrency TransactionCurrency Transaction Currency
WBSElementExternalID WBSElementExternalID WBS Element External ID
CalendarYearMonth CalendarYearMonth
CalendarYearQuarter CalendarYearQuarter
CalendarYearWeek CalendarYearWeek
PrdcssrJournalEntryCompanyCode PrdcssrJournalEntryCompanyCode Predecessor Journal Entry Company Code
PrdcssrJournalEntryFiscalYear PrdcssrJournalEntryFiscalYear Predecessor Journal Entry Fiscal Year
PredecessorJournalEntry PredecessorJournalEntry Predecessor Journal Entry
PredecessorJournalEntryItem PredecessorJournalEntryItem Predecessor Journal Entry Item
Plant Plant Valuation Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
PerformanceObligation PerformanceObligation Performance Obligation
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
AssignmentReference AssignmentReference Assignment Reference
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_PerformanceObligation _PerformanceObligation
_ServiceDocumentType _ServiceDocumentType
_ServiceDocument _ServiceDocument
_ServiceDocumentItem _ServiceDocumentItem
AssetClass AssetClass Asset Class
FinancialAccountType FinancialAccountType Fin. Account Type
BusinessArea BusinessArea Business Area
ValuationArea ValuationArea Valuation Area
AccountingDocumentType AccountingDocumentType Journal Entry Type
_AccountingDocumentType _AccountingDocumentType
KeyFiguresOrglChgTransferAmountInCCCrcy Transfer Posting by Orgl Change in CompanyCode Currency
OrglChgCrrtnAmountInCCCrcy OrglChgCrrtnAmountInCCCrcy Correction Posting by Orgl Change in CompanyCode Currency
OrglChgTransfAmountInGlobCrcy OrglChgTransfAmountInGlobCrcy Transfer Posting by Orgl Change in Global Currency
OrglChgCrrtnAmountInGlobCrcy OrglChgCrrtnAmountInGlobCrcy Correction Posting by Orgl Change in Global Currency
OrglChgTransfAmtInFuncnlCrcy OrglChgTransfAmtInFuncnlCrcy Transfer Posting by Orgl Change in Functional Currency
OrglChgCrrtnAmtInFuncnlCrcy OrglChgCrrtnAmtInFuncnlCrcy Correction Posting by Orgl Change in Functional Currency

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_OrglChangeTransferPostg.
-- 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: CORGLCHGTRPO
-- Parameters: P_Language : sylangu, P_BusinessUser : syuname, P_OrganizationalChange : finoc_orgl_change, P_OrglChangeEffectiveDate : finoc_effective_date

CREATE VIEW C_OrglChangeTransferPostg AS
SELECT
  lookupEntity: 'I_OrganizationalChange' AS lookupEntityI_OrganizationalChange,
  resultElement: 'OrglChangeEffectiveDate' AS resultElementOrglChangeEffectiveDate,
  binding: [ { targetElement : 'OrganizationalChange' , type : #PARAMETER, value : 'P_OrganizationalChange' AS P_OrganizationalChange,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1:Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  Segment,
  BusinessTransactionType,
  CalendarMonth,
  CalendarQuarter,
  CalendarWeek,
  CalendarYear,
  ChartOfAccounts,
  CompanyCode,
  CompanyCodeCurrency,
  FunctionalCurrency,
  ControllingArea,
  CostCenter,
  Customer,
  CustomerGroup,
  Supplier,
  DistributionChannel,
  OrganizationDivision,
  ControllingDebitCreditCode,
  FiscalPeriod,
  FiscalYear,
  FiscalQuarter,
  FiscalWeek,
  FiscalYearPeriod,
  FiscalYearQuarter,
  FiscalYearWeek,
  FiscalYearVariant,
  FunctionalArea,
  GlobalCurrency,
  AccountingDocument,
  Ledger,
  LedgerGLLineItem,
  LedgerFiscalYear,
  AccountAssignmentType,
  OrderID,
  OrganizationalChange,
  OrglChangeEffectiveDate,
  OriginProfitCenter,
  PartnerCostCtrActivityType,
  PartnerCostCenter,
  PartnerFunctionalArea,
  PartnerOrder,
  PartnerOrder_2,
  PartnerProfitCenter,
  PartnerProjectExternalID,
  PartnerWBSElementExternalID,
  PostingDate,
  Product,
  SoldProduct,
  ProjectExternalID,
  SalesOrganization,
  cast(SoldProductGroup as fis_soldproductgroup preserving type) AS SoldProductGroup,
  PartnerCompany,
  TransactionCurrency,
  WBSElementExternalID,
  CalendarYearMonth,
  CalendarYearQuarter,
  CalendarYearWeek,
  PrdcssrJournalEntryCompanyCode,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  Plant,
  MasterFixedAsset,
  FixedAsset,
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  PerformanceObligation,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  AssignmentReference,
  AssetClass,
  FinancialAccountType,
  BusinessArea,
  ValuationArea,
  AccountingDocumentType,
  OrglChgCrrtnAmountInCCCrcy,
  OrglChgTransfAmountInGlobCrcy,
  OrglChgCrrtnAmountInGlobCrcy,
  OrglChgTransfAmtInFuncnlCrcy,
  OrglChgCrrtnAmtInFuncnlCrcy
FROM I_OrglChgTransfPostgCube
LEFT OUTER JOIN I_OrganizationalChangeVH AS _OrganizationalChangeVH ON _OrganizationalChangeVH.OrganizationalChange = :P_OrganizationalChange  -- association [0..1]
;

Learn More