I_JntVntrRmngCutbackC

DDL: I_JNTVNTRRMNGCUTBACKC SQL: IJVCUTBACKC Type: view COMPOSITE
163 Fields 1 Data Sources

JV Remaining Cutback By Cost Object

I_JntVntrRmngCutbackC is a Composite CDS View (Cube) that provides data about "JV Remaining Cutback By Cost Object" in SAP S/4HANA. It reads from 1 data source (I_JntVntrRmngCutbackAmt) and exposes 163 fields with key fields Ledger, CompanyCode, FiscalYear, FiscalPeriod, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
I_JntVntrRmngCutbackAmt I_JntVntrRmngCutbackAmt from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IJVCUTBACKC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label JV Remaining Cutback By Cost Object view
Analytics.dataCategory #CUBE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view

Fields (163)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
CurrentFiscalYear CurrentFiscalYear Fiscal Year
CurrentFiscalPeriod CurrentFiscalPeriod Fiscal Period
PostingDate PostingDate Posting Date for GR
FiscalYearVariant FiscalYearVariant FY Variant
LedgerFiscalYear LedgerFiscalYear
GLRecordType GLRecordType Record Type
ChartOfAccounts ChartOfAccounts Node Class
GLAccount GLAccount General Ledger
DebitCreditCode DebitCreditCode Single-Character Flag
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
BusinessArea BusinessArea Business Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
OrderID OrderID Order ID
ProjectNetwork ProjectNetwork Order
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
JointVenture JointVenture Joint venture
JointVentureType JointVentureType Venture Type
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVenturePartner JointVenturePartner Joint Venture Partner
JointVentureBillingType JointVentureBillingType
CutbackRun CutbackRun
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
Supplier Supplier Supplier
Segment Segment Segment number
AccountingDocumentType AccountingDocumentType Journal Entry Type
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
SalesDocument SalesDocument SD Document
SalesOrganization SalesOrganization Sales Organization
ServiceDocumentType ServiceDocumentType Transaction Type
ValuationArea ValuationArea Valuation Area
Plant Plant Valuation Area
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
ServiceDocument ServiceDocument Transaction ID
AssetClass AssetClass Asset Class
FunctionalArea FunctionalArea Sendr Fctl Area
TransactionCurrency TransactionCurrency Transaction Currency
GrossAmtInTC GrossAmtInTC Gross Amt in Trans Crcy
CutbackAmtInTC CutbackAmtInTC
RmngCutbackAmtInTC RmngCutbackAmtInTC
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GrossAmtInCCrcy GrossAmtInCCrcy
CutbackAmtInCCrcy CutbackAmtInCCrcy
RmngCutbackAmtInCCrcy RmngCutbackAmtInCCrcy
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
GrossAmtInGCrcy GrossAmtInGCrcy
CutbackAmtInGCrcy CutbackAmtInGCrcy
RmngCutbackAmtInGCrcy RmngCutbackAmtInGCrcy
BalanceTransactionCurrency BalanceTransactionCurrency Currency
GrossAmtInBlTCrcy GrossAmtInBlTCrcy
CutbackAmtInBlTCrcy CutbackAmtInBlTCrcy
RmngCutbackAmtInBlTCrcy RmngCutbackAmtInBlTCrcy
FunctionalCurrency FunctionalCurrency Functional Currency
GrossAmtInFCrcy GrossAmtInFCrcy
CutbackAmtInFCrcy CutbackAmtInFCrcy
RmngCutbackAmtInFCrcy RmngCutbackAmtInFCrcy
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
GrossAmtInFDCrcy1 GrossAmtInFDCrcy1
CutbackAmtInFDCrcy1 CutbackAmtInFDCrcy1
RmngCutbackAmtInFDCrcy1 RmngCutbackAmtInFDCrcy1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
GrossAmtInFDCrcy2 GrossAmtInFDCrcy2
CutbackAmtInFDCrcy2 CutbackAmtInFDCrcy2
RmngCutbackAmtInFDCrcy2 RmngCutbackAmtInFDCrcy2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
GrossAmtInFDCrcy3 GrossAmtInFDCrcy3
CutbackAmtInFDCrcy3 CutbackAmtInFDCrcy3
RmngCutbackAmtInFDCrcy3 RmngCutbackAmtInFDCrcy3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
GrossAmtInFDCrcy4 GrossAmtInFDCrcy4
CutbackAmtInFDCrcy4 CutbackAmtInFDCrcy4
RmngCutbackAmtInFDCrcy4 RmngCutbackAmtInFDCrcy4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
GrossAmtInFDCrcy5 GrossAmtInFDCrcy5
CutbackAmtInFDCrcy5 CutbackAmtInFDCrcy5
RmngCutbackAmtInFDCrcy5 RmngCutbackAmtInFDCrcy5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
GrossAmtInFDCrcy6 GrossAmtInFDCrcy6
CutbackAmtInFDCrcy6 CutbackAmtInFDCrcy6
RmngCutbackAmtInFDCrcy6 RmngCutbackAmtInFDCrcy6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
GrossAmtInFDCrcy7 GrossAmtInFDCrcy7
CutbackAmtInFDCrcy7 CutbackAmtInFDCrcy7
RmngCutbackAmtInFDCrcy7 RmngCutbackAmtInFDCrcy7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
GrossAmtInFDCrcy8 GrossAmtInFDCrcy8
CutbackAmtInFDCrcy8 CutbackAmtInFDCrcy8
RmngCutbackAmtInFDCrcy8 RmngCutbackAmtInFDCrcy8
JVAFundingCurrency1 JVAFundingCurrency1
GrossAmtInFundCrcy GrossAmtInFundCrcy
CutbackAmtInFundCrcy CutbackAmtInFundCrcy
RmngCutbackAmtInFundCrcy RmngCutbackAmtInFundCrcy
_CompanyCode _CompanyCode
_Ledger _Ledger
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_DebitCreditCode _DebitCreditCode
_ControllingArea _ControllingArea
_BusinessArea _BusinessArea
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_Order _Order
_ProjectNetwork _ProjectNetwork
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_BalanceTransactionCurrency _BalanceTransactionCurrency
_FunctionalCurrency _FunctionalCurrency
_FreeDefinedCurrency1 _FreeDefinedCurrency1
_FreeDefinedCurrency2 _FreeDefinedCurrency2
_FreeDefinedCurrency3 _FreeDefinedCurrency3
_FreeDefinedCurrency4 _FreeDefinedCurrency4
_FreeDefinedCurrency5 _FreeDefinedCurrency5
_FreeDefinedCurrency6 _FreeDefinedCurrency6
_FreeDefinedCurrency7 _FreeDefinedCurrency7
_FreeDefinedCurrency8 _FreeDefinedCurrency8
_BaseUnit _BaseUnit
_JointVentureMasterFld _JointVentureMasterFld
_JntVntrRecoveryInd _JntVntrRecoveryInd
_JntVntrEquityGrp _JntVntrEquityGrp
_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster
_FiscalYearVariant _FiscalYearVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalPeriodForVariant _FiscalPeriodForVariant
_MasterFixedAsset _MasterFixedAsset
_JointVenturePayrollType _JointVenturePayrollType
_AssetTransactionType _AssetTransactionType
_WBSElementBasicData _WBSElementBasicData
_WBSElementExternalID _WBSElementExternalID
_JntVntrBusinessPartner _JntVntrBusinessPartner
_Supplier _Supplier
_GLAccountInCompanyCode _GLAccountInCompanyCode
_AccountingDocumentType _AccountingDocumentType
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Customer _Customer
_SalesDocument _SalesDocument
_FixedAsset _FixedAsset
_DistributionChannel _DistributionChannel
_ServiceDocument _ServiceDocument
_Segment _Segment
_FinancialAccountType _FinancialAccountType
_SalesOrganization _SalesOrganization
_Plant _Plant
_ServiceDocumentType _ServiceDocumentType
_PurReqValuationArea _PurReqValuationArea

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 I_JntVntrRmngCutbackC.
-- 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: IJVCUTBACKC

