FOREIGNDOC

FOREIGNDOC is an SAP database table in S/4HANA. It contains 34 fields.

Fields (34)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
AssignmentReference AssignmentReference 2
BusinessTransactionType BusinessTransactionType 1
CompanyCode CompanyCode 3
CompanyCodeCurrency CompanyCodeCurrency 1
Country Country 2
Currency Currency 2
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
FiscalPeriod FiscalPeriod 1
FiscalYear FiscalYear 1
IsReversal IsReversal 1
IsReversed IsReversed 1
KZ_TaxTurnoverCode KZ_TaxTurnoverCode 2
OriginalReferenceDocument OriginalReferenceDocument 1
PaidVAT PaidVAT 2
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 1
SenderLogicalSystem SenderLogicalSystem 1
StatryRptCategory StatryRptCategory 1
StatryRptgEntity StatryRptgEntity 1
StatryRptRunID StatryRptRunID 1
SupplierName SupplierName 2
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy,VATToBePaid 3
TaxCode TaxCode 1
TaxGroupOperation TaxGroupOperation 1
TaxNumber1 TaxNumber 2
TaxReportingDate TaxReportingDate 1
VATToBePaid VATToBePaid 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 FOREIGNDOC (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ASSIGNMENTREFERENCE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    COUNTRY,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    FISCALYEAR,
    ISREVERSAL,
    ISREVERSED,
    KZ_TAXTURNOVERCODE,
    ORIGINALREFERENCEDOCUMENT,
    PAIDVAT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    SENDERLOGICALSYSTEM,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIERNAME,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXCODE,
    TAXGROUPOPERATION,
    TAXNUMBER1,
    TAXREPORTINGDATE,
    VATTOBEPAID
);