RJY_MAM_ORDERLIST SAP (IS-M/AM: CIC, Order Overview: Item/Schedule Line Data) Structure details

Dictionary Type: Structure
Description: IS-M/AM: CIC, Order Overview: Item/Schedule Line Data




ABAP Code to SELECT data from RJY_MAM_ORDERLIST
Related tables to RJY_MAM_ORDERLIST
Access table RJY_MAM_ORDERLIST




Structure field list including key, data, relationships and ABAP select examples

RJY_MAM_ORDERLIST is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-M/AM: CIC, Order Overview: Item/Schedule Line Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_RJY_MAM_ORDERLIST TYPE RJY_MAM_ORDERLIST.

The RJY_MAM_ORDERLIST table consists of various fields, each holding specific information or linking keys about IS-M/AM: CIC, Order Overview: Item/Schedule Line Data data available in SAP. These include AVM_NR (IS-M/AM: Sales Document Number), AVM_NR_HOT_SPOT (Advertising Management Order Number for Hotspot in CIC List), POS_NR (IS-M: Order Item Number), VKORG (Sales Organization).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP RJY_MAM_ORDERLIST structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
AVM_NRIS-M/AM: Sales Document Number AVM_NRCHAR10Assigned to domainALPHAAVM_NRJHAMJHA
AVM_NR_HOT_SPOTAdvertising Management Order Number for Hotspot in CIC List ISM_AVM_NR_HOTSPCHAR10Assigned to domainALPHAAVM_NR
POS_NRIS-M: Order Item Number POS_NRNUMC3Assigned to domainAVM_PNR
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
AUARTIS-M: Sales Document Type AUART_PAMCHAR4Assigned to domainAUART_PAMJHRMJHAUART_PAM
POS_ARTIS-M: Order-Publishing-Media - Item Type AVMPOS_ARTCHAR2TJH17AVMPOS_ART
PSTYVIS-M: Item Category for Sales Document PSTYV_PAMCHAR4TJHAPPSTYV_PAM
BELEGEINHIS-M/AM: Booking Unit BELEGEINHCHAR10Assigned to domainALPHABELEINHJBEMJJ1
INHK_KFMIS-M: Business Content Component INHK_KFMCHAR8JJTIKOALPHAINHALTSKOMJJ1
XAGENAUFTRIS-M: Agency order indicator XAGENAUFTRCHAR1XFELD
PREIS_AVM1IS-M: Price Field 1 in the Order PREIS_AVM1CURR15(2) WERTV8
PREIS_AVM2IS-M: Price Field 2 in the Order PREIS_AVM2CURR15(2) WERTV8
WAEHRGSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
GPAGBusiness Partner: Sold-to Party GPAGCHAR10Assigned to domainALPHAGPNR
INSERENTIS-M: Advertiser INSERENTCHAR10Assigned to domainALPHAGPNRJGPMJG0M
INSZ_NRIS-M: Advertiser assignment number INSZ_NRNUMC4NUMC4
ALTINSGPNRIS-M: Alternative Customer Number for Advertiser ALTINSGPNRCHAR15CHAR15
AG_NAMEIS-M: Business Partner Name NAME1_ISPCHAR35NAME
INS_NAMEIS-M: Business Partner Name NAME1_ISPCHAR35NAME
WERBK_TYPIS-M: Combination Sale Type WKOMBI_TYPCHAR2Assigned to domainWKOMBI_TYPMJHWKOMBI_TYP
SELDAT_VONIS-M: Start Date for Item SELDAT_VONDATS8DATUM
SELDAT_BISIS-M: End Date for Items SELDAT_BISDATS8DATUM
STATUSKIS-M: Status STATUSKCHAR2PAM_STATUS
AMPELIS-M: Light for representing the status visually ISP_AMPELCHAR4CHAR004
STICHWIS-M: Keyword STICHWCHAR40TEXT40
PRODHIS-M/AM: Product Hierarchy J_PRODHCHAR18JJT179J_PRODH
PRODHTEXTDescription BEZEI20CHAR20TEXT20
STORNOGRNDIS-M: Cancellation Reason STOGRD_PAMCHAR3Assigned to domainSTOGRD_PAMMJHSTOGRD_PAM
XSTORNIERTIS-M: Canceled Order Object Indicator XSTORNIERTCHAR1XFELD
AVM_HRKNFTIS-M/AM: Order Origin AVM_HRKNFTCHAR1AVM_HRKNFT
TEC_AVM_NRIS-M: Order number in technical system TEC_AVM_NRCHAR10CHAR10
KAMPAGNEIS-M: Campaign (customer) KAMPAGNECHAR6Assigned to domainKAMPAGNE
BRAN_PAMIS-M/AM: Current Industry Sector Associated With Order Item BRAN_POSCHAR10Assigned to domainBRACO
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
CHIFFRE_NRIS-M/AM: Box Number CHIFFRECHAR10ALPHACHIFFRE_NRJHOMJHC
COPY_NO_STARTIS-M/AM: Start of Period for Copy ISM_COPY_NO_STARTCHAR14PAM_PERIOD
COPY_NO_ENDIS-M/AM: End of Period for Copy ISM_COPY_NO_ENDCHAR14PAM_PERIOD
NE_TERMINIS-M: Next/Last Publication Date NE_TERMINDATS8DATUM
NE_HEFTIS-M: Copy Number for the Next/Last Publication NE_HEFTCHAR14PAM_PERIOD
EIN_NRIS-M: Schedule Line EIN_NRNUMC6Assigned to domainAVMENR
EINTL_ANZIS-M: Number of Schedule Lines in an Item EINTL_ANZNUMC6NUMC6
WS_TIMESLCIS-M: Commercial Time Slice WS_TIMESLCCHAR2Assigned to domainWS_TIMESLC
WS_BLOCKIS-M: Commercial Cluster WS_BLOCKCHAR2Assigned to domainWS_BLOCK
WS_STELLEIS-M: Position (Sequence) Within a Commercial Cluster WS_STELLENUMC3NUMC3
GFK_CODEIS-M: Society for Consumer Research Code GFK_CODECHAR6CHAR06
PK_SERVICE_DATEPackage Service Date ISM_PACKAGE_SERVICE_DATEDATS8DATUM
START_DATEPublication Start Date ISM_PUBLICATION_START_DATEDATS8DATUM
PACKAGE_IDPackage ISM_PACKAGE_IDCHAR10JJTPCALPHAISM_PACKAGE_ID
PK_REF_AVM_NROrder Number for Package Reference Order ISM_PK_REF_AVM_NRCHAR10Assigned to domainALPHAAVM_NR
PK_REF_POS_NRItem Number of Package Item to be Referenced ISM_PK_REF_POS_NRNUMC3Assigned to domainAVM_PNR
PK_ELEMENT_IDPackage Element ID ISM_PK_ELEMENT_IDNUMC3Assigned to domainISM_PK_ELEMENT_ID
PK_PSTYVPackage Item Category ISM_PK_PSTVYCHAR4TJHAPPSTYV_PAM
PACKAGE_TYPEPackage Type ISM_PACKAGE_TYPENUMC2ISM_PACKAGE_TYPE
PACKAGE_CATEGORYPackage Category ISM_PACKAGE_CATEGORYCHAR4Assigned to domainALPHAISM_PACKAGE_CATEGORY

Key field Non-key field



How do I retrieve data from SAP structure RJY_MAM_ORDERLIST using ABAP code?

As RJY_MAM_ORDERLIST is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RJY_MAM_ORDERLIST as there is no data to select.

How to access SAP table RJY_MAM_ORDERLIST

Within an ECC or HANA version of SAP you can also view further information about RJY_MAM_ORDERLIST and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!