DOC

164 Fields

DOC is an SAP database table in S/4HANA. It contains 164 fields.

Fields (164)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,ClearingAccountingDocument 6
KEY AccountingDocumentItem AccountingDocumentItem 2
KEY BillingDocument BillingDocument 2
KEY BillingDocumentList BillingDocumentList 2
KEY BusinessPartner BusinessPartner 2
KEY CABPItemNumber CABPItemNumber 1
KEY CADocumentNumber CADocumentNumber 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
KEY CommodityOrderRequest CommodityOrderRequest 1
KEY CommodityOrderRequestUUID CommodityOrderRequestUUID 1
KEY CompanyCode CompanyCode 10
KEY CompanyCodeCurrency CompanyCodeCurrency 4
KEY docref docref 1
KEY FiscalYear ClearingFiscalYear,FiscalYear 8
KEY GLAccount GLAccount 1
KEY PT_SAFTDocumentNumber PT_SAFTDocumentNumber 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY Supplier Supplier 2
KEY TradingContractItem TradingContractItem 1
KEY TradingContractNumber TradingContractNumber 1
KEY TransactionCurrency TransactionCurrency 5
KEY WithholdingTaxIncomeType WithholdingTaxIncomeType 2
KEY WithholdingTaxPercent WithholdingTaxPercent 2
KEY WithholdingTaxType WithholdingTaxType 2
_AccountingDocumentCategory _AccountingDocumentCategory 1
_AccountingDocumentType _AccountingDocumentType 1
_Branch _Branch 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 4
_CompanyCodeCurrency _CompanyCodeCurrency 1
_Customer _Customer 1
_CustomerPaymentTerms _CustomerPaymentTerms 2
_FiscalYear _FiscalYear 2
_JournalEntry _JournalEntry 1
_Onetime _Onetime 1
_ReportingCurrency _ReportingCurrency 1
_Supplier _Supplier 1
AbsoluteExchangeRate ExchangeRate 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 2
AccountingDocumentType AccountingDocumentType 2
AdditionalCurrency1 AdditionalCurrency1 1
AdditionalCurrency2 AdditionalCurrency2 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency 1
BillingDocumentDate BillingDocumentDate 1
BPTaxNumber BPTaxNumber 1
BusinessPartnerCountry BusinessPartnerCountry 2
BusinessPartnerName BusinessPartnerName 1
BusinessPartnerNumber BusinessPartnerNumber 1
BusinessPlace BusinessPlace 2
CAReferenceDocument CAReferenceDocument 1
CarryFwdBalAmtInCCCrcy CarryFwdBalAmtInCCCrcy 1
CarryFwdBalanceAmtInTransCrcy CarryFwdBalanceAmtInTransCrcy 1
ChartOfAccounts ChartOfAccounts 2
CityName CityName 1
ClearingJournalEntry ClearingJournalEntry 1
CmmdtyOrdReqDocExternalID CmmdtyOrdReqDocExternalID 1
Country Country 1
CrdtCarryFwdBalAmtInTransCrcy CrdtCarryFwdBalAmtInTransCrcy 1
CrdtPrevPerdYTDAmtInTransCrcy CrdtPrevPerdYTDAmtInTransCrcy 1
CrdtStartingBalAmtInTransCrcy CrdtStartingBalAmtInTransCrcy 1
CreatedByUser CreatedByUser 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 1
CreditCarryFwdBalAmtInCCCrcy CreditCarryFwdBalAmtInCCCrcy 1
CreditEndingBalAmtInCCCrcy CreditEndingBalAmtInCCCrcy 1
CreditEndingBalAmtInTransCrcy CreditEndingBalAmtInTransCrcy 1
Creditor Creditor 1
CreditPrevPeriodYTDAmtInCCCrcy CreditPrevPeriodYTDAmtInCCCrcy 1
CreditStartingBalAmtInCCCrcy CreditStartingBalAmtInCCCrcy 1
CustomerPaymentTerms CustomerPaymentTerms 2
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 1
DebitCarryFwdBalAmtInCCCrcy DebitCarryFwdBalAmtInCCCrcy 1
DebitCarryFwdBalAmtInTransCrcy DebitCarryFwdBalAmtInTransCrcy 1
DebitCreditCode DebitCreditCode 1
DebitEndingBalAmtInCCCrcy DebitEndingBalAmtInCCCrcy 1
DebitEndingBalAmtInTransCrcy DebitEndingBalAmtInTransCrcy 1
DebitPrevPerdYTDAmtInTransCrcy DebitPrevPerdYTDAmtInTransCrcy 1
DebitPrevPeriodYTDAmtInCCCrcy DebitPrevPeriodYTDAmtInCCCrcy 1
DebitStartingBalAmtInCCCrcy DebitStartingBalAmtInCCCrcy 1
DebitStartingBalAmtInTransCrcy DebitStartingBalAmtInTransCrcy 1
Debtor Debtor 1
dmbtr_shl amountincompanycodecurrency 1
document_key ConcurDocumentKey 1
DocumentBillingStatus DocumentBillingStatus 2
DocumentDate DocumentDate 3
DocumentItemText DocumentItemText 1
DocumentReferenceID DocumentReferenceID 1
EmailAddress EmailAddress 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 1
EndingBalanceAmtInTransCrcy EndingBalanceAmtInTransCrcy 1
ExchangeRate ExchangeRate 1
ExchangeRateDate ExchangeRateDate 2
FinancialAccountType FinancialAccountType 1
FiscalPeriod FiscalPeriod 4
GLAccountLongName GLAccountLongName 1
h_hwaer h_hwaer 1
InputFiscalYear InputFiscalYear 1
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency 1
InvoiceReference InvoiceReference 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
IsReversal IsReversal 1
IsReversed IsReversed 1
ItemIsReportingRelevant ItemIsReportingRelevant 1
jahrper jahrper 1
kalnr sourcekalnr 1
Name Name 1
OfficialWhldgTaxCode OfficialWhldgTaxCode 1
OrganizationBPName1 OrganizationBPName1 1
OriginalReferenceDocument OriginalReferenceDocument 1
pkalnr targetkalnr 1
POBox POBox 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PostingDate PostingDate 4
PostingKey PostingKey 1
PrevPerdYTDAmountInTransCrcy PrevPerdYTDAmountInTransCrcy 1
PrevPeriodYTDAmtInCCCrcy PrevPeriodYTDAmtInCCCrcy 1
ReferenceDocumentType ReferenceDocumentType 1
Region Region 1
ReportingCurrency ReportingCurrency 2
ReportingDate ReportingDate 1
ReverseDocument ReverseDocument 1
RU_BudgetClassificationCode RU_BudgetClassificationCode 1
RU_SupplierKPP RU_SupplierKPP 1
RU_TerritoryClassfctnOKTMO RU_TerritoryClassfctnOKTMO 1
RU_UnifiedTaxNoticePaymentVers RU_UnifiedTaxNoticePaymentVers 1
RU_UnifiedTaxNoticePeriodCode RU_UnifiedTaxNoticePeriodCode 1
runref runref 1
SalesDocumentDate BillingDocumentDate 1
SDDocumentCategory SDDocumentCategory 2
SearchTerm1 SearchTerm1 1
SpecialGLCode SpecialGLCode 1
SpecialGLTransactionType SpecialGLTransactionType 1
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy 1
StartingBalanceAmtInTransCrcy StartingBalanceAmtInTransCrcy 1
StreetName StreetName 1
SupplierName SupplierName 1
SupplierRecipientType SupplierRecipientType 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumber5 TaxNumber5 1
TaxSection TaxSection 1
TotalGrossAmount TotalGrossAmount 1
TotalNetAmount TotalNetAmount 1
TotalTaxAmount TotalTaxAmount 1
TransactionCode TransactionCode 1
VATRegistration VATRegistration 1
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy 1
WhldgTaxAmtInTransacCrcy WhldgTaxAmtInTransacCrcy 1
WhldgTaxBaseAmtInTransacCrcy WhldgTaxBaseAmtInTransacCrcy 1
WhldgTaxDocumentType WhldgTaxDocumentType 1
WithholdingTaxCode WithholdingTaxCode 1
YrToDteAmtInTransacCrcy YrToDteAmtInTransacCrcy 1
YTDAmtInLoclCrcy YTDAmtInLoclCrcy 1
YTDCrdtAmtInCoCodeCrcy YTDCrdtAmtInCoCodeCrcy 1
YTDCrdtAmtInTransCrcy YTDCrdtAmtInTransCrcy 1
YTDDebitAmtInCoCodeCrcy YTDDebitAmtInCoCodeCrcy 1
YTDDebitAmtInTransCrcy YTDDebitAmtInTransCrcy 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 DOC (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    BILLINGDOCUMENT,
    BILLINGDOCUMENTLIST,
    BUSINESSPARTNER,
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    COMMODITYORDERREQUEST,
    COMMODITYORDERREQUESTUUID,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    DOCREF,
    FISCALYEAR,
    GLACCOUNT,
    PT_SAFTDOCUMENTNUMBER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    TRANSACTIONCURRENCY,
    WITHHOLDINGTAXINCOMETYPE,
    WITHHOLDINGTAXPERCENT,
    WITHHOLDINGTAXTYPE,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _BRANCH,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CUSTOMER,
    _CUSTOMERPAYMENTTERMS,
    _FISCALYEAR,
    _JOURNALENTRY,
    _ONETIME,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    ABSOLUTEEXCHANGERATE,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BILLINGDOCUMENTDATE,
    BPTAXNUMBER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    CAREFERENCEDOCUMENT,
    CARRYFWDBALAMTINCCCRCY,
    CARRYFWDBALANCEAMTINTRANSCRCY,
    CHARTOFACCOUNTS,
    CITYNAME,
    CLEARINGJOURNALENTRY,
    CMMDTYORDREQDOCEXTERNALID,
    COUNTRY,
    CRDTCARRYFWDBALAMTINTRANSCRCY,
    CRDTPREVPERDYTDAMTINTRANSCRCY,
    CRDTSTARTINGBALAMTINTRANSCRCY,
    CREATEDBYUSER,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINTRANSCRCY,
    CREDITCARRYFWDBALAMTINCCCRCY,
    CREDITENDINGBALAMTINCCCRCY,
    CREDITENDINGBALAMTINTRANSCRCY,
    CREDITOR,
    CREDITPREVPERIODYTDAMTINCCCRCY,
    CREDITSTARTINGBALAMTINCCCRCY,
    CUSTOMERPAYMENTTERMS,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCARRYFWDBALAMTINCCCRCY,
    DEBITCARRYFWDBALAMTINTRANSCRCY,
    DEBITCREDITCODE,
    DEBITENDINGBALAMTINCCCRCY,
    DEBITENDINGBALAMTINTRANSCRCY,
    DEBITPREVPERDYTDAMTINTRANSCRCY,
    DEBITPREVPERIODYTDAMTINCCCRCY,
    DEBITSTARTINGBALAMTINCCCRCY,
    DEBITSTARTINGBALAMTINTRANSCRCY,
    DEBTOR,
    DMBTR_SHL,
    DOCUMENT_KEY,
    DOCUMENTBILLINGSTATUS,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    EMAILADDRESS,
    ENDINGBALANCEAMTINCOCODECRCY,
    ENDINGBALANCEAMTINTRANSCRCY,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    GLACCOUNTLONGNAME,
    H_HWAER,
    INPUTFISCALYEAR,
    INVOICEAMOUNTINFRGNCURRENCY,
    INVOICEREFERENCE,
    ISBUSINESSPURPOSECOMPLETED,
    ISREVERSAL,
    ISREVERSED,
    ITEMISREPORTINGRELEVANT,
    JAHRPER,
    KALNR,
    NAME,
    OFFICIALWHLDGTAXCODE,
    ORGANIZATIONBPNAME1,
    ORIGINALREFERENCEDOCUMENT,
    PKALNR,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTINGDATE,
    POSTINGKEY,
    PREVPERDYTDAMOUNTINTRANSCRCY,
    PREVPERIODYTDAMTINCCCRCY,
    REFERENCEDOCUMENTTYPE,
    REGION,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    RU_BUDGETCLASSIFICATIONCODE,
    RU_SUPPLIERKPP,
    RU_TERRITORYCLASSFCTNOKTMO,
    RU_UNIFIEDTAXNOTICEPAYMENTVERS,
    RU_UNIFIEDTAXNOTICEPERIODCODE,
    RUNREF,
    SALESDOCUMENTDATE,
    SDDOCUMENTCATEGORY,
    SEARCHTERM1,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    STARTINGBALANCEAMTINCOCODECRCY,
    STARTINGBALANCEAMTINTRANSCRCY,
    STREETNAME,
    SUPPLIERNAME,
    SUPPLIERRECIPIENTTYPE,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXSECTION,
    TOTALGROSSAMOUNT,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCODE,
    VATREGISTRATION,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WHLDGTAXDOCUMENTTYPE,
    WITHHOLDINGTAXCODE,
    YRTODTEAMTINTRANSACCRCY,
    YTDAMTINLOCLCRCY,
    YTDCRDTAMTINCOCODECRCY,
    YTDCRDTAMTINTRANSCRCY,
    YTDDEBITAMTINCOCODECRCY,
    YTDDEBITAMTINTRANSCRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BILLINGDOCUMENT, BILLINGDOCUMENTLIST, BUSINESSPARTNER, CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, COMMODITYORDERREQUEST, COMMODITYORDERREQUESTUUID, COMPANYCODE, COMPANYCODECURRENCY, DOCREF, FISCALYEAR, GLACCOUNT, PT_SAFTDOCUMENTNUMBER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIER, TRADINGCONTRACTITEM, TRADINGCONTRACTNUMBER, TRANSACTIONCURRENCY, WITHHOLDINGTAXINCOMETYPE, WITHHOLDINGTAXPERCENT, WITHHOLDINGTAXTYPE)
);

Learn More