OPERATIONALVIEW

115 Fields

OPERATIONALVIEW is an SAP database table in S/4HANA. It contains 115 fields.

Fields (115)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 10
KEY AccountingDocumentItem AccountingDocumentItem 9
KEY CO_DIANReportFormat CO_DIANReportFormat 3
KEY CO_DIANReportItemType CO_DIANReportItemType 3
KEY CompanyCode CompanyCode 10
KEY FiscalYear FiscalYear 8
KEY Ledger Ledger 9
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SourceLedger SourceLedger 2
KEY StatryRptCategory StatryRptCategory 8
KEY StatryRptgEntity StatryRptgEntity 8
KEY StatryRptRunID StatryRptRunID 8
KEY TransactionTypeDetermination TransactionTypeDetermination 9
_AccountingDocumentType _AccountingDocumentType 7
_AlternativeGLAccount _AlternativeGLAccount 5
_BalanceTransactionCurrency _BalanceTransactionCurrency 1
_ChartOfAccounts _ChartOfAccounts 7
_CompanyCode _CompanyCode 9
_CompanyCodeCurrency _CompanyCodeCurrency 1
_Country _Country 7
_CountryChartOfAccounts _CountryChartOfAccounts 7
_Customer _Customer 5
_DebitCreditCode _DebitCreditCode 1
_FinancialAccountType _FinancialAccountType 8
_FiscalYear _FiscalYear 8
_FreeDefinedCurrency1 _FreeDefinedCurrency1 1
_FreeDefinedCurrency2 _FreeDefinedCurrency2 1
_FreeDefinedCurrency3 _FreeDefinedCurrency3 1
_FreeDefinedCurrency4 _FreeDefinedCurrency4 1
_FreeDefinedCurrency5 _FreeDefinedCurrency5 1
_FreeDefinedCurrency6 _FreeDefinedCurrency6 1
_FreeDefinedCurrency7 _FreeDefinedCurrency7 1
_FreeDefinedCurrency8 _FreeDefinedCurrency8 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GlobalCurrency _GlobalCurrency 1
_JournalEntry _JournalEntry 8
_Ledger _Ledger 7
_OffsettingAccountType _OffsettingAccountType 5
_OffsettingAccountWithBP _OffsettingAccountWithBP 5
_PurchasingDocument _PurchasingDocument 7
_PurchasingDocumentItem _PurchasingDocumentItem 7
_ReferenceDocumentType _ReferenceDocumentType 5
_ReportingCurrency _ReportingCurrency 7
_Supplier _Supplier 5
_TransactionCurrency _TransactionCurrency 1
AccountAssignmentNumber AccountAssignmentNumber 7
AccountingDocCreatedByUser AccountingDocCreatedByUser 2
AccountingDocumentType AccountingDocumentType 9
AlternativeGLAccount AlternativeGLAccount 9
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 1
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 1
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 1
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 1
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 1
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 1
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
AmountInReportingCurrency AmountInReportingCurrency 7
AmountInTransactionCurrency AmountInTransactionCurrency 1
BalanceTransactionCurrency BalanceTransactionCurrency 1
BusinessPlace BusinessPlace 10
ChartOfAccounts ChartOfAccounts 9
ClearingDate ClearingDate 2
CO_DIANAmountClassification CO_DIANAmountClassification,CO_DIANAmountClassificationGL 2
CO_DIANAmountClassificationGL CO_DIANAmountClassificationGL 1
CO_DIANAmountClassificationVAT CO_DIANAmountClassificationVAT 1
CompanyCodeCountry CompanyCodeCountry 7
CompanyCodeCurrency CompanyCodeCurrency 1
CostCenter CostCenter 2
CountryChartOfAccounts CountryChartOfAccounts 9
Customer Customer 7
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 2
FinancialAccountType FinancialAccountType 9
FiscalPeriod FiscalPeriod 2
FreeDefinedCurrency1 FreeDefinedCurrency1 1
FreeDefinedCurrency2 FreeDefinedCurrency2 1
FreeDefinedCurrency3 FreeDefinedCurrency3 1
FreeDefinedCurrency4 FreeDefinedCurrency4 1
FreeDefinedCurrency5 FreeDefinedCurrency5 1
FreeDefinedCurrency6 FreeDefinedCurrency6 1
FreeDefinedCurrency7 FreeDefinedCurrency7 1
FreeDefinedCurrency8 FreeDefinedCurrency8 1
GLAccount GLAccount 9
GLAccountType GLAccountType 2
GlobalCurrency GlobalCurrency 1
InventoryValuationType InventoryValuationType 1
IsReversal IsReversal 2
IsReversed IsReversed 2
OffsettingAccount OffsettingAccount 8
OffsettingAccountType OffsettingAccountType 8
OplAcctgDocItmCntrySpcfcRef1 OplAcctgDocItmCntrySpcfcRef1 7
PostingDate PostingDate 9
Product Product 1
ProfitCenter ProfitCenter 2
PurchasingDocument PurchasingDocument 8
PurchasingDocumentItem PurchasingDocumentItem 7
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 7
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 7
ReferenceDocument ReferenceDocument 6
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 4
ReferenceDocumentItem ReferenceDocumentItem 6
ReferenceDocumentType ReferenceDocumentType 6
ReportingCurrency ReportingCurrency 8
SenderLogicalSystem SenderLogicalSystem 4
SpecialGLCode SpecialGLCode 2
Supplier Supplier 7
TaxAmount TaxAmount 1
TaxBaseAmount TaxBaseAmount 4
TaxCode TaxCode 9
TransactionCurrency TransactionCurrency 1
ValuationArea ValuationArea 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OPERATIONALVIEW (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TRANSACTIONTYPEDETERMINATION,
    _ACCOUNTINGDOCUMENTTYPE,
    _ALTERNATIVEGLACCOUNT,
    _BALANCETRANSACTIONCURRENCY,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _COUNTRY,
    _COUNTRYCHARTOFACCOUNTS,
    _CUSTOMER,
    _DEBITCREDITCODE,
    _FINANCIALACCOUNTTYPE,
    _FISCALYEAR,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLOBALCURRENCY,
    _JOURNALENTRY,
    _LEDGER,
    _OFFSETTINGACCOUNTTYPE,
    _OFFSETTINGACCOUNTWITHBP,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _REFERENCEDOCUMENTTYPE,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    _TRANSACTIONCURRENCY,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BUSINESSPLACE,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CO_DIANAMOUNTCLASSIFICATION,
    CO_DIANAMOUNTCLASSIFICATIONGL,
    CO_DIANAMOUNTCLASSIFICATIONVAT,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    INVENTORYVALUATIONTYPE,
    ISREVERSAL,
    ISREVERSED,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OPLACCTGDOCITMCNTRYSPCFCREF1,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCURRENCY,
    SENDERLOGICALSYSTEM,
    SPECIALGLCODE,
    SUPPLIER,
    TAXAMOUNT,
    TAXBASEAMOUNT,
    TAXCODE,
    TRANSACTIONCURRENCY,
    VALUATIONAREA,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TRANSACTIONTYPEDETERMINATION)
);

Learn More