A_CmtmtCarryForwardDocument

DDL: A_CMTMTCARRYFORWARDDOCUMENT SQL: ACMMTCCFDOC Type: view COMPOSITE
75 Fields 1 Data Sources 1 Associations

Funds Management Carry Forward Document

A_CmtmtCarryForwardDocument is a Composite CDS View that provides data about "Funds Management Carry Forward Document" in SAP S/4HANA. It reads from 1 data source (I_CmtmtCarryForwardDocument) and exposes 75 fields with key fields CommitmentCarryForwardDocument, FinancialManagementArea, ReceiverFinMgmtAreaFiscalYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmtmtCarryForwardDocument I_CmtmtCarryForwardDocument from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CmtmtCarryFwdDoc _Extension $projection.CommitmentCarryForwardDocument = _Extension.CommitmentCarryForwardDocument and $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.ReceiverFinMgmtAreaFiscalYear = _Extension.ReceiverFinMgmtAreaFiscalYear

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ACMMTCCFDOC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Funds Management Carry Forward Document view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name CommitmentCarryForwardDocument_Type view
VDM.viewType #COMPOSITE view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY CommitmentCarryForwardDocument CommitmentCarryForwardDocument
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY ReceiverFinMgmtAreaFiscalYear ReceiverFinMgmtAreaFiscalYear
FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory
FundsMgmtCarryBackStatus FundsMgmtCarryBackStatus
FundsMgCarryBackRefDocument FundsMgCarryBackRefDocument
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
FundsMgmtReferenceDocumentItem FundsMgmtReferenceDocumentItem
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
RefDocAccountAssignment RefDocAccountAssignment
FundsMgmtRefDocScheduleLine FundsMgmtRefDocScheduleLine
RefDocPricingElementContent RefDocPricingElementContent
ReferenceDocumentType ReferenceDocumentType Reference Document Type
CompanyCode CompanyCode Receiver Company Code
OriginAccountingDocFiscalYear OriginAccountingDocFiscalYear
FundsManagementDocument FundsManagementDocument
FundsMgmtValueType FundsMgmtValueType
FundsManagementDocumentItem FundsManagementDocumentItem
FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
CmtmtCarryFwdAmtInFMACrcy CmtmtCarryFwdAmtInFMACrcy
TransactionCurrency TransactionCurrency Transaction Currency
CmtmtCarryFwdAmtInTransCrcy CmtmtCarryFwdAmtInTransCrcy
SndrPostdCshEffctyFiscalYear SndrPostdCshEffctyFiscalYear
FndsMgmtSenderStatisticalType FndsMgmtSenderStatisticalType
SenderLedger SenderLedger
SenderPostedFund SenderPostedFund
SenderPostedBudgetPeriod SenderPostedBudgetPeriod
SenderPostedFundsCenter SenderPostedFundsCenter
SenderPostedCommitmentItem SenderPostedCommitmentItem
SenderPostedFunctionalArea SenderPostedFunctionalArea
SenderPostedFundedProgram SenderPostedFundedProgram
SenderPostedGrantId SenderPostedGrantId
SenderPostedFundsMgmtCustField SenderPostedFundsMgmtCustField
SenderFinMgmtAreaFiscalYear SenderFinMgmtAreaFiscalYear
RcvrPostdCshEffctyFiscalYear RcvrPostdCshEffctyFiscalYear
FndsMgmtRcvrStatisticalType FndsMgmtRcvrStatisticalType
ReceiverLedger ReceiverLedger
ReceiverPostedFund ReceiverPostedFund
ReceiverPostedBudgetPeriod ReceiverPostedBudgetPeriod
ReceiverPostedFundsCenter ReceiverPostedFundsCenter
ReceiverPostedCommitmentItem ReceiverPostedCommitmentItem
ReceiverPostedFunctionalArea ReceiverPostedFunctionalArea
ReceiverPostedFundedProgram ReceiverPostedFundedProgram
ReceiverPostedGrantId ReceiverPostedGrantId
ReceiverPostedFundsMgmtCustFld ReceiverPostedFundsMgmtCustFld
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
BudgetEntryDocument BudgetEntryDocument Document Number
FundsMgmtTransactionNumber FundsMgmtTransactionNumber
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
FundsMgCarryForwardLevel FundsMgCarryForwardLevel
FundsMgCarryForwardCounter FundsMgCarryForwardCounter
FsclYrChgDocHasFollowOnDoc FsclYrChgDocHasFollowOnDoc
FundsMgmtCarryFwdBudgetStatus FundsMgmtCarryFwdBudgetStatus
_FinMgmtArea _FinMgmtArea
_FinMgmtFiscalYear _FinMgmtFiscalYear
_ReferenceDocumentType _ReferenceDocumentType
_SenderFund _SenderFund
_SenderCommitmentItem _SenderCommitmentItem
_SenderBudgetPeriod _SenderBudgetPeriod
_SenderFunctionalArea _SenderFunctionalArea
_SenderFundedProgram _SenderFundedProgram
_SenderFundsCenter _SenderFundsCenter
_SenderGrant _SenderGrant
_ReceiverFund _ReceiverFund
_ReceiverCommitmentItem _ReceiverCommitmentItem
_ReceiverBudgetPeriod _ReceiverBudgetPeriod
_ReceiverFunctionalArea _ReceiverFunctionalArea
_ReceiverFundedProgram _ReceiverFundedProgram
_ReceiverFundsCenter _ReceiverFundsCenter
_ReceiverGrant _ReceiverGrant
_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea
_BudgetEntryDocument _BudgetEntryDocument

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 A_CmtmtCarryForwardDocument.
-- 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: ACMMTCCFDOC

