JKWERBVB SAP (Mix Structure for XJKWERB) Structure details

Dictionary Type: Structure
Description: Mix Structure for XJKWERB




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




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

JKWERBVB 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 "Mix Structure for XJKWERB" 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_JKWERBVB TYPE JKWERBVB.

The JKWERBVB table consists of various fields, each holding specific information or linking keys about Mix Structure for XJKWERB data available in SAP. These include MANDT (Client), VBELN (IS-M/SD: Publishing Sales Order), POSNR (Original Item in Publishing Sales Order), WERBEART (Sales Source).. 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 JKWERBVB 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 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_SAPRCHAR18JMTMATMATN1MATNR_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 VSGRCHEURCHAR10JGTGPNRALPHAGPNRMJG0G
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
XVTPROABCommission settlement performed XVTPROABCHAR1XFELD
DBCODEDB Code for Structural Changes DBCODECHAR1DBCODE

Key field Non-key field



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

As JKWERBVB 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 JKWERBVB as there is no data to select.

How to access SAP table JKWERBVB

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