WLF_D_PSDOC_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_PERSSETTLMTDOCTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_PSDOC_D (
    MANDT,                          -- Client [MANDT]
    PERSONNELSETTLEMENTDOCUMENT,    -- Personnel Settlement Document [WLF_PERS_SETTLMT_DOC]
    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]
    POSTINGDATE,                    -- Posting Date [WFDAT]
    PERSSETTLMTACCTGTRANSFSTS,      -- Posting Status [WFBSK]
    DOCUMENTDATE,                   -- Document Date [WLF_DOCUMENT_DATE]
    DOCUMENTREFERENCEID,            -- Reference [XBLNR1]
    ASSIGNMENTREFERENCE,            -- Assignment [DZUONR]
    SETTLMTAPPLSTS,                 -- Appl. Status [WSTATE]
    SETTLMTAPPLSTSGRP,              -- Status Group [WSTATG]
    PRICINGPROCEDURE,               -- Pricing Procedure [WLF_KALSM]
    PRICINGDOCUMENT,                -- Document Condition [WLF_KNUMV]
    PERSONWORKAGREEMENT,            -- Personnel No. [PERNR_D]
    PERSONNELCOSTCENTER,            -- Worker Cost Center [WLF_PERS_KOSTL]
    PERSONNELCONTROLLINGAREA,       -- Worker Controlling Area [WLF_PERS_KOKRS]
    COMPANYCODE,                    -- Company Code [FIS_BUKRS]
    SALESORGANIZATION,              -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,            -- Distr. Channel [VTWEG]
    DIVISION,                       -- Division [SPART]
    SALESOFFICE,                    -- Sales Office [VKBUR]
    SALESGROUP,                     -- Sales Group [VKGRP]
    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]
    PERSSETTLMTDOCCURRENCY,         -- Doc. Currency [WAERL]
    EXCHANGERATE,                   -- Exchange Rate [WLF_UKURS_CURR_NO_CNEXT]
    EXCHANGERATETYPE,               -- Exch. Rate Type [KURST]
    EXCHANGERATEISFIXED,            -- Exch.Rate Fixed [WKUFIX]
    EXCHANGERATEDATE,               -- Exchange Rate Date [VDM_V_EXCHANGE_RATE_DATE]
    TOTALNETAMOUNT,                 -- Net Amount [NETWR_LF]
    PERSSETTLMTDOCISREVERSED,       -- Document Is Reversed [WLF_FKSTO_PSDOC]
    RVSDPERSSETTLMTDOC,             -- Reversed Document [LFAKS]
    PERSSETTLMTDOCACTIVITYREASON,   -- Header Document Creation Activity Reason [WLF_WFGRU_HEADER]
    PAYMENTREFERENCE,               -- Payment Reference [FARP_KIDNO]
    CNDNCONTRTYPE,                  -- Contract Type [WCB_CONTRACT_TYPE]
    SETTLMTRELTDCNDNCONTR,          -- Related Condition Contract [WLF_RELATED_COCO_NUM]
    CNDNCONTRPROCVAR,               -- Process Variant [WCB_PROCESS_VARIANT]
    FISCALPERIOD,                   -- Fiscal Period [FINS_FISCALPERIOD]
    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]
    SETTLMTDATE,                    -- Settlement Date [WB2_SETTLEMENT_DATE]
    PERSSETTLMTDOCINCMPLTNSRSN,     -- Incomplete Rsn [WLF_INCOMPLETENESS_REASON]
    SETTLMTBUSPROCVAR,              -- Proc. Category [WLF_PROCESS_TYPE]
    SETTLMTBUSPROCCAT,              -- Use Case Type [WLF_USE_CASE_TYPE]
    TOTALSETTLMTQUANTITY,           -- Total Quantity [WB2_TOTAL_MENGE]
    TOTALSETTLMTQUANTITYUNIT,       -- UoM Total Quantity [WB2_TOTAL_WFKME]
    TOTALSETTLMTNETWEIGHT,          -- Total Net Weight [WB2_TOTAL_NTGEW]
    TOTALSETTLMTGROSSWEIGHT,        -- Total Gross Weight [WB2_TOTAL_BRGEW]
    TOTALSETTLMTWEIGHTUNIT,         -- UoW Total Weight [WB2_TOTAL_GEWEI]
    TOTALSETTLMTVOLUME,             -- Total Volume [WB2_TOTAL_VOLUM]
    TOTALSETTLMTVOLUMEUNIT,         -- Unit Total Volume [WB2_TOTAL_VOLEH]
    SETTLMTPERIODSTARTDATE,         -- Start Date of Period [WB2_SETTLEMENT_START_DATE]
    SETTLMTPERIODENDDATE,           -- End Date of Period [WB2_SETTLEMENT_END_DATE]
    CNDNCONTRPROCESSCATEGORY,       -- Process Category [WCB_PROCESS_CATEGORY]
    POSTINGPARTNERCAT,              -- Posting Partner [WLF_POST_PARTY]
    JOURNALENTRYCREATIONDATE,       -- Journal Entry Creation Date [WLF_JOURNAL_ENTRY_CRTN_DTE_UTC]
    JOURNALENTRYCREATIONTIME,       -- Journal Entry Creation Time [WLF_JOURNAL_ENTRY_CRTN_TME_UTC]
    SETTLMTCOMPENSATIONREASON,      -- Compensation Reason [WLF_COMPN_RSN]
    SETTLMTCOMPNVAR,                -- Compensation Variant [WLF_COMPN_VARIANT]
    APPLELMNTBEHAVIORGRP,           -- Element Behavior Group [WLF_APP_VIS_GRP]
    PERSSETTLMTDOCCHANGESTATE,      -- Change State [WLF_CHANGE_STATE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_WBRK_INCL_EEW_PS,         -- Dummy [WBRK_INCL_EEW]
    PRIMARY KEY (MANDT, PERSONNELSETTLEMENTDOCUMENT, DRAFTUUID)
);