/ACCGO/T_STLHEAD

Transparent Table Application Table
114 Fields 15 CDS Views

Settlement header table

/ACCGO/T_STLHEAD is an SAP database table in S/4HANA. Settlement header table. It contains 114 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
E_SettlmtDoc view from EXTENSION Extension View for Settlement Unit Head
I_ACMSettlementDocABDNumberVH view from BASIC Settlement ABD Number
I_ACMSettlementLatestCreation view from BASIC Settlement Unit Latest based on Creation
I_ACMSettlementUnitHeader view from BASIC ACM Settlement Unit Header Data
I_ACMSettlmtHdrCostRevCkpt view_entity from BASIC Basic Entity for Settlement Header for CRC
I_ACMTrdContrSettlmtLnkDet view_entity from BASIC ACM TradContrct Settlmt HdrItm link det
I_ACMTrdgContrSettlmtLinkDets view from BASIC ACM Contract Settlement Link details
I_SettlementDocumentHeader view from BASIC Interface for Settlement Unit Header Data
I_SettlementUnitVH view from BASIC Basic layer for Settlement Unit Val Help
P_ACCGO_STL_DOC_DETAILS view from BASIC
P_ACMTrdgContrToInvcLink view from BASIC Contract Invoice Link
P_PPMGContractSettlemtLink view from BASIC Settlement Linked to Contract
P_PPMGContrToInvoiceLink view from BASIC Contract Invoice Link
P_SettlementUnitHeader view from BASIC
P_STOR_STL_DETAILS view from BASIC