CREATE VIEW A_CmtmtCarryForwardDocument AS
SELECT
  CommitmentCarryForwardDocument,
  FinancialManagementArea,
  ReceiverFinMgmtAreaFiscalYear,
  FundsMgmtRefDocumentCategory,
  FundsMgmtCarryBackStatus,
  FundsMgCarryBackRefDocument,
  ReferenceDocument,
  ReferenceDocumentContext,
  FundsMgmtReferenceDocumentItem,
  ReferenceDocumentLogicalSystem,
  RefDocAccountAssignment,
  FundsMgmtRefDocScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  CompanyCode,
  OriginAccountingDocFiscalYear,
  FundsManagementDocument,
  FundsMgmtValueType,
  FundsManagementDocumentItem,
  FinancialManagementAreaCrcy,
  CmtmtCarryFwdAmtInFMACrcy,
  TransactionCurrency,
  CmtmtCarryFwdAmtInTransCrcy,
  SndrPostdCshEffctyFiscalYear,
  FndsMgmtSenderStatisticalType,
  SenderLedger,
  SenderPostedFund,
  SenderPostedBudgetPeriod,
  SenderPostedFundsCenter,
  SenderPostedCommitmentItem,
  SenderPostedFunctionalArea,
  SenderPostedFundedProgram,
  SenderPostedGrantId,
  SenderPostedFundsMgmtCustField,
  SenderFinMgmtAreaFiscalYear,
  RcvrPostdCshEffctyFiscalYear,
  FndsMgmtRcvrStatisticalType,
  ReceiverLedger,
  ReceiverPostedFund,
  ReceiverPostedBudgetPeriod,
  ReceiverPostedFundsCenter,
  ReceiverPostedCommitmentItem,
  ReceiverPostedFunctionalArea,
  ReceiverPostedFundedProgram,
  ReceiverPostedGrantId,
  ReceiverPostedFundsMgmtCustFld,
  CommitmentItemFiscalYear,
  BudgetEntryDocument,
  FundsMgmtTransactionNumber,
  CreatedByUser,
  CreationDate,
  CreationTime,
  FundsMgCarryForwardLevel,
  FundsMgCarryForwardCounter,
  FsclYrChgDocHasFollowOnDoc,
  FundsMgmtCarryFwdBudgetStatus
FROM I_CmtmtCarryForwardDocument
LEFT OUTER JOIN E_CmtmtCarryFwdDoc AS _Extension ON CommitmentCarryForwardDocument = _Extension.CommitmentCarryForwardDocument AND FinancialManagementArea = _Extension.FinancialManagementArea AND ReceiverFinMgmtAreaFiscalYear = _Extension.ReceiverFinMgmtAreaFiscalYear  -- association [1..1]
;

Learn More