/ACCGO/T_STLITEM - Settlement Item Table
Settlement Item Table information is stored in SAP table /ACCGO/T_STLITEM.
It is part of development package /ACCGO/COMMON in software component LO-AGR. This development package consists of objects that can be grouped under "ACCGO: Package for all DDIC and Common Objects".
It is part of development package /ACCGO/COMMON in software component LO-AGR. This development package consists of objects that can be grouped under "ACCGO: Package for all DDIC and Common Objects".
Fields for table /ACCGO/T_STLITEM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| STL_ITEM_GUID | Settlement Item GUID | X | /ACCGO/E_SETTLEMENT_ITEM_GUID | RAW | 16 | |
| SETTL_ITEM | Settlement Item | /ACCGO/E_SETTL_ITEM | NUMC | 12 | ||
| .INCLUDE | /ACCGO/CAS_S_STL_ITEM_DATA | 0 | ||||
| STL_HEADER_GUID | Settlement Header GUID | /ACCGO/E_SETTLEMENT_GUID | RAW | 16 | * | |
| CONTRACT_TYPE | Trading Contract Type | TCTYP | CHAR | 8 | * | |
| CONTRACT | Trading Contract | TKONN | CHAR | 20 | ||
| CONTRACT_ITEM | Item Number of Trading Contract | TPOSN | NUMC | 12 | ||
| COMMODITY_ITEM | Sub-Item Number of Trading Contract | TPOSN_SUB | NUMC | 12 | ||
| SDATE | Date | /ACCGO/E_AUDATE | CHAR | 16 | ||
| MATNR | Material Number | MATNR | CHAR | 80 | ||
| MATGRP | Material Group | MATKL | CHAR | 18 | ||
| DPQS_ID | DPQS Schedule | /ACCGO/E_SCHDL | CHAR | 20 | ||
| APPLDOC | Application Document Number | /ACCGO/E_APPLDOC | CHAR | 20 | * | |
| APPLDOC_ITEM | Application Document Item Number | /ACCGO/E_APPLDOC_ITEM_NUM | NUMC | 20 | ||
| HIGHER_LEVEL_ITE | Parent Application Document Item | /ACCGO/E_PARENT_APPLDOC_ITEM | NUMC | 20 | ||
| APPL_GUID | Application GUID | /ACCGO/E_APPL_GUID | RAW | 16 | ||
| APPL_VERSION | Application Version | /ACCGO/E_APPL_VERSION | NUMC | 8 | ||
| UIS_ID | Load Data Capture Object ID | /ACCGO/E_UIS_ID | CHAR | 20 | ||
| AGRID | Application Group ID | /ACCGO/E_AGR_ID | CHAR | 20 | ||
| FULL_SHIP_QTY | Full Shipment Quantity | /ACCGO/E_QUAN_FULL_SHIP | QUAN | 7 | ||
| SH_DATE | Shipping Date | /ACCGO/E_SH_DATE | DATS | 16 | ||
| RE_DATE | Receiving Date | /ACCGO/E_RE_DATE | DATS | 16 | ||
| TOT_QUANTITY_ADJ | Quantity Adjustment | /ACCGO/E_Q_ADJUST | QUAN | 7 | ||
| ADJ_UOM | Unit of Measure | /ACCGO/E_MEINS | UNIT | 6 | * | |
| BPRICE | Base Price | /ACCGO/E_PRC_COND_VALUE | CURR | 6 | ||
| DOC_CURR | Currency Key | WAERS | CUKY | 10 | TCURC | |
| UNIT_QUANTITY | Quantity in Base UoM | /ACCGO/E_QUAN_UNIT | QUAN | 7 | ||
| UNIT_UOM | Per Unit UoM | /ACCGO/E_PER_MEINS | UNIT | 6 | * | |
| CONTRACT_QTY | Quantity in Contract UoM | /ACCGO/E_CONTRACT_QTY | QUAN | 7 | ||
| CONTRACT_UOM | Contract Units of Measurement | /ACCGO/E_CONTRACT_UOM | UNIT | 6 | * | |
| SCALE_QUANTITY | Quantity in Scale UoM | /ACCGO/E_SCALE_QTY | QUAN | 7 | ||
| SCALE_UOM | Scale Units of Measurement | /ACCGO/E_SCALE_UOM | UNIT | 6 | * | |
| DOCUMENT_QTY | Quantity in Document UoM | /ACCGO/E_DOCUMENT_QTY | QUAN | 7 | ||
| DOCUMENT_UOM | Document Units of Measurement | /ACCGO/E_DOCUMENT_UOM | UNIT | 6 | * | |
| CANCL_FEE | Cancellation Fee | /ACCGO/E_FEE | CURR | 7 | ||
| CANC_PLOT_ID | Pricing Lot ID for Commodity Item | /ACCGO/E_PRICINGLOT_ID | CHAR | 20 | ||
| DPQS_ADJ_AMT | DPQS Adjustment Amount | /ACCGO/E_DPQS_ADJ_AMOUNT | CURR | 10 | ||
| TOT_PRICE_ADJUST | Price Adjustment | /ACCGO/E_P_ADJUST | CURR | 10 | ||
| NET_ADJ_AMT | Net Adjusted Amount | /ACCGO/E_NEX_ADJ_AMT | CURR | 10 | ||
| NET_AMOUNT | Net Amount | /ACCGO/E_NET_AMT | CURR | 10 | ||
| GROSS_AMOUNT | Net Amount | /ACCGO/E_NET_AMT | CURR | 10 | ||
| OFFSET_ITEM | Offset Item Indicator | /ACCGO/E_OFFSET_FLG | CHAR | 2 | ||
| APPL_ID | Application ID | /ACCGO/E_APPL_ID | CHAR | 20 | ||
| APPL_STATUS | Application Status | /ACCGO/E_APPL_STATUS | CHAR | 4 | ||
| KUNAG | Sold-to Party | KUNAG | CHAR | 20 | * | |
| LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
| SIDE | Side | WLF_PR_SIDE | CHAR | 4 | ||
| PTERM | Payment Term | /ACCGO/E_PTERM | CHAR | 8 | ||
| LAND1 | Company Country/Region | LAND | CHAR | 6 | * | |
| BUKRS | Company Code | BUKRS | CHAR | 8 | ||
| WERKS | Plant | WERKS_D | CHAR | 8 | ||
| GSBER | Business Area | GSBER | CHAR | 8 | * | |
| PRCTR | Profit Center | PRCTR | CHAR | 20 | ||
| VKORG | Sales Organization | VKORG | CHAR | 8 | ||
| VTWEG | Distribution Channel | VTWEG | CHAR | 4 | ||
| SPART | Division | SPART | CHAR | 4 | ||
| EKORG | Purchasing organization | EKORG | CHAR | 8 | * | |
| EKGRP | Purchasing Group | EKGRP | CHAR | 6 | * | |
| CR_DB_MEMO_REQ | Credit/Debit Memo Request | /ACCGO/E_CREDIT_DEBIT_MEMO_REQ | CHAR | 20 | ||
| BILLDUE_DOCNO | Settlement Billing Due Document | /ACCGO/E_CAS_BILLDUE_DOC | CHAR | 20 | ||
| BILLDUE_DOCTYP | Billing Due Document Type | /ACCGO/E_CAS_BILLDUE_DOC_TYP | CHAR | 4 | ||
| ACCDOC_NUM | Accounting Document Number | /ACCGO/ACCDOC_NUM | CHAR | 20 | ||
| FISCAL_YEAR | Accounting Document Year | /ACCGO/ACCDOC_YEAR | NUMC | 8 | ||
| REV_ACCDOC_NUM | Reverse Accounting Document Number | /ACCGO/REV_ACCDOC_NUM | CHAR | 20 | ||
| REV_FISCAL_YEAR | Reverse Accounting Document Year | /ACCGO/REV_ACCDOC_YEAR | NUMC | 8 | ||
| REF_PRICE | Reference Price | /ACCGO/E_REF_PRICE | CURR | 8 | ||
| REF_CUKY | Reference Currency Unit | /ACCGO/E_REF_CUKY | CUKY | 10 | * | |
| WBELN | Document Number | WBELN_AG | CHAR | 20 | * | |
| POSNR | Document Item | WPOSNR_LF | NUMC | 12 | * | |
| BASE_NET_AMOUNT | Net Amount | /ACCGO/E_NET_AMT | CURR | 10 | ||
| BASE_GROSS_AMOUNT | Net Amount | /ACCGO/E_NET_AMT | CURR | 10 | ||
| QTY_CHANGE_TYPE | Quantity Update | /ACCGO/E_QTY_UPD | CHAR | 2 | ||
| STRG_START_DATE | Storage Start Date | /ACCGO/E_STRG_START_DATE | DATS | 16 | ||
| STRG_END_DATE | Commingle: Storage End Date | /ACCGO/E_STRG_END_DATE | DATS | 16 | ||
| NUMBER_OF_DAYS | Number of Days | /ACCGO/E_NUMBER_OF_DAYS | INT4 | 4 | ||
| PAYOUT_PERCENTAG | Prepayment Payout Percentage | /ACCGO/E_PAYOUT_PERCENTAGE | DEC | 3 | ||
| NET_AMT_AFTER_PPYMT | Payout Amount | /ACCGO/E_NET_AMT_AFT_PPYMT | CURR | 10 | ||
| NET_AMT_CURR_AFTER_PPYMT | Currency | /ACCGO/E_WAERS | CUKY | 10 |