DOCS

40 Fields

DOCS is an SAP database table in S/4HANA. It contains 40 fields.

Fields (40)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 5
KEY AccountingDocumentItem AccountingDocumentItem 5
KEY CompanyCode CompanyCode 5
KEY FiscalYear FiscalYear 5
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
_PTRSmallBusiness _PTRSmallBusiness 3
_ReportedItemsLog _ReportedItemsLog 4
AccountingDocumentType AccountingDocumentType 5
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 3
AU_AccountingDocumentType AU_AccountingDocumentType 4
AU_PartialPaymentFlag AU_PartialPaymentFlag 3
AU_PurContrPaymentTerms AU_PurContrPaymentTerms 3
AU_SelfInvoiceFlag AU_SelfInvoiceFlag 3
BPTaxNumber BPTaxNumber 3
BusinessPartner BusinessPartner 3
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 4
CompanyCodeName CompanyCodeName 4
DebitCreditCode DebitCreditCode 5
InvoiceIssueDate InvoiceIssueDate 4
InvoiceReference InvoiceReference 5
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 5
LastGoodsReceiptPostingDate LastGoodsReceiptPostingDate 3
NetPaymentDays NetPaymentDays 1
NumberOfDays NumberOfDays 1
PaymentDate PaymentDate 3
PaymentTerms PaymentTerms 3
PostingDate PostingDate 4
PurchaseContract PurchaseContract 4
PurchaseOrder PurchaseOrder 4
ReportingDate ReportingDate 3
Supplier Supplier 4
SupplierAccountGroup SupplierAccountGroup 5
SupplierInvoice SupplierInvoice 5
SupplierInvoiceFiscalYear SupplierInvoiceFiscalYear 5
SupplierInvoiceOrigin SupplierInvoiceOrigin 3
TradingPartner TradingPartner 5
VATRegistration VATRegistration 4

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 DOCS (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    _PTRSMALLBUSINESS,
    _REPORTEDITEMSLOG,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AU_ACCOUNTINGDOCUMENTTYPE,
    AU_PARTIALPAYMENTFLAG,
    AU_PURCONTRPAYMENTTERMS,
    AU_SELFINVOICEFLAG,
    BPTAXNUMBER,
    BUSINESSPARTNER,
    CASHDISCOUNTAMTINCOCODECRCY,
    COMPANYCODECURRENCY,
    COMPANYCODENAME,
    DEBITCREDITCODE,
    INVOICEISSUEDATE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    LASTGOODSRECEIPTPOSTINGDATE,
    NETPAYMENTDAYS,
    NUMBEROFDAYS,
    PAYMENTDATE,
    PAYMENTTERMS,
    POSTINGDATE,
    PURCHASECONTRACT,
    PURCHASEORDER,
    REPORTINGDATE,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERINVOICE,
    SUPPLIERINVOICEFISCALYEAR,
    SUPPLIERINVOICEORIGIN,
    TRADINGPARTNER,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More