馃攳
SAP ACH, Wire Part 12 - YouTube
Channel: unknown
[0]
hi welcome in this lecture
[4]
we will create the payment file layout
[6]
our transaction code for this
[8]
is dmee we will log into
[14]
sap
[19]
d m e e
[23]
tree type f4
[27]
so the tree type which is used for
[30]
payment file is p
[31]
a y m
[35]
format tree
[39]
here we have to give the name which was
[42]
created in the
[43]
ob in the last lecture that is format
[46]
we have created in the last lecture z
[50]
underscore jpmc
[54]
for this particular format we have to
[57]
create the file layout
[60]
create we have an option to create a
[63]
flat file
[64]
or xml file here the requirement is to
[68]
create a flat file
[69]
select flat file
[73]
let us enter the dme free properties
[76]
so in dma 3 basically there are
[79]
three sections header data
[82]
header section detail records and
[85]
trailer
[86]
uh these are known as segments uh
[90]
segments so going to the
[93]
so first we will give the dma tree
[95]
properties then we define the
[97]
header segment below that we will define
[100]
the
[100]
payment records and then in the last of
[103]
trailer segment will come
[106]
dmetry properties administrative data
[109]
short description this is for jpmc
[114]
wire transfer flat file
[121]
format attributes click on field type
[126]
f4 so
[128]
the flat file created can have fields
[131]
separated by a delimiter
[133]
a delimiter could be a comma or a pipe
[136]
or a semicolon
[137]
or it can have a fields which have fixed
[140]
length
[141]
we will select the option one because
[143]
that's the requirement as per
[145]
bank layout
[149]
in the delimiter area enter the
[151]
delimiter comma
[155]
labels now labels
[159]
uh so the in the flat file the nodes
[162]
have various labels header is one node
[166]
detailed records are another node
[168]
trailer is another node
[170]
so the header node comes at level one
[174]
payment records is a node which comes
[176]
below header it is a sub
[178]
node of header so it comes at level two
[182]
so we will have level one in repetition
[186]
factor
[186]
we will give one because header record
[190]
will appear only once in the
[191]
full flat file similarly trailer record
[195]
which will also have label one will
[196]
appear only once in the flat file
[199]
label 2 this can have repetition label
[204]
as many as we want i'm going to give 999
[207]
here
[209]
the reason for this is level 2 here is
[212]
in this file is assigned to payment
[214]
records and in a flat file there will be
[217]
more than one payment records
[220]
sort fields sort fields now
[223]
these are fields based on which program
[226]
will sort the data before populating it
[229]
in the flat file so for the header area
[232]
let us say the sort field
[234]
as the program run id
[237]
which is field la ufi
[241]
structure is fb a yh
[247]
level is 1 and
[250]
for level 2 we take this sort field as
[254]
payment document field for that is doc1
[259]
r structure is again f
[262]
p a y h
[266]
as discussed in the earlier lectures to
[270]
know the details of tables and which
[272]
fields to use
[274]
we can always look at the tables in the
[277]
below window so you see payment medium
[280]
the table
[281]
is fba yh and to look at the fields of
[285]
this table
[286]
just click on the icon next to it
[289]
and here are the fields i've also shared
[293]
an excel which gives
[294]
details of details about the
[296]
functionality of each of these fields
[300]
that will be available in the course
[301]
material in the lecture
[304]
file data select carriage return
[308]
and line feed
[311]
let's see at carriage return
[314]
f1 to know more details about a
[317]
particular field
[318]
means that the carriage return is
[319]
inserted at the end of a segment
[322]
so yeah so we have a segment at the end
[326]
of the segment if you want a new line
[328]
a carriage we have to select the
[330]
carriage return
[336]
save
[338]
so in this lecture we have entered that
[341]
we have created the file layout
[344]
z underscore jpmc we have entered the
[346]
dme
[347]
tree properties in the next lecture we
[350]
will
[351]
take our file layout continue with our
[353]
file layout z underscore jpmc
[355]
and will create the first segment that
[358]
is header for that file
Most Recent Videos:
You can go back to the homepage right here: Homepage