OPERATIONALVIEW

109 Fields

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

Fields (109)

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

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,
    _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,
    ISREVERSAL,
    ISREVERSED,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OPLACCTGDOCITMCNTRYSPCFCREF1,
    POSTINGDATE,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCURRENCY,
    SPECIALGLCODE,
    SUPPLIER,
    TAXAMOUNT,
    TAXBASEAMOUNT,
    TAXCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TRANSACTIONTYPEDETERMINATION)
);

Learn More