SAP ARTHIER_ASSIGN I_ARTICLEHIERASSIGNTP I_ARTICLEHIERASSIGNTP Table

Overview

ARTHIER_ASSIGN is a standard SAP S/4HANA table that stores I_ARTICLEHIERASSIGNTP I_ARTICLEHIERASSIGNTP data. There are total 14 fields in the ARTHIER_ASSIGN table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ARTHIER_ASSIGN belongs to Material Master (LO-MD-MM) module and is located in the package VDM Master Data Article Hierarchy (VDM_MD_PRODUCT_ARTICLE_HIER).

In addition, following links provide an overview of foreign key relationships, if any, that link ARTHIER_ASSIGN to other SAP tables and standard CDS views available based on ARTHIER_ASSIGN table in S/4HANA 2020.

Techincal Settings of ARTHIER_ASSIGN

Below are technical details of the table ARTHIER_ASSIGN

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ARTHIER_ASSIGN Fields

The following table gives you an overview of the fields available in ARTHIER_ASSIGN

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
DRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
HIERARCHYIDHierarchyWRF_HIER_CNTCHAR2
PRODUCTMaterial NumberMATNRCHAR40
HIERARCHYNODEHierarchy NodeWRF_STRUC_NODECHAR18
ARTICLEHIERASSGMTVALDTYSTRTDTEValidity Start Date of Assignment in Article HierarchyWRF_DATE_FROMDATS8
ARTICLEHIERASSGMTVALDTYENDDATEValidity End Date of Assignment in Article HierarchyWRF_DATE_TODATS8
ARTICLEHIERMAINASSIGNMENTMain AssignmentWRF_MAIN_FLAGCHAR1
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR1
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC21
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC21
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR1
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ARTHIER_ASSIGN

Other References