FARR_D_POB

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.

-- Performance Obligations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_POB (
    CLIENT,                          -- Client [MANDT]
    POB_ID,                          -- POB [FARR_POB_ID]
    POB_NAME,                        -- Perf.Obligat.Name [FARR_POB_NAME]
    POB_ROLE,                        -- Leading/Linked [FARR_POB_ROLE]
    POB_TYPE,                        -- POB Type [FARR_POB_TYPE]
    POB_CATEGORY,                    -- POB Category [FARR_POB_CATEGORY]
    ACCT_PRINCIPLE,                  -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    COMPANY_CODE,                    -- Company Code [BUKRS]
    CUSTOMER_ID,                     -- Customer [KUNNR]
    PARTNER,                         -- Busn. Partner [BU_PARTNER]
    RECEIVABLE_ACCOUNT,              -- ReceivAccount [FARR_RECEIV_ACCOUNT]
    SALES_ORG,                       -- Sales Org. [FARR_SALES_ORG]
    SSP,                             -- StdAlone Price [FARR_SSP]
    SSP_CURK,                        -- Currency [WAERS]
    SSP_PERCENTAGE,                  -- SSP Percent. [FARR_SSP_PERCENTAGE]
    SSP_PERC_SOURCE,                 -- SSP % Base [FARR_SSP_PERCENT_SOURCE]
    SSP_RANGE_PERC,                  -- SSP Tol. Perc. [FARR_SSP_RANGE_PERCENTAGE]
    SSP_RANGE_AMOUNT,                -- SSP Tolerance [FARR_SSP_RANGE_AMOUNT]
    QUANTITY,                        -- Quantity [FARR_QUANTITY]
    QUANTITY_UNIT,                   -- Unit of Measure [FARR_QUANTITY_UNIT]
    DURATION,                        -- Duration [FARR_DURATION]
    DURATION_UNIT,                   -- Duration Unit [FARR_DURATION_UNIT]
    EVENT_TYPE,                      -- Event Type [FARR_EVENT_TYPE]
    FULFILL_TYPE,                    -- Fulfillment Type [FARR_FULFILL_TYPE]
    DEFERRAL_METHOD,                 -- Deferral Method [FARR_DEFERRAL_METHOD]
    RESIDUAL_POB,                    -- Residual [FARR_RESIDUAL_POB]
    PREVENT_ALLOC,                   -- Excl. from Alloc. [FARR_PREVENT_ALLOCATION]
    START_DATE,                      -- Start Date [FARR_START_DATE]
    END_DATE,                        -- End Date [FARR_END_DATE]
    INCEPTION_DATE,                  -- Inception Date [FARR_INCEPTION_DATE]
    START_DATE_TYPE,                 -- Start Date Type [FARR_START_DATE_TYPE]
    DISTINCT_TYPE,                   -- Composition [FARR_DISTINCT]
    DISTINCT_FULFILL,                -- Unit Distinct [FARR_DISTINCT_FULFILL]
    VALUE_RELEVANT,                  -- Value-Relevant [FARR_VALUE_RELEVANT]
    STATUS,                          -- Perf.Oblig.Status [FARR_POB_STATUS]
    REVIEW_REASON,                   -- Review Reason [FARR_REVIEW_REASON]
    REVIEW_DATE,                     -- Review Date [FARR_REVIEW_DATE]
    INVOICE_EFFECT_TYPE,             -- Invoice Effect [FARR_INVOICE_EFFECT_TYPE]
    BILLING_PLAN_INV,                -- Bill. Plan Inv. [FARR_BILLING_PLAN_INVOICE]
    HAS_BILLING_PLAN,                -- Billing Plan [FARR_HAS_BILLING_PLAN]
    SIMPLIFY_INVOICE,                -- Simplified Invoice [FARR_SIMPLIFY_INVOICE]
    X_ESTIMATED_QUAN,                -- Estim. Quantity [FARR_X_ESTIMATED_QUAN]
    XNEGATIVE_ITEM,                  -- Negative Amount [FARR_XNEGATIVE_ITEM]
    COST_RECOGNITION,                -- Cost Recognition [FARR_COST_RECOGNITION]
    NO_RECOG_NEG_REV,                -- No Recog Impair [FARR_NO_RECOG_NEG_REV]
    FINAL_DATE,                      -- Finalizat. Date [FARR_FINALIZATION_DATE]
    VALUE_BASED_FULFILLMENTS,        -- Fm.basedvalues [FARR_VALUE_BASED_FULFILLMENTS]
    FKBER,                           -- Functional Area [FKBER]
    GSBER,                           -- Business Area [GSBER]
    SEGMENT,                         -- Segment [FB_SEGMENT]
    PRCTR,                           -- Profit Center [PRCTR]
    PAOBJNR,                         -- Profit. segment [FARR_PROFIT_SEGMENT_NUM]
    KOSTL,                           -- Cost Center [KOSTL]
    AUFNR,                           -- Order [AUFNR]
    KDAUF,                           -- Sales Order [FARR_SALES_ORDER_NUM]
    KDPOS,                           -- Sales Ord. Item [FARR_ORDER_ITEM_NUM]
    PS_POSID,                        -- WBS Element [PS_POSID]
    PS_PSP_PNR,                      -- WBS Element [PS_PSP_PNR]
    COOBJNR,                         -- CO Object number [FARR_COOBJNR]
    MANUAL_CREATED,                  -- Manual Created [FARR_MANUAL_CREATED]
    CORA_INTEG_TYPE,                 -- Integration Type [FARR_CORA_INTEG_TYPE]
    BLOCKING_STATUS,                 -- Blocking Status [FARR_DPP_BLOCKING_STATUS]
    DUMMY_CONTR_ITM_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    POB_EEW_DUMMY,                   -- Dummy [CFD_DUMMY]
    REP_EEW_DUMMY,                   -- Dummy [CFD_DUMMY]
    URR_INTEGRATION_TYPE,            -- URR Integration Type [FARR_URR_INTEGRATION_TYPE]
    HI_LEVEL_POB_ID,                 -- Higher-Level POB [FARR_HI_LEVEL_POB_ID]
    LEADING_POB_ID,                  -- Leading POB [FARR_LEADING_POB_ID]
    BOM_POB_ID,                      -- Root POB in BOM [FARR_BOM_POB_ID]
    CONTRACT_ID,                     -- Contract [FARR_CONTRACT_ID]
    RISK_CLASS,                      -- Credit Risk Class [CREDIT_RISK_CLASS]
    ALLOC_AMT,                       -- Allocated Amount [FARR_ALLOC_AMT]
    ALLOC_AMT_CURK,                  -- Currency [WAERS]
    MANUAL_CHANGED,                  -- Manual Changed [FARR_MANUAL_CHANGED]
    MANUAL_DELETED,                  -- Manual Deleted [FARR_MANUAL_DELETED]
    MANUAL_SPREADING,                -- Manual Spreading [FARR_MANUAL_SPREADING]
    STRUCTURE_CHANGE,                -- Structure Changed [FARR_STRUCTURE_CHANGE]
    SOFT_DELETED,                    -- Soft Deleted [FARR_SOFT_DELETED]
    DISTRIBUTED_ORG_PRICE,           -- Original Price [FARR_ORIGINAL_PRICE]
    TRX_PRICE,                       -- Contractual Price [FARR_TRANSACTION_PRICE]
    FINAL_INVOICE,                   -- Final Invoice [FARR_FINAL_INVOICE]
    FULLY_FULFILLED,                 -- Fully Fulfilled [FARR_FULLY_FULFILLED]
    SOURCE_OF_PRICE,                 -- Source of Price [FARR_SOURCE_OF_PRICE]
    REV_REC_BLOCK,                   -- Suspend Posting [FARR_REV_REC_BLOCK]
    COMPLETION_DATE,                 -- Completion Date [FARR_COMPLETION_DATE]
    HAS_PRO_CHANGE,                  -- Has Contr Modif [FARR_HAS_PRO]
    STATUS_CHANGED_BY,               -- Status Changed By [FARR_STATUS_CHANGED_BY]
    STATUS_CHANGED_ON,               -- Status Changed On [FARR_STATUS_CHANGED_ON]
    REVIEW_REASON_CHANGED_BY,        -- Changed By [FARR_REVIEW_REASON_CHANGED_BY]
    REVIEW_REASON_CHANGED_ON,        -- Changed On [FARR_REVIEW_REASON_CHANGED_ON]
    VALIDATE_RESULT,                 -- Validation Result [FARR_VALIDATE_RESULT]
    PENDING_CONFLICT,                -- Pending Conflict [FARR_PENDING_CONFLICT]
    ATTR_CONFLICT,                   -- Attr conflict [FARR_ATTR_CONFLICT]
    SPREAD_CONFLICT,                 -- Spreading Conflict [FARR_SPREAD_CONFLICT]
    EFFECTIVE_QTY,                   -- Effective Quantity [FARR_EFFECTIVE_QUANTITY]
    MIG_PACKAGE,                     -- Migration Package ID [FARR_MIG_PACKAGE]
    UNIT_SSP,                        -- StdAlone Price [FARR_SSP]
    POSTED,                          -- Postings exist [FARR_POSTED]
    REC_COST,                        -- Recognizable Cost [FARR_RECOG_COST]
    COST,                            -- Cost(Total) [FARR_COST]
    COST_CURK,                       -- Cost Currency [FARR_COST_CURK]
    DELIVERED_QUANTITY,              -- Delivered Qty [FARR_DELIVERED_QUANTITY]
    DELIVERED_QTY_DIFF,              -- Diff to Dlv Qty [FARR_DIFF_DLV_QTY]
    INCLUDE_MA_FUL,                  -- FulType/EveType Chg [FARR_INCLUDE_MA_FUL]
    ASSET_ACCOUNT,                   -- AssetAcct [FARR_ASSET_ACCOUNT]
    LIABILITY_ACCOUNT,               -- ConLiaAcct [FARR_LIABILITY_ACCOUNT]
    CO_INTEGRATION,                  -- CO Integration [FARR_CO_INTEGRATION]
    INITIAL_EFFECTIVE_DATE,          -- Initial Effect. Date [FARR_INITIAL_EFFECTIVE_DATE]
    EFFECTIVE_QTY_UNIT,              -- Unit of Measure [FARR_QUANTITY_UNIT]
    EFFECTIVE_QTY_UNIT_ND,           -- Unit of Measure [FARR_QUANTITY_UNIT]
    MAX_CUMLTD_FULFILL_RECONKEY_ND,  -- Reconcil. Key [FARR_RECON_KEY]
    ACCRUED_COST_ACCOUNT,            -- Accrued Cost Account [FARR_ACCRUED_COST_ACCOUNT]
    DEFERRED_COST_ACCOUNT,           -- Deferred Cost Acct [FARR_DEFERRED_COST_ACCOUNT]
    SUSPENSION_DATE,                 -- Suspension Date [FARR_SUSPENSION_DATE]
    SUSPENSION_REASON,               -- Suspension Reason [FARR_SUSPENSION_REASON]
    ASSET_IMPAIRMENT_ACCOUNT,        -- Termination Acct. [FARR_ASSET_IMPAIRMENT_ACCOUNT]
    LCC,                             -- LCC [FARR_LCC]
    CREATED_BY,                      -- Created By [ERNAM]
    CREATED_ON,                      -- Created On [ERDAT]
    LAST_CHANGED_BY,                 -- Changed By [AENAM]
    LAST_CHANGED_ON,                 -- Changed on [FARR_LAST_CHANGE_ON]
    PRIMARY KEY (CLIENT, POB_ID)
);