/ACCGO/T_GRP_HDR

Transparent Table Application Table
114 Fields 6 CDS Views

Settlement Group Header

/ACCGO/T_GRP_HDR is an SAP database table in S/4HANA. Settlement Group Header. It contains 114 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_ACMSettlementDocContainer view from BASIC ACM Settlement Document Container
I_ACMSettlementGroupHeaderData view from BASIC ACM Settlement Group Header Table Data
I_ACMSettlmtGrpHdrCostRevCkpt view_entity from BASIC Basic Entity for Settl Group Hdr for CRC
I_SettlementGroupHeader view from BASIC Interface Layer For Settlement Group Header
P_ACMTrdgContrToInvcLink view inner BASIC Contract Invoice Link
P_PPMGContrToInvoiceLink view inner BASIC Contract Invoice Link

Fields (114)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY guid /ACCGO/E_STL_GROUP_GUID Stl GRP GUID
group_id /ACCGO/E_STL_CTNR_ID Group ID
group_yr /ACCGO/E_STL_GRP_YR Grp Yr
settl_type /ACCGO/E_STL_TYP Settlement Type
doc_cat /ACCGO/E_SETTL_CAT Document Category
doc_typ /ACCGO/E_DOC_TYP CAS Document Type
counter_party /ACCGO/E_COUNTER_PARTY Counterparty
side WLF_PR_SIDE Side
doc_curr WAERS Currency
contract_type TCTYP Contract Type
net_amount /ACCGO/E_NET_AMT Net Amount
inv_gross_amt /ACCGO/E_GROSS_AMT Gross Amount
amt_currency WAERS Currency
tax_amount /ACCGO/E_TAX_AMT Tax Amount
tax_amt_currency WAERS Currency
image_doc_num /ACCGO/E_IMAGE_DOC_NUM Image Document Numb.
vend_inv_num /ACCGO/E_VEND_INV_NUM Vendor Invoice Num
vend_inv_date /ACCGO/E_VEND_INV_DATE Vendor Invoice Date
delv_terms INCO1 Incoterms
inco2 INCO2 Incoterms 2
pterm /ACCGO/E_PTERM Payment Term
pmnt_method DZLSCH Pymt Meth.
alt_pterm /ACCGO/E_ALT_PTERM Alt. Pay.Term
alt_pdate /ACCGO/E_ALT_PDATE Alt. Payment Date
alt_ptype /ACCGO/E_ALT_PTYPE Alt. Payment Type
alt_pmnt_status /ACCGO/E_PMT_STATUS Deferred Payment
company_code BUKRS Company Code
profit_center PRCTR Profit Center
lifnr LIFNR Supplier
invoicing_party LIFNR Supplier
bankn BANKN Bank Account
date_issued DATUM Date
check_number /ACCGO/E_CHECK_NUMBER Check Number
check_amount /ACCGO/E_CHECK_AMOUNT Check Amount
check_curr WAERS Currency
house_bank_id /ACCGO/E_HOUSE_BANK_ID House Bank ID
abd_number WBELN_AG Document Number
settl_scenario /ACCGO/E_SETTL_SCENARIO Settl Scenario
follow_doc /ACCGO/E_INVOICE_DOCUMENT_1 Invoice Doc Num 1
follow_doc_year /ACCGO/E_INVOICE_YEAR_1 Invoice Doc Year 1
follow_doc_type /ACCGO/E_INVOICE_DOC_TYPE_1 Invoice Doc Type 1
follow_doc1 /ACCGO/E_INVOICE_DOCUMENT_2 Invoice Doc Num 2
follow_doc1_year /ACCGO/E_INVOICE_YEAR_2 Invoice Doc Year 2
follow_doc1_type /ACCGO/E_INVOICE_DOC_TYPE_2 Invoice Doc Type 2
gl_account_doc1 /ACCGO/E_INVOICE_DOCUMENT_3 Invoice Doc Num 3
gl_account_year1 /ACCGO/E_INVOICE_YEAR_3 Invoice Doc Year 3
gl_account_type1 /ACCGO/E_INVOICE_DOC_TYPE_3 Invoice Doc Type 3
gl_account_doc2 /ACCGO/E_INVOICE_DOCUMENT_4 Invoice Doc Num 4
gl_account_year2 /ACCGO/E_INVOICE_YEAR_4 Invoice Doc Year 4
gl_account_type2 /ACCGO/E_INVOICE_DOC_TYPE_4 Invoice Doc Type 4
invoice_status /ACCGO/E_INV_STATUS Invoice Status
payspt_accdoc_no /ACCGO/E_PAYSPT_ACCDOC Payment Split AccNo.
payspt_accdoc_yr /ACCGO/E_PAYSPT_ACCYR Payment Split AccYr
mirror_sg_guid /ACCGO/E_MIRROR_STL_GRP_GUID Mirror Stl Grp Guid
kunnr KUNNR Customer
quantity_upd_ind /ACCGO/E_QTY_UPD Qty Upd
translation_date WWERT_D Translatn Date
deleted BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
last_lien_update /ACCGO/E_LIEN_UPDATE_ON Last Lien Update
last_lien_upd_by /ACCGO/E_CHANGED_BY Changed By
werks WERKS_D Plant
abd_db_cr_ind /ACCGO/E_ABD_DEBIT_CREDIT_IND C/D Indicator
block_fi_posting_of_abd BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
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
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
pstl_active /ACCGO/E_PSTL_ACTIVE GL Pr.STL.Active
fx_relevant /ACCGO/E_FX_RELEVANT FX Change relevant
stop_settlement /ACCGO/E_STOP_SETT_RELEASE Stop Settlement
overfill_status /ACCGO/E_OVERFILL_INDICATOR Automatic/ Manual
ignore_dpqs /ACCGO/E_IGNORE_DPQS Ignore DPQS
final_si_fee_stl /ACCGO/E_FINAL_SI_FEE_STL Final SI Fee Settle
threshold_perc /ACCGO/E_THRESHOLD Threshold Percentage
th_copied_status BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
payout_percentag /ACCGO/E_PAYOUT_PERCENTAGE Prepmt Payout %
pp_abd_fi_number /ACCGO/E_PP_ABD_FI_NUMBER Prepmt Recov ABD
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
payout_copied_status BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
prpcnt_copied_status BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
ppr_abd_number /ACCGO/E_PPR_ABD_NUMBER Prepmt Req Rec ABD
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
interest_data_copied_status /ACCGO/E_INTDAT_COPIED_STATUS IntDataCopiedStatus
ppa_rec_abd_cp_source /ACCGO/E_PPA_REC_ABD_CP_SOURCE Ctrprty Source
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
counter_party_approve /ACCGO/E_COUNTER_PARTY_APPROVE Counter Party
counter_party_review /ACCGO/E_COUNTER_PARTY_REVIEW Counter Party Review
reason_code /ACCGO/E_RSN_CODE Reason Code
stop_stl_by_countr_prty /ACCGO/E_STOP_STL Counter Party
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 Group Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_GRP_HDR (
    MANDT,                        -- Client [MANDT]
    GUID,                         -- Stl GRP GUID [/ACCGO/E_STL_GROUP_GUID]
    GROUP_ID,                     -- Group ID [/ACCGO/E_STL_CTNR_ID]
    GROUP_YR,                     -- Grp Yr [/ACCGO/E_STL_GRP_YR]
    SETTL_TYPE,                   -- Settlement Type [/ACCGO/E_STL_TYP]
    DOC_CAT,                      -- Document Category [/ACCGO/E_SETTL_CAT]
    DOC_TYP,                      -- CAS Document Type [/ACCGO/E_DOC_TYP]
    COUNTER_PARTY,                -- Counterparty [/ACCGO/E_COUNTER_PARTY]
    SIDE,                         -- Side [WLF_PR_SIDE]
    DOC_CURR,                     -- Currency [WAERS]
    CONTRACT_TYPE,                -- Contract Type [TCTYP]
    NET_AMOUNT,                   -- Net Amount [/ACCGO/E_NET_AMT]
    INV_GROSS_AMT,                -- Gross Amount [/ACCGO/E_GROSS_AMT]
    AMT_CURRENCY,                 -- Currency [WAERS]
    TAX_AMOUNT,                   -- Tax Amount [/ACCGO/E_TAX_AMT]
    TAX_AMT_CURRENCY,             -- Currency [WAERS]
    IMAGE_DOC_NUM,                -- Image Document Numb. [/ACCGO/E_IMAGE_DOC_NUM]
    VEND_INV_NUM,                 -- Vendor Invoice Num [/ACCGO/E_VEND_INV_NUM]
    VEND_INV_DATE,                -- Vendor Invoice Date [/ACCGO/E_VEND_INV_DATE]
    DELV_TERMS,                   -- Incoterms [INCO1]
    INCO2,                        -- Incoterms 2 [INCO2]
    PTERM,                        -- Payment Term [/ACCGO/E_PTERM]
    PMNT_METHOD,                  -- Pymt Meth. [DZLSCH]
    ALT_PTERM,                    -- Alt. Pay.Term [/ACCGO/E_ALT_PTERM]
    ALT_PDATE,                    -- Alt. Payment Date [/ACCGO/E_ALT_PDATE]
    ALT_PTYPE,                    -- Alt. Payment Type [/ACCGO/E_ALT_PTYPE]
    ALT_PMNT_STATUS,              -- Deferred Payment [/ACCGO/E_PMT_STATUS]
    COMPANY_CODE,                 -- Company Code [BUKRS]
    PROFIT_CENTER,                -- Profit Center [PRCTR]
    LIFNR,                        -- Supplier [LIFNR]
    INVOICING_PARTY,              -- Supplier [LIFNR]
    BANKN,                        -- Bank Account [BANKN]
    DATE_ISSUED,                  -- Date [DATUM]
    CHECK_NUMBER,                 -- Check Number [/ACCGO/E_CHECK_NUMBER]
    CHECK_AMOUNT,                 -- Check Amount [/ACCGO/E_CHECK_AMOUNT]
    CHECK_CURR,                   -- Currency [WAERS]
    HOUSE_BANK_ID,                -- House Bank ID [/ACCGO/E_HOUSE_BANK_ID]
    ABD_NUMBER,                   -- Document Number [WBELN_AG]
    SETTL_SCENARIO,               -- Settl Scenario [/ACCGO/E_SETTL_SCENARIO]
    FOLLOW_DOC,                   -- Invoice Doc Num 1 [/ACCGO/E_INVOICE_DOCUMENT_1]
    FOLLOW_DOC_YEAR,              -- Invoice Doc Year 1 [/ACCGO/E_INVOICE_YEAR_1]
    FOLLOW_DOC_TYPE,              -- Invoice Doc Type 1 [/ACCGO/E_INVOICE_DOC_TYPE_1]
    FOLLOW_DOC1,                  -- Invoice Doc Num 2 [/ACCGO/E_INVOICE_DOCUMENT_2]
    FOLLOW_DOC1_YEAR,             -- Invoice Doc Year 2 [/ACCGO/E_INVOICE_YEAR_2]
    FOLLOW_DOC1_TYPE,             -- Invoice Doc Type 2 [/ACCGO/E_INVOICE_DOC_TYPE_2]
    GL_ACCOUNT_DOC1,              -- Invoice Doc Num 3 [/ACCGO/E_INVOICE_DOCUMENT_3]
    GL_ACCOUNT_YEAR1,             -- Invoice Doc Year 3 [/ACCGO/E_INVOICE_YEAR_3]
    GL_ACCOUNT_TYPE1,             -- Invoice Doc Type 3 [/ACCGO/E_INVOICE_DOC_TYPE_3]
    GL_ACCOUNT_DOC2,              -- Invoice Doc Num 4 [/ACCGO/E_INVOICE_DOCUMENT_4]
    GL_ACCOUNT_YEAR2,             -- Invoice Doc Year 4 [/ACCGO/E_INVOICE_YEAR_4]
    GL_ACCOUNT_TYPE2,             -- Invoice Doc Type 4 [/ACCGO/E_INVOICE_DOC_TYPE_4]
    INVOICE_STATUS,               -- Invoice Status [/ACCGO/E_INV_STATUS]
    PAYSPT_ACCDOC_NO,             -- Payment Split AccNo. [/ACCGO/E_PAYSPT_ACCDOC]
    PAYSPT_ACCDOC_YR,             -- Payment Split AccYr [/ACCGO/E_PAYSPT_ACCYR]
    MIRROR_SG_GUID,               -- Mirror Stl Grp Guid [/ACCGO/E_MIRROR_STL_GRP_GUID]
    KUNNR,                        -- Customer [KUNNR]
    QUANTITY_UPD_IND,             -- Qty Upd [/ACCGO/E_QTY_UPD]
    TRANSLATION_DATE,             -- Translatn Date [WWERT_D]
    DELETED,                      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    LAST_LIEN_UPDATE,             -- Last Lien Update [/ACCGO/E_LIEN_UPDATE_ON]
    LAST_LIEN_UPD_BY,             -- Changed By [/ACCGO/E_CHANGED_BY]
    WERKS,                        -- Plant [WERKS_D]
    ABD_DB_CR_IND,                -- C/D Indicator [/ACCGO/E_ABD_DEBIT_CREDIT_IND]
    BLOCK_FI_POSTING_OF_ABD,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    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]
    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]
    PSTL_ACTIVE,                  -- GL Pr.STL.Active [/ACCGO/E_PSTL_ACTIVE]
    FX_RELEVANT,                  -- FX Change relevant [/ACCGO/E_FX_RELEVANT]
    STOP_SETTLEMENT,              -- Stop Settlement [/ACCGO/E_STOP_SETT_RELEASE]
    OVERFILL_STATUS,              -- Automatic/ Manual [/ACCGO/E_OVERFILL_INDICATOR]
    IGNORE_DPQS,                  -- Ignore DPQS [/ACCGO/E_IGNORE_DPQS]
    FINAL_SI_FEE_STL,             -- Final SI Fee Settle [/ACCGO/E_FINAL_SI_FEE_STL]
    THRESHOLD_PERC,               -- Threshold Percentage [/ACCGO/E_THRESHOLD]
    TH_COPIED_STATUS,             -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PAYOUT_PERCENTAG,             -- Prepmt Payout % [/ACCGO/E_PAYOUT_PERCENTAGE]
    PP_ABD_FI_NUMBER,             -- Prepmt Recov ABD [/ACCGO/E_PP_ABD_FI_NUMBER]
    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]
    PAYOUT_COPIED_STATUS,         -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PRPCNT_COPIED_STATUS,         -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PPR_ABD_NUMBER,               -- Prepmt Req Rec ABD [/ACCGO/E_PPR_ABD_NUMBER]
    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]
    INTEREST_DATA_COPIED_STATUS,  -- IntDataCopiedStatus [/ACCGO/E_INTDAT_COPIED_STATUS]
    PPA_REC_ABD_CP_SOURCE,        -- Ctrprty Source [/ACCGO/E_PPA_REC_ABD_CP_SOURCE]
    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]
    COUNTER_PARTY_APPROVE,        -- Counter Party [/ACCGO/E_COUNTER_PARTY_APPROVE]
    COUNTER_PARTY_REVIEW,         -- Counter Party Review [/ACCGO/E_COUNTER_PARTY_REVIEW]
    REASON_CODE,                  -- Reason Code [/ACCGO/E_RSN_CODE]
    STOP_STL_BY_COUNTR_PRTY,      -- Counter Party [/ACCGO/E_STOP_STL]
    STL_OBJNR,                    -- Object number [J_OBJNR]
    PRIMARY KEY (MANDT, GUID)
);

Learn More