OPENRECEIVABLES

87 Fields

OPENRECEIVABLES is an SAP database table in S/4HANA. It contains 87 fields.

Fields (87)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AccountingDocumentItem AccountingDocumentItem 3
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 3
KEY LedgerGLLineItem LedgerGLLineItem 2
_AccountingClerk _AccountingClerk 1
_BusinessArea _BusinessArea 1
_ChartOfAccounts _ChartOfAccounts 2
_CompanyCode _CompanyCode 2
_CompanyCodeCountry _CompanyCodeCountry 1
_ControllingArea _ControllingArea 2
_Country _Country 1
_CurrentProfitCenter _CurrentProfitCenter 2
_Customer _Customer 2
_CustomerAccountGroup _CustomerAccountGroup 1
_CustomerClassification _CustomerClassification 2
_CustomerCompany _CustomerCompany 1
_CustomerCountry _CustomerCountry 1
_CustomerRegion _CustomerRegion 1
_FinancialAccountType _FinancialAccountType 2
_FiscalYear _FiscalYear 1
_FunctionalArea _FunctionalArea 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 2
_JournalEntry _JournalEntry 2
_PaymentMethod _PaymentMethod 1
_ProfitCenter _ProfitCenter 2
_ProjectBasicData _ProjectBasicData 1
_ProjectExternalID _ProjectExternalID 1
_ReconciliationAccount _ReconciliationAccount 1
_Segment _Segment 1
_SpecialGLCode _SpecialGLCode 2
_WBSElementBasicData _WBSElementBasicData 1
_WBSElementExternalID _WBSElementExternalID 1
AccountingClerk AccountingClerk 1
AccountingDocumentCategory AccountingDocumentCategory 2
AccountingDocumentType AccountingDocumentType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 3
AmountInTransactionCurrency AmountInTransactionCurrency 2
AssignmentReference AssignmentReference 2
BillingDocument BillingDocument 2
BusinessArea BusinessArea 2
CashDiscount1Days CashDiscount1Days 1
CashDiscount2Days CashDiscount2Days 1
ChartOfAccounts ChartOfAccounts 2
ClearingDate ClearingDate 3
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 3
ControllingArea ControllingArea 2
Country Country 1
CreditControlArea CreditControlArea 1
Customer Customer 3
CustomerAccountGroup CustomerAccountGroup 2
CustomerAccountNote CustomerAccountNote 1
CustomerBasicAuthorizationGrp CustomerBasicAuthorizationGrp 2
CustomerClassification CustomerClassification 2
CustomerCorporateGroup CustomerCorporateGroup 2
CustomerCountry CustomerCountry 2
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp 1
CustomerRegion CustomerRegion 2
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 3
DueCalculationBaseDate DueCalculationBaseDate 1
FinancialAccountType FinancialAccountType 3
FollowOnDocumentType FollowOnDocumentType 3
FunctionalArea FunctionalArea 1
GLAccount GLAccount 3
InvoiceItemReference InvoiceItemReference 3
InvoiceReference InvoiceReference 3
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 3
NetDueDate NetDueDate 2
NetPaymentDays NetPaymentDays 1
NumberOfOpenItems NumberOfOpenItems 1
PaymentMethod PaymentMethod 2
PostingDate PostingDate 3
ProfitCenter ProfitCenter 2
ProjectExternalID ProjectExternalID 1
ProjectInternalID ProjectInternalID 1
ReconciliationAccount ReconciliationAccount 1
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 2
Reference2IDByBusinessPartner Reference2IDByBusinessPartner 2
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 2
Segment Segment 2
SpecialGLCode SpecialGLCode 3
SpecialGLTransactionType SpecialGLTransactionType 3
TransactionCurrency TransactionCurrency 2
WBSElementExternalID WBSElementExternalID 1
WBSElementInternalID WBSElementInternalID 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 OPENRECEIVABLES (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    _ACCOUNTINGCLERK,
    _BUSINESSAREA,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECOUNTRY,
    _CONTROLLINGAREA,
    _COUNTRY,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERACCOUNTGROUP,
    _CUSTOMERCLASSIFICATION,
    _CUSTOMERCOMPANY,
    _CUSTOMERCOUNTRY,
    _CUSTOMERREGION,
    _FINANCIALACCOUNTTYPE,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _JOURNALENTRY,
    _PAYMENTMETHOD,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _PROJECTEXTERNALID,
    _RECONCILIATIONACCOUNT,
    _SEGMENT,
    _SPECIALGLCODE,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    ACCOUNTINGCLERK,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BILLINGDOCUMENT,
    BUSINESSAREA,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT2DAYS,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COUNTRY,
    CREDITCONTROLAREA,
    CUSTOMER,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERACCOUNTNOTE,
    CUSTOMERBASICAUTHORIZATIONGRP,
    CUSTOMERCLASSIFICATION,
    CUSTOMERCORPORATEGROUP,
    CUSTOMERCOUNTRY,
    CUSTOMERFINSAUTHORIZATIONGRP,
    CUSTOMERREGION,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DUECALCULATIONBASEDATE,
    FINANCIALACCOUNTTYPE,
    FOLLOWONDOCUMENTTYPE,
    FUNCTIONALAREA,
    GLACCOUNT,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    NETDUEDATE,
    NETPAYMENTDAYS,
    NUMBEROFOPENITEMS,
    PAYMENTMETHOD,
    POSTINGDATE,
    PROFITCENTER,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    RECONCILIATIONACCOUNT,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE2IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    SEGMENT,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    TRANSACTIONCURRENCY,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM)
);

Learn More