COMMISSINV

45 Fields

COMMISSINV is an SAP database table in S/4HANA. It contains 45 fields.

Fields (45)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 3
KEY Invoice Invoice 2
KEY InvoiceYear InvoiceYear 2
KEY RevisionNumber RevisionNumber 3
KEY RU_VATReturnSectionType RU_VATReturnSectionType 3
AmountInTransactionCurrency AmountInTransactionCurrency 2
BusinessPartner BusinessPartner 2
BusinessPartnerName BusinessPartnerName 2
ContractNum ContractNum 2
CorrectionDocumentDate CorrectionDocumentDate,IncomingCorrectionInvoiceDate 2
CorrectionInvoice CorrectionInvoice 2
CorrectionInvoiceDate CorrectionInvoiceDate 2
CorrectionInvoiceRevisionDate CorrectionInvoiceRevisionDate 1
CorrectionInvoiceRevisionNmbr CorrectionInvoiceRevisionNmbr 1
CorrectionInvoiceYear CorrectionInvoiceYear 2
Customer Customer 2
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup 2
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp 2
DocumentDate DocumentDate 2
ExternalCorrectionInvoice ExternalCorrectionInvoice 2
ExternalInvoice ExternalInvoice 2
InvoiceDate InvoiceDate 2
IsReversal IsReversal 2
IsReversed IsReversed 3
LinkingCurr Currency 1
LinkingStatus CommsnTradeInvoiceLinkStatus 1
OriginalInvoiceRevisionDate OriginalInvoiceRevisionDate 1
OriginalInvoiceRevisionNumber OriginalInvoiceRevisionNumber 1
PostingDate PostingDate 2
ReverseDocument ReverseDocument 2
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 2
RU_RegistrationInvoiceDate RU_RegistrationInvoiceDate 1
RU_VATReturnVersion RU_VATReturnVersion 2
Supplier Supplier 2
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 2
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp 2
TaxAmount TaxAmount 2
TaxReportingDate TaxReportingDate 1
TotalLinkedAmount CommsnTradeInvoiceLinkedAmount 1
TotalLinkedVAT CommsnTradeInvcLinkedVATAmount 1
TotalUnLinkedAmount CommsnTradeInvcNotLinkedAmount 1
TotalUnLinkedVAT CommsnTradeInvcNotLinkedVATAmt 1
TransactionCurrency TransactionCurrency 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 COMMISSINV (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    INVOICE,
    INVOICEYEAR,
    REVISIONNUMBER,
    RU_VATRETURNSECTIONTYPE,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME,
    CONTRACTNUM,
    CORRECTIONDOCUMENTDATE,
    CORRECTIONINVOICE,
    CORRECTIONINVOICEDATE,
    CORRECTIONINVOICEREVISIONDATE,
    CORRECTIONINVOICEREVISIONNMBR,
    CORRECTIONINVOICEYEAR,
    CUSTOMER,
    CUSTOMERCOMPANYAUTHZNGROUP,
    CUSTOMERFINSAUTHORIZATIONGRP,
    DOCUMENTDATE,
    EXTERNALCORRECTIONINVOICE,
    EXTERNALINVOICE,
    INVOICEDATE,
    ISREVERSAL,
    ISREVERSED,
    LINKINGCURR,
    LINKINGSTATUS,
    ORIGINALINVOICEREVISIONDATE,
    ORIGINALINVOICEREVISIONNUMBER,
    POSTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RU_REGISTRATIONINVOICEDATE,
    RU_VATRETURNVERSION,
    SUPPLIER,
    SUPPLIERCOMPANYAUTHZNGROUP,
    SUPPLIERFINSAUTHORIZATIONGRP,
    TAXAMOUNT,
    TAXREPORTINGDATE,
    TOTALLINKEDAMOUNT,
    TOTALLINKEDVAT,
    TOTALUNLINKEDAMOUNT,
    TOTALUNLINKEDVAT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, INVOICE, INVOICEYEAR, REVISIONNUMBER, RU_VATRETURNSECTIONTYPE)
);

Learn More