/ACCGO/T_UISHDR
LDC Header Table
/ACCGO/T_UISHDR is an SAP database table in S/4HANA. LDC Header Table. It contains 39 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ACMLoadDataCaptureHdr1 | view | from | BASIC | Basic ACM UIS Header |
| I_ACMSupplierSplit | view_entity | from | BASIC | Interface for Vendor split |
| I_LoadDataCaptureEventData | view | from | BASIC | Load Data Capture data |
| I_LoadDataCaptureHdr | view | from | BASIC | ACM UIS Header |
| P_ACMLoadDataCaptureHdr | view_entity | from | COMPOSITE | |
| P_LDC_DATA | view | from | BASIC | |
| P_LDC_VENDORSPLIT | view_entity | from | COMPOSITE | |
| P_QREP_VERSION | view | inner | BASIC |
Fields (39)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | uis_key | /ACCGO/E_UIS_GUID | LDC Key | |||
| uis_id | /ACCGO/E_UIS_ID | LDC ID | ||||
| uis_type | /ACCGO/E_UIS_TYPE | LDC Type | ||||
| group_id | /ACCGO/E_UIS_GRPID | Group ID | ||||
| vendor | LIFNR | Supplier | ||||
| customer | KUNNR | Customer | ||||
| new_vendor_flag | /ACCGO/E_NEW_VENDOR_FLG | New Vendor | ||||
| vendor_addr_flag | /ACCGO/E_NEW_ADDR_FLG | New Address | ||||
| gs_addr_flag | /ACCGO/E_NEW_ADDR_FLG | New Address | ||||
| merge_key | /ACCGO/E_UIS_GUID | LDC Key | ||||
| goods_supplier | LIFNR | Supplier | ||||
| scalp_rel | /ACCGO/E_UIS_SCALP_REL | Back-to-Back? | ||||
| goods_movmnt_ind | XFELD | Checkbox | ||||
| inter_intra_rel | XFELD | Checkbox | ||||
| vendor_split_type | /ACCGO/E_VSPLIT_TYPE | Vendor Split | ||||
| split_profile | /ACCGO/E_UISVNDSPL_GRP | Vendor Grouping | ||||
| block_vsplt | XFELD | Checkbox | ||||
| currency | /ACCGO/E_FEE_CURRENCY | Currency | ||||
| mbs_rel | /ACCGO/E_UIS_MBS_REL | Multiple Buy Sell | ||||
| vendor_name | AD_NAME1 | Name | ||||
| vendor_dummy_flag | /ACCGO/E_UIS_DUMMY_VENDOR | Undefined Vendor | ||||
| vendor_street | AD_STREET | Street | ||||
| vendor_postal_code | AD_PSTCD1 | Postal Code | ||||
| vendor_city | AD_CITY1 | City | ||||
| vendor_country | LAND1 | Country/Reg. | ||||
| vendor_region | REGIO | Region | ||||
| vendor_phone | AD_TLNMBR1 | Telephone | ||||
| vendor_country_name | LANDX | Country/Region | ||||
| vendor_title | AD_TITLETX | Title | ||||
| vehicle_rel | /ACCGO/E_VEH_CONTR_REL | Vehicle Contract | ||||
| ext_uis_id | /ACCGO/E_UIS_EXT_ID | External ID | ||||
| created_by | /ACCGO/E_CREATED_BY | Created By | ||||
| created_on | /ACCGO/E_CREATED_ON | Created On | ||||
| changed_by | /ACCGO/E_CHANGED_BY | Changed By | ||||
| changed_on | /ACCGO/E_CHANGED_ON | Changed On | ||||
| merge_id | /ACCGO/E_UIS_ID | LDC ID | ||||
| tcp_indicator | /ACCGO/E_TCP_INDICATOR | TCP Indicator | ||||
| ccp_partner | /ACCGO/E_CCP_PARTNER | CCP Partner |
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.
-- LDC Header Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_UISHDR (
MANDT, -- Client [MANDT]
UIS_KEY, -- LDC Key [/ACCGO/E_UIS_GUID]
UIS_ID, -- LDC ID [/ACCGO/E_UIS_ID]
UIS_TYPE, -- LDC Type [/ACCGO/E_UIS_TYPE]
GROUP_ID, -- Group ID [/ACCGO/E_UIS_GRPID]
VENDOR, -- Supplier [LIFNR]
CUSTOMER, -- Customer [KUNNR]
NEW_VENDOR_FLAG, -- New Vendor [/ACCGO/E_NEW_VENDOR_FLG]
VENDOR_ADDR_FLAG, -- New Address [/ACCGO/E_NEW_ADDR_FLG]
GS_ADDR_FLAG, -- New Address [/ACCGO/E_NEW_ADDR_FLG]
MERGE_KEY, -- LDC Key [/ACCGO/E_UIS_GUID]
GOODS_SUPPLIER, -- Supplier [LIFNR]
SCALP_REL, -- Back-to-Back? [/ACCGO/E_UIS_SCALP_REL]
GOODS_MOVMNT_IND, -- Checkbox [XFELD]
INTER_INTRA_REL, -- Checkbox [XFELD]
VENDOR_SPLIT_TYPE, -- Vendor Split [/ACCGO/E_VSPLIT_TYPE]
SPLIT_PROFILE, -- Vendor Grouping [/ACCGO/E_UISVNDSPL_GRP]
BLOCK_VSPLT, -- Checkbox [XFELD]
CURRENCY, -- Currency [/ACCGO/E_FEE_CURRENCY]
MBS_REL, -- Multiple Buy Sell [/ACCGO/E_UIS_MBS_REL]
VENDOR_NAME, -- Name [AD_NAME1]
VENDOR_DUMMY_FLAG, -- Undefined Vendor [/ACCGO/E_UIS_DUMMY_VENDOR]
VENDOR_STREET, -- Street [AD_STREET]
VENDOR_POSTAL_CODE, -- Postal Code [AD_PSTCD1]
VENDOR_CITY, -- City [AD_CITY1]
VENDOR_COUNTRY, -- Country/Reg. [LAND1]
VENDOR_REGION, -- Region [REGIO]
VENDOR_PHONE, -- Telephone [AD_TLNMBR1]
VENDOR_COUNTRY_NAME, -- Country/Region [LANDX]
VENDOR_TITLE, -- Title [AD_TITLETX]
VEHICLE_REL, -- Vehicle Contract [/ACCGO/E_VEH_CONTR_REL]
EXT_UIS_ID, -- External ID [/ACCGO/E_UIS_EXT_ID]
CREATED_BY, -- Created By [/ACCGO/E_CREATED_BY]
CREATED_ON, -- Created On [/ACCGO/E_CREATED_ON]
CHANGED_BY, -- Changed By [/ACCGO/E_CHANGED_BY]
CHANGED_ON, -- Changed On [/ACCGO/E_CHANGED_ON]
MERGE_ID, -- LDC ID [/ACCGO/E_UIS_ID]
TCP_INDICATOR, -- TCP Indicator [/ACCGO/E_TCP_INDICATOR]
CCP_PARTNER, -- CCP Partner [/ACCGO/E_CCP_PARTNER]
PRIMARY KEY (MANDT, UIS_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA