Which CDS Views use VALUATIONACDOCA?

VALUATIONACDOCA is used by 4 CDS view(s), including: VAL_Partial_clear_base, VALUATIONINVOICE, VALUATIONREORGLINEITEM, ValuationValuationItems.

How many fields does VALUATIONACDOCA have?

VALUATIONACDOCA has 143 fields. Key fields: AccountingDocument, CompanyCode, FiscalYear, Ledger, LedgerGLLineItem, SourceLedger.

VALUATIONACDOCA

CDS View

ACDOCA view for valuation

VALUATIONACDOCA is a CDS View in S/4HANA. ACDOCA view for valuation. It contains 143 fields. 4 CDS views read from this table.

CDS Views using this table (4)

View	Type	Join	Description
VAL_Partial_clear_base	view_entity	from	Valuation run: partial clearing items(before reorg)
VALUATIONINVOICE	view_entity	from	Valuation run: original invoices(before reorg)
VALUATIONREORGLINEITEM	view_entity	inner	Valuation run: reorged invoices
ValuationValuationItems	view_entity	from	Impairment postings

Fields (143)

Key	Field	CDS Fields	Used in Views
KEY	AccountingDocument	AccountingDocument,PredecessorJournalEntry	4
KEY	CompanyCode	CompanyCode,PrdcssrJournalEntryCompanyCode	4
KEY	FiscalYear	FiscalYear,PrdcssrJournalEntryFiscalYear	4
KEY	Ledger	Ledger	4
KEY	LedgerGLLineItem	LedgerGLLineItem,PredecessorJournalEntryItem	4
KEY	SourceLedger	SourceLedger	4
	AccountingDocumentCategory	AccountingDocumentCategory	3
	AccountingDocumentItem	AccountingDocumentItem	2
	AccrualItemType	AccrualItemType	4
	AccrualObject	AccrualObject	4
	AccrualObjectLogicalSystem	AccrualObjectLogicalSystem	4
	AccrualObjectType	AccrualObjectType	4
	AccrualReferenceObject	AccrualReferenceObject	4
	AccrualSubobject	AccrualSubobject	4
	AmountInBalanceTransacCrcy	AmountInBalanceTransacCrcy	4
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	4
	AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	4
	AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	4
	AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	4
	AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	4
	AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	4
	AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	4
	AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	4
	AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	4
	AmountInGlobalCurrency	AmountInGlobalCurrency	4
	AssignmentReference	AssignmentReference	3
	BalanceTransactionCurrency	BalanceTransactionCurrency	4
	BudgetPeriod	BudgetPeriod	3
	BusinessArea	BusinessArea	3
	BusinessPartner	BusinessPartner	2
	BusinessProcess	BusinessProcess	3
	BusinessTransactionCategory	BusinessTransactionCategory	4
	CashLedgerAccount	CashLedgerAccount	3
	CashLedgerCompanyCode	CashLedgerCompanyCode	3
	ChartOfAccounts	ChartOfAccounts	2
	ClearingAccountingDocument	ClearingAccountingDocument	3
	ClearingDate	ClearingDate	3
	ClearingDocFiscalYear	ClearingDocFiscalYear	3
	CompanyCodeCurrency	CompanyCodeCurrency	4
	ControllingArea	ControllingArea	3
	CostCenter	CostCenter	3
	CostCtrActivityType	CostCtrActivityType	3
	CostObject	CostObject	3
	CreationDateTime	CreationDateTime	4
	CreditRiskClass	CreditRiskClass	2
	Customer	Customer	3
	CUSTOMER_SUPPLIER_GROUP_KEY	CUSTOMER_SUPPLIER_GROUP_KEY	2
	DocumentDate	DocumentDate	2
	FinancialAccountType	FinancialAccountType	2
	FinancialTransactionType	FinancialTransactionType	3
	FinancialValuationObject	FinancialValuationObject	3
	FinancialValuationObjectType	FinancialValuationObjectType	3
	FinancialValuationSubobject	FinancialValuationSubobject	3
	FiscalPeriod	FiscalPeriod	3
	FiscalYearPeriod	FiscalYearPeriod	4
	FreeDefinedCurrency1	FreeDefinedCurrency1	4
	FreeDefinedCurrency2	FreeDefinedCurrency2	4
	FreeDefinedCurrency3	FreeDefinedCurrency3	4
	FreeDefinedCurrency4	FreeDefinedCurrency4	4
	FreeDefinedCurrency5	FreeDefinedCurrency5	4
	FreeDefinedCurrency6	FreeDefinedCurrency6	4
	FreeDefinedCurrency7	FreeDefinedCurrency7	4
	FreeDefinedCurrency8	FreeDefinedCurrency8	4
	FunctionalArea	FunctionalArea	3
	Fund	Fund	3
	FundedProgram	FundedProgram	3
	FundsCenter	FundsCenter	3
	GLAccount	GLAccount	3
	GLAccountType	GLAccountType	2
	GlobalCurrency	GlobalCurrency	4
	GLRecordType	GLRecordType	4
	GrantID	GrantID	3
	HouseBank	HouseBank	3
	HouseBankAccount	HouseBankAccount	3
	InvoiceItemReference	InvoiceItemReference	1
	InvoiceReference	InvoiceReference	1
	InvoiceReferenceFiscalYear	InvoiceReferenceFiscalYear	1
	IsOpenItemManaged	IsOpenItemManaged	1
	IsReversal	IsReversal	4
	JointVenture	JointVenture	3
	JointVentureCostRecoveryCode	JointVentureCostRecoveryCode	3
	JointVentureEquityGroup	JointVentureEquityGroup	3
	JointVentureEquityType	JointVentureEquityType	3
	JointVenturePartner	JointVenturePartner	3
	LedgerFiscalYear	LedgerFiscalYear	3
	MASTERDATAPARTNERCOMPANY	MASTERDATAPARTNERCOMPANY	4
	MASTERDATARECNCLNACCT	MASTERDATARECNCLNACCT	4
	Material	Material	3
	NetDueDate	NetDueDate	3
	OffsettingAccount	OffsettingAccount	2
	OrderID	OrderID	3
	OrganizationalChange	OrganizationalChange	3
	OriginalCreditRiskClass	CreditRiskClass	1
	OriginalGlAccount	OriginalGlAccount	4
	p_is_mdc_on	p_is_mdc_on	4
	PartnerBudgetPeriod	PartnerBudgetPeriod	3
	PartnerBusinessArea	PartnerBusinessArea	3
	PartnerCompany	PartnerCompany	2
	PartnerCostCenter	PartnerCostCenter	3
	PartnerEquityGroup	PartnerEquityGroup	3
	PartnerFunctionalArea	PartnerFunctionalArea	3
	PartnerFund	PartnerFund	3
	PartnerGrant	PartnerGrant	3
	PartnerProfitCenter	PartnerProfitCenter	3
	PartnerSegment	PartnerSegment	3
	PartnerVenture	PartnerVenture	3
	Plant	Plant	3
	PostingDate	OriginalPostingDate,PostingDate	4
	PostingKey	PostingKey	2
	PrdcssrJournalEntryCompanyCode	PrdcssrJournalEntryCompanyCode	1
	PrdcssrJournalEntryFiscalYear	PrdcssrJournalEntryFiscalYear	2
	PredecessorJournalEntry	PredecessorJournalEntry	2
	PredecessorJournalEntryItem	PredecessorJournalEntryItem	2
	PredecessorReferenceDocCntxt	PredecessorReferenceDocCntxt	1
	PredecessorReferenceDocItem	PredecessorReferenceDocItem	1
	PredecessorReferenceDocument	PredecessorReferenceDocument	1
	Product	Product	3
	ProfitCenter	ProfitCenter	4
	ProjectNetwork	ProjectNetwork	3
	PubSecBudgetAccount	PubSecBudgetAccount	3
	PubSecBudgetAccountCoCode	PubSecBudgetAccountCoCode	3
	RealEstateBuilding	RealEstateBuilding	3
	RealEstateProperty	RealEstateProperty	3
	REBusinessEntity	REBusinessEntity	3
	ReferenceDocumentType	ReferenceDocumentType	4
	RelatedNetworkActivity	RelatedNetworkActivity	3
	relatednetworkactivityinternal	relatednetworkactivityinternal	3
	SalesOrder	SalesOrder	3
	SalesOrderItem	SalesOrderItem	3
	Segment	Segment	4
	ServiceDocument	ServiceDocument	3
	ServiceDocumentItem	ServiceDocumentItem	3
	ServiceDocumentType	ServiceDocumentType	3
	ShipToParty	ShipToParty	3
	SpecialGLCode	SpecialGLCode	4
	SponsoredClass	SponsoredClass	3
	SponsoredProgram	SponsoredProgram	3
	SubLedgerAcctLineItemType	SubLedgerAcctLineItemType	4
	Supplier	Supplier	3
	TaxCode	TaxCode	3
	TaxCountry	TaxCountry	3
	WBSElement	WBSElement	3
	WBSElementInternalID	WBSElementInternalID	3