CREATE VIEW I_JntVntrRmngCutbackC AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  AccountingDocument,
  LedgerGLLineItem,
  CurrentFiscalYear,
  CurrentFiscalPeriod,
  PostingDate,
  FiscalYearVariant,
  LedgerFiscalYear,
  GLRecordType,
  ChartOfAccounts,
  GLAccount,
  DebitCreditCode,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  BusinessArea,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  OrderID,
  ProjectNetwork,
  WBSElementInternalID,
  WBSElementExternalID,
  JointVenture,
  JointVentureType,
  JointVentureEquityGroup,
  JointVentureEquityType,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  CutbackRun,
  BaseUnit,
  Quantity,
  Supplier,
  Segment,
  AccountingDocumentType,
  FinancialAccountType,
  Customer,
  SalesDocument,
  SalesOrganization,
  ServiceDocumentType,
  ValuationArea,
  Plant,
  DistributionChannel,
  OrganizationDivision,
  ServiceDocument,
  AssetClass,
  FunctionalArea,
  TransactionCurrency,
  GrossAmtInTC,
  CutbackAmtInTC,
  RmngCutbackAmtInTC,
  CompanyCodeCurrency,
  GrossAmtInCCrcy,
  CutbackAmtInCCrcy,
  RmngCutbackAmtInCCrcy,
  GlobalCurrency,
  GrossAmtInGCrcy,
  CutbackAmtInGCrcy,
  RmngCutbackAmtInGCrcy,
  BalanceTransactionCurrency,
  GrossAmtInBlTCrcy,
  CutbackAmtInBlTCrcy,
  RmngCutbackAmtInBlTCrcy,
  FunctionalCurrency,
  GrossAmtInFCrcy,
  CutbackAmtInFCrcy,
  RmngCutbackAmtInFCrcy,
  FreeDefinedCurrency1,
  GrossAmtInFDCrcy1,
  CutbackAmtInFDCrcy1,
  RmngCutbackAmtInFDCrcy1,
  FreeDefinedCurrency2,
  GrossAmtInFDCrcy2,
  CutbackAmtInFDCrcy2,
  RmngCutbackAmtInFDCrcy2,
  FreeDefinedCurrency3,
  GrossAmtInFDCrcy3,
  CutbackAmtInFDCrcy3,
  RmngCutbackAmtInFDCrcy3,
  FreeDefinedCurrency4,
  GrossAmtInFDCrcy4,
  CutbackAmtInFDCrcy4,
  RmngCutbackAmtInFDCrcy4,
  FreeDefinedCurrency5,
  GrossAmtInFDCrcy5,
  CutbackAmtInFDCrcy5,
  RmngCutbackAmtInFDCrcy5,
  FreeDefinedCurrency6,
  GrossAmtInFDCrcy6,
  CutbackAmtInFDCrcy6,
  RmngCutbackAmtInFDCrcy6,
  FreeDefinedCurrency7,
  GrossAmtInFDCrcy7,
  CutbackAmtInFDCrcy7,
  RmngCutbackAmtInFDCrcy7,
  FreeDefinedCurrency8,
  GrossAmtInFDCrcy8,
  CutbackAmtInFDCrcy8,
  RmngCutbackAmtInFDCrcy8,
  JVAFundingCurrency1,
  GrossAmtInFundCrcy,
  CutbackAmtInFundCrcy,
  RmngCutbackAmtInFundCrcy
FROM I_JntVntrRmngCutbackAmt
;

Learn More