A_CmtmtCarryForwardLotItem

DDL: A_CMTMTCARRYFORWARDLOTITEM SQL: ACMMTLOTIT Type: view COMPOSITE
85 Fields 1 Data Sources 2 Associations

Commitment Carryforward Lot Item

A_CmtmtCarryForwardLotItem is a Composite CDS View that provides data about "Commitment Carryforward Lot Item" in SAP S/4HANA. It reads from 1 data source (I_CmtmtCarryForwardLotCube) and exposes 85 fields with key fields FinancialManagementArea, SenderFinMgmtAreaFiscalYear, CommitmentCarryForwardLot, CommitmentCarryForwardLotItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmtmtCarryForwardLotCube I_CmtmtCarryForwardLotCube from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_CmtmtCarryForwardLotItem _ExtensionItem $projection.FinancialManagementArea = _ExtensionItem.FinancialManagementArea and $projection.SenderFinMgmtAreaFiscalYear = _ExtensionItem.SenderFinMgmtAreaFiscalYear and $projection.CommitmentCarryForwardLot = _ExtensionItem.CommitmentCarryForwardLot and $projection.CommitmentCarryForwardLotItem = _ExtensionItem.CommitmentCarryForwardLotItem
[1..1] E_CommitmentCarryForwardLot _Extension $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.SenderFinMgmtAreaFiscalYear = _Extension.SenderFinMgmtAreaFiscalYear and $projection.CommitmentCarryForwardLot = _Extension.CommitmentCarryForwardLot

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ACMMTLOTIT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Commitment Carryforward Lot Item view
AccessControl.authorizationCheck #MANDATORY 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 CmtmtCarryForwardLotItem_Type view
VDM.viewType #COMPOSITE view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY SenderFinMgmtAreaFiscalYear SenderFinMgmtAreaFiscalYear
KEY CommitmentCarryForwardLot CommitmentCarryForwardLot
KEY CommitmentCarryForwardLotItem CommitmentCarryForwardLotItem
CmtmtCarryForwardApprovalStep CmtmtCarryForwardApprovalStep
CmtmtCarryFwdLotIsCompleted CmtmtCarryFwdLotIsCompleted
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
CmtmtCarryFwdApprvlCmtmtDate CmtmtCarryFwdApprvlCmtmtDate
CmtmtCarryFwdApprvlCmtmtTime CmtmtCarryFwdApprvlCmtmtTime
CarryFwdApprvlCmtmtCrtedByUser CarryFwdApprvlCmtmtCrtedByUser
CarryFwdApprvlBdgtForCmtmtDate CarryFwdApprvlBdgtForCmtmtDate
CarryFwdApprvlBdgtForCmtmtTime CarryFwdApprvlBdgtForCmtmtTime
ApprvlBdgtForCmtmtCrtedByUser ApprvlBdgtForCmtmtCrtedByUser
CmtmtCarryFwdLotDescription CmtmtCarryFwdLotDescription
ZeroCmtmtCarryFwdSts ZeroCmtmtCarryFwdSts
ReferenceDocument ReferenceDocument Reference Document
FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
FundsMgmtReferenceDocumentItem FundsMgmtReferenceDocumentItem
RefDocAccountAssignment RefDocAccountAssignment
FundsMgmtRefDocScheduleLine FundsMgmtRefDocScheduleLine
RefDocPricingElementContent RefDocPricingElementContent
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
FundsManagementDocument FundsManagementDocument
FundsManagementDocumentItem FundsManagementDocumentItem
CompanyCode CompanyCode Receiver Company Code
OriginAccountingDocFiscalYear OriginAccountingDocFiscalYear
SenderLedger SenderLedger
FundsMgmtValueType FundsMgmtValueType
FundsMgmtCarryForwardStatus FundsMgmtCarryForwardStatus
FundsMgCarryForwardCounter FundsMgCarryForwardCounter
ReceiverPostedGrantId ReceiverPostedGrantId
ReceiverPostedFund ReceiverPostedFund
ReceiverPostedFundsCenter ReceiverPostedFundsCenter
ReceiverPostedCommitmentItem ReceiverPostedCommitmentItem
ReceiverPostedFunctionalArea ReceiverPostedFunctionalArea
ReceiverPostedFundedProgram ReceiverPostedFundedProgram
ReceiverPostedBudgetPeriod ReceiverPostedBudgetPeriod
SenderPostedGrantId SenderPostedGrantId
SenderPostedFund SenderPostedFund
SenderPostedFundsCenter SenderPostedFundsCenter
SenderPostedCommitmentItem SenderPostedCommitmentItem
SenderPostedFunctionalArea SenderPostedFunctionalArea
SenderPostedFundedProgram SenderPostedFundedProgram
SenderPostedBudgetPeriod SenderPostedBudgetPeriod
CommitmentCarryForwardDocument CommitmentCarryForwardDocument
CmtmtCarryFwdDocPredecessor CmtmtCarryFwdDocPredecessor
CmtmtCarryForwardDocumentRoot CmtmtCarryForwardDocumentRoot
CmtmtCarryFwdAdjmtValueType CmtmtCarryFwdAdjmtValueType
CmtmtCarryFwdDocumentIsRoot CmtmtCarryFwdDocumentIsRoot
CmtmtCarryFwdAmtInFMACrcy CmtmtCarryFwdAmtInFMACrcy
CmtmtCarryFwdAmtInTransCrcy CmtmtCarryFwdAmtInTransCrcy
CmtmtCarryFwdTotAmtInFMACrcy CmtmtCarryFwdTotAmtInFMACrcy
CmtmtCarryFwdTotAmtInTransCrcy CmtmtCarryFwdTotAmtInTransCrcy
TransactionCurrency TransactionCurrency Transaction Currency
FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
FundsMgmtCmtmtItemIsCompleted FundsMgmtCmtmtItemIsCompleted Set "Completed"
FundsManagementStatisticalType FundsManagementStatisticalType
SenderPostedFundsMgmtCustField SenderPostedFundsMgmtCustField
ReceiverPostedFundsMgmtCustFld ReceiverPostedFundsMgmtCustFld
_FinMgmtArea _FinMgmtArea
_FinMgmtFiscalYear _FinMgmtFiscalYear
_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
_CommitmentCarryForwardLot _CommitmentCarryForwardLot
_ReferenceDocumentType _ReferenceDocumentType
_Currency _Currency
_TransactionCurrency _TransactionCurrency

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_CmtmtCarryForwardLotItem.
-- 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: ACMMTLOTIT

