LFB1_STXL_PRC

Transparent Table Application Table
22 Fields 1 CDS Views

Process Records Of OTC 147, Table LFB1_STXL

LFB1_STXL_PRC is an SAP database table in S/4HANA. Process Records Of OTC 147, Table LFB1_STXL. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPSupplierCompanyTextProcess view_entity from BASIC Supplier Company Descr Base

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Process Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY relid SYCHAR02 CHAR02 data element for SYST
KEY tdobject TDOBJECT Text object
KEY tdname TDOBNAME Text Name
KEY tdid TDID Text ID
KEY tdspras SPRAS Language
KEY srtf2 SYBIN1 BIN1 data element for SYST
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
KEY bukrs BUKRS Company Code
KEY line_counter MDC_LONGTEXT_LINE_COUNT Counter
lifnr LIFNR Supplier
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
tdformat TDFORMAT Tag column
tdline TDLINE Text Line
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index

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.

-- Process Records Of OTC 147, Table LFB1_STXL
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFB1_STXL_PRC (
    CLIENT,                    -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Process Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    RELID,                     -- CHAR02 data element for SYST [SYCHAR02]
    TDOBJECT,                  -- Text object [TDOBJECT]
    TDNAME,                    -- Text Name [TDOBNAME]
    TDID,                      -- Text ID [TDID]
    TDSPRAS,                   -- Language [SPRAS]
    SRTF2,                     -- BIN1 data element for SYST [SYBIN1]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    BUKRS,                     -- Company Code [BUKRS]
    LINE_COUNTER,              -- Counter [MDC_LONGTEXT_LINE_COUNT]
    LIFNR,                     -- Supplier [LIFNR]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    TDFORMAT,                  -- Tag column [TDFORMAT]
    TDLINE,                    -- Text Line [TDLINE]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, RELID, TDOBJECT, TDNAME, TDID, TDSPRAS, SRTF2, ASSIGNMENT_ID, BUKRS, LINE_COUNTER)
);

Learn More