SUPPLIERCUSTOMEROPENITEM

105 Fields

SUPPLIERCUSTOMEROPENITEM is an SAP database table in S/4HANA. It contains 105 fields.

Fields (105)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY BusinessPartner BusinessPartner 1
KEY CO_DIANReportFormat CO_DIANReportFormat 1
KEY CO_DIANReportItemType CO_DIANReportItemType 1
KEY CO_DIANTaxNumberType CO_DIANTaxNumberType 2
KEY CompanyCode CompanyCode 1
KEY FinancialAccountType FinancialAccountType 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY ReportedTaxNumber ReportedTaxNumber 1
KEY SourceLedger SourceLedger 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY TaxNumberType TaxNumberType 1
_BalanceTransactionCurrency _BalanceTransactionCurrency 1
_CO_DIANCountryMapping _CO_DIANCountryMapping 1
_CO_DIANTaxMapping _CO_DIANTaxMapping 1
_CompanyCode _CompanyCode 1
_CompanyCodeCountryMapping _CompanyCodeCountryMapping 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_DebitCreditCode _DebitCreditCode 1
_FinancialAccountType _FinancialAccountType 1
_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
_OneTimeAccountBP _OneTimeAccountBP 1
_ReportingCurrency _ReportingCurrency 1
_TransactionCurrency _TransactionCurrency 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
AdditionalLastName AdditionalLastName 1
AlternativeGLAccount AlternativeGLAccount 1
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 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BalanceTransactionCurrency BalanceTransactionCurrency 1
BusinessPartnerCategory BusinessPartnerCategory 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPlace BusinessPlace 1
ChartOfAccounts ChartOfAccounts 1
CityCode CityCode 1
CityName CityName 1
ClearingDate ClearingDate 1
CO_DIANAmountClassification CO_DIANAmountClassification 1
CO_DIANCountry CO_DIANCountry 1
CompanyCodeAddressID CompanyCodeAddressID 1
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
DebitCreditCode DebitCreditCode 1
FirstName FirstName 1
FiscalPeriod FiscalPeriod 1
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 1
GLAccountName GLAccountName 1
GlobalCurrency GlobalCurrency 1
IsNaturalPerson IsNaturalPerson 1
LastName LastName 1
MiddleName MiddleName 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
OrganizationBPName3 OrganizationBPName3 1
OrganizationBPName4 OrganizationBPName4 1
PostingDate PostingDate 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentItem ReferenceDocumentItem 1
Region Region 1
ReportingCurrency ReportingCurrency 1
SpecialGLCode SpecialGLCode 1
StreetName StreetName 1
Supplier Supplier 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumber5 TaxNumber5 1
TransactionCurrency TransactionCurrency 1
VATRegistration VATRegistration 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 SUPPLIERCUSTOMEROPENITEM (
    ACCOUNTINGDOCUMENT,
    BUSINESSPARTNER,
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    CO_DIANTAXNUMBERTYPE,
    COMPANYCODE,
    FINANCIALACCOUNTTYPE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    REPORTEDTAXNUMBER,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXNUMBERTYPE,
    _BALANCETRANSACTIONCURRENCY,
    _CO_DIANCOUNTRYMAPPING,
    _CO_DIANTAXMAPPING,
    _COMPANYCODE,
    _COMPANYCODECOUNTRYMAPPING,
    _COMPANYCODECURRENCY,
    _DEBITCREDITCODE,
    _FINANCIALACCOUNTTYPE,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLOBALCURRENCY,
    _ONETIMEACCOUNTBP,
    _REPORTINGCURRENCY,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALLASTNAME,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPLACE,
    CHARTOFACCOUNTS,
    CITYCODE,
    CITYNAME,
    CLEARINGDATE,
    CO_DIANAMOUNTCLASSIFICATION,
    CO_DIANCOUNTRY,
    COMPANYCODEADDRESSID,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DEBITCREDITCODE,
    FIRSTNAME,
    FISCALPERIOD,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    GLACCOUNT,
    GLACCOUNTNAME,
    GLOBALCURRENCY,
    ISNATURALPERSON,
    LASTNAME,
    MIDDLENAME,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REGION,
    REPORTINGCURRENCY,
    SPECIALGLCODE,
    STREETNAME,
    SUPPLIER,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BUSINESSPARTNER, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, CO_DIANTAXNUMBERTYPE, COMPANYCODE, FINANCIALACCOUNTTYPE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, REPORTEDTAXNUMBER, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXNUMBERTYPE)
);

Learn More