CREATE VIEW A_CmtmtCarryForwardLotItem AS
SELECT
  FinancialManagementArea,
  SenderFinMgmtAreaFiscalYear,
  CommitmentCarryForwardLot,
  CommitmentCarryForwardLotItem,
  CmtmtCarryForwardApprovalStep,
  CmtmtCarryFwdLotIsCompleted,
  CreationDate,
  CreationTime,
  CreatedByUser,
  CmtmtCarryFwdApprvlCmtmtDate,
  CmtmtCarryFwdApprvlCmtmtTime,
  CarryFwdApprvlCmtmtCrtedByUser,
  CarryFwdApprvlBdgtForCmtmtDate,
  CarryFwdApprvlBdgtForCmtmtTime,
  ApprvlBdgtForCmtmtCrtedByUser,
  CmtmtCarryFwdLotDescription,
  ZeroCmtmtCarryFwdSts,
  ReferenceDocument,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentContext,
  FundsMgmtReferenceDocumentItem,
  RefDocAccountAssignment,
  FundsMgmtRefDocScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  FundsManagementDocument,
  FundsManagementDocumentItem,
  CompanyCode,
  OriginAccountingDocFiscalYear,
  SenderLedger,
  FundsMgmtValueType,
  FundsMgmtCarryForwardStatus,
  FundsMgCarryForwardCounter,
  ReceiverPostedGrantId,
  ReceiverPostedFund,
  ReceiverPostedFundsCenter,
  ReceiverPostedCommitmentItem,
  ReceiverPostedFunctionalArea,
  ReceiverPostedFundedProgram,
  ReceiverPostedBudgetPeriod,
  SenderPostedGrantId,
  SenderPostedFund,
  SenderPostedFundsCenter,
  SenderPostedCommitmentItem,
  SenderPostedFunctionalArea,
  SenderPostedFundedProgram,
  SenderPostedBudgetPeriod,
  CommitmentCarryForwardDocument,
  CmtmtCarryFwdDocPredecessor,
  CmtmtCarryForwardDocumentRoot,
  CmtmtCarryFwdAdjmtValueType,
  CmtmtCarryFwdDocumentIsRoot,
  CmtmtCarryFwdAmtInFMACrcy,
  CmtmtCarryFwdAmtInTransCrcy,
  CmtmtCarryFwdTotAmtInFMACrcy,
  CmtmtCarryFwdTotAmtInTransCrcy,
  TransactionCurrency,
  FinancialManagementAreaCrcy,
  CommitmentItemFiscalYear,
  FundsMgmtCmtmtItemIsCompleted,
  FundsManagementStatisticalType,
  SenderPostedFundsMgmtCustField,
  ReceiverPostedFundsMgmtCustFld
FROM I_CmtmtCarryForwardLotCube
LEFT OUTER JOIN E_CmtmtCarryForwardLotItem AS _ExtensionItem ON FinancialManagementArea = _ExtensionItem.FinancialManagementArea AND SenderFinMgmtAreaFiscalYear = _ExtensionItem.SenderFinMgmtAreaFiscalYear AND CommitmentCarryForwardLot = _ExtensionItem.CommitmentCarryForwardLot AND CommitmentCarryForwardLotItem = _ExtensionItem.CommitmentCarryForwardLotItem  -- association [1..1]
LEFT OUTER JOIN E_CommitmentCarryForwardLot AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND SenderFinMgmtAreaFiscalYear = _Extension.SenderFinMgmtAreaFiscalYear AND CommitmentCarryForwardLot = _Extension.CommitmentCarryForwardLot  -- association [1..1]
;

Learn More