DB_WBRK_WBRL
Generated Table for View
DB_WBRK_WBRL is an SAP database table in S/4HANA. Generated Table for View. It contains 250 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| wlf_cds_db_wbrk_wbrl | view | from | CDS-View on DB-View DB_WBRK_WBRL |
Fields (250)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | wbeln | WBELN_AG | Document Number | |||
| KEY | lfart | WFART | Sett. Doc. Type | |||
| KEY | lftyp | WFTYP | Sett. Doc. Cat. | |||
| KEY | wrart | WRART | Settl Proc Type | |||
| KEY | wbtyp | WBTYP | Sett. Pro. Cat. | |||
| KEY | wrtyp | WRTYP | Entry Category | |||
| KEY | abart | NAFKT | Settl. Category | |||
| KEY | kalsm | KALSM_D | Procedure | |||
| KEY | kalsmd | KALSM_D | Procedure | |||
| KEY | wfdat | WFDAT | Posting Date | |||
| KEY | rfbsk | WFBSK | Posting Status | |||
| KEY | lifre | LIFRE | Invoicing Party | |||
| KEY | lnrzb | W_LIFZE | Payee | |||
| KEY | kunre | KUNRE | Bill-to Party | |||
| KEY | kunrg | KUNRG | Payer | |||
| KEY | ekorg | EKORG | Purchasing Org. | |||
| KEY | vkorg | VKORG | Sales Org. | |||
| KEY | vtweg | VTWEG | Distr. Channel | |||
| KEY | spart | SPART | Division | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | erzet | WLF_ERZEIT | Created At | |||
| KEY | erdat | ERDAT | Created On | |||
| KEY | ernam | ERNAM | Created By | |||
| KEY | aedat | AEDAT | Changed On | |||
| KEY | bldat | WLF_DOCUMENT_DATE | Document Date | |||
| KEY | xblnr | XBLNR1 | Reference | |||
| KEY | zuonr | DZUONR | Assignment | |||
| KEY | waerl | WAERL | Doc. Currency | |||
| KEY | wstwae | WSTWAE | Stats Currency | |||
| KEY | wkurs | UKURS_CURR | Exchange Rate | |||
| KEY | stcur | STCUR | Exch.rate stats | |||
| KEY | kufix | WKUFIX | Exch.Rate Fixed | |||
| KEY | wkurs_dat | WLF_EXCHG_RATE_DATE | Exch. Rate Date | |||
| KEY | brtwr | BRTWR_LF | Gross Amount | |||
| KEY | zterm | DZTERM | Pyt Terms | |||
| KEY | zbd1t | DZBDET | Payment in | |||
| KEY | zbd1p | DZBD1P | CD Percentage 1 | |||
| KEY | zbd2t | DZBD2T | Days 2 | |||
| KEY | zbd2p | DZBD2P | CD Percentage 2 | |||
| KEY | zbd3t | DZBD3T | Days Net | |||
| KEY | zlsch | DZLSCH | Pymt Meth. | |||
| KEY | netwr | NETWR_LF | Net Amount | |||
| KEY | netwrd | NETWRD_LF | Net Amount | |||
| KEY | brtwrd | BRTWRD_LF | Gross Amount | |||
| KEY | ztermd | WZTERMD | Cust PayTrms | |||
| KEY | zbd1td | WZBD1TD | Payment in | |||
| KEY | zbd1pd | WZBD1PD | Cash Discount 1 | |||
| KEY | zbd2td | WZBD2TD | Payment in | |||
| KEY | zbd2pd | WZBD2PD | Cash discount 2 | |||
| KEY | zbd3td | WZBD3TD | Payment in | |||
| KEY | zlschd | SCHZW_BSEGD | Cust Pmt Method | |||
| KEY | gsktod | SKFBP | Csh.Disc.Bas | |||
| KEY | gskto | SKFBP | Csh.Disc.Bas | |||
| KEY | fksto | WLF_FKSTO | Doc. Reversed | |||
| KEY | kappl | KAPPL | Application | |||
| KEY | knumv | KNUMV | Doc. Condition | |||
| KEY | knumvd | KNUMV | Doc. Condition | |||
| KEY | stafo | STAFO | Update Group | |||
| KEY | lfaks | LFAKS | Reversed Document | |||
| KEY | knuma | KNUMA | Agreement | |||
| KEY | lfart_rl | WFART_RL | SttDoc Type SDL | |||
| KEY | wfdat_rl | WFDAT_RL | Posting Date | |||
| KEY | wbeln_rl | WBELN_RL | Sett. Doc. List | |||
| KEY | ekgrp | EKGRP | Purch. Group | |||
| KEY | valtg | WVALTG | Add.Value Days | |||
| KEY | valdt | WVALDT | Fixed Val.Date | |||
| KEY | mwsbk | MWSBP | Tax Amount | |||
| KEY | mwsbkd | MWSBPD | Tax Amount | |||
| KEY | navnk | NAVNW | Non-deductible | |||
| KEY | logsys | LOGSYS | Logical system | |||
| KEY | diekz | DIEKZ | Service Ind. | |||
| KEY | landl | LANDL | Supply C/R | |||
| KEY | lzbkz | LZBKZ | SCB Ind. | |||
| KEY | kkber | KKBER | Cred.Contr.Area | |||
| KEY | lfgru | WFGRU | Activity Reason | |||
| KEY | valtgd | WVALTD | Add.Value Days | |||
| KEY | valdtd | WVALDD | Fixed Val.Date | |||
| KEY | kidno | KIDNO | Payment Ref. | |||
| KEY | wdtyp | DOCTYPE | Doc. Category | |||
| KEY | wkurs_p1 | WKURS_P1 | Exchange Rate | |||
| KEY | wkurs_p2 | WKURS_P2 | Exch. Rate | |||
| KEY | wpycur_p1 | WPYCUR_P1 | Payt Currency | |||
| KEY | wpycur_p2 | WPYCUR_P2 | Payt Currency | |||
| KEY | estatus | WSTATE | Appl. Status | |||
| KEY | kurst | KURST | Exch. Rate Type | |||
| KEY | vkbur | VKBUR | Sales Office | |||
| KEY | vkgrp | VKGRP | Sales Group | |||
| KEY | settle_doc | WLF_EXP_SETTLE_DOC | Settlement Doc. | |||
| KEY | fksto_part | WLF_FKSTO_PART | Partial Revrsl | |||
| KEY | post_party | WLF_POST_PARTY | Posting Partner | |||
| KEY | cpdk_addr | WLF_CPDK_ADDR | OTC Address | |||
| KEY | fksto_party | WLF_FKSTO_PARTY | Reversed Partner | |||
| KEY | contract | WCONTRACT | Contract | |||
| KEY | contract_type | WCONTRACT_TYPE | Contract Cat. | |||
| KEY | collection_type | WCOLLECTION | Summarization | |||
| KEY | cmwae | WAERS_CM | Currency | |||
| KEY | ctlpc | CTLPC_CM | Risk Category | |||
| KEY | cm_amount | AMTBL_CM | Credit Value | |||
| KEY | settle_category | WSETTLE_CATEGORY | Classification Cat. | |||
| KEY | idobj_type_v | WLF_IDOBJ_TYPE_VENDOR | ID ObjType Supp | |||
| KEY | idobj_vendor | WLF_IDOBJ_VENDOR | ID-Object Supplier | |||
| KEY | idobj_type_c | WLF_IDOBJ_TYPE_CUSTOMER | ID ObjType Cust | |||
| KEY | idobj_customer | WLF_IDOBJ_CUSTOMER | ID-Object Customer | |||
| KEY | posting_rule_k | WLF_POSTING_RULE_K | Suppl. PostRule | |||
| KEY | posting_rule_d | WLF_POSTING_RULE_D | Cust. PostRule | |||
| KEY | posting_rule_a | WLF_POSTING_RULE_A | Spec. Post.Rule | |||
| KEY | vkont | CORR_VKONT_KK | Contract Acct | |||
| KEY | vkont_k | CORR_VKONT_KK | Contract Acct | |||
| KEY | wt_active | WLF_WITHHOLDING_TAX_ACTIVE | Withholding Tax Act | |||
| KEY | bukrs_deb | WLF_BUKRS_CUSTOMER_REGU | Cust. Company Code | |||
| KEY | settl_party | WLF_SETTLEMENT_PARTY | Settlmt Part Cat | |||
| KEY | settl_status_v | WLF_SETTLEMENT_STATUS_V | Settl. Status Supp. | |||
| KEY | settl_status_c | WLF_SETTLEMENT_STATUS_C | Settl. Status Cust. | |||
| KEY | settl_doctype_v | WLF_SETTLEMENT_DOCTYPE_V | Doc. Type - Suppl. | |||
| KEY | settl_doctype_c | WLF_SETTLEMENT_DOCTYPE_C | Settlmt Doc Type | |||
| KEY | settl_method | WLF_SETTLEMENT_METHOD | Settlement Procedure | |||
| KEY | settl_block_v | WLF_SETTLEMENT_BLOCK_V | Supplier Settlement Blocking Reason | |||
| KEY | settl_block_c | WLF_SETTLEMENT_BLOCK_C | Customer Settlement Blocking Reason | |||
| KEY | cpdl_addr | WLF_CPDL_ADDR | OTS Address | |||
| KEY | monat | MONAT | Period | |||
| KEY | output_control_is_active | WLF_OUTPUT_CONTROL_IS_ACTIVE | Output Control | |||
| KEY | _dataaging | DATA_TEMPERATURE | Data Aging | |||
| KEY | pernr | PERNR_D | Personnel No. | |||
| KEY | status_group | WSTATG | Status Group | |||
| KEY | jrnl_entr_crtn_dte_utc | WLF_JOURNAL_ENTRY_CRTN_DTE_UTC | Journal Entry Creation Date | |||
| KEY | jrnl_entr_crtn_tme_utc | WLF_JOURNAL_ENTRY_CRTN_TME_UTC | Journal Entry Creation Time | |||
| KEY | settlmt_compn_rsn | WLF_COMPN_RSN | Compensation Reason | |||
| KEY | entity_tag | WLF_ENTITY_TAG | Entity Tag | |||
| KEY | pers_kostl | WLF_PERS_KOSTL | Worker Cost Center | |||
| KEY | pers_kokrs | WLF_PERS_KOKRS | Worker Controlling Area | |||
| KEY | txkrs | WLF_TXKRS | Tax Exchange_Rate | |||
| KEY | txkrs_ic | WLF_TXKRS_IC | Tax Exchange_Rate Intercompany Posting | |||
| KEY | ctxkrs | WLF_CTXKRS | Tax ExRate Rept.Ctry/Reg | |||
| KEY | ctxkrs_ic | WLF_CTXKRS_IC | Tax Exchange Rate Reporting Ctry/Reg. IC | |||
| KEY | ldgrp | FAGL_LDGRP | Ledger Group | |||
| KEY | compn_variant | WLF_COMPN_VARIANT | Compensation Variant | |||
| KEY | visibility_group | WLF_APP_VIS_GRP | Element Behavior Group | |||
| KEY | hxf_btt_code | WLF_FOT_HXF_BTT_CODE | Curr.Transl. Fact. Bus. Trans. Type Code | |||
| KEY | authorization_category | WLF_AUTHORIZATION_CATEGORY | Authorization Cat. | |||
| KEY | lfart_switched_neg | WLF_LFART_SWITCHED_NEGATIVE | Doc. Type Switched | |||
| KEY | dummy_wbrk_incl_eew_ps | WBRK_INCL_EEW | Dummy | |||
| KEY | servconf_id | FSL_SERVCONF_ID | CRM ConfID | |||
| KEY | counter | FSL_COUNTER | Counter Reading | |||
| KEY | counter_unit | FSL_UNIT | Unit of Measure | |||
| KEY | exp_class | WB2_EXPENSE_CLASS | Expense Class | |||
| KEY | exp_calc_type | WB2_EXPENSE_CALC_TYPE | CalculationType | |||
| KEY | doc_settled | WB2_EXP_DOCUMENT_SETTLED | Doc. Settled | |||
| KEY | ref_value_ref | WB2_EXPENSE_REF_VALUE_REF | Unit | |||
| KEY | ref_value | WB2_EXPENSE_REFERENCE_VALUE | Reference Value | |||
| KEY | post_type | WB2_EXPENSE_POSTING_TYPE | Posting Cat. | |||
| KEY | tew_type | WB2_TEW_TYPE | TEW Type | |||
| KEY | step | WB2_STEP | Step | |||
| KEY | partner_exp | PRQ_PARNO | Business partner | |||
| KEY | step_from | WB2_STEP | Step | |||
| KEY | step_tew | WB2_STEP | Step | |||
| KEY | mode | WB2_MODE | Mode | |||
| KEY | partner_exp_type | WB2_PARTNER_EXP_TYPE | Partner | |||
| KEY | iv_check_type_h | WLF_IV_CHECK_TYPE_HEAD | Check Type(Header) | |||
| KEY | iv_accr | WLF_IV_ACCRUAL | Accrual | |||
| KEY | rrlcg | RRLCG | SttDocList Type | |||
| KEY | rrlpa | RRLPA | SDL Partner | |||
| KEY | contr_type | WCB_CONTRACT_TYPE | Contract Type | |||
| KEY | settl_date_type | WB2_SETTLEMENT_DATE_TYPE | Settlement Date Type | |||
| KEY | act_settl_date | WB2_ACTUAL_SETTLEMENT_DATE | Actual Settl. Date | |||
| KEY | settl_date_seq_id | WB2_SETTLEMENT_DATE_SEQ_ID | Settlement Date ID | |||
| KEY | settl_start_date | WB2_SETTLEMENT_START_DATE | Start Date of Period | |||
| KEY | total_menge | WB2_TOTAL_MENGE | Total Quantity | |||
| KEY | total_wfkme | WB2_TOTAL_WFKME | UoM Total Quantity | |||
| KEY | total_ntgew | WB2_TOTAL_NTGEW | Total Net Weight | |||
| KEY | total_brgew | WB2_TOTAL_BRGEW | Total Gross Weight | |||
| KEY | total_gewei | WB2_TOTAL_GEWEI | UoW Total Weight | |||
| KEY | total_volum | WB2_TOTAL_VOLUM | Total Volume | |||
| KEY | total_voleh | WB2_TOTAL_VOLEH | Unit Total Volume | |||
| KEY | total_anzpu | WB2_TOTAL_ANZPU | Total Points | |||
| KEY | total_punei | WB2_TOTAL_PUNEI | Unit Total Points | |||
| KEY | process_variant | WCB_PROCESS_VARIANT | Process Variant | |||
| KEY | process_category | WCB_PROCESS_CATEGORY | Process Category | |||
| KEY | deviating_settl_item | WB2_DEVIATING_SETTL_ITEM | Dev. Settl Data Item | |||
| KEY | settl_variant | WB2_SETTLEMENT_VARIANT | Settlement Variant | |||
| KEY | contr_settl_doc_cat | WB2_CONTR_SETTL_DOC_CAT | Document Category | |||
| KEY | corr_document | WLF_CORR_DOCUMENT | Adjustment Doc. | |||
| KEY | incomp_reason | WLF_INCOMPLETENESS_REASON | Incomplete Rsn | |||
| KEY | lifnr_fi | WLF_LIFNR_FI | Alternative Supplier | |||
| KEY | distrib_incomp | WLF_DISTRIBUTION_INCOMPLETE | Distrib. Incomplete | |||
| KEY | rfbsk_comb_sett | WLF_RFBSK_COMBINED_SETTLEMENT | Posting Status 2 | |||
| KEY | no_text_h | WLF_NO_TEXT | No Texts Exist | |||
| KEY | intrastat_rel | WLF_INTRASTAT_RELEVANT | Intrastat Rel. | |||
| KEY | landtx | WLF_D_LANDTX | Tx Dep Ctry/Reg | |||
| KEY | land1tx | WLF_D_LAND1TX | Tx Des Ctry/Reg | |||
| KEY | xegdr | XEGDR | EU Triang. Deal | |||
| KEY | stceg | WLF_SUPLR_STCEG | Supp.VATReg.No. | |||
| KEY | stcegd | WLF_CUST_STCEG | Cust.VATReg.No. | |||
| KEY | intrastat_flow_d | WLF_INTRASTAT_FLOW_DOC | Goods Flow | |||
| KEY | service_indicator | WLF_SERVICE_INDICATOR | Service Indicator | |||
| KEY | inco1 | INCO1 | Incoterms | |||
| KEY | inco2 | INCO2 | Incoterms 2 | |||
| KEY | incov | INCOV | Inco. Version | |||
| KEY | inco2_l | INCO2_L | Inco. Location1 | |||
| KEY | inco3_l | INCO3_L | Inco. Location2 | |||
| KEY | wkurs_deb | WLF_WKURS_CUSTOMER | Exch.Rate Customer | |||
| KEY | settlement_date | WB2_SETTLEMENT_DATE | Settlement Date | |||
| KEY | process_type | WLF_PROCESS_TYPE | Proc. Category | |||
| KEY | bank_data | WLF_BANK_DATA | Bank Data | |||
| KEY | coll_status | WLF_COLLECTION_STATUS | Collective Settlement Status | |||
| KEY | is_collection | WLF_IS_COLLECTION | Document is Collective Document | |||
| KEY | coll_block | WLF_COLLECTION_BLOCK | Collective Settlement Blocking Reason | |||
| KEY | ref_settl_date | WLF_REFERENCE_SETTLEMENT_DATE | Reference Date | |||
| KEY | landtx_bukrs | WLF_LANDTX_BUKRS | Tax Ctry/Reg. CoCode | |||
| KEY | landtx_bukrs_deb | WLF_LANDTX_BUKRS_DEB | Tax C/R CoCode Cust. | |||
| KEY | use_case | WLF_USE_CASE_TYPE | Use Case Type | |||
| KEY | use_case_guid | WLF_USE_CASE_GUID | Use Case GUID | |||
| KEY | invoice_id | WLF_BTD_ID | Ext. Invoice ID | |||
| KEY | scheme_id | WLF_SCHEME_ID | Scheme | |||
| KEY | scheme_a_id | WLF_SCHEME_A_ID | Scheme ID | |||
| KEY | agency_id_code | WLF_AGENCY_ID_CODE | Agency ID | |||
| KEY | itcup | ITCUP | CUP Code | |||
| KEY | itcig | ITCUG | CIG Code | |||
| KEY | mndid | SEPA_MNDID | Mandate Ref. | |||
| KEY | posnr | WPOSNR_RL | Item | |||
| wbeln_lf | WBELN_LF | Document | ||||
| mwsbp | MWSBPK | Tax Amount | ||||
| navnw | NAVNW | Non-deductible | ||||
| kwert_rl | WKWERT_RL | SDoc List Value | ||||
| mwsbp_rl | WMWSBP_RL | SDListCond Tax | ||||
| wdtyp_l | DOCTYPE_L | List Doc. Cat. | ||||
| wdtyp_li | DOCTYPE_LI | Doc. Cat of List Itm | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| gjahr | GJAHR | Fiscal Year | ||||
| ext_doc_nr | WLF_FOREIGN_DOC_NUMBER | External Doc ID | ||||
| ext_doc_year | WLF_FOREIGN_DOC_YEAR | External Doc Year | ||||
| ext_doc_bukrs | WLF_FOREIGN_DOC_BUKRS | External Doc CoCode | ||||
| ext_doc_item | WLF_FOREIGN_DOC_ITEM_NUMBER | External Doc. Item | ||||
| fbuda_li | FBUDA | Serv. Rend. Dte | ||||
| bupla | BUPLA | Business place | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| kowrr | WKOWRR | Item Control | ||||
| lfgru_li | WFGRU | Activity Reason | ||||
| dummy_wbrl_incl_eew_ps | WBRL_INCL_EEW | Dummy | ||||
| fksto_li | WLF_FKSTO_LIST_ITEM | Reversed | ||||
| wuvprs | WUVPRS | Incomp. Pricing | ||||
| netwr_lp | NETWR_RL | Net Value | ||||
| lifre_lp | LIFRE | Invoicing Party | ||||
| lnrzb_lp | W_LIFZE | Payee | ||||
| kunre_lp | KUNRE | Bill-to Party | ||||
| kunrg_lp | KUNRG | Payer | ||||
| lftyp_lp | WFTYP | Sett. Doc. Cat. | ||||
| logsys_lp | LOGSYS | Logical system | ||||
| dataaging_lp | DATA_TEMPERATURE | Data Aging |
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.
-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DB_WBRK_WBRL (
MANDT, -- Client [MANDT]
WBELN, -- Document Number [WBELN_AG]
LFART, -- Sett. Doc. Type [WFART]
LFTYP, -- Sett. Doc. Cat. [WFTYP]
WRART, -- Settl Proc Type [WRART]
WBTYP, -- Sett. Pro. Cat. [WBTYP]
WRTYP, -- Entry Category [WRTYP]
ABART, -- Settl. Category [NAFKT]
KALSM, -- Procedure [KALSM_D]
KALSMD, -- Procedure [KALSM_D]
WFDAT, -- Posting Date [WFDAT]
RFBSK, -- Posting Status [WFBSK]
LIFRE, -- Invoicing Party [LIFRE]
LNRZB, -- Payee [W_LIFZE]
KUNRE, -- Bill-to Party [KUNRE]
KUNRG, -- Payer [KUNRG]
EKORG, -- Purchasing Org. [EKORG]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
BUKRS, -- Company Code [BUKRS]
ERZET, -- Created At [WLF_ERZEIT]
ERDAT, -- Created On [ERDAT]
ERNAM, -- Created By [ERNAM]
AEDAT, -- Changed On [AEDAT]
BLDAT, -- Document Date [WLF_DOCUMENT_DATE]
XBLNR, -- Reference [XBLNR1]
ZUONR, -- Assignment [DZUONR]
WAERL, -- Doc. Currency [WAERL]
WSTWAE, -- Stats Currency [WSTWAE]
WKURS, -- Exchange Rate [UKURS_CURR]
STCUR, -- Exch.rate stats [STCUR]
KUFIX, -- Exch.Rate Fixed [WKUFIX]
WKURS_DAT, -- Exch. Rate Date [WLF_EXCHG_RATE_DATE]
BRTWR, -- Gross Amount [BRTWR_LF]
ZTERM, -- Pyt Terms [DZTERM]
ZBD1T, -- Payment in [DZBDET]
ZBD1P, -- CD Percentage 1 [DZBD1P]
ZBD2T, -- Days 2 [DZBD2T]
ZBD2P, -- CD Percentage 2 [DZBD2P]
ZBD3T, -- Days Net [DZBD3T]
ZLSCH, -- Pymt Meth. [DZLSCH]
NETWR, -- Net Amount [NETWR_LF]
NETWRD, -- Net Amount [NETWRD_LF]
BRTWRD, -- Gross Amount [BRTWRD_LF]
ZTERMD, -- Cust PayTrms [WZTERMD]
ZBD1TD, -- Payment in [WZBD1TD]
ZBD1PD, -- Cash Discount 1 [WZBD1PD]
ZBD2TD, -- Payment in [WZBD2TD]
ZBD2PD, -- Cash discount 2 [WZBD2PD]
ZBD3TD, -- Payment in [WZBD3TD]
ZLSCHD, -- Cust Pmt Method [SCHZW_BSEGD]
GSKTOD, -- Csh.Disc.Bas [SKFBP]
GSKTO, -- Csh.Disc.Bas [SKFBP]
FKSTO, -- Doc. Reversed [WLF_FKSTO]
KAPPL, -- Application [KAPPL]
KNUMV, -- Doc. Condition [KNUMV]
KNUMVD, -- Doc. Condition [KNUMV]
STAFO, -- Update Group [STAFO]
LFAKS, -- Reversed Document [LFAKS]
KNUMA, -- Agreement [KNUMA]
LFART_RL, -- SttDoc Type SDL [WFART_RL]
WFDAT_RL, -- Posting Date [WFDAT_RL]
WBELN_RL, -- Sett. Doc. List [WBELN_RL]
EKGRP, -- Purch. Group [EKGRP]
VALTG, -- Add.Value Days [WVALTG]
VALDT, -- Fixed Val.Date [WVALDT]
MWSBK, -- Tax Amount [MWSBP]
MWSBKD, -- Tax Amount [MWSBPD]
NAVNK, -- Non-deductible [NAVNW]
LOGSYS, -- Logical system [LOGSYS]
DIEKZ, -- Service Ind. [DIEKZ]
LANDL, -- Supply C/R [LANDL]
LZBKZ, -- SCB Ind. [LZBKZ]
KKBER, -- Cred.Contr.Area [KKBER]
LFGRU, -- Activity Reason [WFGRU]
VALTGD, -- Add.Value Days [WVALTD]
VALDTD, -- Fixed Val.Date [WVALDD]
KIDNO, -- Payment Ref. [KIDNO]
WDTYP, -- Doc. Category [DOCTYPE]
WKURS_P1, -- Exchange Rate [WKURS_P1]
WKURS_P2, -- Exch. Rate [WKURS_P2]
WPYCUR_P1, -- Payt Currency [WPYCUR_P1]
WPYCUR_P2, -- Payt Currency [WPYCUR_P2]
ESTATUS, -- Appl. Status [WSTATE]
KURST, -- Exch. Rate Type [KURST]
VKBUR, -- Sales Office [VKBUR]
VKGRP, -- Sales Group [VKGRP]
SETTLE_DOC, -- Settlement Doc. [WLF_EXP_SETTLE_DOC]
FKSTO_PART, -- Partial Revrsl [WLF_FKSTO_PART]
POST_PARTY, -- Posting Partner [WLF_POST_PARTY]
CPDK_ADDR, -- OTC Address [WLF_CPDK_ADDR]
FKSTO_PARTY, -- Reversed Partner [WLF_FKSTO_PARTY]
CONTRACT, -- Contract [WCONTRACT]
CONTRACT_TYPE, -- Contract Cat. [WCONTRACT_TYPE]
COLLECTION_TYPE, -- Summarization [WCOLLECTION]
CMWAE, -- Currency [WAERS_CM]
CTLPC, -- Risk Category [CTLPC_CM]
CM_AMOUNT, -- Credit Value [AMTBL_CM]
SETTLE_CATEGORY, -- Classification Cat. [WSETTLE_CATEGORY]
IDOBJ_TYPE_V, -- ID ObjType Supp [WLF_IDOBJ_TYPE_VENDOR]
IDOBJ_VENDOR, -- ID-Object Supplier [WLF_IDOBJ_VENDOR]
IDOBJ_TYPE_C, -- ID ObjType Cust [WLF_IDOBJ_TYPE_CUSTOMER]
IDOBJ_CUSTOMER, -- ID-Object Customer [WLF_IDOBJ_CUSTOMER]
POSTING_RULE_K, -- Suppl. PostRule [WLF_POSTING_RULE_K]
POSTING_RULE_D, -- Cust. PostRule [WLF_POSTING_RULE_D]
POSTING_RULE_A, -- Spec. Post.Rule [WLF_POSTING_RULE_A]
VKONT, -- Contract Acct [CORR_VKONT_KK]
VKONT_K, -- Contract Acct [CORR_VKONT_KK]
WT_ACTIVE, -- Withholding Tax Act [WLF_WITHHOLDING_TAX_ACTIVE]
BUKRS_DEB, -- Cust. Company Code [WLF_BUKRS_CUSTOMER_REGU]
SETTL_PARTY, -- Settlmt Part Cat [WLF_SETTLEMENT_PARTY]
SETTL_STATUS_V, -- Settl. Status Supp. [WLF_SETTLEMENT_STATUS_V]
SETTL_STATUS_C, -- Settl. Status Cust. [WLF_SETTLEMENT_STATUS_C]
SETTL_DOCTYPE_V, -- Doc. Type - Suppl. [WLF_SETTLEMENT_DOCTYPE_V]
SETTL_DOCTYPE_C, -- Settlmt Doc Type [WLF_SETTLEMENT_DOCTYPE_C]
SETTL_METHOD, -- Settlement Procedure [WLF_SETTLEMENT_METHOD]
SETTL_BLOCK_V, -- Supplier Settlement Blocking Reason [WLF_SETTLEMENT_BLOCK_V]
SETTL_BLOCK_C, -- Customer Settlement Blocking Reason [WLF_SETTLEMENT_BLOCK_C]
CPDL_ADDR, -- OTS Address [WLF_CPDL_ADDR]
MONAT, -- Period [MONAT]
OUTPUT_CONTROL_IS_ACTIVE, -- Output Control [WLF_OUTPUT_CONTROL_IS_ACTIVE]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
PERNR, -- Personnel No. [PERNR_D]
STATUS_GROUP, -- Status Group [WSTATG]
JRNL_ENTR_CRTN_DTE_UTC, -- Journal Entry Creation Date [WLF_JOURNAL_ENTRY_CRTN_DTE_UTC]
JRNL_ENTR_CRTN_TME_UTC, -- Journal Entry Creation Time [WLF_JOURNAL_ENTRY_CRTN_TME_UTC]
SETTLMT_COMPN_RSN, -- Compensation Reason [WLF_COMPN_RSN]
ENTITY_TAG, -- Entity Tag [WLF_ENTITY_TAG]
PERS_KOSTL, -- Worker Cost Center [WLF_PERS_KOSTL]
PERS_KOKRS, -- Worker Controlling Area [WLF_PERS_KOKRS]
TXKRS, -- Tax Exchange_Rate [WLF_TXKRS]
TXKRS_IC, -- Tax Exchange_Rate Intercompany Posting [WLF_TXKRS_IC]
CTXKRS, -- Tax ExRate Rept.Ctry/Reg [WLF_CTXKRS]
CTXKRS_IC, -- Tax Exchange Rate Reporting Ctry/Reg. IC [WLF_CTXKRS_IC]
LDGRP, -- Ledger Group [FAGL_LDGRP]
COMPN_VARIANT, -- Compensation Variant [WLF_COMPN_VARIANT]
VISIBILITY_GROUP, -- Element Behavior Group [WLF_APP_VIS_GRP]
HXF_BTT_CODE, -- Curr.Transl. Fact. Bus. Trans. Type Code [WLF_FOT_HXF_BTT_CODE]
AUTHORIZATION_CATEGORY, -- Authorization Cat. [WLF_AUTHORIZATION_CATEGORY]
LFART_SWITCHED_NEG, -- Doc. Type Switched [WLF_LFART_SWITCHED_NEGATIVE]
DUMMY_WBRK_INCL_EEW_PS, -- Dummy [WBRK_INCL_EEW]
SERVCONF_ID, -- CRM ConfID [FSL_SERVCONF_ID]
COUNTER, -- Counter Reading [FSL_COUNTER]
COUNTER_UNIT, -- Unit of Measure [FSL_UNIT]
EXP_CLASS, -- Expense Class [WB2_EXPENSE_CLASS]
EXP_CALC_TYPE, -- CalculationType [WB2_EXPENSE_CALC_TYPE]
DOC_SETTLED, -- Doc. Settled [WB2_EXP_DOCUMENT_SETTLED]
REF_VALUE_REF, -- Unit [WB2_EXPENSE_REF_VALUE_REF]
REF_VALUE, -- Reference Value [WB2_EXPENSE_REFERENCE_VALUE]
POST_TYPE, -- Posting Cat. [WB2_EXPENSE_POSTING_TYPE]
TEW_TYPE, -- TEW Type [WB2_TEW_TYPE]
STEP, -- Step [WB2_STEP]
PARTNER_EXP, -- Business partner [PRQ_PARNO]
STEP_FROM, -- Step [WB2_STEP]
STEP_TEW, -- Step [WB2_STEP]
MODE, -- Mode [WB2_MODE]
PARTNER_EXP_TYPE, -- Partner [WB2_PARTNER_EXP_TYPE]
IV_CHECK_TYPE_H, -- Check Type(Header) [WLF_IV_CHECK_TYPE_HEAD]
IV_ACCR, -- Accrual [WLF_IV_ACCRUAL]
RRLCG, -- SttDocList Type [RRLCG]
RRLPA, -- SDL Partner [RRLPA]
CONTR_TYPE, -- Contract Type [WCB_CONTRACT_TYPE]
SETTL_DATE_TYPE, -- Settlement Date Type [WB2_SETTLEMENT_DATE_TYPE]
ACT_SETTL_DATE, -- Actual Settl. Date [WB2_ACTUAL_SETTLEMENT_DATE]
SETTL_DATE_SEQ_ID, -- Settlement Date ID [WB2_SETTLEMENT_DATE_SEQ_ID]
SETTL_START_DATE, -- Start Date of Period [WB2_SETTLEMENT_START_DATE]
TOTAL_MENGE, -- Total Quantity [WB2_TOTAL_MENGE]
TOTAL_WFKME, -- UoM Total Quantity [WB2_TOTAL_WFKME]
TOTAL_NTGEW, -- Total Net Weight [WB2_TOTAL_NTGEW]
TOTAL_BRGEW, -- Total Gross Weight [WB2_TOTAL_BRGEW]
TOTAL_GEWEI, -- UoW Total Weight [WB2_TOTAL_GEWEI]
TOTAL_VOLUM, -- Total Volume [WB2_TOTAL_VOLUM]
TOTAL_VOLEH, -- Unit Total Volume [WB2_TOTAL_VOLEH]
TOTAL_ANZPU, -- Total Points [WB2_TOTAL_ANZPU]
TOTAL_PUNEI, -- Unit Total Points [WB2_TOTAL_PUNEI]
PROCESS_VARIANT, -- Process Variant [WCB_PROCESS_VARIANT]
PROCESS_CATEGORY, -- Process Category [WCB_PROCESS_CATEGORY]
DEVIATING_SETTL_ITEM, -- Dev. Settl Data Item [WB2_DEVIATING_SETTL_ITEM]
SETTL_VARIANT, -- Settlement Variant [WB2_SETTLEMENT_VARIANT]
CONTR_SETTL_DOC_CAT, -- Document Category [WB2_CONTR_SETTL_DOC_CAT]
CORR_DOCUMENT, -- Adjustment Doc. [WLF_CORR_DOCUMENT]
INCOMP_REASON, -- Incomplete Rsn [WLF_INCOMPLETENESS_REASON]
LIFNR_FI, -- Alternative Supplier [WLF_LIFNR_FI]
DISTRIB_INCOMP, -- Distrib. Incomplete [WLF_DISTRIBUTION_INCOMPLETE]
RFBSK_COMB_SETT, -- Posting Status 2 [WLF_RFBSK_COMBINED_SETTLEMENT]
NO_TEXT_H, -- No Texts Exist [WLF_NO_TEXT]
INTRASTAT_REL, -- Intrastat Rel. [WLF_INTRASTAT_RELEVANT]
LANDTX, -- Tx Dep Ctry/Reg [WLF_D_LANDTX]
LAND1TX, -- Tx Des Ctry/Reg [WLF_D_LAND1TX]
XEGDR, -- EU Triang. Deal [XEGDR]
STCEG, -- Supp.VATReg.No. [WLF_SUPLR_STCEG]
STCEGD, -- Cust.VATReg.No. [WLF_CUST_STCEG]
INTRASTAT_FLOW_D, -- Goods Flow [WLF_INTRASTAT_FLOW_DOC]
SERVICE_INDICATOR, -- Service Indicator [WLF_SERVICE_INDICATOR]
INCO1, -- Incoterms [INCO1]
INCO2, -- Incoterms 2 [INCO2]
INCOV, -- Inco. Version [INCOV]
INCO2_L, -- Inco. Location1 [INCO2_L]
INCO3_L, -- Inco. Location2 [INCO3_L]
WKURS_DEB, -- Exch.Rate Customer [WLF_WKURS_CUSTOMER]
SETTLEMENT_DATE, -- Settlement Date [WB2_SETTLEMENT_DATE]
PROCESS_TYPE, -- Proc. Category [WLF_PROCESS_TYPE]
BANK_DATA, -- Bank Data [WLF_BANK_DATA]
COLL_STATUS, -- Collective Settlement Status [WLF_COLLECTION_STATUS]
IS_COLLECTION, -- Document is Collective Document [WLF_IS_COLLECTION]
COLL_BLOCK, -- Collective Settlement Blocking Reason [WLF_COLLECTION_BLOCK]
REF_SETTL_DATE, -- Reference Date [WLF_REFERENCE_SETTLEMENT_DATE]
LANDTX_BUKRS, -- Tax Ctry/Reg. CoCode [WLF_LANDTX_BUKRS]
LANDTX_BUKRS_DEB, -- Tax C/R CoCode Cust. [WLF_LANDTX_BUKRS_DEB]
USE_CASE, -- Use Case Type [WLF_USE_CASE_TYPE]
USE_CASE_GUID, -- Use Case GUID [WLF_USE_CASE_GUID]
INVOICE_ID, -- Ext. Invoice ID [WLF_BTD_ID]
SCHEME_ID, -- Scheme [WLF_SCHEME_ID]
SCHEME_A_ID, -- Scheme ID [WLF_SCHEME_A_ID]
AGENCY_ID_CODE, -- Agency ID [WLF_AGENCY_ID_CODE]
ITCUP, -- CUP Code [ITCUP]
ITCIG, -- CIG Code [ITCUG]
MNDID, -- Mandate Ref. [SEPA_MNDID]
POSNR, -- Item [WPOSNR_RL]
WBELN_LF, -- Document [WBELN_LF]
MWSBP, -- Tax Amount [MWSBPK]
NAVNW, -- Non-deductible [NAVNW]
KWERT_RL, -- SDoc List Value [WKWERT_RL]
MWSBP_RL, -- SDListCond Tax [WMWSBP_RL]
WDTYP_L, -- List Doc. Cat. [DOCTYPE_L]
WDTYP_LI, -- Doc. Cat of List Itm [DOCTYPE_LI]
TXJCD, -- Tax Jur. [TXJCD]
PAOBJNR, -- Profit. segment [RKEOBJNR]
GJAHR, -- Fiscal Year [GJAHR]
EXT_DOC_NR, -- External Doc ID [WLF_FOREIGN_DOC_NUMBER]
EXT_DOC_YEAR, -- External Doc Year [WLF_FOREIGN_DOC_YEAR]
EXT_DOC_BUKRS, -- External Doc CoCode [WLF_FOREIGN_DOC_BUKRS]
EXT_DOC_ITEM, -- External Doc. Item [WLF_FOREIGN_DOC_ITEM_NUMBER]
FBUDA_LI, -- Serv. Rend. Dte [FBUDA]
BUPLA, -- Business place [BUPLA]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
KOWRR, -- Item Control [WKOWRR]
LFGRU_LI, -- Activity Reason [WFGRU]
DUMMY_WBRL_INCL_EEW_PS, -- Dummy [WBRL_INCL_EEW]
FKSTO_LI, -- Reversed [WLF_FKSTO_LIST_ITEM]
WUVPRS, -- Incomp. Pricing [WUVPRS]
NETWR_LP, -- Net Value [NETWR_RL]
LIFRE_LP, -- Invoicing Party [LIFRE]
LNRZB_LP, -- Payee [W_LIFZE]
KUNRE_LP, -- Bill-to Party [KUNRE]
KUNRG_LP, -- Payer [KUNRG]
LFTYP_LP, -- Sett. Doc. Cat. [WFTYP]
LOGSYS_LP, -- Logical system [LOGSYS]
DATAAGING_LP, -- Data Aging [DATA_TEMPERATURE]
PRIMARY KEY (MANDT, WBELN, LFART, LFTYP, WRART, WBTYP, WRTYP, ABART, KALSM, KALSMD, WFDAT, RFBSK, LIFRE, LNRZB, KUNRE, KUNRG, EKORG, VKORG, VTWEG, SPART, BUKRS, ERZET, ERDAT, ERNAM, AEDAT, BLDAT, XBLNR, ZUONR, WAERL, WSTWAE, WKURS, STCUR, KUFIX, WKURS_DAT, BRTWR, ZTERM, ZBD1T, ZBD1P, ZBD2T, ZBD2P, ZBD3T, ZLSCH, NETWR, NETWRD, BRTWRD, ZTERMD, ZBD1TD, ZBD1PD, ZBD2TD, ZBD2PD, ZBD3TD, ZLSCHD, GSKTOD, GSKTO, FKSTO, KAPPL, KNUMV, KNUMVD, STAFO, LFAKS, KNUMA, LFART_RL, WFDAT_RL, WBELN_RL, EKGRP, VALTG, VALDT, MWSBK, MWSBKD, NAVNK, LOGSYS, DIEKZ, LANDL, LZBKZ, KKBER, LFGRU, VALTGD, VALDTD, KIDNO, WDTYP, WKURS_P1, WKURS_P2, WPYCUR_P1, WPYCUR_P2, ESTATUS, KURST, VKBUR, VKGRP, SETTLE_DOC, FKSTO_PART, POST_PARTY, CPDK_ADDR, FKSTO_PARTY, CONTRACT, CONTRACT_TYPE, COLLECTION_TYPE, CMWAE, CTLPC, CM_AMOUNT, SETTLE_CATEGORY, IDOBJ_TYPE_V, IDOBJ_VENDOR, IDOBJ_TYPE_C, IDOBJ_CUSTOMER, POSTING_RULE_K, POSTING_RULE_D, POSTING_RULE_A, VKONT, VKONT_K, WT_ACTIVE, BUKRS_DEB, SETTL_PARTY, SETTL_STATUS_V, SETTL_STATUS_C, SETTL_DOCTYPE_V, SETTL_DOCTYPE_C, SETTL_METHOD, SETTL_BLOCK_V, SETTL_BLOCK_C, CPDL_ADDR, MONAT, OUTPUT_CONTROL_IS_ACTIVE, _DATAAGING, PERNR, STATUS_GROUP, JRNL_ENTR_CRTN_DTE_UTC, JRNL_ENTR_CRTN_TME_UTC, SETTLMT_COMPN_RSN, ENTITY_TAG, PERS_KOSTL, PERS_KOKRS, TXKRS, TXKRS_IC, CTXKRS, CTXKRS_IC, LDGRP, COMPN_VARIANT, VISIBILITY_GROUP, HXF_BTT_CODE, AUTHORIZATION_CATEGORY, LFART_SWITCHED_NEG, DUMMY_WBRK_INCL_EEW_PS, SERVCONF_ID, COUNTER, COUNTER_UNIT, EXP_CLASS, EXP_CALC_TYPE, DOC_SETTLED, REF_VALUE_REF, REF_VALUE, POST_TYPE, TEW_TYPE, STEP, PARTNER_EXP, STEP_FROM, STEP_TEW, MODE, PARTNER_EXP_TYPE, IV_CHECK_TYPE_H, IV_ACCR, RRLCG, RRLPA, CONTR_TYPE, SETTL_DATE_TYPE, ACT_SETTL_DATE, SETTL_DATE_SEQ_ID, SETTL_START_DATE, TOTAL_MENGE, TOTAL_WFKME, TOTAL_NTGEW, TOTAL_BRGEW, TOTAL_GEWEI, TOTAL_VOLUM, TOTAL_VOLEH, TOTAL_ANZPU, TOTAL_PUNEI, PROCESS_VARIANT, PROCESS_CATEGORY, DEVIATING_SETTL_ITEM, SETTL_VARIANT, CONTR_SETTL_DOC_CAT, CORR_DOCUMENT, INCOMP_REASON, LIFNR_FI, DISTRIB_INCOMP, RFBSK_COMB_SETT, NO_TEXT_H, INTRASTAT_REL, LANDTX, LAND1TX, XEGDR, STCEG, STCEGD, INTRASTAT_FLOW_D, SERVICE_INDICATOR, INCO1, INCO2, INCOV, INCO2_L, INCO3_L, WKURS_DEB, SETTLEMENT_DATE, PROCESS_TYPE, BANK_DATA, COLL_STATUS, IS_COLLECTION, COLL_BLOCK, REF_SETTL_DATE, LANDTX_BUKRS, LANDTX_BUKRS_DEB, USE_CASE, USE_CASE_GUID, INVOICE_ID, SCHEME_ID, SCHEME_A_ID, AGENCY_ID_CODE, ITCUP, ITCIG, MNDID, POSNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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