@AbapCatalog.viewEnhancementCategory: [ #NONE ]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'ACDOCA view for valuation'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: { serviceQuality: #X, sizeCategory: #S, dataClass: #MIXED }

define view entity VALUATIONACDOCA

as select from VALUATIONACDOCAMDCON as acdoca

{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key LedgerGLLineItem,
  key Ledger,
  key SourceLedger,

      p_is_mdc_on,
      AccountingDocumentItem,
      ClearingAccountingDocument,
      ClearingDocFiscalYear,
      ClearingDate,
      NetDueDate,
      ChartOfAccounts,
      FiscalYearPeriod,
      FinancialAccountType,
      SalesOrder,
      SalesOrderItem,
      InvoiceReference,
      InvoiceItemReference,
      InvoiceReferenceFiscalYear,
      FollowOnDocumentType,
      IsReversed,
      IsReversal,
      OrganizationalChange,
      GLAccount,
      OriginalGlAccount,
      CreationDateTime,
      SubLedgerAcctLineItemType,
      DocumentDate,
      PostingDate,
      AccountingDocumentCategory,
      LedgerFiscalYear,
      ReferenceDocumentType,
      IsOpenItemManaged,
      DebitCreditCode,
      PostingKey,
      BusinessTransactionCategory,
      GLAccountType,
      AssignmentReference,
      FiscalPeriod,
      OffsettingAccount,
      WBSElement,
      BalanceTransactionCurrency,
      CompanyCodeCurrency,
      GlobalCurrency,
      FreeDefinedCurrency1,
      FreeDefinedCurrency2,
      FreeDefinedCurrency3,
      FreeDefinedCurrency4,
      FreeDefinedCurrency5,
      FreeDefinedCurrency6,
      FreeDefinedCurrency7,
      FreeDefinedCurrency8,
     @Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
      acdoca.AmountInBalanceTransacCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      acdoca.AmountInCompanyCodeCurrency,

      @Semantics.amount.currencyCode: 'GlobalCurrency'
      acdoca.AmountInGlobalCurrency,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
      acdoca.AmountInFreeDefinedCurrency1,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
      acdoca.AmountInFreeDefinedCurrency2,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
      acdoca.AmountInFreeDefinedCurrency3,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
      acdoca.AmountInFreeDefinedCurrency4,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
      acdoca.AmountInFreeDefinedCurrency5,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
      acdoca.AmountInFreeDefinedCurrency6,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
      acdoca.AmountInFreeDefinedCurrency7,

      @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
      acdoca.AmountInFreeDefinedCurrency8,

      TaxCode,
      TaxCountry,
      HouseBank,
      HouseBankAccount,
      CostCtrActivityType,
      WBSElementInternalID,
      FinancialTransactionType,
      JointVenture,
      JointVentureEquityGroup,
      PartnerVenture,
      JointVenturePartner,
      JointVentureCostRecoveryCode,
      JointVentureEquityType,
      ProjectNetwork,
      RelatedNetworkActivity,
      OrderID,
      BusinessProcess,
      CostObject,
      CostCenter,
      ProfitCenter,
      FunctionalArea,
      BusinessArea,
      ControllingArea,
      Segment,
      PartnerCostCenter,
      PartnerProfitCenter,
      PartnerFunctionalArea,
      PartnerBusinessArea,
      PartnerCompany,
      PartnerSegment,
      Supplier,
      Customer,
      FinancialValuationObjectType,
      FinancialValuationObject,
      FinancialValuationSubobject,
      REBusinessEntity,
      RealEstateBuilding,
      RealEstateProperty,
      Fund,
      BudgetPeriod,
      GrantID,
      PubSecBudgetAccount,
      CashLedgerAccount,
      SponsoredProgram,
      SponsoredClass,
      Plant,
      Product,
      ShipToParty,
      PartnerFund,
      PartnerGrant,
      CashLedgerCompanyCode,
      FundsCenter,
      PartnerEquityGroup,
      FundedProgram,
      PartnerBudgetPeriod,
      AccrualObjectType,
      AccrualObject,
      AccrualSubobject,
      AccrualItemType,
      AccrualReferenceObject,
      AccrualObjectLogicalSystem,
      PubSecBudgetAccountCoCode,
      ServiceDocument,
      ServiceDocumentItem,
      ServiceDocumentType,
      Material,
      PredecessorJournalEntry,
      PrdcssrJournalEntryFiscalYear,
      PredecessorJournalEntryItem,
      PredecessorReferenceDocCntxt,
      PredecessorReferenceDocument,
      PredecessorReferenceDocItem,
      PrdcssrJournalEntryCompanyCode,
      GLRecordType,
      CUSTOMER_SUPPLIER_GROUP_KEY,
      relatednetworkactivityinternal,
      BusinessPartner,
      CreditRiskClass,
      OriginalCreditRiskClass,
      SpecialGLCode,
      MASTERDATARECNCLNACCT,
      MASTERDATAPARTNERCOMPANY,

      /* Associations */
      _Customer,
      _CustomerCompany,
      _PostingKey,
      _Supplier,
      _SupplierCompany
}

union all
  select from VALUATIONACDOCAMDCOFF

{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key LedgerGLLineItem,
  key Ledger,
  key SourceLedger,

      p_is_mdc_on,
      AccountingDocumentItem,
      ClearingAccountingDocument,
      ClearingDocFiscalYear,
      ClearingDate,
      NetDueDate,
      ChartOfAccounts,
      FiscalYearPeriod,
      FinancialAccountType,
      SalesOrder,
      SalesOrderItem,
      InvoiceReference,
      InvoiceItemReference,
      InvoiceReferenceFiscalYear,
      FollowOnDocumentType,
      IsReversed,
      IsReversal,
      OrganizationalChange,
      GLAccount,
      OriginalGlAccount,
      CreationDateTime,
      SubLedgerAcctLineItemType,
      DocumentDate,
      PostingDate,
      AccountingDocumentCategory,
      LedgerFiscalYear,
      ReferenceDocumentType,
      IsOpenItemManaged,
      DebitCreditCode,
      PostingKey,
      BusinessTransactionCategory,
      GLAccountType,
      AssignmentReference,
      FiscalPeriod,
      OffsettingAccount,
      WBSElement,
      BalanceTransactionCurrency,
      CompanyCodeCurrency,
      GlobalCurrency,
      FreeDefinedCurrency1,
      FreeDefinedCurrency2,
      FreeDefinedCurrency3,
      FreeDefinedCurrency4,
      FreeDefinedCurrency5,
      FreeDefinedCurrency6,
      FreeDefinedCurrency7,
      FreeDefinedCurrency8,
      AmountInBalanceTransacCrcy,
      AmountInCompanyCodeCurrency,
      AmountInGlobalCurrency,
      AmountInFreeDefinedCurrency1,
      AmountInFreeDefinedCurrency2,
      AmountInFreeDefinedCurrency3,
      AmountInFreeDefinedCurrency4,
      AmountInFreeDefinedCurrency5,
      AmountInFreeDefinedCurrency6,
      AmountInFreeDefinedCurrency7,
      AmountInFreeDefinedCurrency8,
      TaxCode,
      TaxCountry,
      HouseBank,
      HouseBankAccount,
      CostCtrActivityType,
      WBSElementInternalID,
      FinancialTransactionType,
      JointVenture,
      JointVentureEquityGroup,
      PartnerVenture,
      JointVenturePartner,
      JointVentureCostRecoveryCode,
      JointVentureEquityType,
      ProjectNetwork,
      RelatedNetworkActivity,
      OrderID,
      BusinessProcess,
      CostObject,
      CostCenter,
      ProfitCenter,
      FunctionalArea,
      BusinessArea,
      ControllingArea,
      Segment,
      PartnerCostCenter,
      PartnerProfitCenter,
      PartnerFunctionalArea,
      PartnerBusinessArea,
      PartnerCompany,
      PartnerSegment,
      Supplier,
      Customer,
      FinancialValuationObjectType,
      FinancialValuationObject,
      FinancialValuationSubobject,
      REBusinessEntity,
      RealEstateBuilding,
      RealEstateProperty,
      Fund,
      BudgetPeriod,
      GrantID,
      PubSecBudgetAccount,
      CashLedgerAccount,
      SponsoredProgram,
      SponsoredClass,
      Plant,
      Product,
      ShipToParty,
      PartnerFund,
      PartnerGrant,
      CashLedgerCompanyCode,
      FundsCenter,
      PartnerEquityGroup,
      FundedProgram,
      PartnerBudgetPeriod,
      AccrualObjectType,
      AccrualObject,
      AccrualSubobject,
      AccrualItemType,
      AccrualReferenceObject,
      AccrualObjectLogicalSystem,
      PubSecBudgetAccountCoCode,
      ServiceDocument,
      ServiceDocumentItem,
      ServiceDocumentType,
      Material,
      PredecessorJournalEntry,
      PrdcssrJournalEntryFiscalYear,
      PredecessorJournalEntryItem,
      PredecessorReferenceDocCntxt,
      PredecessorReferenceDocument,
      PredecessorReferenceDocItem,
      PrdcssrJournalEntryCompanyCode,
      GLRecordType,
      CUSTOMER_SUPPLIER_GROUP_KEY,
      relatednetworkactivityinternal,
      BusinessPartner,
      CreditRiskClass,
      OriginalCreditRiskClass,
      SpecialGLCode,
      MASTERDATARECNCLNACCT,
      MASTERDATAPARTNERCOMPANY,

      /* Associations */
      _Customer,
      _CustomerCompany,
      _PostingKey,
      _Supplier,
      _SupplierCompany
}

Depth:

VALUATIONACDOCA

CDS Views using this table (4)

Fields (143)

Learn More