K_BTCHCMB - Combined PRODSED and PRODUCT

Apr 26, 2024

SET SCHEMA XXX_5DTA;
CREATE OR REPLACE VIEW K_BTCHCMB AS
 SELECT PD_COMP, 
 PD_REQTYPE,
 PD_BATCH,
 PD_BIRTH,
 PD_LASTUPD,
 PD_ACTBUYR,
 PD_ACTREGN,
 PD_ACTLOCN,
 PD_ACTUSER,
 PD_ACTSUPL,
 PD_ACTSUB,
 PD_PROD,
 PD_PRODSEQ,
 PD_DESC1,
 PD_REVIEW,
 PD_ANSALE$,
 PD_ANSALEU,
 PR_BUYR,
 PR_REGN,
 PR_LOCN,
 PR_SUPL,
 PR_SUPLSUB,
 PR_SUPLUSR,
 PR_SUPLUSB,
 PR_SUPLORG,
 PR_SUPLORS,
 PR_PROD,
 PR_ALTSRCE,
 PR_TEMPORY,
 PR_PRODSEQ,
 PR_DESC1,
 PR_DESC2,
 PR_NDC_UPC,
 PR_MFG,
 PR_CATALOG,
 PR_UOM,
 PR_PACKSIZ,
 PR_TIHI,
 PR_GROUP1,
 PR_GROUP1O,
 PR_GROUP2,
 PR_GROUP2O,
 PR_GROUP3,
 PR_GROUP3O,
 PR_GROUP4,
 PR_GROUP4O,
 PR_GROUP5,
 PR_GROUP5O,
 PR_WHSLOCN,
 PR_BIRTH,
 PR_RFBIRTH,
 PR_LASTUPD,
 PR_LINECST,
 PR_LEADTM,
 PR_LEADTMP,
 PR_LEADTMV,
 PR_LEADTMS,
 PR_LEADTMT,
 PR_COSTREG,
 PR_COSTDIV,
 PR_COSTEAC,
 PR_OVRCREG,
 PR_OVRCDIV,
 PR_COSTLST,
 PR_COSTLDT,
 PR_BRKFLAG,
 PR_BRKCOST,
 PR_SALES,
 PR_SALESLW,
 PR_QTYOHND,
 PR_QTYOORD,
 PR_QTYBACK,
 PR_QTYHOLD,
 PR_QTYPEND,
 PR_QTYBALN,
 PR_PROMQTY,
 PR_PROMBEG,
 PR_PROMEND,
 PR_USRSTAT,
 PR_SYSSTAT,
 PR_SOQNITE,
 PR_FORCAST,
 PR_FORMANL,
 PR_CUSTUSG,
 PR_FORFREZ,
 PR_PROBDAT,
 PR_FORDEVP,
 PR_FORSERR,
 PR_FORCHG,
 PR_MINQTY,
 PR_MINQTYO,
 PR_BUYMULT,
 PR_BUYMULO,
 PR_BUYMULI,
 PR_CONVPAK,
 PR_CONVPKO,
 PR_CONVPKP,
 PR_DAYSOUT,
 PR_DAYSPRV,
 PR_DAYSUNT,
 PR_INTRVAL,
 PR_OTIMFAC,
 PR_MAXDAYS,
 PR_MAMINID,
 PR_MAMAXID,
 PR_MAMINIU,
 PR_MAMAXIU,
 PR_ADD_DAY,
 PR_ANSALE$,
 PR_ANSALEU,
 PR_DEVTIMF,
 PR_SSTIMEF,
 PR_SAFESUM,
 PR_WEIGHT,
 PR_WEIGHTO,
 PR_WEIGHTD,
 PR_WEIGHDO,
 PR_VOLUME,
 PR_VOLUMEO,
 PR_VOLUMED,
 PR_VOLUMDO,
 PR_PURINCR,
 PR_PURINCO,
 PR_DISOTHR,
 PR_SEASONL,
 PR_SEASACT,
 PR_SEASSRC,
 PR_SERVICE,
 PR_SERVSIM,
 PR_SVCEPRV,
 PR_FORCINT,
 PR_FORCYR,
 PR_FORCPER,
 PR_FSTSLYR,
 PR_FSTSLPR,
 PR_HISTPER,
 PR_PROMPER,
 PR_LONGTRM,
 PR_DELTCNT,
 PR_SPLTPRM,
 PR_SPLTTMP,
 PR_ENDPER,
 PR_ENDPERS,
 PR_FBUYDAT,
 PR_LSTORDR,
 PR_LSTRCVD,
 PR_LSTINTR,
 PR_ACCSALE,
 PR_ACCOUTS,
 PR_ACCDEM,
 PR_RNKBUY$,
 PR_RNKBUYU,
 PR_RNKLOC$,
 PR_RNKLOCU,
 PR_RNKCOM$,
 PR_RNKCOMU,
 PR_RNKSUP$,
 PR_RNKSUPU,
 PR_RNKDATE,
 PR_POQTYDV,
 PR_POQTYUM,
 PR_DEAL,
 PR_DEALBEG,
 PR_DEALEND,
 PR_DEALALW,
 PR_DEALUSE,
 PR_PRVFORE,
 PR_PRVDEVP,
 PR_PRVSERR,
 PR_PRVTS,
 PR_PRVLOST,
 PR_PRVSALE,
 PR_PRVEXPT,
 PR_PRVDEMD,
 PR_TRNOORD,
 PR_ALTOORD,
 PR_CONTFLG,
 PR_OVERFLG,
 PR_OVERUNT,
 PR_OVERCST,
 PR_OVERCUR,
 PR_OVERMAX,
 PR_MFGOUT,
 PR_PROCALT,
 PR_FORMETH,
 PR_INVMETH,
 PR_EXCUNTL,
 PR_EXCAFTR,
 PR_REBATE,
 PR_TRANPTD,
 PR_TRANLST,
 PR_REPCARY,
 PR_EXCLEAD,
 PR_NONSTCK,
 PR_COMPROD,
 PR_CMBLOCN,
 PR_CMBSUPL,
 PR_CMBSUB,
 PR_ACCTYP1,
 PR_ACCTYP2,
 PR_ACCTYP3,
 PR_ACCTYP4,
 PR_ACCTYP5,
 PR_ACCTYP6,
 PR_ACCTYP7,
 PR_ACCTYP8,
 PR_ACCTYP9,
 PR_CARCOUN,
 PR_USERA1,
 PR_USERA2,
 PR_USERA3,
 PR_USERN1,
 PR_USERN2,
 PR_USERN3,
 PR_DISOTHO,
 PR_DISUNT7,
 PR_DISUN7O,
 PR_DISUNT8,
 PR_DISUN8O,
 PR_DISUNT9,
 PR_DISUN9O
            
FROM K_PRODSED
LEFT JOIN K_PRODUCT
                     ON PD_COMP = PR_COMP
                         AND PD_ACTLOCN = PR_LOCN
                         AND PD_PROD = PR_PROD
                         AND PD_ACTSUPL = PR_SUPL
                         AND PD_ACTSUB = PR_SUPLSUB
WHERE PR_TEMPORY = 0 and PR_ALTSRCE = 0 and PR_DELTCNT = 0; 

LABEL ON TABLE K_BTCHCMB IS 'Combined PRODSED-PRODUCT';

---