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]
    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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_WBRK_INCL_EEW_PS,         -- Dummy [WBRK_INCL_EEW]
    PRIMARY KEY (MANDT, SETTLMTDOC, DRAFTUUID)
);