VALUATIONACDOCA
ACDOCA view for valuation
VALUATIONACDOCA is a CDS View in S/4HANA. ACDOCA view for valuation. It contains 146 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| VAL_Partial_clear_base | view_entity | from | Valuation run: partial clearing items(before reorg) | |
| VALUATIONACDOCAMDCRECL | view_entity | from | ACDOCA view for MDC and Reclassification valuation | |
| 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 (146)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument,PredecessorJournalEntry | 5 |
| KEY | CompanyCode | CompanyCode,PrdcssrJournalEntryCompanyCode | 5 |
| KEY | FiscalYear | FiscalYear,PrdcssrJournalEntryFiscalYear | 4 |
| KEY | Ledger | Ledger | 5 |
| KEY | LedgerFiscalYear | FiscalYear,LedgerFiscalYear | 4 |
| KEY | LedgerGLLineItem | LedgerGLLineItem,PredecessorJournalEntryItem | 5 |
| KEY | SourceLedger | SourceLedger | 5 |
| AccountingDocumentCategory | AccountingDocumentCategory | 4 | |
| AccountingDocumentItem | AccountingDocumentItem | 3 | |
| AccrualItemType | AccrualItemType | 5 | |
| AccrualObject | AccrualObject | 5 | |
| AccrualObjectLogicalSystem | AccrualObjectLogicalSystem | 5 | |
| AccrualObjectType | AccrualObjectType | 5 | |
| AccrualReferenceObject | AccrualReferenceObject | 5 | |
| AccrualSubobject | AccrualSubobject | 5 | |
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | 5 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 5 | |
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | 5 | |
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | 5 | |
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | 5 | |
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | 5 | |
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | 5 | |
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | 5 | |
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | 5 | |
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | 5 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 5 | |
| AssignmentReference | AssignmentReference | 4 | |
| BalanceTransactionCurrency | BalanceTransactionCurrency | 5 | |
| BudgetPeriod | BudgetPeriod | 4 | |
| BusinessArea | BusinessArea | 4 | |
| BusinessPartner | BusinessPartner | 3 | |
| BusinessProcess | BusinessProcess | 4 | |
| BusinessTransactionCategory | BusinessTransactionCategory | 5 | |
| CashLedgerAccount | CashLedgerAccount | 4 | |
| CashLedgerCompanyCode | CashLedgerCompanyCode | 4 | |
| ChartOfAccounts | ChartOfAccounts | 3 | |
| ClearingAccountingDocument | ClearingAccountingDocument | 4 | |
| ClearingDate | ClearingDate | 4 | |
| ClearingDocFiscalYear | ClearingDocFiscalYear | 4 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 5 | |
| ControllingArea | ControllingArea | 4 | |
| CostCenter | CostCenter | 4 | |
| CostCtrActivityType | CostCtrActivityType | 4 | |
| CostObject | CostObject | 4 | |
| CreationDateTime | CreationDateTime | 5 | |
| CreditRiskClass | CreditRiskClass | 2 | |
| Customer | Customer | 4 | |
| CUSTOMER_SUPPLIER_GROUP_KEY | CUSTOMER_SUPPLIER_GROUP_KEY | 3 | |
| DocumentDate | DocumentDate | 2 | |
| FinancialAccountType | FinancialAccountType | 3 | |
| FinancialTransactionType | FinancialTransactionType | 4 | |
| FinancialValuationObject | FinancialValuationObject | 4 | |
| FinancialValuationObjectType | FinancialValuationObjectType | 4 | |
| FinancialValuationSubobject | FinancialValuationSubobject | 4 | |
| FiscalPeriod | FiscalPeriod | 4 | |
| FiscalYearPeriod | FiscalYearPeriod | 5 | |
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | 5 | |
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | 5 | |
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | 5 | |
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | 5 | |
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | 5 | |
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | 5 | |
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | 5 | |
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | 5 | |
| FunctionalArea | FunctionalArea | 4 | |
| Fund | Fund | 4 | |
| FundedProgram | FundedProgram | 4 | |
| FundsCenter | FundsCenter | 4 | |
| GeneralLedgerAgingIncrement | GeneralLedgerAgingIncrement | 1 | |
| GeneralLedgerAgingScope | GeneralLedgerAgingScope | 1 | |
| GLAccount | GLAccount | 3 | |
| GLAccountType | GLAccountType | 3 | |
| GlobalCurrency | GlobalCurrency | 5 | |
| GLRecordType | GLRecordType | 5 | |
| GrantID | GrantID | 4 | |
| HouseBank | HouseBank | 4 | |
| HouseBankAccount | HouseBankAccount | 4 | |
| InvoiceItemReference | InvoiceItemReference | 1 | |
| InvoiceReference | InvoiceReference | 1 | |
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | 1 | |
| IsOpenItemManaged | IsOpenItemManaged | 2 | |
| IsReversal | IsReversal | 5 | |
| IsReversed | IsReversed | 1 | |
| JointVenture | JointVenture | 4 | |
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | 4 | |
| JointVentureEquityGroup | JointVentureEquityGroup | 4 | |
| JointVentureEquityType | JointVentureEquityType | 4 | |
| JointVenturePartner | JointVenturePartner | 4 | |
| MASTERDATAPARTNERCOMPANY | MASTERDATAPARTNERCOMPANY | 5 | |
| MASTERDATARECNCLNACCT | MASTERDATARECNCLNACCT | 4 | |
| Material | Material | 4 | |
| NetDueDate | NetDueDate | 4 | |
| OffsettingAccount | OffsettingAccount | 3 | |
| OrderID | OrderID | 4 | |
| OrganizationalChange | OrganizationalChange | 3 | |
| OriginalCreditRiskClass | CreditRiskClass | 1 | |
| OriginalGlAccount | GLAccount,OriginalGlAccount | 5 | |
| p_is_mdc_on | p_is_mdc_on | 5 | |
| PartnerBudgetPeriod | PartnerBudgetPeriod | 4 | |
| PartnerBusinessArea | PartnerBusinessArea | 4 | |
| PartnerCompany | PartnerCompany | 3 | |
| PartnerCostCenter | PartnerCostCenter | 4 | |
| PartnerEquityGroup | PartnerEquityGroup | 4 | |
| PartnerFunctionalArea | PartnerFunctionalArea | 4 | |
| PartnerFund | PartnerFund | 4 | |
| PartnerGrant | PartnerGrant | 4 | |
| PartnerProfitCenter | PartnerProfitCenter | 4 | |
| PartnerSegment | PartnerSegment | 4 | |
| PartnerVenture | PartnerVenture | 4 | |
| Plant | Plant | 4 | |
| PostingDate | OriginalPostingDate,PostingDate | 5 | |
| PostingKey | PostingKey | 2 | |
| PrdcssrJournalEntryCompanyCode | PrdcssrJournalEntryCompanyCode | 2 | |
| PrdcssrJournalEntryFiscalYear | PrdcssrJournalEntryFiscalYear | 3 | |
| PredecessorJournalEntry | PredecessorJournalEntry | 3 | |
| PredecessorJournalEntryItem | PredecessorJournalEntryItem | 3 | |
| PredecessorReferenceDocCntxt | PredecessorReferenceDocCntxt | 1 | |
| PredecessorReferenceDocItem | PredecessorReferenceDocItem | 1 | |
| PredecessorReferenceDocument | PredecessorReferenceDocument | 1 | |
| Product | Product | 4 | |
| ProfitCenter | ProfitCenter | 5 | |
| ProjectNetwork | ProjectNetwork | 4 | |
| PubSecBudgetAccount | PubSecBudgetAccount | 4 | |
| PubSecBudgetAccountCoCode | PubSecBudgetAccountCoCode | 4 | |
| RealEstateBuilding | RealEstateBuilding | 4 | |
| RealEstateProperty | RealEstateProperty | 4 | |
| REBusinessEntity | REBusinessEntity | 4 | |
| ReferenceDocumentType | ReferenceDocumentType | 5 | |
| RelatedNetworkActivity | RelatedNetworkActivity | 4 | |
| relatednetworkactivityinternal | relatednetworkactivityinternal | 4 | |
| SalesOrder | SalesOrder | 4 | |
| SalesOrderItem | SalesOrderItem | 4 | |
| Segment | Segment | 5 | |
| ServiceDocument | ServiceDocument | 4 | |
| ServiceDocumentItem | ServiceDocumentItem | 4 | |
| ServiceDocumentType | ServiceDocumentType | 4 | |
| ShipToParty | ShipToParty | 4 | |
| SpecialGLCode | SpecialGLCode | 5 | |
| SponsoredClass | SponsoredClass | 4 | |
| SponsoredProgram | SponsoredProgram | 4 | |
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | 5 | |
| Supplier | Supplier | 4 | |
| TaxCode | TaxCode | 4 | |
| TaxCountry | TaxCountry | 4 | |
| WBSElement | WBSElement | 4 | |
| WBSElementInternalID | WBSElementInternalID | 4 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- ACDOCA view for valuation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VALUATIONACDOCA (
ACCOUNTINGDOCUMENT,
COMPANYCODE,
FISCALYEAR,
LEDGER,
LEDGERFISCALYEAR,
LEDGERGLLINEITEM,
SOURCELEDGER,
ACCOUNTINGDOCUMENTCATEGORY,
ACCOUNTINGDOCUMENTITEM,
ACCRUALITEMTYPE,
ACCRUALOBJECT,
ACCRUALOBJECTLOGICALSYSTEM,
ACCRUALOBJECTTYPE,
ACCRUALREFERENCEOBJECT,
ACCRUALSUBOBJECT,
AMOUNTINBALANCETRANSACCRCY,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINFREEDEFINEDCURRENCY1,
AMOUNTINFREEDEFINEDCURRENCY2,
AMOUNTINFREEDEFINEDCURRENCY3,
AMOUNTINFREEDEFINEDCURRENCY4,
AMOUNTINFREEDEFINEDCURRENCY5,
AMOUNTINFREEDEFINEDCURRENCY6,
AMOUNTINFREEDEFINEDCURRENCY7,
AMOUNTINFREEDEFINEDCURRENCY8,
AMOUNTINGLOBALCURRENCY,
ASSIGNMENTREFERENCE,
BALANCETRANSACTIONCURRENCY,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSPARTNER,
BUSINESSPROCESS,
BUSINESSTRANSACTIONCATEGORY,
CASHLEDGERACCOUNT,
CASHLEDGERCOMPANYCODE,
CHARTOFACCOUNTS,
CLEARINGACCOUNTINGDOCUMENT,
CLEARINGDATE,
CLEARINGDOCFISCALYEAR,
COMPANYCODECURRENCY,
CONTROLLINGAREA,
COSTCENTER,
COSTCTRACTIVITYTYPE,
COSTOBJECT,
CREATIONDATETIME,
CREDITRISKCLASS,
CUSTOMER,
CUSTOMER_SUPPLIER_GROUP_KEY,
DOCUMENTDATE,
FINANCIALACCOUNTTYPE,
FINANCIALTRANSACTIONTYPE,
FINANCIALVALUATIONOBJECT,
FINANCIALVALUATIONOBJECTTYPE,
FINANCIALVALUATIONSUBOBJECT,
FISCALPERIOD,
FISCALYEARPERIOD,
FREEDEFINEDCURRENCY1,
FREEDEFINEDCURRENCY2,
FREEDEFINEDCURRENCY3,
FREEDEFINEDCURRENCY4,
FREEDEFINEDCURRENCY5,
FREEDEFINEDCURRENCY6,
FREEDEFINEDCURRENCY7,
FREEDEFINEDCURRENCY8,
FUNCTIONALAREA,
FUND,
FUNDEDPROGRAM,
FUNDSCENTER,
GENERALLEDGERAGINGINCREMENT,
GENERALLEDGERAGINGSCOPE,
GLACCOUNT,
GLACCOUNTTYPE,
GLOBALCURRENCY,
GLRECORDTYPE,
GRANTID,
HOUSEBANK,
HOUSEBANKACCOUNT,
INVOICEITEMREFERENCE,
INVOICEREFERENCE,
INVOICEREFERENCEFISCALYEAR,
ISOPENITEMMANAGED,
ISREVERSAL,
ISREVERSED,
JOINTVENTURE,
JOINTVENTURECOSTRECOVERYCODE,
JOINTVENTUREEQUITYGROUP,
JOINTVENTUREEQUITYTYPE,
JOINTVENTUREPARTNER,
MASTERDATAPARTNERCOMPANY,
MASTERDATARECNCLNACCT,
MATERIAL,
NETDUEDATE,
OFFSETTINGACCOUNT,
ORDERID,
ORGANIZATIONALCHANGE,
ORIGINALCREDITRISKCLASS,
ORIGINALGLACCOUNT,
P_IS_MDC_ON,
PARTNERBUDGETPERIOD,
PARTNERBUSINESSAREA,
PARTNERCOMPANY,
PARTNERCOSTCENTER,
PARTNEREQUITYGROUP,
PARTNERFUNCTIONALAREA,
PARTNERFUND,
PARTNERGRANT,
PARTNERPROFITCENTER,
PARTNERSEGMENT,
PARTNERVENTURE,
PLANT,
POSTINGDATE,
POSTINGKEY,
PRDCSSRJOURNALENTRYCOMPANYCODE,
PRDCSSRJOURNALENTRYFISCALYEAR,
PREDECESSORJOURNALENTRY,
PREDECESSORJOURNALENTRYITEM,
PREDECESSORREFERENCEDOCCNTXT,
PREDECESSORREFERENCEDOCITEM,
PREDECESSORREFERENCEDOCUMENT,
PRODUCT,
PROFITCENTER,
PROJECTNETWORK,
PUBSECBUDGETACCOUNT,
PUBSECBUDGETACCOUNTCOCODE,
REALESTATEBUILDING,
REALESTATEPROPERTY,
REBUSINESSENTITY,
REFERENCEDOCUMENTTYPE,
RELATEDNETWORKACTIVITY,
RELATEDNETWORKACTIVITYINTERNAL,
SALESORDER,
SALESORDERITEM,
SEGMENT,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SHIPTOPARTY,
SPECIALGLCODE,
SPONSOREDCLASS,
SPONSOREDPROGRAM,
SUBLEDGERACCTLINEITEMTYPE,
SUPPLIER,
TAXCODE,
TAXCOUNTRY,
WBSELEMENT,
WBSELEMENTINTERNALID,
PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERFISCALYEAR, LEDGERGLLINEITEM, SOURCELEDGER)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA