COMMISSINV

40 Fields

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

Fields (40)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY Invoice Invoice 1
KEY InvoiceYear InvoiceYear 1
KEY RevisionNumber RevisionNumber 2
KEY RU_VATReturnSectionType RU_VATReturnSectionType 2
AmountInTransactionCurrency AmountInTransactionCurrency 1
BusinessPartner BusinessPartner 1
BusinessPartnerName BusinessPartnerName 1
ContractNum ContractNum 1
CorrectionDocumentDate CorrectionDocumentDate 1
CorrectionInvoice CorrectionInvoice 1
CorrectionInvoiceDate CorrectionInvoiceDate 1
CorrectionInvoiceYear CorrectionInvoiceYear 1
CustCoIsBusPrpsCmpltd CustCoIsBusPrpsCmpltd 1
Customer Customer 1
CustomerAccountGroup CustomerAccountGroup 1
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup 1
CustomerFinsAuthorizationGrp CustomerFinsAuthorizationGrp 1
CustomerIsBusPrpsCmpltd CustomerIsBusPrpsCmpltd 1
DocumentDate DocumentDate 1
ExternalCorrectionInvoice ExternalCorrectionInvoice 1
ExternalInvoice ExternalInvoice 1
InvoiceDate InvoiceDate 1
IsReversal IsReversal 2
IsReversed IsReversed 2
PostingDate PostingDate 1
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
RU_VATReturnVersion RU_VATReturnVersion 1
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd 1
Supplier Supplier 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 1
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp 1
SupplierIsBusPrpsCmpltd SupplierIsBusPrpsCmpltd 1
TaxAmount TaxAmount 1
TaxReportingDate TaxReportingDate 1
TransactionCurrency TransactionCurrency 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 COMMISSINV (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    INVOICE,
    INVOICEYEAR,
    REVISIONNUMBER,
    RU_VATRETURNSECTIONTYPE,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME,
    CONTRACTNUM,
    CORRECTIONDOCUMENTDATE,
    CORRECTIONINVOICE,
    CORRECTIONINVOICEDATE,
    CORRECTIONINVOICEYEAR,
    CUSTCOISBUSPRPSCMPLTD,
    CUSTOMER,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCOMPANYAUTHZNGROUP,
    CUSTOMERFINSAUTHORIZATIONGRP,
    CUSTOMERISBUSPRPSCMPLTD,
    DOCUMENTDATE,
    EXTERNALCORRECTIONINVOICE,
    EXTERNALINVOICE,
    INVOICEDATE,
    ISREVERSAL,
    ISREVERSED,
    POSTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RU_VATRETURNVERSION,
    SUPLRCOISBUSPRPSCMPLTD,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERCOMPANYAUTHZNGROUP,
    SUPPLIERFINSAUTHORIZATIONGRP,
    SUPPLIERISBUSPRPSCMPLTD,
    TAXAMOUNT,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, INVOICE, INVOICEYEAR, REVISIONNUMBER, RU_VATRETURNSECTIONTYPE)
);

Learn More