Fields (114)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY stl_header_guid /ACCGO/E_SETTLEMENT_GUID STL Hdr GUID
settl_doc /ACCGO/E_SETTL_DOC Settlement Unit
settl_yr /ACCGO/E_SETTL_YR Setl Unit Year
appl_guid /ACCGO/E_APPL_GUID Application GUID
appl_version /ACCGO/E_APPL_VERSION Application Version
doc_typ /ACCGO/E_DOC_TYP CAS Document Type
settl_cat /ACCGO/E_SETTL_CAT Document Category
settl_scenario /ACCGO/E_SETTL_SCENARIO Settl Scenario
settl_type /ACCGO/E_STL_TYP Settlement Type
side WLF_PR_SIDE Side
tkonn TKONN Trading Contract
tposn TPOSN Item Number
tposn_sub TPOSN_SUB Subitem
tposn_com WLF_TPOSN_COM Com. item num.
wbeln /ACCGO/E_ABD_NUMBER ABD Number
posnr /ACCGO/E_ABD_ITEM_NUMBER ABD Item
netwr /ACCGO/E_ABD_VALUE ABD Net Value
cancl_guid /ACCGO/E_CNTRCT_GUID Contract GUID
operation_id /ACCGO/E_WASHOUT_ID Washout ID
post_date /ACCGO/E_POST_DATE Sett. Post Date
appldoc /ACCGO/E_APPLDOC Appl. Document No.
appldoc_item /ACCGO/E_APPLDOC_ITEM_NUM Item No.
kunag KUNAG Sold-to Party
kunrg KUNRG Payer
kunre KUNRE Bill-to Party
lifnr LIFNR Supplier
invoicing_party LIFNR Supplier
mm_thres /ACCGO/E_MM_THRES MM Threshold
sd_thres /ACCGO/E_SD_THRES SD Threshold
land1 LAND1 Country/Reg.
z_regio REGIO Region
pterm /ACCGO/E_PTERM Payment Term
bukrs BUKRS Company Code
prctr PRCTR Profit Center
werks WERKS_D Plant
gsber GSBER Business Area
doc_curr WAERS Currency
dpqs_adj_amt /ACCGO/E_DPQS_ADJ_AMOUNT DPQS Adjustment Amt
gross_amount /ACCGO/E_GROSS_AMT Gross Amount
net_amount /ACCGO/E_NET_AMT Net Amount
threshold_perc /ACCGO/E_THRESHOLD Threshold Percentage
split_flag /ACCGO/E_SPLIT_FLAG Split Exists
lien_flag /ACCGO/E_LIEN_FLAG Lien Exists
adj_stl_hdr /ACCGO/E_SETTLEMENT_ADJ_GUID Adjustment GUID
arconfirm_flag /ACCGO/E_AR_CONFIRM AR Confirm?
apconfirm_flag /ACCGO/E_AP_CONFIRM AP Confirm?
ref_stl_hdr /ACCGO/E_SETTLEMENT_REF_GUID Reference GUID
ref_settl_cat /ACCGO/E_SETTL_CAT Document Category
mirror_stl_hdr /ACCGO/E_SETTLMT_MIRROR_GUID Settlemt Mirror GUID
underfill_amount /ACCGO/E_UNDERFILL_AMOUNT Underfill Amount
cparty_split /ACCGO/E_COUNTER_PARTY_SPLIT Counterparty Split
gm_ind_sent /ACCGO/E_GM_EVENT_IND Goods Mvt Event
po_amount /ACCGO/E_NET_AMT Net Amount
po_currency WAERS Currency
gl_amount /ACCGO/E_NET_AMT Net Amount
gl_currency WAERS Currency
delv_terms INCO1 Incoterms
inco2 INCO2 Incoterms 2
br_sd_rev_scenario /ACCGO/E_BR_SD_REV_SCEN Reversal Scenario
br_material_amount /ACCGO/E_NET_AMT Net Amount
br_mat_amount_curr WAERS Currency
br_mat_amnt_manual FLAG Indicator
lfsnr LFSNR Delivery note
br_nfnum LFSNR Delivery note
run_date DATUM Date
storage_start_date DATUM Date
storage_end_date DATUM Date
accrue_storage_fees /ACCGO/E_ACCRUE_STORAGE_FEE Accrue Storage
accrual_posting_date DATUM Date
accrual_reversal_date DATUM Date
accrual_gl_account /ACCGO/E_ACC_GL_ACNT Accrual G/L Account
accrual_rev_gl_account /ACCGO/E_ACC_REV_GL_ACNT Accrual Rev G/L Acnt
accrual_acct_doc_type BLART Document Type
accrual_act_doc_no /ACCGO/E_ACC_ACT_DOC_NO Document Number
accrual_rev_act_doc_no /ACCGO/E_ACC_REV_ACT_DOC_NO Rev Doc Number
accrual_fiscal_year GJAHR Fiscal Year
accrual_rev_fiscal_year GJAHR Fiscal Year
ref_appldoc /ACCGO/E_APPLDOC Appl. Document No.
ref_item /ACCGO/E_APPLDOC_ITEM_NUM Item No.
ref_side WLF_PR_SIDE Side
ref_sub_item /ACCGO/E_APPLDOC_ITEM_NUM Item No.
ref_vendor LIFNR Supplier
ref_payer LIFNR Supplier
ref_plant WERKS_D Plant
ref_strg_agreement /ACCGO/E_STOR_AGRMNT Stor. Agreement
ref_strg_agreement_item /ACCGO/E_STOR_AGRMNT Stor. Agreement
pstl_active /ACCGO/E_PSTL_ACTIVE GL Pr.STL.Active
effective_date DATS Date
fx_relevant /ACCGO/E_FX_RELEVANT FX Change relevant
rate_type KURST_CURR Exch. Rate Type
dpqs_in_settlement /ACCGO/E_DPQS_IN_SETTLEMENT DPQS in Settlement
isw_applied /ACCGO/E_ISW_USAGE Use ISW
dpqs_accruals_recalc BOOLE_D TRUE
ignore_dpqs /ACCGO/E_IGNORE_DPQS Ignore DPQS
final_si_fee_stl /ACCGO/E_FINAL_SI_FEE_STL Final SI Fee Settle
payout_percentag /ACCGO/E_PAYOUT_PERCENTAGE Prepmt Payout %
pp_abd_fi_number /ACCGO/E_PP_ABD_FI_NUMBER Prepmt Recov ABD
pp_abd_fi_item /ACCGO/E_PP_ABD_FI_ITEM Prepmt Recov DocItem
pp_abd_ff_type PPMGAG_E_POST_PR Settl Recvry Profile
pp_fisc_year GJAHR Fiscal Year
prepayment_percentage /ACCGO/E_PREPAYMENT_PERCENTAGE Prepayment Request %
prepayment_req_type /ACCGO/E_PPAG_REQ_TYPE PrepmtAgree RqstType
first_load /ACCGO/E_FIRST_LOAD First Load
stopinterestdate PPMGAG_E_STOP_INT_DATE Stop Interest Date
suspendfromdate PPMGAG_E_SUSP_FROM_DATE SuspendInterest From
suspendtodate PPMGAG_E_SUSP_TO_DATE Suspend Int Until
stop_interest_date /ACCGO/E_STOP_INT_DATE Stop Interest Date
prepaymentpostingprofile PPMGAG_E_POST_PR Settl Recvry Profile
created_by /ACCGO/E_CREATED_BY Created By
created_on /ACCGO/E_CREATED_ON Created On
changed_by /ACCGO/E_CHANGED_BY Changed By
changed_on /ACCGO/E_CHANGED_ON Changed On
stl_objnr J_OBJNR Object number

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.

