_SETTLMTDOCITEM
_SETTLMTDOCITEM is an SAP database table in S/4HANA. It contains 124 fields.
Fields (124)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SettlmtDocItem | SettlmtDocItem | 2 |
| KEY | SettlmtMgmtDocItem | SettlmtDocItem | 1 |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| BusVolDocDistributionChannel | BusVolDocDistributionChannel | 1 | |
| BusVolDocDivision | BusVolDocDivision | 1 | |
| BusVolDocSalesOrganization | BusVolDocSalesOrganization | 1 | |
| CashDiscountIsDeductible | CashDiscountIsDeductible | 1 | |
| CollSettlmtItemBlkgReason | CollSettlmtItemBlkgReason | 1 | |
| CustItmEligibleAmtForCshDisc | CustItmEligibleAmtForCshDisc | 1 | |
| CustomerEffectiveItemAmount | CustomerEffectiveItemAmount | 1 | |
| CustomerItemGrossAmount | CustomerItemGrossAmount | 3 | |
| CustomerItemNetAmount | CustomerItemNetAmount | 3 | |
| CustomerItemSettlmtBlkgReason | CustomerItemSettlmtBlkgReason | 1 | |
| CustomerItemSettlmtStatus | CustomerItemSettlmtStatus | 1 | |
| CustomerItemTaxAmount | CustomerItemTaxAmount | 1 | |
| CustomerPrcDetnIsIncmplt | CustomerPrcDetnIsIncmplt | 1 | |
| CustomerRebateBasisAmount | CustomerRebateBasisAmount | 1 | |
| CustomerSettlementOrder | CustomerSettlementOrder | 1 | |
| CustomerSettlmtRecipient | CustomerSettlmtRecipient | 1 | |
| CustomerSubtotal1Amount | CustomerSubtotal1Amount | 1 | |
| CustomerSubtotal2Amount | CustomerSubtotal2Amount | 1 | |
| CustomerSubtotal3Amount | CustomerSubtotal3Amount | 1 | |
| CustomerSubtotal4Amount | CustomerSubtotal4Amount | 1 | |
| CustomerSubtotal5Amount | CustomerSubtotal5Amount | 1 | |
| CustomerSubtotal6Amount | CustomerSubtotal6Amount | 1 | |
| CustomerTaxCode | CustomerTaxCode | 1 | |
| CustSettlmtBusinessArea | CustSettlmtBusinessArea | 1 | |
| CustSettlmtControllingArea | CustSettlmtControllingArea | 1 | |
| CustSettlmtCostCenter | CustSettlmtCostCenter | 1 | |
| CustSettlmtProfitCenter | CustSettlmtProfitCenter | 1 | |
| CustSettlmtWBSElmntInternalID | CustSettlmtWBSElmntInternalID | 1 | |
| GLAccount | GLAccount | 1 | |
| HigherLevelItem | HigherLevelItem | 1 | |
| InventoryValuationType | InventoryValuationType | 1 | |
| ItemDistributionStatus | ItemDistributionStatus | 1 | |
| ItemGrossWeight | ItemGrossWeight | 1 | |
| ItemIntrastatRelevance | ItemIntrastatRelevance | 1 | |
| ItemNetWeight | ItemNetWeight | 1 | |
| ItemSettlmtRelevance | ItemSettlmtRelevance | 1 | |
| ItemVolume | ItemVolume | 1 | |
| ItemVolumeUnit | ItemVolumeUnit | 1 | |
| ItemWeightUnit | ItemWeightUnit | 1 | |
| ItmSettlmtDocCollRelevance | ItmSettlmtDocCollRelevance | 1 | |
| LowerLevelItemExists | LowerLevelItemExists | 1 | |
| NetPriceAmount | NetPriceAmount | 1 | |
| NetPriceQuantity | NetPriceQuantity | 1 | |
| NetPriceQuantityUnit | NetPriceQuantityUnit | 1 | |
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | 1 | |
| Plant | Plant | 1 | |
| PriceSpecificationProductGroup | PriceSpecificationProductGroup | 1 | |
| PricingDate | PricingDate | 1 | |
| PriorSupplier | PriorSupplier | 1 | |
| Product | Product | 1 | |
| ProductCommissionGroup | ProductCommissionGroup | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProductHierarchy | ProductHierarchy | 1 | |
| ProductPurchasePointsQty | ProductPurchasePointsQty | 1 | |
| ProductPurchasePointsQtyUnit | ProductPurchasePointsQtyUnit | 1 | |
| SalesSpcfcProductGroup1 | SalesSpcfcProductGroup1 | 1 | |
| SalesSpcfcProductGroup2 | SalesSpcfcProductGroup2 | 1 | |
| SalesSpcfcProductGroup3 | SalesSpcfcProductGroup3 | 1 | |
| SalesSpcfcProductGroup4 | SalesSpcfcProductGroup4 | 1 | |
| SalesSpcfcProductGroup5 | SalesSpcfcProductGroup5 | 1 | |
| SalesVolumeRebateGroup | SalesVolumeRebateGroup | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| SettlementFiscalYear | SettlementFiscalYear | 1 | |
| SettlmtAddlRefDoc | SettlmtAddlRefDoc | 1 | |
| SettlmtAddlRefDocCat | SettlmtAddlRefDocCat | 1 | |
| SettlmtAddlRefDocFiscalYear | SettlmtAddlRefDocFiscalYear | 1 | |
| SettlmtAddlRefDocItem | SettlmtAddlRefDocItem | 1 | |
| SettlmtAddlRefDocLogicalSyst | SettlmtAddlRefDocLogicalSyst | 1 | |
| SettlmtDateCat | SettlmtDateCat | 1 | |
| SettlmtDocItemCancld | SettlmtDocItemCancld | 1 | |
| SettlmtDocItemCat | SettlmtDocItemCat | 1 | |
| SettlmtDocItemCollSts | SettlmtDocItemCollSts | 1 | |
| SettlmtDocItemStatus | SettlmtDocItemStatus | 1 | |
| SettlmtDocItemText | SettlmtDocItemText | 1 | |
| SettlmtItemActivityReason | SettlmtItemActivityReason | 1 | |
| SettlmtItmStatisticalPrpty | SettlmtItmStatisticalPrpty | 3 | |
| SettlmtPrecdgDoc | SettlmtPrecdgDoc | 1 | |
| SettlmtPrecdgDocCat | SettlmtPrecdgDocCat | 1 | |
| SettlmtPrecdgDocItem | SettlmtPrecdgDocItem | 1 | |
| SettlmtQuantity | SettlmtQuantity | 1 | |
| SettlmtQuantityUnit | SettlmtQuantityUnit | 1 | |
| SettlmtRefDoc | SettlmtRefDoc | 1 | |
| SettlmtRefDocCat | SettlmtRefDocCat | 1 | |
| SettlmtRefDocCompanyCode | SettlmtRefDocCompanyCode | 1 | |
| SettlmtRefDocFiscalYear | SettlmtRefDocFiscalYear | 1 | |
| SettlmtRefDocItem | SettlmtRefDocItem | 1 | |
| SettlmtRefDocLogicalSyst | SettlmtRefDocLogicalSyst | 1 | |
| SettlmtRefDocReltdFiscalYear | SettlmtRefDocReltdFiscalYear | 1 | |
| SettlmtSourceDoc | SettlmtSourceDoc | 1 | |
| SettlmtSourceDocCat | SettlmtSourceDocCat | 1 | |
| SettlmtSourceDocItem | SettlmtSourceDocItem | 1 | |
| SettlmtToBaseQuantityDnmntr | SettlmtToBaseQuantityDnmntr | 1 | |
| SettlmtToBaseQuantityNmrtr | SettlmtToBaseQuantityNmrtr | 1 | |
| SettlmtToNetPriceQtyDnmntr | SettlmtToNetPriceQtyDnmntr | 1 | |
| SettlmtToNetPriceQtyNmrtr | SettlmtToNetPriceQtyNmrtr | 1 | |
| SuplrItmEligibleAmtForCshDisc | SuplrItmEligibleAmtForCshDisc | 1 | |
| SuplrSettlmtBusinessArea | SuplrSettlmtBusinessArea | 1 | |
| SuplrSettlmtControllingArea | SuplrSettlmtControllingArea | 1 | |
| SuplrSettlmtCostCenter | SuplrSettlmtCostCenter | 1 | |
| SuplrSettlmtProfitCenter | SuplrSettlmtProfitCenter | 1 | |
| SuplrSettlmtWBSElmntInternalID | SuplrSettlmtWBSElmntInternalID | 1 | |
| SupplierEffectiveItemAmount | SupplierEffectiveItemAmount | 1 | |
| SupplierItemGrossAmount | SupplierItemGrossAmount | 3 | |
| SupplierItemNetAmount | SupplierItemNetAmount | 3 | |
| SupplierItemSettlmtBlkgReason | SupplierItemSettlmtBlkgReason | 1 | |
| SupplierItemSettlmtStatus | SupplierItemSettlmtStatus | 1 | |
| SupplierItemTaxAmount | SupplierItemTaxAmount | 1 | |
| SupplierPrcDetnIsIncmplt | SupplierPrcDetnIsIncmplt | 1 | |
| SupplierProductID | SupplierProductID | 1 | |
| SupplierRebateBasisAmount | SupplierRebateBasisAmount | 1 | |
| SupplierSettlementOrder | SupplierSettlementOrder | 1 | |
| SupplierSubrange | SupplierSubrange | 1 | |
| SupplierSubtotal1Amount | SupplierSubtotal1Amount | 1 | |
| SupplierSubtotal2Amount | SupplierSubtotal2Amount | 1 | |
| SupplierSubtotal3Amount | SupplierSubtotal3Amount | 1 | |
| SupplierSubtotal4Amount | SupplierSubtotal4Amount | 1 | |
| SupplierSubtotal5Amount | SupplierSubtotal5Amount | 1 | |
| SupplierSubtotal6Amount | SupplierSubtotal6Amount | 1 | |
| SupplierTaxCode | SupplierTaxCode | 1 | |
| TaxJurisdiction | TaxJurisdiction | 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 _SETTLMTDOCITEM (
SETTLMTDOCITEM,
SETTLMTMGMTDOCITEM,
BASEUNIT,
BATCH,
BUSVOLDOCDISTRIBUTIONCHANNEL,
BUSVOLDOCDIVISION,
BUSVOLDOCSALESORGANIZATION,
CASHDISCOUNTISDEDUCTIBLE,
COLLSETTLMTITEMBLKGREASON,
CUSTITMELIGIBLEAMTFORCSHDISC,
CUSTOMEREFFECTIVEITEMAMOUNT,
CUSTOMERITEMGROSSAMOUNT,
CUSTOMERITEMNETAMOUNT,
CUSTOMERITEMSETTLMTBLKGREASON,
CUSTOMERITEMSETTLMTSTATUS,
CUSTOMERITEMTAXAMOUNT,
CUSTOMERPRCDETNISINCMPLT,
CUSTOMERREBATEBASISAMOUNT,
CUSTOMERSETTLEMENTORDER,
CUSTOMERSETTLMTRECIPIENT,
CUSTOMERSUBTOTAL1AMOUNT,
CUSTOMERSUBTOTAL2AMOUNT,
CUSTOMERSUBTOTAL3AMOUNT,
CUSTOMERSUBTOTAL4AMOUNT,
CUSTOMERSUBTOTAL5AMOUNT,
CUSTOMERSUBTOTAL6AMOUNT,
CUSTOMERTAXCODE,
CUSTSETTLMTBUSINESSAREA,
CUSTSETTLMTCONTROLLINGAREA,
CUSTSETTLMTCOSTCENTER,
CUSTSETTLMTPROFITCENTER,
CUSTSETTLMTWBSELMNTINTERNALID,
GLACCOUNT,
HIGHERLEVELITEM,
INVENTORYVALUATIONTYPE,
ITEMDISTRIBUTIONSTATUS,
ITEMGROSSWEIGHT,
ITEMINTRASTATRELEVANCE,
ITEMNETWEIGHT,
ITEMSETTLMTRELEVANCE,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
ITMSETTLMTDOCCOLLRELEVANCE,
LOWERLEVELITEMEXISTS,
NETPRICEAMOUNT,
NETPRICEQUANTITY,
NETPRICEQUANTITYUNIT,
NONDEDUCTIBLEINPUTTAXAMOUNT,
PLANT,
PRICESPECIFICATIONPRODUCTGROUP,
PRICINGDATE,
PRIORSUPPLIER,
PRODUCT,
PRODUCTCOMMISSIONGROUP,
PRODUCTGROUP,
PRODUCTHIERARCHY,
PRODUCTPURCHASEPOINTSQTY,
PRODUCTPURCHASEPOINTSQTYUNIT,
SALESSPCFCPRODUCTGROUP1,
SALESSPCFCPRODUCTGROUP2,
SALESSPCFCPRODUCTGROUP3,
SALESSPCFCPRODUCTGROUP4,
SALESSPCFCPRODUCTGROUP5,
SALESVOLUMEREBATEGROUP,
SERVICESRENDEREDDATE,
SETTLEMENTFISCALYEAR,
SETTLMTADDLREFDOC,
SETTLMTADDLREFDOCCAT,
SETTLMTADDLREFDOCFISCALYEAR,
SETTLMTADDLREFDOCITEM,
SETTLMTADDLREFDOCLOGICALSYST,
SETTLMTDATECAT,
SETTLMTDOCITEMCANCLD,
SETTLMTDOCITEMCAT,
SETTLMTDOCITEMCOLLSTS,
SETTLMTDOCITEMSTATUS,
SETTLMTDOCITEMTEXT,
SETTLMTITEMACTIVITYREASON,
SETTLMTITMSTATISTICALPRPTY,
SETTLMTPRECDGDOC,
SETTLMTPRECDGDOCCAT,
SETTLMTPRECDGDOCITEM,
SETTLMTQUANTITY,
SETTLMTQUANTITYUNIT,
SETTLMTREFDOC,
SETTLMTREFDOCCAT,
SETTLMTREFDOCCOMPANYCODE,
SETTLMTREFDOCFISCALYEAR,
SETTLMTREFDOCITEM,
SETTLMTREFDOCLOGICALSYST,
SETTLMTREFDOCRELTDFISCALYEAR,
SETTLMTSOURCEDOC,
SETTLMTSOURCEDOCCAT,
SETTLMTSOURCEDOCITEM,
SETTLMTTOBASEQUANTITYDNMNTR,
SETTLMTTOBASEQUANTITYNMRTR,
SETTLMTTONETPRICEQTYDNMNTR,
SETTLMTTONETPRICEQTYNMRTR,
SUPLRITMELIGIBLEAMTFORCSHDISC,
SUPLRSETTLMTBUSINESSAREA,
SUPLRSETTLMTCONTROLLINGAREA,
SUPLRSETTLMTCOSTCENTER,
SUPLRSETTLMTPROFITCENTER,
SUPLRSETTLMTWBSELMNTINTERNALID,
SUPPLIEREFFECTIVEITEMAMOUNT,
SUPPLIERITEMGROSSAMOUNT,
SUPPLIERITEMNETAMOUNT,
SUPPLIERITEMSETTLMTBLKGREASON,
SUPPLIERITEMSETTLMTSTATUS,
SUPPLIERITEMTAXAMOUNT,
SUPPLIERPRCDETNISINCMPLT,
SUPPLIERPRODUCTID,
SUPPLIERREBATEBASISAMOUNT,
SUPPLIERSETTLEMENTORDER,
SUPPLIERSUBRANGE,
SUPPLIERSUBTOTAL1AMOUNT,
SUPPLIERSUBTOTAL2AMOUNT,
SUPPLIERSUBTOTAL3AMOUNT,
SUPPLIERSUBTOTAL4AMOUNT,
SUPPLIERSUBTOTAL5AMOUNT,
SUPPLIERSUBTOTAL6AMOUNT,
SUPPLIERTAXCODE,
TAXJURISDICTION,
PRIMARY KEY (SETTLMTDOCITEM, SETTLMTMGMTDOCITEM)
);Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA