JKWERB SAP (Publishing Sales Order: Promotion Data) Table details

Dictionary Type: Table
Description: Publishing Sales Order: Promotion Data




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




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

JKWERB is a standard SAP Table which is used to store Publishing Sales Order: Promotion Data data and is available within R/3 SAP systems depending on the version and release level.

The JKWERB table consists of various fields, each holding specific information or linking keys about Publishing Sales Order: Promotion Data data available in SAP. These include VBELN (IS-M/SD: Publishing Sales Order), POSNR (Original Item in Publishing Sales Order), WERBEART (Sales Source), WERBEAKT (Sales Promotion).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP JKWERB table 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 MANDTCLNT3T000MANDT
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10JKAKALPHAAVNRJK1MJK1
POSNROriginal Item in Publishing Sales Order APNR_URNUMC6JKAPAPNR
WERBEARTSales Source WERBEARTCHAR4TJWARALPHAWERBEARTJWA
WERBEAKTSales Promotion WERBEAKTCHAR8TJWAKALPHAWERBEAKTJWTMJW1
GUELTIGVONStart of Validity of Campaign Framework WERBVONDTDATS8DATUMJWV
MINDBEZUGMinimum Length of Subscription MINDBEZUGQUAN2ISPMNG2
MINDBEZEINTime Unit for Minimum Length of Subscription MINDBEZEINUNIT3T006CUNITMEINS
LIEFUNTMAXMaximum Delivery Suspension LIEFUNTMAXQUAN2ISPMNG2
LIEFUMXEINTime unit for maximum delivery suspension LIEFUMXEINUNIT3T006CUNITMEINS
XVTPRORelevant for commission XVTPROCHAR1XFELD
PRVSPCommission settlement block PROVSPERRECHAR2Assigned to domainPROVSPERRE
PROVRARTCommission clawback type PROVRARTCHAR1PROVRART
HAFTDAUERLiability Period for Commission Clawback in Months HAFTDAUERQUAN2ISPMNG2
HAFTDEINHTime Unit for Liability Period HAFTDEINHUNIT3T006CUNITMEINS
XEINMALPRVIndicator: One-time commission XEINMALPRVCHAR1XFELD
XWKZIndicator: Promotion rebate XWKZCHAR1XFELD
XRENDITERenewal commission XRENDITECHAR1XFELD
MATNRWERBIS-M: Material number for gift MATNR_SAPRCHAR18Assigned to domainMATN1MATNR_ISPJMA
ERLDATWERBDate Advertising Bonus Sent ERLDATWERBDATS8DATUM
XSAPRSPERRBlock indicator for gift shipping XSAPRSPERRCHAR1XFELD
ZUZAHLBETRAdditional payment JZUZAHLBETCURR13(2) ISPWV112
ZUZAHLWAERCurrency for Additional Payment JZUZAHLWAECUKY5TCURCWAERS
WERBTRAEGAdvertising Medium WERBTRAEGCHAR10TJW09WERBTRAEG
AVNRWERBOrder Number for Gift 'Free Subscription' AVNRWERBCHAR10Assigned to domainALPHAAVNR
APNRWERBOrder Item Number for Gift 'Free Subscription' APNRWERBNUMC6POSEX_ISP
GPRECHIS-M: Researcher GPRECHCHAR10JGTGPNRALPHAGPNRMJG0R
VSGRCHEURResearcher's Service Company VSGRCHEURCHAR10JGTVSGALPHAGPNRMJG0G
XRECHERZIS-M: Research generated XRECHERZCHAR1XFELD
KONTAKTNRIS-M: Business Partner Sales Activity KONTAKTNRCHAR10JWTWEKOALPHAERSATZNRJWK
VPFLZEITRVCommitment period for sales agent (subscriber) VPFLZEITRVQUAN2ISPMNG2
VPFLZEINHVTime unit for commitment period VPFLZEINHVUNIT3T006CUNITMEINS
PROVFDATCommission due date PROVFDATDATS8DATUM
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
XPROVVSYSTCommission settlement for subscription in legacy system XPROVVSYSTCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table JKWERB using ABAP code

The following ABAP code Example will allow you to do a basic selection on JKWERB to SELECT all data from the table
DATA: WA_JKWERB TYPE JKWERB.

SELECT SINGLE *
FROM JKWERB
INTO CORRESPONDING FIELDS OF WA_JKWERB
WHERE...

How to access SAP table JKWERB

Within an ECC or HANA version of SAP you can also view further information about JKWERB 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!