WLF_D_SDOC_D

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.

-- Draft table for entity R_SETTLMTDOCTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_SDOC_D (
    MANDT,                          -- Client [mandt]
    SETTLMTDOC,                     -- Settlement Doc. [wbeln_zr]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    SETTLMTDOCTYPE,                 -- Settlement Document Type [wlf_settlmt_doc_type]
    SETTLMTDOCCAT,                  -- Settlement Document Category [wlf_settlmt_doc_cat]
    SETTLMTPROCESSTYPE,             -- Settlement Process Type [wlf_settlmt_process_type]
    SETTLMTPROCESSCAT,              -- Settlement Process Category [wlf_settlmt_process_cat]
    LOGISTICSDATAENTRYCAT,          -- Entry Category [wrtyp]
    SETTLMTCAT,                     -- Settl. Category [nafkt]
    SUPPLIERPRICINGPROCEDURE,       -- SuplrPrcgProc. [wlf_suplr_kalsm_d]
    CUSTOMERPRICINGPROCEDURE,       -- CustPrcgProc. [wlf_cust_kalsm_d]
    POSTINGDATE,                    -- Posting Date [wfdat]
    SETTLMTMGMTACCTGTRANSFSTS,      -- Posting Status [wfbsk]
    INVOICINGPARTY,                 -- Invoicing Party [lifre]
    PAYEEPARTY,                     -- Payee [w_lifze]
    BILLTOPARTY,                    -- Bill-to Party [kunre]
    PAYERPARTY,                     -- Payer [kunrg]
    PURCHASINGORGANIZATION,         -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                -- Purch. Group [ekgrp]
    SALESORGANIZATION,              -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,            -- Distr. Channel [vtweg]
    DIVISION,                       -- Division [spart]
    SUPLRSETTLMTCOMPANYCODE,        -- Suppl. Company Code [wlf_suplr_bukrs]
    CUSTSETTLMTCOMPANYCODE,         -- Cust. Company Code [wlf_bukrs_customer_regu]
    CREATEDBYUSER,                  -- Created By [wlf_created_by]
    CREATIONDATE,                   -- Created On [wlf_created_on]
    CREATIONTIME,                   -- Created At [wlf_created_at]
    LASTCHANGEDATE,                 -- Last Changed On [wlf_changed_on]
    DOCUMENTDATE,                   -- Document Date [wlf_document_date]
    DOCUMENTREFERENCEID,            -- Reference [xblnr1]
    ASSIGNMENTREFERENCE,            -- Assignment [dzuonr]
    SETTLMTDOCCURRENCY,             -- Doc. Currency [waerl]
    EXCHANGERATE,                   -- Exchange Rate [wlf_ukurs_curr_no_cnext]
    EXCHANGERATEISFIXED,            -- Exch.Rate Fixed [wkufix]
    EXCHANGERATEDATE,               -- Exchange Rate Date [vdm_v_exchange_rate_date]
    SUPPLIERTOTALGROSSAMOUNT,       -- Supplier Total Gross Amount [wlf_brtwrk_lf]
    SUPPLIERTOTALNETAMOUNT,         -- Supplier Total Net Amount [wlf_netwrk_lf]
    SUPPLIERTOTALTAXAMOUNT,         -- Supplier Total Tax Amount [wlf_suplr_mwsbk]
    CUSTOMERTOTALGROSSAMOUNT,       -- Customer Total Gross Amount [wlf_brtwrd_lf]
    CUSTOMERTOTALNETAMOUNT,         -- Customer Total Net Amount [wlf_netwrd_lf]
    CUSTOMERTOTALTAXAMOUNT,         -- Customer Total Tax Amount [wlf_cust_mwsbk]
    SUPPLIERPAYMENTTERMS,           -- Supplier Payment Terms [wztermk]
    SUPPLIERCASHDISCOUNT1DAYS,      -- Supplier First Payment in Days [wlf_suplr_dzbd1t]
    SUPPLIERCASHDISCOUNT2DAYS,      -- Supplier Second Payment in Days [wlf_suplr_dzbd2t]
    SUPPLIERNETPAYMENTDAYS,         -- Supplier Cash Discount Days [wlf_suplr_dzbd3t]
    SUPPLIERCASHDISCOUNT1PERCENT,   -- Supplier Discount for 1st Payment in % [wlf_suplr_dzbd1p]
    SUPPLIERCASHDISCOUNT2PERCENT,   -- Supplier Discount for 2nd Payment in % [wlf_suplr_dzbd2p]
    SUPPLIERPAYMENTMETHOD,          -- Supplier Payment Method [schzw_bsegk]
    CUSTOMERPAYMENTTERMS,           -- Cust PayTrms [wztermd]
    CUSTOMERCASHDISCOUNT1DAYS,      -- Customer 1st Payment in Days [wlf_sdcust_dzbd1t]
    CUSTOMERCASHDISCOUNT2DAYS,      -- Customer 2nd Payment in Days [wlf_sdcust_dzbd2t]
    CUSTOMERNETPAYMENTDAYS,         -- Customer Cash Discount Days [wlf_sdcust_dzbd3t]
    CUSTOMERCASHDISCOUNT1PERCENT,   -- Customer Discount for 1st Payment in % [wlf_sdcust_dzbd1p]
    CUSTOMERCASHDISCOUNT2PERCENT,   -- Customer Discount for 2nd Payment in % [wlf_sdcust_dzbd2p]
    CUSTOMERPAYMENTMETHOD,          -- Cust Pmt Method [schzw_bsegd]
    SUPLRTOTELIGIBLEAMTFORCSHDISC,  -- Suplr Cash Disc Bas [wlf_suplr_skfbp]
    CUSTTOTELIGIBLEAMTFORCSHDISC,   -- Cust Cash Disc Bas [wlf_cust_skfbp]
    SETTLMTDOCISCANCELED,           -- Doc. Reversed [wlf_fksto_b]
    CANCELEDSETTLMTDOC,             -- Reversed Document [lfaks]
    SUPPLIERPRICINGDOCUMENT,        -- Supplier Document Condition [wlf_knumv_k]
    CUSTOMERPRICINGDOCUMENT,        -- Customer Document Condition [wlf_knumv_d]
    SUPPLIERADDITIONALVALUEDAYS,    -- Supplier Additional Value Days [wlf_wvaltk]
    SUPPLIERFIXEDVALUEDATE,         -- Supplier Fixed Value Date [wlf_wvaldk]
    CUSTOMERADDITIONALVALUEDAYS,    -- Customer Additional Value Days [wlf_wvaltd]
    CUSTOMERFIXEDVALUEDATE,         -- Customer Fixed Value Date [wlf_wvaldd]
    SUPPLYINGCOUNTRY,               -- Supplying Ctry/Reg. [fac_landl]
    STATECENTRALBANKPAYMENTREASON,  -- SCB Ind. [lzbkz]
    CREDITCONTROLAREA,              -- Credit Control Area [farp_kkber]
    SETTLMTDOCACTIVITYREASON,       -- Header Document Creation Activity Reason [wlf_wfgru_header]
    PAYMENTREFERENCE,               -- Payment Reference [farp_kidno]
    SUPPLIERPAYMENTCURRENCY,        -- Payt Currency [wpycur_p1]
    SUPPLIERPAYTCURRENCYEXCHRATE,   -- Supp. Payt Currency Exch. Rate [wlf_wkurs_p1_no_cnext]
    CUSTOMERPAYMENTCURRENCY,        -- Payt Currency [wpycur_p2]
    CUSTOMERPAYTCURRENCYEXCHRATE,   -- Cust. Payt Currency Exch. Rate [wlf_wkurs_p2_no_cnext]
    SETTLMTAPPLSTS,                 -- Appl. Status [wstate]
    EXCHANGERATETYPE,               -- Exch. Rate Type [kurst]
    SALESOFFICE,                    -- Sales Office [vkbur]
    SALESGROUP,                     -- Sales Group [vkgrp]
    SETTLMTRELTDREFDOCCAT,          -- Contract Cat. [wcontract_type]
    SETTLMTRELTDREFDOC,             -- Contract [wcontract]
    SETTLMTRELTDCNDNCONTR,          -- Related Condition Contract [wlf_related_coco_num]
    SETTLMTDOCSMMRZNCAT,            -- Summarization [wcollection]
    CREDITCONTROLAREACURRENCY,      -- Credit Control Area Currency [wlf_creditcontrolareacurrency]
    RELEASEDCREDITAMOUNT,           -- Credit Value [amtbl_cm]
    SETTLMTCLASSIFICATIONCAT,       -- Classification Cat. [wsettle_category]
    SETTLMTPARTNERCAT,              -- Settlmt Part Cat [wlf_settlement_party]
    SUPPLIERSETTLMTSTATUS,          -- Settl. Status Supp. [wlf_settlement_status_v]
    CUSTOMERSETTLMTSTATUS,          -- Settl. Status Cust. [wlf_settlement_status_c]
    SUPPLIERSETTLMTDOCCAT,          -- Doc. Type - Suppl. [wlf_settlement_doctype_v]
    CUSTOMERSETTLMTDOCCAT,          -- Settlmt Doc Type [wlf_settlement_doctype_c]
    SUPPLIERSETTLMTBLKGREASON,      -- Supplier Settlement Blocking Reason [wlf_settlement_block_v]
    CUSTOMERSETTLMTBLKGREASON,      -- Customer Settlement Blocking Reason [wlf_settlement_block_c]
    FISCALPERIOD,                   -- Fiscal Period [fins_fiscalperiod]
    CNDNCONTRTYPE,                  -- Contract Type [wcb_contract_type]
    CNDNCONTRPROCESSCATEGORY,       -- Process Category [wcb_process_category]
    SETTLMTDATECAT,                 -- Settlement Date Type [wb2_settlement_date_type]
    ACTUALSETTLMTDATE,              -- Actual Settl. Date [wb2_actual_settlement_date]
    SETTLMTDATESEQUENTIALID,        -- Settlement Date ID [wb2_settlement_date_seq_id]
    SETTLMTDOCINCMPLTNSRSN,         -- Incomplete Rsn [wlf_incompleteness_reason]
    ALTERNATIVEINVOICINGPARTY,      -- Alternative Supplier [wlf_lifnr_fi]
    COMBINEDSETTLMTPOSTGSTS,        -- Posting Status 2 [wlf_rfbsk_combined_settlement]
    DOCINTRASTATRELEVANCE,          -- Intrastat Rel. [wlf_intrastat_relevant]
    TAXDEPARTURECOUNTRY,            -- Tx Dep Ctry/Reg [wlf_d_landtx]
    TAXDESTINATIONCOUNTRY,          -- Tx Des Ctry/Reg [wlf_d_land1tx]
    ISEUTRIANGULARDEAL,             -- EU Triang. Deal [xegdr]
    SUPPLIERVATREGISTRATION,        -- Supp.VATReg.No. [wlf_suplr_stceg]
    CUSTOMERVATREGISTRATION,        -- Cust.VATReg.No. [wlf_cust_stceg]
    INTRASTATDECLNGDSFLWCAT,        -- Goods Flow [wlf_intrastat_flow_doc]
    SETTLMTDATE,                    -- Settlement Date [wb2_settlement_date]
    SETTLMTBUSPROCVAR,              -- Proc. Category [wlf_process_type]
    SETTLMTDOCCOLLSTS,              -- Collective Settlement Status [wlf_collection_status]
    SETTLMTDOCISCOLLVDOC,           -- Document is Collective Document [wlf_is_collection]
    COLLSETTLMTBLKGREASON,          -- Collective Settlement Blocking Reason [wlf_collection_block]
    SUPLRSETTLMTCOCODETAXCOUNTRY,   -- Tax Ctry/Reg. CoCode [wlf_landtx_bukrs]
    CUSTSETTLMTCOCODETAXCOUNTRY,    -- Tax Country/Region Company Code Customer [wlf_landtx_bukrs_deb_fio]
    SETTLMTBUSPROCCAT,              -- Use Case Type [wlf_use_case_type]
    POSTINGPARTNERCAT,              -- Posting Partner [wlf_post_party]
    SETTLMTPERIODSTARTDATE,         -- Start Date of Period [wb2_settlement_start_date]
    SETTLMTPERIODENDDATE,           -- End Date of Period [wb2_settlement_end_date]
    SETTLMTAPPLSTSGRP,              -- Status Group [wstatg]
    JOURNALENTRYCREATIONDATE,       -- Journal Entry Creation Date [wlf_journal_entry_crtn_dte_utc]
    JOURNALENTRYCREATIONTIME,       -- Journal Entry Creation Time [wlf_journal_entry_crtn_tme_utc]
    CONTRACTACCOUNT,                -- Contract Account [vkont_gfn_kk]
    APPLELMNTBEHAVIORGRP,           -- Element Behavior Group [wlf_app_vis_grp]
    SETTLMTHASDVTGCNDNCONTRDATA,    -- Dev. Settl Data Item [wb2_deviating_settl_item]
    SETTLMTDOCAUTHZNCAT,            -- Authorization Cat. [wlf_authorization_category]
    SETTLMTDOCCHANGESTATE,          -- Change State [wlf_change_state]
    PRIMARY KEY (MANDT, SETTLMTDOC, DRAFTUUID)
);