_INVLINEITEM

_INVLINEITEM is an SAP database table in S/4HANA. It contains 38 fields.

Fields (38)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentItemRef AccountingDocumentItemRef 2
AlternativeUnit AlternativeUnit 2
BaseUnit BaseUnit 2
CompanyCode CompanyCode 2
ConversionFactor ConversionFactor 2
CostCenter CostCenter 1
DebitCreditCode DebitCreditCode 2
DocumentItemText DocumentText 1
FiscalYear FiscalYear 1
GenerationYear GenerationYear 2
MaterialType MaterialType 2
OriginSDDocument OriginSDDocument 2
Product Product 2
ProductDescription ProductDescription 2
ProductPriceUnitQuantity ProductPriceUnitQuantity 2
Quantity Quantity 2
QuantityDenominator QuantityDenominator 2
QuantityNumerator QuantityNumerator 2
RO_SAFTAnalysisType RO_SAFTAnalysisType 1
RO_SAFTTaxBaseDescription RO_SAFTTaxBaseDescription 2
RO_SAFTTaxCode RO_SAFTTaxCode 2
RO_SAFTTaxType RO_SAFTTaxType 2
SalesOrder SalesOrder 2
SalesOrderDate SalesOrderDate 2
SDTransactionCurrency SDTransactionCurrency 2
SourceUnitOfMeasureFactor SourceUnitOfMeasureFactor 2
TargetGLAccount TargetGLAccount 2
TaxAmountInDocCry TaxAmountInDocCry 2
TaxAmountInTransCrcy TaxAmountInTransCrcy 1
TaxExemptCode TaxExemptCode 2
TaxRate TaxRate 2
TaxRateInPercent TaxRateInPercent 2
TotalAmountInLocalCurrency TotalAmountInLocalCurrency 2
TotalAmountInSourceCurrency TotalAmountInSourceCurrency 2
TotalTaxAmount TotalTaxAmount 2
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 _INVLINEITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTITEMREF,
    ALTERNATIVEUNIT,
    BASEUNIT,
    COMPANYCODE,
    CONVERSIONFACTOR,
    COSTCENTER,
    DEBITCREDITCODE,
    DOCUMENTITEMTEXT,
    FISCALYEAR,
    GENERATIONYEAR,
    MATERIALTYPE,
    ORIGINSDDOCUMENT,
    PRODUCT,
    PRODUCTDESCRIPTION,
    PRODUCTPRICEUNITQUANTITY,
    QUANTITY,
    QUANTITYDENOMINATOR,
    QUANTITYNUMERATOR,
    RO_SAFTANALYSISTYPE,
    RO_SAFTTAXBASEDESCRIPTION,
    RO_SAFTTAXCODE,
    RO_SAFTTAXTYPE,
    SALESORDER,
    SALESORDERDATE,
    SDTRANSACTIONCURRENCY,
    SOURCEUNITOFMEASUREFACTOR,
    TARGETGLACCOUNT,
    TAXAMOUNTINDOCCRY,
    TAXAMOUNTINTRANSCRCY,
    TAXEXEMPTCODE,
    TAXRATE,
    TAXRATEINPERCENT,
    TOTALAMOUNTINLOCALCURRENCY,
    TOTALAMOUNTINSOURCECURRENCY,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY
);