-- Settlement header table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_STLHEAD (
    MANDT,                     -- Client [MANDT]
    STL_HEADER_GUID,           -- STL Hdr GUID [/ACCGO/E_SETTLEMENT_GUID]
    SETTL_DOC,                 -- Settlement Unit [/ACCGO/E_SETTL_DOC]
    SETTL_YR,                  -- Setl Unit Year [/ACCGO/E_SETTL_YR]
    APPL_GUID,                 -- Application GUID [/ACCGO/E_APPL_GUID]
    APPL_VERSION,              -- Application Version [/ACCGO/E_APPL_VERSION]
    DOC_TYP,                   -- CAS Document Type [/ACCGO/E_DOC_TYP]
    SETTL_CAT,                 -- Document Category [/ACCGO/E_SETTL_CAT]
    SETTL_SCENARIO,            -- Settl Scenario [/ACCGO/E_SETTL_SCENARIO]
    SETTL_TYPE,                -- Settlement Type [/ACCGO/E_STL_TYP]
    SIDE,                      -- Side [WLF_PR_SIDE]
    TKONN,                     -- Trading Contract [TKONN]
    TPOSN,                     -- Item Number [TPOSN]
    TPOSN_SUB,                 -- Subitem [TPOSN_SUB]
    TPOSN_COM,                 -- Com. item num. [WLF_TPOSN_COM]
    WBELN,                     -- ABD Number [/ACCGO/E_ABD_NUMBER]
    POSNR,                     -- ABD Item [/ACCGO/E_ABD_ITEM_NUMBER]
    NETWR,                     -- ABD Net Value [/ACCGO/E_ABD_VALUE]
    CANCL_GUID,                -- Contract GUID [/ACCGO/E_CNTRCT_GUID]
    OPERATION_ID,              -- Washout ID [/ACCGO/E_WASHOUT_ID]
    POST_DATE,                 -- Sett. Post Date [/ACCGO/E_POST_DATE]
    APPLDOC,                   -- Appl. Document No. [/ACCGO/E_APPLDOC]
    APPLDOC_ITEM,              -- Item No. [/ACCGO/E_APPLDOC_ITEM_NUM]
    KUNAG,                     -- Sold-to Party [KUNAG]
    KUNRG,                     -- Payer [KUNRG]
    KUNRE,                     -- Bill-to Party [KUNRE]
    LIFNR,                     -- Supplier [LIFNR]
    INVOICING_PARTY,           -- Supplier [LIFNR]
    MM_THRES,                  -- MM Threshold [/ACCGO/E_MM_THRES]
    SD_THRES,                  -- SD Threshold [/ACCGO/E_SD_THRES]
    LAND1,                     -- Country/Reg. [LAND1]
    Z_REGIO,                   -- Region [REGIO]
    PTERM,                     -- Payment Term [/ACCGO/E_PTERM]
    BUKRS,                     -- Company Code [BUKRS]
    PRCTR,                     -- Profit Center [PRCTR]
    WERKS,                     -- Plant [WERKS_D]
    GSBER,                     -- Business Area [GSBER]
    DOC_CURR,                  -- Currency [WAERS]
    DPQS_ADJ_AMT,              -- DPQS Adjustment Amt [/ACCGO/E_DPQS_ADJ_AMOUNT]
    GROSS_AMOUNT,              -- Gross Amount [/ACCGO/E_GROSS_AMT]
    NET_AMOUNT,                -- Net Amount [/ACCGO/E_NET_AMT]
    THRESHOLD_PERC,            -- Threshold Percentage [/ACCGO/E_THRESHOLD]
    SPLIT_FLAG,                -- Split Exists [/ACCGO/E_SPLIT_FLAG]
    LIEN_FLAG,                 -- Lien Exists [/ACCGO/E_LIEN_FLAG]
    ADJ_STL_HDR,               -- Adjustment GUID [/ACCGO/E_SETTLEMENT_ADJ_GUID]
    ARCONFIRM_FLAG,            -- AR Confirm? [/ACCGO/E_AR_CONFIRM]
    APCONFIRM_FLAG,            -- AP Confirm? [/ACCGO/E_AP_CONFIRM]
    REF_STL_HDR,               -- Reference GUID [/ACCGO/E_SETTLEMENT_REF_GUID]
    REF_SETTL_CAT,             -- Document Category [/ACCGO/E_SETTL_CAT]
    MIRROR_STL_HDR,            -- Settlemt Mirror GUID [/ACCGO/E_SETTLMT_MIRROR_GUID]
    UNDERFILL_AMOUNT,          -- Underfill Amount [/ACCGO/E_UNDERFILL_AMOUNT]
    CPARTY_SPLIT,              -- Counterparty Split [/ACCGO/E_COUNTER_PARTY_SPLIT]
    GM_IND_SENT,               -- Goods Mvt Event [/ACCGO/E_GM_EVENT_IND]
    PO_AMOUNT,                 -- Net Amount [/ACCGO/E_NET_AMT]
    PO_CURRENCY,               -- Currency [WAERS]
    GL_AMOUNT,                 -- Net Amount [/ACCGO/E_NET_AMT]
    GL_CURRENCY,               -- Currency [WAERS]
    DELV_TERMS,                -- Incoterms [INCO1]
    INCO2,                     -- Incoterms 2 [INCO2]
    BR_SD_REV_SCENARIO,        -- Reversal Scenario [/ACCGO/E_BR_SD_REV_SCEN]
    BR_MATERIAL_AMOUNT,        -- Net Amount [/ACCGO/E_NET_AMT]
    BR_MAT_AMOUNT_CURR,        -- Currency [WAERS]
    BR_MAT_AMNT_MANUAL,        -- Indicator [FLAG]
    LFSNR,                     -- Delivery note [LFSNR]
    BR_NFNUM,                  -- Delivery note [LFSNR]
    RUN_DATE,                  -- Date [DATUM]
    STORAGE_START_DATE,        -- Date [DATUM]
    STORAGE_END_DATE,          -- Date [DATUM]
    ACCRUE_STORAGE_FEES,       -- Accrue Storage [/ACCGO/E_ACCRUE_STORAGE_FEE]
    ACCRUAL_POSTING_DATE,      -- Date [DATUM]
    ACCRUAL_REVERSAL_DATE,     -- Date [DATUM]
    ACCRUAL_GL_ACCOUNT,        -- Accrual G/L Account [/ACCGO/E_ACC_GL_ACNT]
    ACCRUAL_REV_GL_ACCOUNT,    -- Accrual Rev G/L Acnt [/ACCGO/E_ACC_REV_GL_ACNT]
    ACCRUAL_ACCT_DOC_TYPE,     -- Document Type [BLART]
    ACCRUAL_ACT_DOC_NO,        -- Document Number [/ACCGO/E_ACC_ACT_DOC_NO]
    ACCRUAL_REV_ACT_DOC_NO,    -- Rev Doc Number [/ACCGO/E_ACC_REV_ACT_DOC_NO]
    ACCRUAL_FISCAL_YEAR,       -- Fiscal Year [GJAHR]
    ACCRUAL_REV_FISCAL_YEAR,   -- Fiscal Year [GJAHR]
    REF_APPLDOC,               -- Appl. Document No. [/ACCGO/E_APPLDOC]
    REF_ITEM,                  -- Item No. [/ACCGO/E_APPLDOC_ITEM_NUM]
    REF_SIDE,                  -- Side [WLF_PR_SIDE]
    REF_SUB_ITEM,              -- Item No. [/ACCGO/E_APPLDOC_ITEM_NUM]
    REF_VENDOR,                -- Supplier [LIFNR]
    REF_PAYER,                 -- Supplier [LIFNR]
    REF_PLANT,                 -- Plant [WERKS_D]
    REF_STRG_AGREEMENT,        -- Stor. Agreement [/ACCGO/E_STOR_AGRMNT]
    REF_STRG_AGREEMENT_ITEM,   -- Stor. Agreement [/ACCGO/E_STOR_AGRMNT]
    PSTL_ACTIVE,               -- GL Pr.STL.Active [/ACCGO/E_PSTL_ACTIVE]
    EFFECTIVE_DATE,            -- Date [DATS]
    FX_RELEVANT,               -- FX Change relevant [/ACCGO/E_FX_RELEVANT]
    RATE_TYPE,                 -- Exch. Rate Type [KURST_CURR]
    DPQS_IN_SETTLEMENT,        -- DPQS in Settlement [/ACCGO/E_DPQS_IN_SETTLEMENT]
    ISW_APPLIED,               -- Use ISW [/ACCGO/E_ISW_USAGE]
    DPQS_ACCRUALS_RECALC,      -- TRUE [BOOLE_D]
    IGNORE_DPQS,               -- Ignore DPQS [/ACCGO/E_IGNORE_DPQS]
    FINAL_SI_FEE_STL,          -- Final SI Fee Settle [/ACCGO/E_FINAL_SI_FEE_STL]
    PAYOUT_PERCENTAG,          -- Prepmt Payout % [/ACCGO/E_PAYOUT_PERCENTAGE]
    PP_ABD_FI_NUMBER,          -- Prepmt Recov ABD [/ACCGO/E_PP_ABD_FI_NUMBER]
    PP_ABD_FI_ITEM,            -- Prepmt Recov DocItem [/ACCGO/E_PP_ABD_FI_ITEM]
    PP_ABD_FF_TYPE,            -- Settl Recvry Profile [PPMGAG_E_POST_PR]
    PP_FISC_YEAR,              -- Fiscal Year [GJAHR]
    PREPAYMENT_PERCENTAGE,     -- Prepayment Request % [/ACCGO/E_PREPAYMENT_PERCENTAGE]
    PREPAYMENT_REQ_TYPE,       -- PrepmtAgree RqstType [/ACCGO/E_PPAG_REQ_TYPE]
    FIRST_LOAD,                -- First Load [/ACCGO/E_FIRST_LOAD]
    STOPINTERESTDATE,          -- Stop Interest Date [PPMGAG_E_STOP_INT_DATE]
    SUSPENDFROMDATE,           -- SuspendInterest From [PPMGAG_E_SUSP_FROM_DATE]
    SUSPENDTODATE,             -- Suspend Int Until [PPMGAG_E_SUSP_TO_DATE]
    STOP_INTEREST_DATE,        -- Stop Interest Date [/ACCGO/E_STOP_INT_DATE]
    PREPAYMENTPOSTINGPROFILE,  -- Settl Recvry Profile [PPMGAG_E_POST_PR]
    CREATED_BY,                -- Created By [/ACCGO/E_CREATED_BY]
    CREATED_ON,                -- Created On [/ACCGO/E_CREATED_ON]
    CHANGED_BY,                -- Changed By [/ACCGO/E_CHANGED_BY]
    CHANGED_ON,                -- Changed On [/ACCGO/E_CHANGED_ON]
    STL_OBJNR,                 -- Object number [J_OBJNR]
    PRIMARY KEY (MANDT, STL_HEADER_GUID)
);

Learn More