LFA1_AUSP_PRC

Transparent Table Application Table
50 Fields 1 CDS Views

Process Records Of OTC 147, Table LFA1_AUSP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPSuplrClfnObjCharcValProc view_entity from BASIC Supplier Classification Object Characteristic Value

Fields (50)

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 atzhl WZAEHL Counter
KEY mafid KLMAF Object/Class
KEY klart KLASSENART Class Type
KEY adzhl ADZHL Int. counter
KEY source_atinn MDC_SOURCE_ATINN Source ATINN
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
atwrt ATWRT Char. Value
atflv ATFLV Value from
atawe MSEHI Internal UoM
atflb ATFLB Value to
ataw1 MSEHI Internal UoM
atcod ATCOD Code
attlv ATTLV Tolerance from
attlb ATTLB Tolerance to
atprz ATPRZ Percentage
atinc ATINC Increment
ataut ATAUT Author
aennr AENNR Change Number
datuv DATUV Valid From
lkenz LKENZ Deletion Ind.
atimb ATIMB Internal char.
atzis ATZIS Instance cntr
atsrt ATSRT Position
atvglart ATVGLART Comp. type
datub DATUB to
atnam ATNAM Characteristic
atinn ATINN Internal Char.
dec_value_from AUSPEXT_DEC_FROM LowrBndry Nmrc
dec_value_to AUSPEXT_DEC_TO UprBndry Nmrc
curr_value_from AUSPEXT_CURR_FROM LowrBndry Crcy
curr_value_to AUSPEXT_CURR_TO UprBndry Crcy
currency WAERS_CURC Currency
date_from AUSPEXT_DATE_FROM LowrBndry Date
date_to AUSPEXT_DATE_TO UprBndry Date
time_from AUSPEXT_TIME_FROM LowrBndry Time
time_to AUSPEXT_TIME_TO UprBndry Time
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
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
partner_guid BU_PARTNER_GUID BP GUID
changed_at CRMS4_CHANGED_AT Changed On
changed_by CRMS4_CHANGED_BY Changed By
type_bp_guid BU_TYPE Partner Cat.

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 LFA1_AUSP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFA1_AUSP_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]
    ATZHL,                     -- Counter [WZAEHL]
    MAFID,                     -- Object/Class [KLMAF]
    KLART,                     -- Class Type [KLASSENART]
    ADZHL,                     -- Int. counter [ADZHL]
    SOURCE_ATINN,              -- Source ATINN [MDC_SOURCE_ATINN]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    ATWRT,                     -- Char. Value [ATWRT]
    ATFLV,                     -- Value from [ATFLV]
    ATAWE,                     -- Internal UoM [MSEHI]
    ATFLB,                     -- Value to [ATFLB]
    ATAW1,                     -- Internal UoM [MSEHI]
    ATCOD,                     -- Code [ATCOD]
    ATTLV,                     -- Tolerance from [ATTLV]
    ATTLB,                     -- Tolerance to [ATTLB]
    ATPRZ,                     -- Percentage [ATPRZ]
    ATINC,                     -- Increment [ATINC]
    ATAUT,                     -- Author [ATAUT]
    AENNR,                     -- Change Number [AENNR]
    DATUV,                     -- Valid From [DATUV]
    LKENZ,                     -- Deletion Ind. [LKENZ]
    ATIMB,                     -- Internal char. [ATIMB]
    ATZIS,                     -- Instance cntr [ATZIS]
    ATSRT,                     -- Position [ATSRT]
    ATVGLART,                  -- Comp. type [ATVGLART]
    DATUB,                     -- to [DATUB]
    ATNAM,                     -- Characteristic [ATNAM]
    ATINN,                     -- Internal Char. [ATINN]
    DEC_VALUE_FROM,            -- LowrBndry Nmrc [AUSPEXT_DEC_FROM]
    DEC_VALUE_TO,              -- UprBndry Nmrc [AUSPEXT_DEC_TO]
    CURR_VALUE_FROM,           -- LowrBndry Crcy [AUSPEXT_CURR_FROM]
    CURR_VALUE_TO,             -- UprBndry Crcy [AUSPEXT_CURR_TO]
    CURRENCY,                  -- Currency [WAERS_CURC]
    DATE_FROM,                 -- LowrBndry Date [AUSPEXT_DATE_FROM]
    DATE_TO,                   -- UprBndry Date [AUSPEXT_DATE_TO]
    TIME_FROM,                 -- LowrBndry Time [AUSPEXT_TIME_FROM]
    TIME_TO,                   -- UprBndry Time [AUSPEXT_TIME_TO]
    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]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    PARTNER_GUID,              -- BP GUID [BU_PARTNER_GUID]
    CHANGED_AT,                -- Changed On [CRMS4_CHANGED_AT]
    CHANGED_BY,                -- Changed By [CRMS4_CHANGED_BY]
    TYPE_BP_GUID,              -- Partner Cat. [BU_TYPE]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, ATZHL, MAFID, KLART, ADZHL, SOURCE_ATINN, ASSIGNMENT_ID)
);

Learn More