SAFT_LUA_BP_LOG

Transparent Table Application Table

SAF-T LU: Customer item log

SAFT_LUA_BP_LOG is an SAP database table in S/4HANA. SAF-T LU: Customer item log. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_LU_SAFTBusinessPartner view_entity from BASIC SAFT LU Business Partners

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY statryrptgentity srf_reporting_entity Reporting Entity
KEY statryrptcategory srf_rep_cat_id Report ID
KEY statryrptrunid srf_report_run_id Report Run ID
KEY saftmodule saft_module
KEY ledger fins_ledger Ledger
KEY chartofaccounts fis_ktopl Chart of Accounts
KEY companycode fis_bukrs Company Code
KEY businesspartnertype char4 Undefined range (can be used for patch levels)
KEY businesspartner bu_partner Busn. Partner
KEY glaccount fis_racct G/L Account
KEY bpidentificationtypetext char35 CHAR35
bpidentificationnumber char60 Logical System
businesspartnercustomer char35 CHAR35
customer kunnr Customer
suppliertopartner char35 CHAR35
supplier lifnr Supplier
vatregistration char20 Char20
companyname text80 Text
streetname text60 Text
housenumber ad_hsnm1 House Number
cityname text40 Name
postalcode char10 Character Field with Length 10
region char3 3-Byte field
regionname bezei20 Description
country char3 3-Byte field
saftgeneralledgeraccountid char70 Char 70
_dataaging data_temperature Data Aging

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.

-- SAF-T LU: Customer item log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_LUA_BP_LOG (
    MANDT,                       -- Client [mandt]
    STATRYRPTGENTITY,            -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,           -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,              -- Report Run ID [srf_report_run_id]
    SAFTMODULE,                  -- saft_module
    LEDGER,                      -- Ledger [fins_ledger]
    CHARTOFACCOUNTS,             -- Chart of Accounts [fis_ktopl]
    COMPANYCODE,                 -- Company Code [fis_bukrs]
    BUSINESSPARTNERTYPE,         -- Undefined range (can be used for patch levels) [char4]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    GLACCOUNT,                   -- G/L Account [fis_racct]
    BPIDENTIFICATIONTYPETEXT,    -- CHAR35 [char35]
    BPIDENTIFICATIONNUMBER,      -- Logical System [char60]
    BUSINESSPARTNERCUSTOMER,     -- CHAR35 [char35]
    CUSTOMER,                    -- Customer [kunnr]
    SUPPLIERTOPARTNER,           -- CHAR35 [char35]
    SUPPLIER,                    -- Supplier [lifnr]
    VATREGISTRATION,             -- Char20 [char20]
    COMPANYNAME,                 -- Text [text80]
    STREETNAME,                  -- Text [text60]
    HOUSENUMBER,                 -- House Number [ad_hsnm1]
    CITYNAME,                    -- Name [text40]
    POSTALCODE,                  -- Character Field with Length 10 [char10]
    REGION,                      -- 3-Byte field [char3]
    REGIONNAME,                  -- Description [bezei20]
    COUNTRY,                     -- 3-Byte field [char3]
    SAFTGENERALLEDGERACCOUNTID,  -- Char 70 [char70]
    _DATAAGING,                  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, SAFTMODULE, LEDGER, CHARTOFACCOUNTS, COMPANYCODE, BUSINESSPARTNERTYPE, BUSINESSPARTNER, GLACCOUNT, BPIDENTIFICATIONTYPETEXT)
);