SAP-tabelreferentie

WRS1

Assortment

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

Bekijk de structuur, velden en relaties van SAP-tabel WRS1.

SAP-tabel WRS1 heeft 2 primaire sleutelvelden: MANDT,ASORT.

Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.

/ Velden

WRS1 velden.

25 velden
VeldOmschrijvingDatatypeLengteDecimalenChecktabelData-element
Sleutel MANDT ClientCLNT30 T000 MANDT
Sleutel ASORT AssortmentCHAR100 ASORT
STATU Status of assortmentCHAR10 W_S_STATUS
KZLIK Listing Conditions for AssortmentsCHAR10 KZLIK
NLMATFB ID: Carry out subsequent listingCHAR10 NLMATFB
VKORG Sales OrganizationCHAR40 TVKO VKORG
VTWEG Distribution ChannelCHAR20 TVTW VTWEG
LSTFL Listing procedureCHAR20 TWLV LSTVF
DATAB Valid-From DateDATS80 DATAB
DATBI Valid To DateDATS80 DATBI
KOPRO All material groups can be listed - even if there are errorsCHAR10 W_S_KOPRO
LAYPR Listing check: only use layout defined for the assortmentCHAR10 W_S_LAYPR
SOTYP Assortment CategoryCHAR10 W_SOTYP
LAYVR LayoutCHAR100 TWGV LAYVAR
POSDS No data should be sent to assortment user POS systemsCHAR10 W_POS_DS
EXCLU Existence of Exclusion Listing ConditionsCHAR10 W_S_EXCLU
CATEGORY Category NodesCHAR180 CAT_NODE
LAY_LIST_UTIME Time the layout module was last processedCHAR140 LAYOUT_LISTING_UPDTTIME
HIER_ID HierarchyCHAR20 WRF_MATGRP_HIER WRF_HIER_CNT
ASSORTYP Assortment TypeCHAR40 WRFST_TYP WRFDE_ASSORTYP
ASSORDIMVAL1 Value in an Assortment DimensionCHAR40 WRFV_TYPDIMVAL1 WRFDE_ASSORDIMVAL
ASSORDIMVAL2 Value in an Assortment DimensionCHAR40 WRFV_TYPDIMVAL2 WRFDE_ASSORDIMVAL
ASSORDIMVAL3 Value in an Assortment DimensionCHAR40 WRFV_TYPDIMVAL3 WRFDE_ASSORDIMVAL
LAYGR Layout ModuleCHAR100 TWML LAYGR
AEDAT Last Changed OnDATS80 AEDAT
/ Relaties

WRS1 relaties.

17 relaties
TabelVeldChecktabelOmschrijvingCheckveld
WRS1ASSORDIMVAL1WRFV_TYPDIMVAL1Generated Table for ViewASSORDIM1
WRS1ASSORDIMVAL2WRFV_TYPDIMVAL2Generated Table for ViewASSORDIM2
WRS1ASSORDIMVAL3WRFV_TYPDIMVAL3Generated Table for ViewASSORDIM3
WRS1ASSORTYPWRFST_TYPAssortment TypesMANDT
WRS1HIER_IDWRF_MATGRP_HIERArticle Hierarchy PropertiesMANDT
WRS1HIER_IDWRF_MATGRP_HIERArticle Hierarchy PropertiesHIER_ID
WRS1LAYGRTWMLLayout moduleMANDT
WRS1LAYGRTWMLLayout moduleLAYGR
WRS1LAYVRTWGVLayoutMANDT
WRS1LAYVRTWGVLayoutLAYVR
WRS1LSTFLTWLVListing procedure, assortmentsMANDT
WRS1LSTFLTWLVListing procedure, assortmentsLSTFL
WRS1MANDTT000ClientsMANDT
WRS1VKORGTVKOOrganizational Unit: Sales OrganizationsMANDT
WRS1VKORGTVKOOrganizational Unit: Sales OrganizationsVKORG
WRS1VTWEGTVTWOrganizational Unit: Distribution ChannelsMANDT
WRS1VTWEGTVTWOrganizational Unit: Distribution ChannelsVTWEG
Terug naar SAP-tabellen